Forum Discussion

marroth_ds's avatar
marroth_ds
Occasional Contributor
12 years ago

Creating database checkpoint by script

Hi, I'm looking for a way to create a database checkpoint by script which should use a custom SQL query. Because this way I could use my variables in the SQL query and to set which database to u...
TanyaYatskovska's avatar
TanyaYatskovska
Icon for Alumni rankAlumni
12 years ago

Hi Martin,


 


You can change the connection string, login and password at run time via the DBTable object's properties. However, SQL queries cannot be changed dynamically. There is a suggestion to implement this feature in our DB - I've increased its rating. 


 


Currently, if you need to execute dynamic SQL statements, I recommend that you use one of the approaches described in the "Working With Databases" article.