OraFAQ Forum: Forms » :system.record

Home » Developer & Programmer » Forms » :system.record_status

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

:system.record_status [message #484192]

Sun, 28 November 2010 22:59

swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai

Senior Member

Hello friend..

Can somebody explain me about :systen.record_status??

When it become NEW, INSERT, CHANGED, QUERY...I read document but still i cant get it..

I am still confused when it become NEW OR INSERT..

please explain me

Report message to a moderator

Re: :system.record_status [message #484207 is a reply to message #484192]

Mon, 29 November 2010 01:08

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Perhaps you should create a sample form and display record status in various triggers, so that - when you run the form - you'd see exactly what status a record has when entering data, querying, deleting, opening a form etc. It means that you'd use something like this:

-- WHEN-NEW-FORM-INSTANCE trigger:
message('WNFI ' || :system.record_status);

WHEN-NEW-RECORD-INSTANCE trigger:
message('WNRI ' || :system.record_status);

etc.

Report message to a moderator

Re: :system.record_status [message #484211 is a reply to message #484207]

Mon, 29 November 2010 01:19

swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai

Senior Member

i did it but i confused about when record status changed..

i take a one field when i filled this field
all appropriate data shown in data block....
on that time system record status become 'INSERT'
i change some data on that block....but still system record status is 'INSERT'

So i want to ask when :system.record_status become 'CHANGED'
PLEASE HELP ME...

Report message to a moderator

Re: :system.record_status [message #484233 is a reply to message #484211]

Mon, 29 November 2010 02:29

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

It becomes changed when you modify a record that exists in the database.
So either
1) A record you have queried
or
2) A record you have inserted and saved.

Report message to a moderator

Previous Topic:	ORA-00904: "EMP_ID": invalid identifier.
Next Topic:	create unique primary key

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 16:44:30 CST 2025