OraFAQ Forum: Forms » How to create a changing field in form.....

Home » Developer & Programmer » Forms » How to create a changing field in form.....

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

How to create a changing field in form..... [message #119757]

Sun, 15 May 2005 02:59

theone
Messages: 6
Registered: March 2005
Location: Jabalpur

Junior Member

Hi,

Its interesting but i dint have any solution for it.
I wanted to create one item or field such as an image item,
and i want that for each day it will show a different image.
like one day it shows one image,
second day it will show another image.

plz help me for this.

Thanks

Abhi

Report message to a moderator

Re: How to create a changing field in form..... [message #119768 is a reply to message #119757]

Sun, 15 May 2005 05:11

Maaher
Messages: 7065
Registered: December 2001

Senior Member

- Put all your images in a BLOB column of an 'images' table.
- At form startup, query the table according yto your specs.

The display of BLOBs in Forms has been addressed multiple times here, so that can't be the problem.

e.g. add a second column to the images table, containing day of week. Now you can query using sysdate, resulting in a different image for each day of the week.

MHE

Report message to a moderator

Previous Topic:	insert or update
Next Topic:	Calculator Example

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 18:13:27 CDT 2024