f_setdbswitch.srf 964 B

1234567891011121314151617181920212223242526272829303132333435
  1. $PBExportHeader$f_setdbswitch.srf
  2. global type f_setdbswitch from function_object
  3. end type
  4. forward prototypes
  5. global subroutine f_setdbswitch ()
  6. end prototypes
  7. global subroutine f_setdbswitch ();//int ll
  8. //select switch_chkflag into :ll from sys_DB_version;
  9. //Messagebox('1',string(ll))
  10. update sys_DB_version set switch_chkflag=1 using sqlca;
  11. //if sqlca.sqlcode<>0 then
  12. // Messagebox('',sqlca.sqlerrtext)
  13. //end if
  14. commit using sqlca;
  15. //select switch_chkflag into :ll from sys_DB_version;
  16. //Messagebox('11',string(ll))
  17. //
  18. //select switch_chkflag into :ll from sys_DB_version using source_sqlca ;
  19. //Messagebox('2',string(ll))
  20. update sys_DB_version set switch_chkflag=0 using source_sqlca;
  21. //if source_sqlca.sqlcode<>0 then
  22. // Messagebox('',source_sqlca.sqlerrtext)
  23. //end if
  24. commit using source_sqlca ;
  25. //select switch_chkflag into :ll from sys_DB_version using source_sqlca ;
  26. //Messagebox('22',string(ll))
  27. //
  28. disconnect using source_sqlca;
  29. end subroutine