Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Inserting records to SQL Server
Message
From
31/10/2001 11:15:25
 
 
To
30/10/2001 20:04:04
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00574760
Message ID:
00575667
Views:
27
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
Map
View

Click here to load this message in the networking platform