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!