B
Brian Shannon
Need help with some logic:
I have 12 reports that I run nightly currently in a batch file ran through
an external program each on its own command line. If a command line fails
the rest of the commands will not be ran. This was a simple solution. I
don't have error checking or anything in the batch file for I don't want to
learn it.
I am now running the reports with procees.start and using it's error
checking wth process.exitcode to tell me if the report succeeded or failed.
Either way I want to Insert a record notifiying success or failure to my DB.
How should I store the information before inserting? Should I insert each
instance of a report to the DB or store it all in datatable or recordset and
then insert to the DB? If I store it in a recordset/datatable can I execute
one statement for the entire recordset/datatable? I am not sure of my
limitations here!
Thanks
I have 12 reports that I run nightly currently in a batch file ran through
an external program each on its own command line. If a command line fails
the rest of the commands will not be ran. This was a simple solution. I
don't have error checking or anything in the batch file for I don't want to
learn it.
I am now running the reports with procees.start and using it's error
checking wth process.exitcode to tell me if the report succeeded or failed.
Either way I want to Insert a record notifiying success or failure to my DB.
How should I store the information before inserting? Should I insert each
instance of a report to the DB or store it all in datatable or recordset and
then insert to the DB? If I store it in a recordset/datatable can I execute
one statement for the entire recordset/datatable? I am not sure of my
limitations here!
Thanks