> I would like to get the columns from a view or table when performing a
> query. The user is able to create his/her own select query and before
> actually performing a query (which could take some time), I would like
> to know the columns beforehand.
>
> I had the idea to attach 1=2 to the users query, as in:
>
> select xxx
> from tableX
> where 1=2
>
> Is this the best way to handle it?
> The thing I would like to get is to know the columns of the select
> query, without performing a huge query

Check out system table RDB$RELATION_FIELDS

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com