Home » Developer & Programmer » Forms » Clear Record (Windows XP DB 9i - forms 6i)
Clear Record [message #360682] Sat, 22 November 2008 03:00 Go to next message
*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

Re: Clear Record [message #360691 is a reply to message #360682] Sat, 22 November 2008 06:45 Go to previous messageGo to next message
Littlefoot
Messages: 20894
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?
Re: Clear Record [message #360693 is a reply to message #360691] Sat, 22 November 2008 07:48 Go to previous messageGo to next message
*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 413 times)
Re: Clear Record [message #360778 is a reply to message #360693] Mon, 24 November 2008 00:39 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: Clear Record [message #360785 is a reply to message #360682] Mon, 24 November 2008 00:49 Go to previous messageGo to next message
*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh
Senior Member
Yes dear all are database items.
Re: Clear Record [message #360793 is a reply to message #360785] Mon, 24 November 2008 00:58 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: Clear Record [message #360795 is a reply to message #360793] Mon, 24 November 2008 01:00 Go to previous messageGo to next message
*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 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: how to select all check boxes with single click
Next Topic: how insert voice in form
Goto Forum:
  


Current Time: Mon Dec 05 07:13:48 CST 2016

Total time taken to generate the page: 0.12742 seconds