General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Crescencio, thanks again for your help!!!.
I tried the following code and it worked!
**********************************************************
nRes = SQLExec(nHan, "INSERT INTO jeinterface (batch_skey);
Values(" + lcBatchSkey + ") ")
**********************************************************
But when the lcBatchSkey is empty I ge an SQLExec failure.
(the field type in the SQL Server is varchar(50)).
Also when looking at the records in the SQLServer the values are not
left padded with '0'. (the values in the VFP table for the batch_skey
are left padded with 0s ex: '0000000000000001')
Thanks,
Sergio
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only