Hi,I am using dbcheckpoint. I want to change the query for every iteration.So I am using the following code :SQL=DbTable("DbTable_2").GetTOProperty("Source")DbTable("DbTable_2").SetTOProperty "Source", datatable.Value("Query")NewSQL=DbTable("DbTable_2").GetTOProperty("Source")SQL=NewSQLmsgbox SQLDbTable("DbTable_2").Output CheckPoint("DbTable_2")The above code gives me the new query every time for each iteration. However the checkpoint is failing.Any suggestions

Interview Candidate
Oct 19th, 2006
1
1949

Showing Answers 1 - 1 of 1 Answers

garvin

Nov 1st, 2006

Create your database checkpoint first
DbTable("DbTable").Check CheckPoint("DbTable")
Just above your check point you can add the following
DBTable("DbTable").SetTOProperty "source", "SELECT * FROM table WHERE table.column= " & DataTable.Value("ID", dtGlobalSheet)
You can define your GlobalSheet to pull different data for each interation there for doing your database check point with a different set of records