Hi Harry,
-------
SQLEXEC(gnhandle,"insert into vizkeys (realkey,kcurrent,date_used,kprevious,knext,date_up,crypt_key,mess_hash,ownerkey) values (m.realkey,m.kcurrent,m.date_used,'','',m.date_up,'','',m.ownerkey)",'real')
If you put a VFP var reference on a string, it is only a literal for this reference;
you need to use SPT parameters
?:
SQLEXEC(gnhandle,"insert into vizkeys (realkey,kcurrent,date_used,kprevious,knext,date_up,crypt_key,mess_hash,ownerkey)
values
(?m.realkey,?m.kcurrent,?m.date_used,'','',?m.date_up,'','',?m.ownerkey)",'real')
Fabio
