01-16-2008, 11:41 AM
Two ways,
1) check for the column --- select xyz from table if column exist it will show you the data else it will raise an error. Use err object to raise and capture the error ( if it occurs)
2) Other method can be to download the table before and after inserting the column in excel and use getparametercount to get the no of columns each time. If diff is 1 then the column is inserted.
I would prefer the 1st method. 2nd, In my opinion is not efficient.
1) check for the column --- select xyz from table if column exist it will show you the data else it will raise an error. Use err object to raise and capture the error ( if it occurs)
2) Other method can be to download the table before and after inserting the column in excel and use getparametercount to get the no of columns each time. If diff is 1 then the column is inserted.
I would prefer the 1st method. 2nd, In my opinion is not efficient.
Want to fast track your QTP/UFT Learning? Join our UFT Training Course