At 07:54 PM 4/8/2012, mike epstein sony viao office wrote:
Dave: There is a button on the form that updates a few tables and exits
from the form. If there is another user connected to the database when the
save and exit buttons eep has run then the form will not respond and
the option to exit the program on is the only solution . It is then that
some of the updated tables become locked and the user count increases.
Which requires both users to exit the program to clear.
I would love to blame it on network issues but I really think it is an
rbase issue . This is the eep of the save and exit button .
SET TRACE Off
SET MESSAGES OFF
SET ERROR MESSAGES On
SET NULL -0-
UPDATE scratchpd SET callfrom = .vcf WHERE jidcode = .vjcd AND dtcall = .#DATE
UPDATE scratchpd SET jphone = .vjph WHERE jidcode = .vjcd AND dtcall = .#DATE
UPDATE scratchpd SET wkphone = .valtph WHERE jidcode = .vjcd AND dtcall =
.#DATE
UPDATE scratchpd SET ampmprom = .vamp WHERE jidcode = .vjcd AND dtcall =
.#DATE
UPDATE scratchpd SET tmcall = .#TIME WHERE jidcode = .vjcd AND dtcall = .#DATE
UPDATE scratchpd SET typbill = .vtycode WHERE jidcode = .vjcd AND dtcall =
.#DATE
UPDATE scratchpd SET dteprom = .vdtprom1 WHERE jidcode = .vjcd AND dtcall
= .#DATE
UPDATE scratchpd SET svcneed = .svcmo WHERE jidcode = .vjcd AND dtcall =
.#DATE
UPDATE scratchpd SET tidcode = .vtd WHERE jidcode = .vjcd AND dtcall = .#DATE
IF vdtprom1 = .vdtprom1 THEN
UPDATE scratchpd SET flag2 = 't' WHERE flag2 IS NULL AND dteprom = .#DATE
ENDIF
SET NULL ' '
closewindow
SET TRACE OFF
This routine saves all the data that is updated and closes the form
.ONLY WHEN THERE IS ONLY 1 USER CONNECTED TO THE DATABASE
How would power management settings affect the form? Neither of the
computers have been reset.
Mike,
You can decrease the number of times R:BASE will access the "scratchpd"
table by combining the UPDATE commands into one command.
SET TRACE OFF
SET MESSAGES OFF
SET ERROR MESSAGES ON
SET NULL -0-
UPDATE scratchpd SET callfrom = .vcf, jphone = .vjph, +
wkphone = .valtph, ampmprom = .vamp, tmcall = .#TIME, +
typbill = .vtycode, dteprom = .vdtprom1, svcneed = .svcmo, +
tidcode = .vtd WHERE jidcode = .vjcd AND dtcall = .#DATE
IF vdtprom1 = .vdtprom1 THEN
UPDATE scratchpd SET flag2 = 't' WHERE flag2 IS NULL AND dteprom = .#DATE
ENDIF
SET NULL ' '
CLOSEWINDOW
SET TRACE OFF
Check for duplicate or unneeded indexes for the "jidcode" and "dtcall"
columns. Also, if no index is defined, add it if needed.
By increasing the speed of the form EEP, you will decrease the chances in
which users will update the table columns at the same time.
Best regards,
John Minyo II
R:BASE Technologies, Inc.
Customer Service
