TSeba Posted May 4, 2018 Share Posted May 4, 2018 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 1.10.0.1453 of Unigui. Thanks in advance Quote Link to comment Share on other sites More sharing options...
Wilton Ergon Posted May 4, 2018 Share Posted May 4, 2018 You have already tried to set up your sql like this: select convert (varchar, field1) + convert (varchar, field2) as key, field3 from table so you only have 1 field as key field Quote Link to comment Share on other sites More sharing options...
TSeba Posted May 7, 2018 Author Share Posted May 7, 2018 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). Thanks Quote Link to comment Share on other sites More sharing options...
TSeba Posted May 8, 2018 Author Share Posted May 8, 2018 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"). Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.