11/8/2026 3:37:37 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 the use of .NET Extensions in SalesLogix version 7 and higher. View the code of conduct for posting guidelines.
|
|
|
|
Creating Unique IDs
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
|
|
|
| |
|
Re: Creating Unique IDs
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.... |
|
|
|
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!
|
|
|
|
|
|
|
|