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!
|
|
SLX_DBIDS from Another Stored Procedure
Posted: 14 Feb 08 10:22 AM
|
| Can i able to call SLX_DBIDS from within my stored procedure? or Is there any other way i can generate SLX ID from my stored procedure? |
|
|
|
Re: SLX_DBIDS from Another Stored Procedure
Posted: 14 Feb 08 10:31 AM
|
SLX_DBIDS is not a real stored procedure. It is hard coded into the provider like all of the SalesLogix (built-in) "stored procedures"
Although all of these built-in "functions" are called like an SP, stored procedure is really a bad name for them.
The only way you can "call" them is via a SalesLogix Provider connection.
There's a bunch of postings in these forums about how to use SLX_DBIDS..
--
RJLedger - rjlSystems |
|
|
|
Re: SLX_DBIDS from Another Stored Procedure
Posted: 14 Feb 08 10:44 AM
|
| Thanks Bob. I am writing a stored procedure and I want to insert records into salesorder and salesorderitems table. Does any one know how to generate ID from stored procedure? |
|
|
| |
| |
|
Re: SLX_DBIDS from Another Stored Procedure
Posted: 14 Feb 08 3:35 PM
|
| The correct way of generating IDs is through using the SLX_DBIDs routine via a connection to the database using the SLX OLEDB Provider. Use DTS/SSIS to do this and it's not that hard. Anything else is a hack. |
|
|
|