>>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.