You are not only the BEST you are also the FASTEST! Thanks for the quick response.
I did as you said and came up with the following error:
nConVar=SQLCONNECT("ConVar")
=sqlprepare(nConVar,"Select * from list","list")
Error:"Connection handle is invalid."
When I test the connection it is successful.
Any other ideas?
Thanks again, Bob
>Hi Bob ---
>
>No problem :)
>
>>
>>CREATE DATA worktbls\dataconn
>>CREATE CONNECTION ConVar CONNSTRING "DRIVE={SQL Server}SERVER=LISTMAKER_II;UID=sa;PWD=;DATABASE=listmaker"
>>
>>=sqlprepare(ConVar,"Select * from list","list")
>>=sqlexec(ConVar)
>>
>>When the SQLPREPARE executes I get the following error: "Variable ConVar is not found."
>>
>
>The problem is that you are not establishing a connection before doing the SQLPREPARE. If your connection name is ConVar you need a line like:
>
>nConHandle=SQLCONNECT("ConVar")
>
>After you've created the connection but before any other SQL statements. Then, you have to use nConHandle instead of ConVar for SQLPREPARE and SQLEXEC....just remember to use SQLDISCONNECT when done.
Database Development Team