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!
|
|
Create New Field is not Enabled
Posted: 19 Jan 07 12:25 AM
|
fiogf49gjkf0d When I right click on Database Manager, the ‘Create New Field’ is not enabled. We use Saleslogix V6.2 and we have a premier license. Any idea why? I tried to add new fields to a customised table. Many thanks.
April |
|
|
|
Re: Create New Field is not Enabled
Posted: 19 Jan 07 1:19 AM
|
fiogf49gjkf0d Which table are you trying to add a field to? The base tables (in 6.2) do not allow you to add new fields to them. You have to instead create a new 1-1 child table from the base table and add fields to that. |
|
|
|
Re: Create New Field is not Enabled
Posted: 21 Jan 07 3:36 PM
|
fiogf49gjkf0d It is not a system table. It is a user defined table created for my employer by our previous business partner. |
|
|
|
Re: Create New Field is not Enabled
Posted: 21 Jan 07 3:45 PM
|
fiogf49gjkf0d IIRC if field lever security has been enabled on the table then it will lock it from adding additional fields as well. The fact that the table is "locked" means that it is no longer seen as a user table, which only reason I can think of that would cause this is that field level security is on or someone set it to not be a user table - which is not very likely.
You can force the table to be seen as a user table, and therefore editable by executing the following query
update sysdba.sectabledefs set userdef = 'T' where tablename = 'MYTABLENAME'
Of course, huge disclaimer applies here. I don't have any idea what ipact, if any, that this would have on field level security. |
|
|
|
Re: Create New Field is not Enabled
Posted: 21 Jan 07 3:55 PM
|
fiogf49gjkf0d Thank you Ryan. I'd better create a new 1-1 child table. I can't afford any complication it may occur. The table I tried to add fields stores products of our design projects. We also have few remote offices. |
|
|
| |
|
Re: Create New Field is not Enabled
Posted: 22 Jan 07 7:54 AM
|
fiogf49gjkf0d I think I've seen this happen as well when a column is created outside of SLX, directly in SQL Server. Are there any fields added outside of SalesLogix?
Jeff
|
|
|
|
Re: Create New Field is not Enabled
Posted: 22 Jan 07 11:48 AM
|
fiogf49gjkf0d If the columns in the database table do not match the columns in SECTABLEDEFS (which is what is displayed in the database manager) then the Database Manager will 'lock' down the table.
Also if the developer locked down the table for any reason (like using the SLX Import Wizard, which didn't like unlocked tables 'back in the day').....then the table will not be open for modifying tables.
UPDATE SECTABLEDEFS SET USERDEF = 'T' where TABLENAME = 'whatever'
is perfectly acceptable.
Their is no field level security for 1:many tables......
but the SECPROFILES may be off...
|
|
|
| |
|