Jump to content

Error updating lookup fields with multiple fields in LookupKeyFields

Recommended Posts

Hi, I have the following problem. When I want to modify in a form a Lookup field that has more than one field defined in LookupKeyFields (Ex: "Company; Agreement") the error "TableName: Field" Company; Agreement "not found" is generated. That error does not occur when there is a single field in LookupKeyFields. Any idea why this error occurs and how can I solve it? ... I have cases that I need to define 2 or more fields in LookupKeyFields and in the version of delphi 7 I worked correctly.

I am using Delphi 10.2 Tokyo with version of Unigui.


Thanks in advance

Link to post
Share on other sites
Hi, thanks for the answer.

In this case I am not working with SQL but I have defined the permanent Lookup field within a TIBCTable component (I'm using Interbase tables).






Link to post
Share on other sites
Hi, I add more information that I hope will clarify my problem.

The error "TableName: Field" Company; Agreement "not found" is generated when the Post is made, not when the information is displayed in the grid. And it appears in the case that I want to change the value of the Lookup field in the record.


I could also see that the Demo project "DBLookupCombo" works correctly but has a single key field in "KeyField". I attach an image of my project where you can see that both the property "KeyFields" and the property "LookupKeyFields" have 2 fields of the tables (in this case "Empresa;ObraSocial").



Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...