DBGrid dblookupcombobox from depended query

[enver penjo]

For example:

I have added table delivery where we can add orderid and when we add it then we should be choose (from lookup) products from that orderid.

[Tomas Rosinsky]

Hi, 

it could be easily done by custom code. Use Field.OnChange event for orderId and set the list for the lookupcombo according to used orderId - e.g.  add condition for orderId and requery dataset for the list.

Or use my rDBComboBoxUDB which supports using of internal dataset with conditions....

Tomas

Dne pondělí 4. dubna 2022 v 17:31:22 UTC+2 uživatel penj...@gmail.com napsal:

[enver penjo]

i Have added:

procedure TForm5.qDeliveryorderidChange(Sender: TField);
var a,s:string;
begin
  a:=':'+qDelivery.FieldByName('orderid').AsString;
  with self.qOrderDetails do begin
       s:=stringreplace(sq,':OrderID',a,[]);
       sql.Text:=s;
       open;
  end;
end;

But nothing happens!

[Tomas Rosinsky]

Thanks for information :)

Dne pondělí 4. dubna 2022 v 23:19:12 UTC+2 uživatel penj...@gmail.com napsal:

[enver penjo]

It did not help!

[Tomas Rosinsky]

There was no question in your message so what did you expect from me? 

It is your code and the issue is not related to my components, you have probably wrong sql statement (char : should not be here). 

If you want me to check and fix your code next time we can make a deal, no problem. Just explain what is expected and I will provide the solution for free as many time before or send you the expected price for my time. ok?

Thanks for understanding.

Tomas

Dne čtvrtek 7. dubna 2022 v 1:52:34 UTC+2 uživatel penj...@gmail.com napsal: