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