5/7/2026 12:47:41 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 writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.
|
|
|
|
Database table fields data source
Posted: 25 Sep 09 12:49 PM
|
Hi All,
I ran the SLX Profiler to see the SQL executed when an activity is completed. One of the statements executed was the following:
UPDATE SITEKEYS SET KEYVALUE = 'A0001LO', MODIFYDATE = '20090925 14:05:20', MODIFYUSER = 'UDEMOA00001H' WHERE SITECODE = 'DEMO' AND KEYTYPE = 6 AND KEYVALUE = 'A0001LN'
Does anyone know the source of KEYVALUE, SITECODE, KEYTYPE and KEYDESC?
KEYDESC doesnt apper in the SQL statement but is a field in the table. |
|
|
|
Re: Database table fields data source
Posted: 26 Sep 09 5:43 AM
|
| Essentially, in order to generate unique keys, the system needs to know how to generate them. For each user/RO/RU the sitekeys is used to generate new keys and each key is generated by type (e.g. a new account ID will be generated by the next key value for the keytype of 1 and for that user's (if they are a remote user, otherwise the system sitecode is used) sitecode ID. it's not something you'll want to play with ! |
|
|
|
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!
|
|
|
|
|
|
|
|