General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Insert into an SQL table from VFP
How do I move records from a VFP table in a DBC into an SQL table?? Using VFP 6 and SQL 7.
I have the DBF in the DBC with the exact same fields as the SQL table.
I tried to append from that DBF and it dies after one record saying that a certain field can not be blank (null) , but it is NOT blank in the DBF.
I tried to scatter memvar then Insert into the SQL table (a remote view in the DBC) and it insert one record FINE, but always dies on the SECOND record it does not allow nulls (but there IS data in the DBF field for record 2).
HELP!!!!!!!!!!
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