At 12:26 PM 7/25/2009, Jim Belisle wrote:
Razzak,
This is my DAT file that opens the main form.
CONNECT Labor
CLS
-- Make sure that previously SATTACHed table is detached
SET ERROR MESSAGE 2038 OFF
SDETACH Leadall NOCHECK
SET ERROR MESSAGE 2038 ON
-- Make sure that the previously DSN-Less Database is Disconnected
SDISCONNECT ';Driver=R:BASE 7.6 Database Driver (*.rb1);dbq=Sales'
-- Now Connect the Database Using the DSN-Less Connection
SCONNECT ';Driver=R:BASE 7.6 Database Driver (*.rb1);dbq=Sales'
-- Attach Leadall table with proper columns. --
SATTACH LEADALL USING LEADCODE ALIAS
CONTACT,COMPNAME,COMPADD,COMPCITY,
COMPSTATE,COMPZIP,COMPAREA,COMPPHPRE,COMPPHSUF,COMPEXT,sPROMOCAT,sPROMOI
D,LEADDATE,DATEANSW,SALEPER,TICDATE,INTEREST,LEADGOOD,NOTES,LEADCODE
EDIT USING KayParkMainMenu
-- Make sure that DSN-Less Database is Disconnected
SDISCONNECT ';Driver=R:BASE 7.6 Database Driver (*.rb1);dbq=SALES'
DISCONNECT
EXIT
RETURN
Would I put this code SET TIMEOUT 60
before (or just after) the CONNCET LABOR statement or
before (or just after) the EDIT USING KayParkMainMenu statement?
Jim,
Technically, you can put it anywhere you like. The TIMEOUT settings
is not dependent on the database. This specific setting is related
to R:BASE session.
I would put it at the beginning of the startup .DAT file for obvious
reason.
Very Best R:egards,
Razzak.
