is this bug or i missing something ?

tigerwing · Post by **tigerwing** » 10.08.2007, 05:19

hi everyone

this is my first time using firebird 2.0
fortunenally it is good to handle firebird's datas...

anyway... i'm use D7 + zeoslib-6.6.1 + firebird-2.0
i can do 'select query' to any tables and it's works fine!

but i met a error msg like
'SQL Error: Dynamic SQL Error SQL error code = -104 Token unknown - line 1, column 1 show. Error Code: -104. Invalid token The SQL: show tables;;'
when querying which 'show tables;'

i don't know it's zeoslib's bug or i was missing something...

andy · Post by **andy** » 10.08.2007, 10:25

Show us the full SQL statement, that raises the error.

tigerwing · Post by **tigerwing** » 13.08.2007, 14:33

hi andy

i was mention it already

anyway i was querying 'show tables;' and was error occured like
'SQL Error: Dynamic SQL Error SQL error code = -104 Token unknown - line 1, column 1 show. Error Code: -104. Invalid token The SQL: show tables;;'

i want to see my database's tables but i cann't

Post by **mdaems** » 13.08.2007, 15:50

No experience with firebird, but assuming 'show tables' is the right query, I think it may be the semicolon ";" that's duplicated. Did you add it to the sql property? Does it make a difference when you remove it?
If not, please log it in the bugtracker (http://zeosbugs.firmos.at/). If you can add your sample project, that's even easier for the debugging developer.

Mark

tigerwing · Post by **tigerwing** » 14.08.2007, 03:17

hi mdaems

i was try you mentioned but same result

so i decide to logreport to bugtracker with sample project

anyway thanks

hmm... i cann't login http://zeosbugs.firmos.at so i leave my sample project here

cipto_kh · Post by **cipto_kh** » 14.08.2007, 04:34

The command "show tables" is not valid DML SQL statement, you also cann't execute that query in IBExpert. If you want to get the list of the table, you can try this:
ZConnection1.GetTableNames('', Memo1.Lines); //to display in TMemo component

or you can query like this:
select rdb$relation_name from rdb$relations

or if you want to display user table only:
select rdb$relation_name from rdb$relations
where rdb$relation_name not containing '$'

Post by **mdaems** » 14.08.2007, 07:11

Thanks cipto,

Problem closed...

@tigerwing :
To log a bug report you need to register agian at the bug tracker website. We know it's a little annoying, but you can use same name and password if you want. (please use the same username, that's easy when trying to contact you using pm on the forum)

Actually, there's another solution to the show tables problem : Use TZConnection.GetTableNames. Somebody else already solved the problem for you.

Mark

tigerwing · Post by **tigerwing** » 22.10.2007, 03:23

thank you

i'm late but it's helpful