I am trying this database checkpoint with statements like select ,delete,update.
But everytime select statements work fine and other statements cause errors. Does that mean that only select statements are allowed and we cannot do delete,update operations using database checkpoints?
I have found that any sql that will work on your database can be run by winrunner, certainly Select, delete and update works. However when I do an update statement the tls function does return a -1, same with the delete statement. However when I look in the db the statement has worked, so I ignore the fact that I get -1 back from the functions.
I have found that I receive a -1 on commands that aren't supposed to return any rows to cycle through when using the db_execute_query command which should be used when trying to execute SQL statements against the database you have (instead of trying to use a database checkpoint to execute the SQL commands)