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 		Previous revision
sms_error_-_index_out_of_date [2019/03/28 17:07]
smerritt [Explanation of Error] 		sms_error_-_index_out_of_date [2019/06/13 19:37] (current)
smerritt [Explanation of Error]
Line 76: Line 76:
 - Run a dbrebuild scan on the table(s) to see if it needs to be rebuilt. If so, rebuild it - Launch SSLIP and SMS - confirm that the error no longer appears - Run a dbrebuild scan on the table(s) to see if it needs to be rebuilt. If so, rebuild it - Launch SSLIP and SMS - confirm that the error no longer appears
  
-''INSERT INTO "\\server\Cyrious$\SMS\NewData\Order"''+**<font 16px/inherit;;inherit;;inherit>SQL 1</font>**
  
-''SELECT * ''+<code sql> 
 +INSERT INTO "\\server\Cyrious$\SMS\NewData\Adjustments Database" 
 +SELECT * 
 +FROM "\\server\Cyrious$\SMS\Data\Adjustments Database" 
 +</code> 
 + 
 +**<font 16px/inherit;;inherit;;inherit>SQL 2</font>** 
 + 
 +<code sql> 
 +INSERT INTO "\\server\Cyrious$\SMS\NewData\Contact Database" 
 +SELECT * 
 +FROM "\\server\Cyrious$\SMS\Data\Contact Database" 
 +</code> 
 + 
 +**<font 16px/inherit;;inherit;;inherit>SQL 3</font>** 
 + 
 +<code sql> 
 +INSERT INTO "\\server\Cyrious$\SMS\NewData\Customer Database" 
 +SELECT * 
 +FROM "\\server\Cyrious$\SMS\Data\Customer Database" 
 +</code> 
 + 
 +**<font 16px/inherit;;inherit;;inherit>SQL 4</font>** 
 + 
 +<code sql> 
 +INSERT INTO "\\server\Cyrious$\SMS\NewData\Estimate Database" 
 +SELECT * 
 +FROM "\\server\Cyrious$\SMS\Data\Estimate Database" 
 +</code> 
 + 
 +**<font 16px/inherit;;inherit;;inherit>SQL 5</font>** 
 + 
 +<code sql> 
 +INSERT INTO "\\server\Cyrious$\SMS\NewData\Estimate Details Database" 
 +SELECT * 
 +FROM "\\server\Cyrious$\SMS\Data\Estimate Details Database" 
 +</code> 
 + 
 +**<font 16px/inherit;;inherit;;inherit>SQL 6</font>** 
 + 
 +<code sql> 
 +INSERT INTO "\\server\Cyrious$\SMS\NewData\Estimate Modifiers Database" 
 +SELECT * 
 +FROM "\\server\Cyrious$\SMS\Data\Estimate Modifiers Database" 
 +</code> 
 + 
 +**<font 16px/inherit;;inherit;;inherit>SQL 7</font>** 
 + 
 +<code sql> 
 + 
 +INSERT INTO "\\server\Cyrious$\SMS\NewData\GL Database" 
 +SELECT * 
 +FROM "\\server\Cyrious$\SMS\Data\GL Database" 
 +</code> 
 + 
 +**<font 16px/inherit;;inherit;;inherit>SQL 8</font>** 
 + 
 +<code sql> 
 +INSERT INTO "\\server\Cyrious$\SMS\NewData\Order Database" 
 +SELECT * 
 +FROM "\\server\Cyrious$\SMS\Data\Order Database" 
 +</code> 
 + 
 +**<font 16px/inherit;;inherit;;inherit>SQL 9</font>** 
 + 
 +<code sql> 
 +INSERT INTO "\\server\Cyrious$\SMS\NewData\Order Database" 
 +SELECT * 
 +FROM "\\server\Cyrious$\SMS\Data\Order Database" 
 +</code> 
 + 
 +**<font 16px/inherit;;inherit;;inherit>SQL 10</font>** 
 + 
 +<code sql> 
 +INSERT INTO "\\server\Cyrious$\SMS\NewData\Order Details Database" 
 +SELECT * 
 +FROM "\\server\Cyrious$\SMS\Data\Order Details Database" 
 +</code> 
 + 
 +**<font 16px/inherit;;inherit;;inherit>SQL 11</font>** 
 + 
 +<code sql> 
 +INSERT INTO "\\server\Cyrious$\SMS\NewData\Order Modifiers Database" 
 +SELECT * 
 +FROM "\\server\Cyrious$\SMS\Data\Order Modifiers Database" 
 +</code> 
 + 
 +**<font 16px/inherit;;inherit;;inherit>SQL 12</font>** 
 + 
 +<code sql> 
 +INSERT INTO "\\server\Cyrious$\SMS\NewData\Order Modifiers Database" 
 +SELECT * 
 +FROM "\\server\Cyrious$\SMS\Data\Order Modifiers Database" 
 +</code> 
 +</code>
  
-''FROM "\\server\Cyrious$\SMS\Data\Order"''