Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with a local view not updating the base table
Message
From
19/07/1999 19:17:17
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00243350
Message ID:
00243356
Views:
22
>I'm trying to insert a value into a local view but it's not working and not returning any errors.
>
>The view is in a forms DE with NoDataOnLoad = .t., within a method on the form is the following code:
>
>SELECT contact_by_id &&the local view
>lcAbId = NewId("AddressBook") &&generates a new PK
>thisform.CurId = lcAbId && store the PK in the form
>
>** add a new record to the view
>INSERT into contact_by_id ;
> (ab_id, abstatus) values (lcAbId, .t.)
>
>The code works correctly. If I look in the data session (it's private) after the code runs the ab_id field in the view has the correct value. I issue a tableupdate(.t., .t.), which returns .T. and close the form.
>
>If I browse the base table the ab_id field is blank(?). The abstatus and any other fields contain the correct values.
>
>I've checked everything I can think to check but I can't figure out why the 1 field won't update.
>
>Any ideas?

Did you use the view builder? If you did make sure that field is checked to update.

HTH

Dan
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform