Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connection Handles vs Statement Handles
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
01685354
Message ID:
01685359
Views:
43
>>Hi everybody, I have this doubt. In VFP what is a Connection Handle vs. a Statement Handle? Are they the same? When/how use each one of them?
>
>The connection handle is like SQLCONNECT() and SQLCONNECTSTRING() functions ... I assume the statement handle is the SQL statement used in the SQLEXEC() function.

You create a connection handle thusly:

gnConnHandle = SQLStringConnect(lcConnString)

Once created it allows you to execute commands on the SQL server.

e.g. ln_commit = SQLCOMMIT(gnConnHandle)

I've never used a statement handle.
Has anyone here used one?
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.
Previous
Reply
Map
View

Click here to load this message in the networking platform