how to add new column to recordset??

huela · October 13th, 2004, 01:22 PM

I know I can use rs to get recordset from certain table or tables such as:
strSql = "Select Fund, Deal, [Deal Name] from tbl_irrdeals â
rs.Open strSql, con, ADODB.adOpenForwardOnly, ADODB.adLockBatchOptimistic

But my question is I need add one Boolean column which is not related to any table to this recordset.
Could I use this: strSql = "Select Fund, Deal, [Deal Name], 0 as flag from tbl_irrdeals â

I heard there is append function: rs.fields.append flag, adboolean but it doesnât work with me.
Anybody know how to add the new column to the recordset??? Thanks a lot