"Shahid Juma" wrote ...
Is there a way for me to determing if a column exists in the table? ex. I
have RS("var"), where RS is a recordset. My code is dynamic but some
tables will have "var" while some won't.
Hello Shahid,
You didn't mention which database you were using, it might not make any
difference, but with SQL Server you could query the system objects to find
out columns that are within a table, I believe you could also get the data
types and lengths.
This article might give you something you want in a very raw manner:
http://www.4guysfromrolla.com/webtech/112900-1.shtml
You could simply iterate through the rs.fields and check for the existance
of your field...
When you pop the variable after the RS you don't need the quotes either, so
you'd have:
RS(strField)
(I believe)..
Regards
Rob