HomeActive Query BuilderActiveQuery and PowerBuilder - Constant values

ActiveQuery and PowerBuilder - Constant values


Hi ,

How can I get the value for the constants like 'xsAuto'
The problem is that in PowerBuilder I can not use the contants - i need the actual value.
Can you provide me with a header file listing all the constants and their respective values ?

Thanks in advance
Regards Steen Jakobsen


In VB this is valid
................................
ActiveQueryBuilderX1.SQLSyntax = xsAuto



In PowerBuilder This is valid
.................
Long ll_myvar_xsAuto = 123
ActiveQueryBuilderX1.Object.SQLSyntax = ll_myvar_xsAuto




Steen jakobsen | email
September 15 2008, 02:55 AM
Dear Steen,

Below is the full list of "xs" constants for PowerBuilder.

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_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
Sergey Smagin | email
1 day, 2 hours since original post
Great :-) Thanks

/Steen
Steen jakobsen | email
1 day, 4 hours since original post
This topic is closed