SQLOptions Type

Unit
AstaSQLUtils

Declaration
type TAstaServerSQLOptionTypes = (ssUseQuotesInFieldNames,
  ssTableNameInInsertStatments, ssBooleanAsInteger,
  ssUSDatesForLocalSQL, ssTerminateWithSemiColon,
  ssNoQuotesInDates, ssDoubleQuoteStrings, ssUseISInNullCompares);

TAstaServerSQLOptions = set of TAstaServerSQLOptionTypes;

Description

ssUseQuotesInFieldNames      Used for Paradox or any database that allows spaces in field names.

ssTableNameInInsertStatments      Databases like Access need this set to false.

ssBooleanAsInteger            MS SQL Server has bit fields that map to ftBoolean in the VCL but then SQL must be generated as Integers (eg. 0 or 1).

ssUSDatesForLocalSQL            Interbase, Paradox and xBase using the BDE don’t like international dates so this forces the server to receive US formatted dates.

ssTerminateWithSemiColon      :      Access likes it’s SQL statements to be termintaed with semi-colons.

ssNoQuotesInDates            Use this if you don’t want to use single quotes in dates and datetimes.

ssDoubleQuoteStrings            Use this if your strings don’t need single quotes but double quotes.

ssUseISInNullCompares            Paradox doesn’t like = null and wants IS null.