Micro Focus QTP (UFT) Forums

Hi,

Assume in the database we have a table named "X".
I have Created or added a new column to the table "X".
Now I want to insert a check point to ensure the Newely created column is added to the table.

Could some one let me know your comments.
Is it possible?????

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.