Advertisement
EmilianoRoldanR

Error al pagar agrupado domicilio SoftRestaurant 9.0PRO

Aug 24th, 2019
395
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.60 KB | None | 0 0
  1. -- Error al pagar agrupado domicilio SoftRestaurant 9.0PRO
  2.  
  3. --Consulta 1
  4. ALTER TABLE tempcheques ADD cuentapagadaprocesada bit DEFAULT NULL
  5.  
  6. --Consulta 2
  7. IF NOT EXISTS(SELECT * FROM syscolumns AS sc INNER JOIN sysobjects AS so ON sc.id=so.id AND sc.name='paymentmethod_id' AND so.name='tempcheques')
  8. BEGIN
  9. ALTER TABLE tempcheques ADD paymentmethod_id INT NOT NULL DEFAULT -1
  10. END
  11.  
  12. IF NOT EXISTS(SELECT * FROM syscolumns AS sc INNER JOIN sysobjects AS so ON sc.id=so.id AND sc.name='paymentmethod_id' AND so.name='cheques')
  13. BEGIN
  14. ALTER TABLE cheques ADD paymentmethod_id INT NOT NULL DEFAULT -1
  15. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement