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!

External Development Forums - SalesLogix OLEDB Provider
Forum to discuss using the SalesLogix OLE DB Provider from external applications (including usage of built-in provider procedures). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix OLEDB Provider | New Thread

View: Search:

Author

Thread: Identity column for SLX Tables

NagaratnaPandi
Posts: 111

Identity column for SLX Tables Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 25 May 09 4:39 AM

Hi all,
I heard that, we can implement an identity column for saleslogix tables id field, so that the id will be generated automatically instead of creating new id whenever we are inserting a new record.
Is it true?
If so, is there any drawbacks when we enable that (like synchronization etc).
How can i enable that.
What will be the seed and increment value for the identity column.
Please let me know.

[Reply][Quote]

Phil Parkin
Posts: 819

Re: Identity column for SLX Tables Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 25 May 09 7:56 PM

It is kind of true. This is not a SQL Server identity field though - you have no control over seed and increment.

To check and/or enable the feature, start the SLX DB Manager program, navigate to the table you are interested and check the 'Auto Increment' flag for the ID. Save changes and then stop and start SLX services on your SLX server.

From then on, you will be able to INSERT rows to that table without specifying the ID, which will be generated by the SLX OLEDB Provider. This provider also takes care of sync for you.

You must use an SLX OLEDB connection for this feature to work - straight inserts via SQL will not generate the ID field, regardless of the auto increment setting.

[Reply][Quote]

NagaratnaPandi
Posts: 111

Re: Identity column for SLX Tables Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 25 May 09 11:19 PM

Thanks Phil.

[Reply][Quote]

Page 1 of 1

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!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/25/2024 9:12:04 PM