| Subject | Defined Lookup Fields Become Blank when Lookup Table is Edited. |
|---|---|
| Author | Craig Cox |
| Post date | 2013-07-09T17:53:43Z |
Delphi XE, IBO 4.9, FB 2.5, Win 7, DevExpress VCL 12.2.6
I have an IBO table that I have added a lookup field to. The lookup table is bi-directional.
I present the table information to the user in a DevExpress Grid. When the user needs to change the status of a record (add or change a date typically), they double click to open a form that shows a single record to edit. After they edit the record, they close the form and the record gets posted.
I use a BeforePost event to make a few changes to some other fields that are not shown to the user, but are based on the users choices. One field is in the table in which the lookup field resides, and one field is in the lookup table itself, but not the key field or lookup value.
All of this works as designed, except the Lookup value in the destination table becomes blank, and remains that way even though the associated key field and lookup field values are unchanged.
Even when I restart the program, the records that get edited do not get "repaired", and remain blank as if the lookup is broken for that particular record.
Any thoughts?
I have an IBO table that I have added a lookup field to. The lookup table is bi-directional.
I present the table information to the user in a DevExpress Grid. When the user needs to change the status of a record (add or change a date typically), they double click to open a form that shows a single record to edit. After they edit the record, they close the form and the record gets posted.
I use a BeforePost event to make a few changes to some other fields that are not shown to the user, but are based on the users choices. One field is in the table in which the lookup field resides, and one field is in the lookup table itself, but not the key field or lookup value.
All of this works as designed, except the Lookup value in the destination table becomes blank, and remains that way even though the associated key field and lookup field values are unchanged.
Even when I restart the program, the records that get edited do not get "repaired", and remain blank as if the lookup is broken for that particular record.
Any thoughts?