General information
Title:
SQLXMLBulkLoad problem
Hi All.
I am trying to use SQLXMLBulkLoad example posted by Doug Henning to create a bulk upload from VFP into SQL server.
In my SQL Server structure I do not allow NULL values for any of my fields, except DateTime fields.
During upload if a table has any character fields with no values, the upload will fail and the error message says
"OLE IDispatch exception code 0 from General operational error: No data was provided for column 'columnname' on table 'tablename', and this column cannot contain NULL values..."
Any suggestions how to work around it?
Thank you
Yelena
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