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.