>Im try wrotte an application from VFP3.0b and SqlServer 6.5, this applicantion dont uses 'views', only stored procedures, users dont have permission to select,update, insert or delete, only execute stored procedures, ok, all remote tables have a timestamp field, and I get a row by Stored Procedure, Row by row, when I Send Updates, the parameters in the Stored Procedures be: Id, Some description, etc and Timestamp value, this value is in the local cursor a Memo(binary ) field, and the Odbc error when send is 'Implicit convertion of Varchar in Varbinary is ????, use convert function'. When I use with a Remote view the same update, VFP sends in the Timestamp Column 0x0000010000E800 for example, and no error. How can I do that in a program?
>Excuse my bad, bad English, thanks in advance.
>Claudio

If your update requires calling stored procedure with parameters then you you will have to convert the character representation of the timestamp to binary or varbinary.

If your memo field is called cmemo you might issue statements like this:

lcSQL = [exec spupdate '] + m.id + [', CONVERT(BINARY, '] + ALLTRIM(cmemo) + [')]
EXECSQL(handle, lcSQL)

etc.

Bob