Write back to table

[jibberski]

I would like to set some flags in my database after the report is run. How would I go about having CR9 connect and execute an insert SQL command at time of execution? Thanks for your time!

 

[synapsevampire]

First learn what type of database is being used, then consider using a Stored Procedure to perform the insert and then return whatever rows the report needs.

Again, this is dependent on the database being used.

You might also be able to do this by using a Add Command object, though I haven't tried that.

Not posting basic technical information such as the database and connectivity used will of course limit how people can respond.

-k

 

[jibberski]

ODBC to MS-SQL server mirroring Timberline Pervasive data. I'm am limited to CR9 pro OEM from Timberline. Thank you for your response.

 

[synapsevampire]

Did you try:

You might also be able to do this by using a Add Command object which does an insert, though I haven't tried that.

-k

 

[jibberski]

The add command works! Thanks again for the help.