HomeActive Query Builder - HowTos and TroubleshootingActive Query Builder ActiveX EditionList of possible SQLSyntax values

6.3. List of possible SQLSyntax values

Below is the full list of values for the ActiveQueryBuilderX.SQLSyntax property ("xs" constants).

Long aqbSyntax_xsAuto = 0x00000002
Long aqbSyntax_xsUniversal = 0x00000004

Long aqbSyntax_xsSQL89 = 0x00000001
Long aqbSyntax_xsSQL92 = 0x00000000
Long aqbSyntax_xsSQL2003 = 0x00000003

Long aqbSyntax_xsMSSQL7 = 0x0000000A
Long aqbSyntax_xsMSSQL2000 = 0x0000000B
Long aqbSyntax_xsMSSQL2005 = 0x0000000C
Long aqbSyntax_xsMSSQL2008 = 0x0000000D
Long aqbSyntax_xsMSSQL2012 = 0x0000000E

Long aqbSyntax_xsMySQL3 = 0x00000014
Long aqbSyntax_xsMySQL40 = 0x00000015
Long aqbSyntax_xsMySQL41 = 0x00000016
Long aqbSyntax_xsMySQL5 = 0x00000017

Long aqbSyntax_xsPGSQL = 0x0000001E

Long aqbSyntax_xsSQLite = 0x00000028

Long aqbSyntax_xsOracle7 = 0x00000032
Long aqbSyntax_xsOracle8i = 0x00000033
Long aqbSyntax_xsOracle9i = 0x00000034
Long aqbSyntax_xsOracle10g = 0x00000035
Long aqbSyntax_xsOracle11g = 0x00000036

Long aqbSyntax_xsInformixDS8 = 0x0000003C
Long aqbSyntax_xsInformixDS9 = 0x0000003D
Long aqbSyntax_xsInformixDS10 = 0x0000003E
Long aqbSyntax_xsInformixDS11 = 0x0000003f

Long aqbSyntax_xsJet3 = 0x00000046
Long aqbSyntax_xsJet4 = 0x00000047
Long aqbSyntax_xsAccess97 = 0x00000048
Long aqbSyntax_xsAccess2000 = 0x00000049
Long aqbSyntax_xsAccessXP = 0x0000004A
Long aqbSyntax_xsAccess2003 = 0x0000004B

Long aqbSyntax_xsFirebird1 = 0x00000050
Long aqbSyntax_xsFirebird1_5 = 0x00000051
Long aqbSyntax_xsFirebird2 = 0x00000052

Long aqbSyntax_xsInterbase = 0x0000005A

Long aqbSyntax_xsSybaseASA = 0x00000064
Long aqbSyntax_xsSybaseASE = 0x00000065

Long aqbSyntax_xsDB2 = 0x0000006E

Long aqbSyntax_xsTeradata = 0x00000078

This page was: Helpful | Not Helpful