Forum Discussion
SmartBear_Suppo
Alumni
13 years agoHi!
So here's how I interpret what you're trying to do. Please correct me if I'm wrong.
You're reading from a database (using a datasource test step), and at some point during your test case, you're generating an email address (or does it come from somewhere else?). This email address is stored as a test case-level property. Then, finally, you want to insert this new email address into the same database you read from to begin with. Is that correct?
You can do this by, in your DataSink test step, running the following query:
This will use the property you have stored on the TestCase and use it in the query.
If I've misunderstood anything, or if this doesn't solve your issue, please let me know and I'll happily assist further.
Regards,
Arian
SmartBear Sweden
So here's how I interpret what you're trying to do. Please correct me if I'm wrong.
You're reading from a database (using a datasource test step), and at some point during your test case, you're generating an email address (or does it come from somewhere else?). This email address is stored as a test case-level property. Then, finally, you want to insert this new email address into the same database you read from to begin with. Is that correct?
You can do this by, in your DataSink test step, running the following query:
INSERT INTO data_table_name ('EMAIL_ACTUAL') VALUES (${#TestCase#name_of_the_email_property})This will use the property you have stored on the TestCase and use it in the query.
If I've misunderstood anything, or if this doesn't solve your issue, please let me know and I'll happily assist further.
Regards,
Arian
SmartBear Sweden