Page 1 of 1

Pattern at zconnection.gettablenames

Posted: 22.10.2005, 13:28
by Bigeddie
hi all,

I'm new in doing DB-programming and I have a problem with
zconnection.gettablenames:
by using '' as the pattern-string there's always the same errorcoming up
' SQLerror: you have an error in your SQL syntax, check the manual that corresponds to your MySql server version for the right syntaxto use near 'LIKE '%'' at line 1.

ZEOSLib Version 6.5.1
delphi 7
Mysql 4.1.14

greetings

bigeddie

Posted: 24.11.2005, 11:05
by bitmapbrother
Hmm ... I have same problem ... can someone write an example pls?

zeosdbo-6.5.1-alpha_cvs_26-09-2005.zip
cpp builder 6
mysql 4.1.5 gamma

Posted: 24.11.2005, 11:55
by bitmapbrother
Compiled "zeosdbo-6.5.1-alpha_cvs_13-10-2005.zip" and same result with mysql but works with postgresql-8.x without problems :?:

Posted: 24.11.2005, 19:48
by bitmapbrother
Downloaded latest source from CVS and still have that problem. Can someone write me example how GetTableNames should be used with mysql? thx.

Posted: 25.11.2005, 13:02
by bitmapbrother
Hmm ... no one is using GetTableNames with mysql-4.1 ... its such a basic thing isnt it? plz help