Am Donnerstag, den 11.08.2005, 19:22 +0200 schrieb Marc Santhoff:
> Am Donnerstag, den 11.08.2005, 17:50 +0200 schrieb Marc Santhoff:
> > Am Donnerstag, den 11.08.2005, 08:28 +0200 schrieb Frank Schönheit - Sun
>
> Me again,
and again, ...
[...]
> ' NOT Okay -oCmp.setQuery("SELECT A, B, C, D, E, F, G FROM test.TestTab
> Testtab WHERE ((A=15021) OR (A=15020))")
> ' Okay - oCmp.setQuery("SELECT * FROM TestTab WHERE ((A=15021) OR
> (A=15020))")
> ' Okay - oCmp.setQuery("SELECT A FROM TestTab WHERE ((A=15021) OR
> (A=15020))")
> ' Okay - oCmp.setQuery("SELECT A, B FROM TestTab WHERE ((A=15021) OR
> (A=15020))")
> ' Okay - oCmp.setQuery("SELECT A, B, C FROM TestTab WHERE ((A=15021) OR
> (A=15020))")
> ' NOT Okay (css.sdbs.SQLException: "Syntax error in SQL expression"):
> oCmp.setQuery("SELECT A, B, C, D FROM TestTab WHERE ((A=15021) OR
> (A=15020))")
>
> msgbox oCmp.getComposedQuery()
I've done the same to the Bibliography database and found out:
It is the column name "D"! Any other combination works well ... =:()
Marc
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
