View User Profile

Comment: Re: Creating SalesLogix Table ID Values - The Definitive Guide
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 \|

page cache (param): 11/22/2024 4:53:57 PM