Hello,Is it possible to get SQL query during test execution with the help of the script?For example I have DBTables with Table1, Table2 and Table3. And during test execution I need to write SQL query of these tables to txt file.Thanks

> [...] but all necessary data is encoded so I can't get it from there...Hm-m-m... Good to know. In my simple test everything was in English and thus not encoded. I think that you may check if something simple like Base64 was used to encode data and encode them in this case.

Hello Kateryna,I am unsure of your question. Do you want to write what comes out of the SQL statement to a text file? For instance, suppose your statement is the following:: SELECT * FROM Table1::Then you would want to display the results of that statement into a txt file, correct?

That is not what I'm looking for. I need exact SQL query so my team without TestComplete can compare results and why there was a bug.I have DB checkpoint with a query and result of this query. So how to get a result I know, but how to get a query which give this result I can't understand...

I suppose, you can learn this from your SQL Server. I've googled some info.

But I can alway see this Custom query by editing DBTable, isn't there a way to get it directly from the script without executing. It should be saved somewhere...

Getting SQL Query in the script | SmartBear Community

AlexKaras
Champion Level 3
13 years ago
> [...] but all necessary data is encoded so I can't get it from there...

Hm-m-m... Good to know. In my simple test everything was in English and thus not encoded. I think that you may check if something simple like Base64 was used to encode data and encode them in this case.
smcmickle
Contributor
13 years ago
Hello Kateryna,

I am unsure of your question. Do you want to write what comes out of the SQL statement to a text file? For instance, suppose your statement is the following::

SELECT * FROM Table1

::

Then you would want to display the results of that statement into a txt file, correct?
Kateryna
Contributor
13 years ago
That is not what I'm looking for. I need exact SQL query so my team without TestComplete can compare results and why there was a bug.

I have DB checkpoint with a query and result of this query. So how to get a result I know, but how to get a query which give this result I can't understand...
TanyaYatskovska
Alumni
13 years ago

I suppose, you can learn this from your SQL Server. I've googled some info.
Kateryna
Contributor
13 years ago
But I can alway see this Custom query by editing DBTable, isn't there a way to get it directly from the script without executing. It should be saved somewhere...
Kateryna
Contributor
13 years ago
Any ideas? I realy need an answer...
TanyaYatskovska
Alumni
13 years ago

Hi Kateryna,

Are you talking about the DBTable.ConnectionString property?
Kateryna
Contributor
13 years ago
That's not what I meant. For example, when you add checkpoint to your keyword test you can select custom query to the db.That query I need to get from the script during test execution.
TanyaYatskovska
Alumni
13 years ago

Hi Kateryna,

I see. A DBTable checkpoint allows using custom queries, but do not allow getting/modifying the query from the script. So if you need to verify results of a dynamic SQL query, you will have to implement the needed data retrieval and data comparison code manually. To learn how to work with databases in TC, see the"Working With Databases" article.

BTW, we have a corresponding suggestion in our DB and your request has increased its rating.
Kateryna
Contributor
13 years ago
Thank you for your reply, I've already seen that article. I got the results of the query and wrote them to the file, but without initial query this result it pointless... so I guess I'll wait for new updates in TC...