Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with a local view not updating the base table
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Problem with a local view not updating the base table
Miscellaneous
Thread ID:
00243350
Message ID:
00243350
Views:
47
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?
Roi
'MCP' Visual FoxPro

In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!
Next
Reply
Map
View

Click here to load this message in the networking platform