User Tools

Site Tools


normal_processing_steps

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision Both sides next revision
normal_processing_steps [2021/02/02 20:40]
dlm [Troubleshooting]
normal_processing_steps [2021/02/02 20:43]
dlm [Suggested Ways to Add a Column to a Schema That Already Exists]
Line 25: Line 25:
  
   * In SQL, execute a new query against the main database:   * In SQL, execute a new query against the main database:
-::ALTER TABLE dbo.TABLENAME +ALTER TABLE dbo.TABLENAME 
-::ADD New_field varchar(20)     +ADD New_field varchar(20)     
-:::(this step can also be done by right-clicking on the SQL table and using Design.)<br /><br />+(This step can also be done by right-clicking on the SQL table and using Design.)   
 :*In the Novoschema editor, add the new column with the exact same name – (New_field in previous step). <br /><br /> :*In the Novoschema editor, add the new column with the exact same name – (New_field in previous step). <br /><br />
 :*Save the schema and generate the code, Uncheck ‘Generate Primary Table’.  <br /><br /> :*Save the schema and generate the code, Uncheck ‘Generate Primary Table’.  <br /><br />
normal_processing_steps.txt · Last modified: 2021/02/09 15:37 by dlm

DokuWiki Appliance - Powered by TurnKey Linux