I have webtable with 9 columns like:
Name Net NetValue Cash1 Cash2 Cash3 Blank Person1 Person2
Values for these columns are being fetched from a table in Database.How should I compare these values with backend .what approach shouldI adopt
Get the values from the webtable(by using GetCellData()) and stored in array variable.
Get the values from the database this values also stroed in second array varible
compare both array values by using control statements
for i=0 to Ubound(firstarraysize)
Comparison logic would depend on the size of data.
You can look at the approach suggested by Kishore,
Plan to write data into other data sources and compare.
Frame SQL queries based on the data in the webtable.
-- Here to Learn and share ---