>>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.
Aleksey,
Well, I couldn't ask for a better authority.... ;-)
Thank you for your reply.
My understanding is that FP 2.5 free tables don't recognize nulls natively. What I understand you to say is that I would need to include all the fields (28) of the table and values for them in my UPDATE command. Is this correct? Assigning DEFAULT values to the CUSRSORSCHEMA property didn't seem to work. How would you do this?
Thanks,
Tim
Duty is ours, the results are God's - John Quincy Adams