Fernando,
>First of all, thanks for replying!
No problem :)
>The
"Select 1" syntax is accepted by all SQL engines?
That's a good question ... I would assume that at least most db servers support this, since you're only supplying a constant in the select list. There's nothing really special to it.
> Initially I thought using the
"Select Top 1" syntax, but Informix doesn't accept it.
The TOP clause is AFAIK not an ANSI standard clause, so I wouldn't expect it to be running on all RDBMS.
> Using the
"Select 1" syntax with an Informix table returned me a result cursor with only one column named "Exp" with all values of "1".
The expected result of a SELECT 1 FROM table WHERE id=99 is to return a recordset with one column containing "1". Is that what you get?
Armin