The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Insert HistoryIDs?
Posted: 16 Nov 09 2:22 PM
|
Hello -
We are developing a new reporting process. Excel reports are being emailed from Reporting services via data-driven subscriptions. The report is sent from an onclick event in an MS Access (2000) application that uses the SLX database for source. We want to update the SLX History table when the report is emailed. We can call a stored procedure to insert the info into the table, but what about about generating the IDs for the History table? If auto-increment is activated is it necessary to call SLX_BDIDS? (SQL 2005, SLX 7.2) What are your suggestions? (the easier the better!)
thanks!
j. |
|
|
|
Re: Insert HistoryIDs?
Posted: 16 Nov 09 2:56 PM
|
| If Auto Increment is turned on for the History table, and as long as you are writing the data via the SLX OLEDB Provider you don't have a need to call the function to generate IDs. |
|
|
|
Re: Insert HistoryIDs?
Posted: 16 Nov 09 4:00 PM
|
Thanks, Raul!
To clarify:
MS Access connects to SQL via SLX OLEDB provider
Execute SQL sproc (insert into table)
Close SLX OLEDB connection
Are there any major reasons for not having auto increment enabled for the history table? It is currently not enabled, but I don't know the reasoning behind this setup.
j.
|
|
|
|
Re: Insert HistoryIDs?
Posted: 16 Nov 09 4:10 PM
|
As far as I know, it just hasn't been turned on.
The SLX Application on its own doesn't rely on the auto-increment, so no need for it to be turned on. Never the less, you could turn it on as needed. |
|
|
|