Update the Project's temp variable of type DB Table
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Update the Project's temp variable of type DB Table
Hi.
Is there a way to update the DB table type field (in the Project Variable Temporary variable section) with its connection string information using a script?
{Query: "whatever cmd'"; connection string: "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=myId;Initial Catalog=myDB;Data Source=localhost"}
I'm getting type mismatch if I assign that value to Project.Variables.MyTable which is of type Data Table (initial value is {No Table})
Thanks
- Labels:
-
Script Tests
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Any takers and suggestions?
Thanks!
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @wynfranc100 -
Have you considered writing a short script to work with your DB table instead of using a temp Project Variable?
Also - the type of variable should be a string I believe (if you are looking to use in place of the connection string) but if you could provide an image/script it would be helpful to better understand your issue.
Thanks,
Emma
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Emma!
Hi @wynfranc100! Are you still facing this issue? Please provide the details Emma requires to keep investigating.
In case you found a solution, feel free to share it with other community members!
Sonya Mihaljova
Community and Education Specialist
