List of possible SQLSyntax values (ActiveX Edition)
Last modified:
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