>>
>>Prepare it before the call if you don't want it to be asked.
>>
>>m.Whatever = 'myCryptedKey'
>>m.myRealKey = 'one of my keys'
>>SQLEXEC(gnhandle,"update vizkeys set crypt_key=?m.whatever where realkey=?m.myRealKey ")
>>
>>Cetin
>
>tried that:
>
>m.whatever='arbitrary string'
>SQLPREPARE(gnhandle,"update vizkeys set crypt_key=?m.whatever where realkey='one of my keys' ","real")
>SQLEXEC(gnhandle)
>
>and the SQLEXEC line still stopped and asked for the value of m.whatever...

Harry,
Assuming your sample Notwhwind data employees table accept nulls :

local lnHandle
lnHandle=SQLStringConnect('DRIVER=SQL Server;'+;
        'SERVER=servername;Trusted_connection=Yes')
For ix=1 to 5
  SQLExec(lnhandle,;
   "insert into Northwind.dbo.employees (FirstName,LastName)"+;
   " values ('Later','ChangeMe')")
endfor
SQLExec(lnHandle,'select * from Northwind.dbo.employees')
browse
m.whatever='arbitrary name'
SQLPrepare(lnhandle,"update Northwind.dbo.employees"+;
        " set LastName=?m.whatever where FirstName='Later'","real")
SQLEXEC(lnhandle)
SQLExec(lnHandle,'select * from Northwind.dbo.employees')
SQLDisconnect(lnHandle)
Select real
Browse

Cetin