| |
|
|
|
|
enuSQLSyntax Enumeration
Represents enumeration used for SQLSyntax property.
Member Name |
Description |
ANSIStandardSQL |
Returns Standard ANSI SQL Syntax |
MSAccessSQL |
Used for search on Microsoft Access database, or using DAO to connect to Access database. If you use ADO, you need to use ANSIStandardSQL syntax. |
MySQLFullTextSearch |
MySQL full text search |
MySQLWithLikeKeyword |
MySQL standard searching with LIKE keyword |
MSSQLFullTextSearch |
Microsoft SQL Server full text search |
MSSQLWithLikeKeyword |
Microsoft SQL Server standard searching with LIKE keyword |
OracleText |
Oracle text searching |
OracleWithLikeKeyword |
Searching with LIKE keyword on Oracle database |
For your small web site you decided that is enough to use MS Access database. After few months, database become too large for MS Access. Also, web site si now very popular and number of visits demand a lot of database connections. You need to switch to some more powerfull database technology, like MySQL, MS SQL or Oracle. Whatever you decide, you don't need to write a new code for your web application! It is enough to change SQLSyntax property to the appropriate value. You can even quickly test your web application with different database technologies to see what is the best solution.
|
|
|
| |
