10 years ago
Compare Excel-Data with data from a DBTable
Hi,
i am new with Testcomplete and need support for this topic.
My Testproject so far:
1. prepared data in a excel-file
2. created a Keywordtest with a Data-Driven Loop , where i process the data from the excel-file
Target:
I want to compare a column value (excel) which i use in the data loop with column values of a database_table in the background.
In TC you can create DBTable Objects.
Which is the best way to compare data for these topic ?
It is possible in TC, when i create a SQLStatement (DBTable-Object)
to have direct access to a column value from the excel-file, for a more specific query ?
It would be nice, if somebody have a solution for me (Links,Articles,Posts,Guides...)
Ralf
i am new with Testcomplete and need support for this topic.
My Testproject so far:
1. prepared data in a excel-file
2. created a Keywordtest with a Data-Driven Loop , where i process the data from the excel-file
Target:
I want to compare a column value (excel) which i use in the data loop with column values of a database_table in the background.
In TC you can create DBTable Objects.
Which is the best way to compare data for these topic ?
It is possible in TC, when i create a SQLStatement (DBTable-Object)
to have direct access to a column value from the excel-file, for a more specific query ?
It would be nice, if somebody have a solution for me (Links,Articles,Posts,Guides...)
Ralf