General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only