Differences

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

--- normal_processing_steps [2021/02/02 20:43]
dlm [Suggested Ways to Add a Column to a Schema That Already Exists]
+++ normal_processing_steps [2021/02/05 21:08]
dlm
@@ Line 1: / Line 1: @@
+[[main_page|NovoMotion Outbound Main Page]]
 ====== 'Normal' Processing Steps ======
 \\
@@ Line 25: / Line 28: @@
   * In SQL, execute a new query against the main database:
-ALTER TABLE dbo.TABLENAME
+<code>ALTER TABLE dbo.TABLENAME
-ADD New_field varchar(20)
+ADD New_field varchar(20) </code>
-(This step can also be done by right-clicking on the SQL table and using Design.)
+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 [[novo_motion_schema_editor|NovoMotion Schema Editor]], add the new column with the exact same name – (New_field in previous step).
-:*Save the schema and generate the code, Uncheck ‘Generate Primary Table’.  <br /><br />
+  * Save the schema and generate the code, Uncheck ‘Generate Primary Table’.
-:*On UNIX copy to clipboard, paste into SQL, verify the first thing is [Use…_TRIGGER], and execute on SQL. <br /><br />
+  * On UNIX copy to clipboard, paste into SQL, verify the first thing is [Use…_TRIGGER], and execute on SQL.
-:*On Windows click the "Execute on SQL Server" button. <br /><br />
+  * On Windows click the "Execute on SQL Server" button.
-:*Verify there are no records in BCI.QUARANTINE that were created between the alter table and schema editor change steps. <br /><br />
+  *Verify there are no records in BCI.QUARANTINE that were created between the alter table and schema editor change steps.
-:*LOAD.BCI.ACTION for any records that need the new column. <br /><br />
+  *[[load_bci.action|LOAD.BCI.ACTION]] for any records that need the new column.
+\\
+[[main_page|NovoMotion Outbound Main Page]]

NovoRoi Systems DokuWiki

User Tools

Site Tools

Differences

Page Tools