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!

Architect Forums - SalesLogix Scripting & Customization
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.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Scripting & Customization | New Thread

View: Search:

Author

Thread: SLX 6.2.0 Saleslogix thinks one of MY custom tables belongs to it

Adrian Zawierka
Posts: 6

SLX 6.2.0 Saleslogix thinks one of MY custom tables belongs to it Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 08 Jul 08 11:31 AM

The DB Manager seems to think one of my custom tables is one of Saleslogix standard tables and will NOT let me add fields and make any other changes normally allowed to custom tables. How do I reclaim the table from Saleslogix?

I do not have the option to upgrade from version 6.2.0 due to very heavy customisation.

I have checked that the field USERDEFINED inside the table SECTABLEDEFS is set to 'T' for all my fields on that table

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: SLX 6.2.0 Saleslogix thinks one of MY custom tables belongs to it Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 10 Jul 08 7:43 PM

Have you enabled field level security to it? If so, it locks the table and does not allow further changes to it.

[Reply][Quote]

Adrian Zawierka
Posts: 6

Re: SLX 6.2.0 Saleslogix thinks one of MY custom tables belongs to it Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 11 Jul 08 3:08 AM

No Field Level Security is Not Enabled on that table, we have never enabled it on any of our custom tables.

I have tried bundling the table and installing the bundle on a copy of the SLX database but the new copy also ended up in the same state.

[Reply][Quote]

RJ Samp
Posts: 973

Re: SLX 6.2.0 Saleslogix thinks one of MY custom tables belongs to it Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 22 Jul 08 1:12 PM

UPDATE SECTABLEDEFS SET USERDEF = 'T' WHERE TABLENAME = 'MyCustomTableName'

Also the RESYNCTABLEDEFS fields must match the database fields....exactly. No more, no less.

[Reply][Quote]

Adrian Zawierka
Posts: 6

Re: SLX 6.2.0 Saleslogix thinks one of MY custom tables belongs to it Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 23 Jul 08 7:15 AM

Have already checked both those points and everything there is set correctly.

[Reply][Quote]

RJ Samp
Posts: 973

Re: SLX 6.2.0 Saleslogix thinks one of MY custom tables belongs to it Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 23 Jul 08 2:10 PM

Usually SLX won't let you edit your own custom table if any field is in or NOT IN Resynctabledefs that matches the Field Name, Field Order (vs Field Offset), datatype/length. So if your DB has 12 fields, then Resynctabledefs must have 12 fields....all of the same DB type, all the same length, etc.

Check the Join Data to see if you have a global join in there.....

push comes to shove.....

create a temp table, put the data in there, drop the table in SLX, create in SLX, move the data back from the temp table.

[Reply][Quote]

Adrian Zawierka
Posts: 6

Re: SLX 6.2.0 Saleslogix thinks one of MY custom tables belongs to it Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 24 Jul 08 3:00 AM

In 6.2.0 ResyncTableDefs only has one entry per table for ALL tables both standard and custom and NOT one per field.

The Table that has one entry per field is SECTABLEDEFS and this does have the correct entries in it.

Push came to shove and I recreated the table from scratch

I have control of my table back

[Reply][Quote]

RJ Samp
Posts: 973

Re: SLX 6.2.0 Saleslogix thinks one of MY custom tables belongs to it Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 24 Jul 08 11:37 AM

Quote:

Originally posted by Adrian Zawierka

In 6.2.0 ResyncTableDefs only has one entry per table for ALL tables both standard and custom and NOT one per field.

The Table that has one entry per field is SECTABLEDEFS and this does have the correct entries in it.

Push came to shove and I recreated the table from scratch

I have control of my table back

yea, my problem with the typo. ReSyncTableDefs is 1 per TABLE, SecTableDefs is 1 per SLX recognized field. The fieldoffset in SecTableDefs must sort out to the Field Order in the database.....so if MyTable.AccountID fieldoffset = 136 and it's the 2nd field in the database....then one and only one field in that table must have a fieldoffset number < 136.

Glad you got the table 'back'.

[Reply][Quote]

Page 1 of 1

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!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 8/24/2025 6:24:52 PM