Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CursorAdapter and Null values
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
01236827
Message ID:
01236853
Views:
16
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform