Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ODBC
Message
De
01/10/2001 11:05:46
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
01/10/2001 11:02:56
Steven Dyke
Safran Seats USA
Texas, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Re: ODBC
Divers
Thread ID:
00556482
Message ID:
00562567
Vues:
30
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform