Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Passthrough
Message
From
24/01/2003 09:38:54
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
SQL Passthrough
Miscellaneous
Thread ID:
00745051
Message ID:
00745051
Views:
60
I need to use a variable for SQLSTRINGCONNECT() I can't seem to make a variable work.

Working Code:
lcConnection = 'DRIVER=Client Access ODBC Driver (32-bit);SYSTEM=GVAS400;DefaultLibraries=webprddt6;'+;
'TRANSLATE=1;UID=DRAW;PWD=WEBER;SIGNON=2;SSL=3'

gnHandle1 = SQLSTRINGCONNECT(&lcConnection)

= SQLDISCONNECT(gnHandle1)

None Working Code:
Select actpth From pathtbl Where compid == 'PC341sde' And pthname == 'ClientAccess' InTo Cursor myodbcx
lcConnection = myodbcx.actpth

gnHandle1 = SQLSTRINGCONNECT(&lcConnection)

= SQLDISCONNECT(gnHandle1)
Next
Reply
Map
View

Click here to load this message in the networking platform