Naomi,
>Are you using insert or APPEND BLANK? AFAIK APPEND BLANK is not affected by SET NULL, only insert-SQL when not every field is specified.
>
>Ok, I didn't read your original statement carefully. Yes, you're using APPEND BLANK, so you're right, it's not affected.
Yes, I'm using APPEND BLANK. After read your post, I tried to find a way to replace APPEND BLANK to INSERT-SQL, but VFP doens't accept just "INSERT INTO MyCursor". It needs to add, at least, one field... :-( - and I don't want to track it (in this case).
Thanks again!
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Rodolfo Duarte