Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ODBC
Message
From
01/10/2001 11:05:46
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
01/10/2001 11:02:56
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: ODBC
Miscellaneous
Thread ID:
00556482
Message ID:
00562567
Views:
28
>Cetin,
>
>I tried this and the error doesn't appear. However, no cursor is generated either.
>
>My Code Now:
>lcConnection = 'DRIVER=Client Access ODBC Driver (32-bit);SYSTEM=GVAS400;DefaultLibraries=webprddtx;'+;
> 'TRANSLATE=1;UID=SDE;PWD=BEREAN5;SIGNON=2;SSL=3'
>
>gnHandle1 = SQLSTRINGCONNECT(lcConnection)
>
>gnHandleb = "Select dm_drawing_number From drawmstrp InTo Cursor mySeeThisfit"
>
>If gnHandle1 <= 0 Then
> Wait Window "Connection not Made"
> Cancel
>Else
> *Wait Window "Connection Made"
> = SQLSETPROP(gnHandle1, 'asynchronous', .F.)
> = SQLEXEC(gnHandle1,"'"+gnHandleb+"'")
>EndIf
>= SQLDISCONNECT(gnHandle1)

Are you sure Steve ? When 3rd parameter is not specified VFP creates it with a default name of 'SQLRESULT' (SQLRESULT1,SQLRESULT2.. in case of multiple sets).
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform