>Not too wierd, just working as advertised. The column is tagged as not null on SQL so every row must have a value in the VFP table in the column to be inserted into SQL.
>
>Also, I would be careful about calling a column just 'DATE' as things like Oracle and SQL are much more unforgiving about reserved words.
>
>PF
>
>>
>>I am now getting invalid Insert erros , one of my columns named Date, it says it can not accept nulls values, weird since it has only appended only a row into SQL , in my FoxProtable I have about 100 rows.
Hey and you are correct my friend, ;-), it is only kind of extrange that
only the first row will get commiteed into SQL, when there is 99 more to go
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement