[RBG7-L] - Re: rbsync

[Emmitt Dove]

Deb,

If you're having problems with the database files getting out of sync you can try this:

    SET AUTOSYNC ON
    CONNECT dbname
    IF SQLCODE IN (1212,1213,1214,-2520) THEN
      RBSYNC dbname EXECUTE
      CONNECT dbname
    ENDIF

    IF SQLCODE <> 0 AND SQLCODE <> -2495 THEN
      PAUSE 2 USING 'ERROR:  Cannot connect to database.  Exiting ...'
      EXIT
      RETURN
-- or do whatever you choose at this point.
    ENDIF

Anyone,
 
Where is the best place to put RBSYNC?  Exiting or Connecting?
 
Thanks.

Deb Roepken
cmri
631-587-1495

 

Emmitt Dove
Manager, DairyPak Business Systems
Blue Ridge Paper Products, Inc.
40 Lindeman Drive
Trumbull, CT  06611
(203) 673-2231
[EMAIL PROTECTED]
[EMAIL PROTECTED]