This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
normal_processing_steps [2021/02/02 20:38] dlm [Troubleshooting] |
normal_processing_steps [2021/02/02 20:43] dlm [Suggested Ways to Add a Column to a Schema That Already Exists] |
||
---|---|---|---|
Line 20: | Line 20: | ||
| Connection does not exist | Verify the correct login and password are entered in the SQL Options tab of the [[novo_motion_schema_editor|NovoMotion Schema Editor]]. If they are, verify the datasource is set up. If it is, verify the login has permission to the database on the SQL server. | | | Connection does not exist | Verify the correct login and password are entered in the SQL Options tab of the [[novo_motion_schema_editor|NovoMotion Schema Editor]]. If they are, verify the datasource is set up. If it is, verify the login has permission to the database on the SQL server. | | ||
| Invalid Object Name error | Verify the database name on the SQL options tab of the [[novo_motion_schema_editor|NovoMotion Schema Editor]] is fully qualified i.e dbo.filename | | | Invalid Object Name error | Verify the database name on the SQL options tab of the [[novo_motion_schema_editor|NovoMotion Schema Editor]] is fully qualified i.e dbo.filename | | ||
+ | |||
+ | |||
+ | ====Suggested Ways to Add a Column to a Schema That Already Exists==== | ||
+ | |||
+ | * In SQL, execute a new query against the main database: | ||
+ | ALTER TABLE dbo.TABLENAME | ||
+ | ADD New_field varchar(20) | ||
+ | (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 /> | ||
+ | :*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], | ||
+ | :*On Windows click the " | ||
+ | :*Verify there are no records in BCI.QUARANTINE that were created between the alter table and schema editor change steps. <br /><br /> | ||
+ | : | ||
+ |