[WD23] Query Question

Hi, as an example, I have a simple table control here, item# + quantity:

[attachment 2773 Bestellungen.png]

The problem: the combo in column 1 of the table should contain only those item numbers which are not in the table. Is there a query for that?

Of course, currently I'm doing that by code and fill the combo with all of the items which are NOT already in the table (TableSeek ..). Is there a more elegant way by query??



Edited 1 time(s). Last edit at 07/29/2018 07:57AM by GuenterP.

Hi Guenter,

you could create a variable like "Artikel_Liste" and add each GUID (or ID) of the selected product as string with ";" as delimiter.

Then " select all product where ID is not in List "Artikel_liste"

Hi Gunter,

"Good Day"

You can use "Not In" in SQL query.

Create a string and add all current using IDs separated by Comma.

sStr is string = "1,2,3"

Select Artikel from Table_name where ID Not In sStr

Thanks and Regards

Shijo S Philip
https://ssphilip.com/

Hi Michael and Shijo,

thank you, I'll try to get one of your suggestions to run!