Subject Re: [firebird-support] Select * from where 0=1
Author Martijn Tonies
> >I need to retrieve an empty resultset with all fields of a given table. I
> >tried the two following queries :
> If you need only fields definition, there is no need to open
> dataset. Prepare is quite enough.

I believe this depends on what connectivity set you're using.
For example, this works fine with all Firebird connectivity sets,
but doesn't for, say, ADO or ODBC.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions