wynfranc100
4 years agoOccasional Contributor
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