Subject Re: cur.execute("show tables") giving error
Author asforza2sell
Thanks for the info.

--- In firebird-python@yahoogroups.com, Uwe Grauer <mailinglists@...>
wrote:
>
> asforza2sell wrote:
> > when I try to do a "show tables" or a "show table X" command from the
> > execute method in kinterbasd, I get the following error:
> >
> > Traceback (most recent call last):
> > File "<stdin>", line 1, in ?
> > kinterbasdb.ProgrammingError: (-104, 'isc_dsql_prepare: \n Dynamic
> > SQL Error\n
> > SQL error code = -104\n Token unknown - line 1, char 1\n show')
> >
> > Should this command work for me? Other simple sql statements work,
> > like "select" and "insert". What am I doing wrong?
> >
> > thanks,
> > allen
> >
> "show tables" isn't a valid statement in Firebird.
> Maybe you should read some documentation first.
>
> Uwe
>