Hello,
I do not know how to get the list of tables in an Interbase databse. When I tried to use the sql command "SHOW TABLE;" in the php function "ibase_query();" I got "Dynamic SQL Error SQL error code = -104 Token unknown - line 1,...". Select commands work well but this not.
Does anybody know where is the problem?
Thanks Ge0rge

    show table is a mysqlism. Postgresql does it differently, as I'm sure interbase does as well. You'll have to read the interbase docs to see what to do.

      Originally posted by Sxooter
      show table is a mysqlism. Postgresql does it differently, as I'm sure interbase does as well. You'll have to read the interbase docs to see what to do.

      Thanks for your reply, but I am sure I've read the Interbase documantation. "SHOW TABLE" is a regular Interbase SQL command. I've tried this command with the command line Interbase client. Probably there is no way how to make this command work via PHP. Maybe via the ODBC PHP library but that's not what I need. I am bound to the Interbase library.
      Thanks once more.

        It may be one of those things that the isql client "interprets" for you. i.e. it's not actually SQL, it's a meta command to isql.

          Write a Reply...