Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Tuesday, March 19, 2024 
 
View User Profile  

 User Profile - Joe  
Joe
Scribe Software

fjrigjwwe9r1SiteUser:UserBio
fiogf49gjkf0d


Log in to send this member a message!
 


 Joe's Contributions
Joe has contributed 1 comments and 0 articles.
 
Select to view:    
Comment: Re: Creating SalesLogix Table ID Values - The Definitive Guide
fiogf49gjkf0d
Ryan,

I'm a bit confused by the 'Exceptions to be aware of' section in your article re: slx_dbids.
I tried a test to create ids for all of the tablenames and keynames in your list, and I got mixed results (against Slgx 6.2.0.1474). These are the results of getting 100 ids for each item in the list:

"ATTACHMENT" QQF8AA0000DW
"FILEATTACH" QQF8AA0007SY

"USERNOTIFICATION" QQF8AA0007VQ
"USERNOTIFY" QQF8AA0007YI

"AGENTS" QQF8AA00081A
"HOSTTASK" QQF8AA000842

"RESOURCELIST" RQF8AA000000
"RESOURCE" QQF8AA00086U

"USEROPTION" vQF8AA00006J
"USERVIEW" QQF8AA0008CE

"JOINDATA" jQF8AA00009M
"JOIN" >>> error parsing SQL <<<

"PROCEDURES" XQF8AA00002X
"PROCEDURE" QQF8AA0008F6

"SEC_FUNCTIONOWNER" WQF8AA00003W
"FUNCTIONHANDLER" QQF8AA0008HY

It looks like some of the pairs return a different entity and site prefix (RESOURCELIST/RESOURCE), while other pairs both return Custom entity keys (ATTACHMENT & FILEATTACHMENT), and one fails entirely (JOIN).

Any ideas on this? And is this still an issue with 7.0 to your knowledge?

Thanks,
Joe


Author: Joe - 9/28/2006

 


 
 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 | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 3/19/2024 1:51:58 AM