Sign Up Now!Log In
hamzajosh 3/21/2018 9:56:11 AM

Add new column to existing table and screen

I have a custom screen created in GP using a custom table. I want to add a new field/column to the screen/table in Dexterity. What's the best way to do this?

I have tried adding the field in Dex, Adding it to the table and adding the column in SQL. As soon as I add the field to table in Dex, the screen stops working. I remove the field in Dex leaving column in SQL and screen still works fine. Someone told me to remove the column from SQL, add it in Dex and run the program and it will add the column to SQL and that does not work either. I am stuck and cannot find instructions for this anywhere. I have gone thru all the dex manuals and still cannot find instructions.


Version: All
Section: Dexterity, Dynamics GP