Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!uunet!ncrlnk!ncrwic!sfc!chas From: chas@sfc.Wichita.NCR.COM (Charles Binford) Newsgroups: comp.databases Subject: Re: Oracle Forms question Message-ID: <327@sfc.Wichita.NCR.COM> Date: 12 Feb 90 14:36:11 GMT References: <8921@portia.Stanford.EDU> <1990Feb9.202005.2307@oracle.com> Organization: NCR Corporation, Wichita, Kansas Lines: 14 In article <1990Feb9.202005.2307@oracle.com> tgreenla@oracle.uucp (Terry Greenlaw) writes: > The rowid check is the best way I know of in SQL*Forms versions >before 3.0. If you have version 3.0 of SQL*Forms, there is a system variable >called SYSTEM.RECORD_STATUS that contains the record status (New, Queried, >Changed,etc.) of the record the cursor is currently in. However, the rowid >test will still also work with version 3.0. Good Luck, Thanks for all of the help. Testing the rowid for null, not null did the trick for me (I'm on version 2.0). -- Charles Binford, Automation Engineering, NCR PPD Wichita