Home » Developer & Programmer » Forms » Display a record at for one time in the day
Display a record at for one time in the day [message #188851] Tue, 22 August 2006 02:28 Go to next message
emadbsb
Messages: 334
Registered: May 2005
Location: egypt
Senior Member

Hii All

I hope someone solve to me this issue

i have a "display item" in my form
that display item must be displayed for one time in the day
that time is at the first time this screen is openned in the day

i mean when this form is openned at the date "22-08-2006" this display item is displayed at the first time in that date
and when open it again in the same date (day) that display item mustnot appear again

it will appear again at the date of "23-08-2006" also for the first time in that date (day)


Thanks for everyone helped and helping me
Re: Display a record at for one time in the day [message #188860 is a reply to message #188851] Tue, 22 August 2006 03:34 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

Is there other way storing the history other than database? Then store the date in a table then over write it daily. you have to read from that table each form instance to know if item was already displayed on that day.
Re: Display a record at for one time in the day [message #188869 is a reply to message #188851] Tue, 22 August 2006 04:16 Go to previous messageGo to next message
emadbsb
Messages: 334
Registered: May 2005
Location: egypt
Senior Member

how will i update that table daily
do you mean using sql update its value everyday ?????
Re: Display a record at for one time in the day [message #189033 is a reply to message #188851] Tue, 22 August 2006 20:20 Go to previous message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

Yes, update the table on it's first display on that day. Then you can check if that was already displayed on that day by comparing that with sysdate.
Previous Topic: ORA-302000 error with CLIENT_TEXT_IO.FOPEN
Next Topic: to make tax_code field obbligatory
Goto Forum:
  


Current Time: Fri Sep 20 10:23:16 CDT 2024