OraFAQ Forum: Forms » Clear Record

Home » Developer & Programmer » Forms » Clear Record (Windows XP DB 9i - forms 6i)

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

Clear Record [message #360682]

Sat, 22 November 2008 03:00

*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh

Senior Member

Hi Guyz,

EMPID
EMP_NAME
BASIC
HOUSING
HOUSING_PERIOD
TRANSPORTATION
OTHER_ALLOWANCES
STATUS
VACATION
TICKET
TICKET2
DESTINATION
MEDICAL
MEDICAL2
TRANSPORTATION2
HOUSING2
CAR_NO_ENG
CAR_NO_ARA
CAR_NAME
CAR_MODEL
VEHICLE_TYPE
CAR_SERIAL_NUMBER
CAR_COLOR
CAR_CHASIS_NO

I have the above table in the transporation field is the list item when i select the CAR in transporation it will enable the last records as below

(CAR_NO_ENG
CAR_NO_ARA
CAR_NAME
CAR_MODEL
VEHICLE_TYPE
CAR_SERIAL_NUMBER
CAR_COLOR
CAR_CHASIS_NO

and im taking the records from LOV into the above item

but if i select the another item in the transporation it the above item deactivate. but the records cannot be clear.

i want to clear the record if the company does not provide the car

how can i clear the particular above records ?

can anyone give me some good example. all these field in a single block.

Regards

Report message to a moderator

Re: Clear Record [message #360691 is a reply to message #360682]

Sat, 22 November 2008 06:45

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

Senior Member
Account Moderator

Quote:

i want to clear the record if the company does not provide the car

IF :car IS NULL THEN
   CLEAR_RECORD;
END IF;

I believe it can't be that simple, can it?

Besides, if I were your user, I'd be mad if all items I've entered are cleared just because I forgot to provide the car. Wouldn't you rather display a warning instead?

Report message to a moderator

Re: Clear Record [message #360693 is a reply to message #360691]

Sat, 22 November 2008 07:48

*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh

Senior Member

hi little,

thanks for your support

dear it was not like that.

i have an list item on item trasporation
example : 1) Included 2) Company 3) CAR

already data is there but when i select the CAR the rest of the filed whic i explain before
CAR_NO_ENG
CAR_NO_ARA
CAR_NAME
CAR_MODEL
VEHICLE_TYPE
CAR_SERIAL_NUMBER
CAR_COLOR
CAR_CHASIS_NO

suppose if i select Company or Included the above items are disable, and user can see the data whic i dont want
attach is the snap shot.

in image1 when i select the car the above item are enabled and you can insert the data.
on image2 when i select the another filed i can see the data which is belongs to CAR filed. i want to clear those filed.

Regards

Attachment: image1.pdf
(Size: 130.94KB, Downloaded 1480 times)

Report message to a moderator

Re: Clear Record [message #360778 is a reply to message #360693]

Mon, 24 November 2008 00:39

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Are these items 'database' items or 'non-database' items? That is, if one is changed will that change be recorded automatically in the database?

David

Report message to a moderator

Re: Clear Record [message #360785 is a reply to message #360682]

Mon, 24 November 2008 00:49

*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh

Senior Member

Yes dear all are database items.

Report message to a moderator

Re: Clear Record [message #360793 is a reply to message #360785]

Mon, 24 November 2008 00:58

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Then if the user does not have access to 'car' then wouldn't you want them cleared in that person's record?

David

Report message to a moderator

Re: Clear Record [message #360795 is a reply to message #360793]

Mon, 24 November 2008 01:00

*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh

Senior Member

David,

previously company provide car to the employee after that they take the car and provide transportation allowance to the employee

this is the story in my company... Laughing

[Updated on: Mon, 24 November 2008 01:01]

Report message to a moderator

Re: Clear Record [message #361062 is a reply to message #360795]

Mon, 24 November 2008 23:57

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

EITHER
make the displayed fields non-database and only populate them when you want to use them, remembering that you have to populate the database field through the When-Validate-Item trigger on the non-database field when it is updated or inserted
OR
use a visual-attribute where the foreground and background colours are the same (this makes the text invisible) and set the insert and update properties to 'false'.

David

Report message to a moderator

Previous Topic:	how to select all check boxes with single click
Next Topic:	how insert voice in form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 14:53:45 CST 2025