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!

Architect Forums - SalesLogix .NET Extensions
Forum to discuss the use of .NET Extensions in SalesLogix version 7 and higher. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix .NET Extensions | New Thread

View: Search:

Author

Thread: Creating Unique IDs

Raj
Posts: 1

Creating Unique IDs Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 21 Jul 10 12:13 PM

Hi,
I am new to Saleslogix. We are using Saleslogix 7.2. I want to create .NET DLL to create unique Ids for the table. I saw some samples and they are using SLXDB_ID. Is it must to use this procedure to generate unique ids? If yes, How to add that procedure into .NET Class. If not, what is the best way to generate?

Thanks

[Reply][Quote]

Raul A. Chavez
Posts: 1300

Re: Creating Unique IDs Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 21 Jul 10 3:37 PM

Check the Articles under OLEDB Provider (left bar).

One of the best will be this one:

http://www.slxdeveloper.com/page.aspx?action=viewarticle&articleid=87

[Reply][Quote]

RJ Samp
Posts: 973

Re: Creating Unique IDs Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 03 Aug 10 8:35 AM

If this is on the LAN side...table name Abbreviation & cSTR(Timer) kinds of stuff always has worked for me....you need a 12 character unique string for the TABLE......

the POSTALCODE table: "USZIP0" + "5 digit postal code" + 0,1,2,3....for multiple towns\city per zip. it's a free ID with no overhead of hitting SYS Key Gen table....

I'll give you all a hint.....on a one to many table the ParentID is ALWAYS unique for the first record related to any parent......

Parent Table ACCOUNT keyfield: ACCOUNTID= 'A1'
Child Table AARDVARK table keyfield: AARDVARKID = 'A1', ACCOUNTID (the parent) = 'A1'

works every time.....it's a free ID with no overhead of hitting SYS Key Gen table....

[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 8:32:08 PM