search

smarthaert / txquery

Automatically exported from code.google.com/p/txquery
Other
0 stars 0 forks source link

Not In Can Not Work, what can i do? #20

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1.  Same Txt Data, one dataset read 3 row, the other dataset read 5 rows
2. use SQL like: 'SELECT * FROM New_dangjuDataSet WHERE StartGanhaoEndGanHao 
not in (SELECT StartGanhaoEndGanHao FROM Old_dangjuDataSet)' ;
3. the more 2 rows can not find

What version of the product are you using? On what operating system?
delphi 2007 + 2.1;

Please provide any additional information below.

Original issue reported on code.google.com by zhangron...@163.com on 23 Oct 2011 at 6:33

GoogleCodeExporter commented 9 years ago 
the test project

Original comment by zhangron...@163.com on 23 Oct 2011 at 6:38

Attachments:

GoogleCodeExporter commented 9 years ago 
You Should use the 'ALL' clause:

SELECT * FROM New_dangjuDataSet WHERE StartGanhaoEndGanHao not in ALL (SELECT 
StartGanhaoEndGanHao FROM Old_dangjuDataSet)

Seems to work.  Please try the modified TXQuery sources posted In Issue 19.

Original comment by fdue...@gmail.com on 1 Nov 2011 at 7:40

GoogleCodeExporter commented 9 years ago 
Hi please Check Issue 21 to use the updated sources, I changed the default 
behaviour when using the 'NOT IN' so it will work as expected

Original comment by fdue...@gmail.com on 3 Nov 2011 at 4:27