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.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05