Hi, I'm wondering if there's a way to refer columns by number in WHERE
conditions.

I need this because I'm creating a generic method to create where
clauses for hopefully ANY query, in FreePascal.

I need this:

select col1, col2, colN 
from ...
join ...
where
  col1 = condition1, col2 = condition2

But now I need to know the name of the column in advance, and some times
the column name does refer to a real column, but a CASE statement or a
COALESCE.

Regards,
-- 
Leonardo M. Ramé
http://leonardorame.blogspot.com

Reply via email to