Pattern at zconnection.gettablenames

Bigeddie · Post by **Bigeddie** » 22.10.2005, 13:28

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

bitmapbrother · Post by **bitmapbrother** » 24.11.2005, 11:05

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

bitmapbrother · Post by **bitmapbrother** » 24.11.2005, 11:55

Compiled "zeosdbo-6.5.1-alpha_cvs_13-10-2005.zip" and same result with mysql but works with postgresql-8.x without problems

bitmapbrother · Post by **bitmapbrother** » 24.11.2005, 19:48

Downloaded latest source from CVS and still have that problem. Can someone write me example how GetTableNames should be used with mysql? thx.

bitmapbrother · Post by **bitmapbrother** » 25.11.2005, 13:02

Hmm ... no one is using GetTableNames with mysql-4.1 ... its such a basic thing isnt it? plz help