/
Adding a column to a View Table


Adding a column to a View Table

Adding a column to a View Table

Issue/Symptom/Question

How to add a column to a View Table

Applies To

PLEdit. GoldView, Golden

Resolution/Fix/Answer

  • Connect to the customer's database through Golden.
  • All the tables in the Customer's database can be seen by going to: Tools → GoldView.

  • However, to update the tables one needs to go to: Tools → PLEdit. Search and click on the table that needs to be updated.

  • Within the parenthesis in the 'View' statement add the name one wants to identify the column with.
  • In the 'Select' statement add the column name.

  • Once the necessary updates have been made, click on 'Code' and then 'Compile'.

 

  • To check, if the changes are reflected correctly, run and check the relevant script in Golden. 



Related content

Load Work Orders into PENTA via Table Interface Method
Load Work Orders into PENTA via Table Interface Method
More like this
Quick way to move columns in the Dispatch Grid
Quick way to move columns in the Dispatch Grid
More like this
Can we create custom tables in our Penta Oracle Database?
Can we create custom tables in our Penta Oracle Database?
More like this
How do I add a column that calculates Gross Profit for Jobs to Date in the Margin Analysis Report?
How do I add a column that calculates Gross Profit for Jobs to Date in the Margin Analysis Report?
More like this