Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating CursorAdapter w/Free Tables
Message
From
14/10/2006 21:28:21
 
 
To
12/10/2006 21:40:56
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01161323
Message ID:
01162048
Views:
35
>AERROR, BTW, says that one of the fields in the underlying table will not accept nulls. So the insert appears to be failing b/c one of the fields that I'm not assigning a value to thinks I'm trying to assign a null. Do you see anything that might cause the Insert to fail to the free table? Do you know of anything that limits the usage of free tables in CursorAdapters?
>

Hi Tim,

I don't think the error is caused by the fact that you are working with a free table. For a new record, non-modified fields are not included by CursorAdapter into INSERT command. If one of those omitted fields happens to be a non-NULL field in the table, you may get the error you describe. Make sure to assign values to the fields like that before doing TABLEUPDATE.

Thanks,
Aleksey.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform