|
| Iniciado por guest, 29,jul. 2018 07:57 - 3 respuestas |
| |
| | | |
|
| |
| Publicado el 29,julio 2018 - 07:57 |
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?? |
| |
| |
| | | |
|
| | |
| |
| Publicado el 30,julio 2018 - 07:15 |
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" |
| |
| |
| | | |
|
| | |
| |
| Publicado el 30,julio 2018 - 08:03 |
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/ |
| |
| |
| | | |
|
| | |
| |
| Publicado el 30,julio 2018 - 08:13 |
Hi Michael and Shijo,
thank you, I'll try to get one of your suggestions to run! |
| |
| |
| | | |
|
| | | | |
| | |
|