>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!
You can try with
insert into myCursor (MyCharField) values ("")
but it's not worth it and it will disallow to make the class generic. So, just stick with the schema unless someone knows a better way.
If it's not broken, fix it until it is.
My Blog