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.