>>I have a remote view of a VFP DBC table. I inserted several records from arrays, etc. into the view. Now I issue tableupdate() at the click of a form button and nothing happens - no records are written to the table.
>>
>>Am I misusing the function because I didn't read from the table into the view first? What's the best way for getting the view info into the table?
>
>NO, you don't need to REQUERY the view before updating from it. Your problem lies elsewhere. In addition to Jim's advice, check to make sure that the view is set to updatable, a key field is specified, and the proper fields are marked as updatable.

Eric, Jim and Steve,

I find myself asking this thread question more frequently. Is there a connection between this, the thread "Theory of lost data" from around 08-16 to 08-20, and the behavior discussed in the FoxTalk article by Maskens and Kramek "Where do you want to GOTO"

I have several applications that all use local tables and parent/child form header/grid style, and allow data entry on grids, and do not use views. Depending on the position and the the current control, I interpret toolbar clicks as adding a parent or adding a child on whether the call came from the grid or not, hotkeys and rightmouse menus as well.

Defaults for the primary key fields and foreign key fields come from the stored procedures when the record is added. Most of the time this all works, but sometimes I get a record saved that has a blank primary key field. Sooner or later it would happen again, and then I have a PK violation, etc.

Since I could not figure out what was causing it, and the input from the users about what they were doing when it happened was sporadic, I mostly responded by throwing TableUpdate() and Refresh() code at it, but only made matters worse.

Using debug output and wait windows and so on I can see the new key being generated correctly and the RI code running. Should I issue a TableUpdate() immediately, upon adding a new record, or do I have to check that the stored procedure defaults in the field definitions do the right thing after the TableUpdate()? I will do as you and Jim suggest and make sure I have all the parameters in effect. Isn't it possible to do it with child grids directly?

Thanks for your thoughts

Al