8/18/2025 4:28:39 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
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!
Forum to discuss general T-SQL questions and help with queries related to SalesLogix data. View the code of conduct for posting guidelines.
|
|
|
|
New keyvalue
Posted: 02 Jan 08 3:27 PM
|
I need to be able to create a new accountID, using Store Procedure.
I undertand I can do this using the script, but we need to do that when exporting data from file.
We need to add 1 to the KeyValue fiel, but I like to know the logic to do that and not crash with SalesLigic tool.
thanks |
|
|
|
Re: New keyvalue
Posted: 02 Jan 08 5:35 PM
|
Stored procedures are not supported in SLX, as they break synchronisation. There is no way for you to generate 'proper' SLX IDs from within your stored proc.
If you want to script an import into SLX, you can do this by connecting to the SLX database using the SLX OLEDB provider and calling the SLX_DBIDS function (exposed by the provider) to generate the IDs. This is not a job for someone who does not understand the SLX entity model, as several tables need to be populated to make an account usable and consistent when accessed by the sales client.
There are some third party tools available that will make SLX imports easier - Inaport and Scribe come to mind.
PP |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|