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!
|
|
Adding New Fields to a Table
Posted: 03 Jul 07 8:30 AM
|
| What are the rules for adding a new field to a table through the Database Manager? I need to add a new field to a table but the option is not available on this table. The table is a custom table and not one of the Saleslogix standard tables. Will someone please let me know why I wouldn't be able to a field to a table? Thank you. |
|
|
|
Re: Adding New Fields to a Table
Posted: 05 Jul 07 10:22 AM
|
| I have run into this in the past, and it is usually due to a misalignment between fields and field types on what is in the database verses what is in the SecTableDefs and ReSyncTableDefs table. Because I don't have a lot of experience with this, I can't be more specific. Maybe someone else on this board can assist, but for now - look at those tables and see what you have in the database. It's bound to be something like that. Also, the main thing preventing you from making changes is the field called UserDef in the SecTableDefs (I think). You will have to play with it, but that's where I would start. |
|
|
|
Re: Adding New Fields to a Table
Posted: 06 Jul 07 1:22 PM
|
This is from memory, so appologixe if I make a slight syntax error...
update sectabledefs set userdefined = 'T' where tablname = 'YourtableName'
In order to add new columns to any SLX table prior to SLX v7.0, all columns in the table must be set to UserDefined = 'T' as the DB Manager then assumes that the table itself must be a user defined table and thus it must be OK for you to modify the table.
It would be better if there were a UserDefined column in the resynctabledefs table where all SLX tables are defined (a feature request has been submitted).
As of SLX v7.0 we are now able to add columns to the stock SLX tables as well.
|
|
|
|
Re: Adding New Fields to a Table
Posted: 06 Jul 07 1:55 PM
|
| I would like to thank you both for the ideas. Although I have recreated the table and added the data back into it. Now that I have added the table it allowed me to create a new field. |
|
|
|
Re: Adding New Fields to a Table
Posted: 09 Jul 07 6:17 AM
|
Did you save the old table to see what the differences were? There might just be one little thing different that is not yet in the new table. Did the old table have triggers or anything that might not be supported by the DB manager (I don't know for sure)?
John G. |
|
|
|
Re: Adding New Fields to a Table
Posted: 09 Jul 07 8:57 AM
|
| No I didn't go back and research the differences in the tables. If I get some time I will take a look. Also there was nothing special about the table. |
|
|
|