I am retrofitting an application which today looks something like this... BEGIN TRANSACTION
READU REC FROM F.FILE, ITEM.ID THEN REC = DATE() WRITE REC ON F.FILE, ITEM.ID THEN COMMIT END ELSE RELEASE END END ELSE ROLLBACK END END TRANSACTION Changes require the lock be acquired prior to the BEGIN TRANSACTION... READU REC FROM F.FILE, ITEM.ID THEN BEGIN TRANSACTION REC = DATE() WRITE REC ON F.FILE, ITEM.ID THEN COMMIT END ELSE ROLLBACK END END TRANSACTION END ELSE RELEASE F.FILE, ITEM.ID END Are there any negative consequences of doing so? Thanks. Perry Taylor Zirmed, Inc. Perry Taylor Office (877) 494-7633 ext. 4392 Direct (502) 779-4392 Zirmed, Inc. 626 West Main St., 6th Floor Louisville, KY 40202 www.zirmed.com CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/