4/20/2024 1:34:57 AM
|
| |
| 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 designing applications to work with SalesLogix. View the code of conduct for posting guidelines.
|
|
|
|
Cannot always see external table
Posted: 01 Jun 06 9:08 AM
|
generico cialis prezzo tadalafil generico sandoz fiogf49gjkf0d I created a simple table in my SalesLogix DB using SQL Query Analyzer. When I Terminal Serve to the SalesLogix app server and open the Client, I can see my table when I try to create a local join in Query Builder from Account.AccountID to my table.
However, if I run the Client from my local computer and log in as the same (ADMIN) user to the same SalesLogix DB, I do not see my table when I try the same local join.
Is there something I need to do here, or am I attempting the impossible?
Here's the script for my simple table.
CREATE TABLE [Jimtest2] (
[ACCOUNTID] [STANDARDID] NOT NULL ,
[FIELD2] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
CONSTRAINT [PK_JIMTEST2] PRIMARY KEY NONCLUSTERED
(
[ACCOUNTID]
) WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
|
|
|
|
Re: Cannot always see external table
Posted: 01 Jun 06 5:10 PM
|
bentelan effetti collaterali bentelan fiale read here fiogf49gjkf0d and you never will...
SalesLogix REQUIRES you add your new tables through their DBManager tool. SLX is self-centric in that it calls to itself to find out what tables and fields exist... 
Take a look at the SECTableDefs table. New DB entities must be registered here.
c |
|
|
|
Re: Cannot always see external table
Posted: 02 Jun 06 5:16 AM
|
vivatrol low dose naltrexone alcohol link fiogf49gjkf0d Yeah, we even tried populating sectabledefs with our table and fields and it still didn't see it. Is there any other place where SLX keeps table info? I was just making up the sectabledefs.seqcode number, making sure that it was unique. Could it be that SLX keeps the "next available seqcode" number somewhere and that I was just confusing it? |
|
|
|
Re: Cannot always see external table
Posted: 02 Jun 06 7:42 AM
|
fiogf49gjkf0d I am not sure of all places SLX keeps and uses this information. However, rebuilding your table in DBManager and porting data to the new table should be a short and easy task. Oh, don't forget to repop the join table too.
BTW: If it is any consolation, I think everyone here has learned this particular lesson the hard way..
c
I have not failed 10,000 times, I have successfully found 10,000 ways that do not work.
-- Thomas A.Edison |
|
|
|
Re: Cannot always see external table
Posted: 05 Jun 06 10:00 AM
|
am i pregnant quiz early signs of pregnancy do i have a uti or am i pregnant quiz go fiogf49gjkf0d SLX keeps data in the sectabledefs, resynctabledefs and in an xml plugin in the plugin table. If you add the data properly to the sectabledefs and resynctabledefs you can then delete the xml plugin (It has XMLPLUGIN in the pluginID column). The next time you open SLX it should rebuild the XML schema and build in your new table. Some versions of SalesLogix required you to add an additional table through the workgroup admin beforte the XML file correctly got rebuilt, so depending on your version you may need to do that. The procedure for that was to delete the xml plugin, create an new temporary table, apply the changes. That recreates the XML, then you can delete that new temp table. You may also need to add data to the JoinData table.
I would recommend for simplicity not to create tables outside of the SLX interface, but if you must than there should be a way to get SLX to recognize it. |
|
|
|
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!
|
|
|
|
|
|
|
|