OraFAQ Forum: Forms » Inserting more than one images in the same rerocd

Home » Developer & Programmer » Forms » Inserting more than one images in the same rerocd (Oracle 10g forms, widows XP)

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

Inserting more than one images in the same rerocd [message #292535]

Wed, 09 January 2008 02:58

gulljee78
Messages: 3
Registered: December 2007

Junior Member

Hi friends,

I have one block (images), with two columns.

Id number
Images blob.

And child block (child) has two columns.

ID
Detail

I have to add more than one picture in Images field of that particular record, and than I have to navigate picture. With previous and next button. And with one print button I will take out the print from these pictures.

Currently I can insert one picture only through browse button. But it does not allow me to insert more than one picture in the same field.

What changes I should make in your opinions, which will enabled me to insert more than one picture in that particular record. And then I will be able to navigate easily through next and previous button.

Regards,

gull

Report message to a moderator

Re: Inserting more than one images in the same rerocd [message #292779 is a reply to message #292535]

Wed, 09 January 2008 19:45

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

Senior Member
Account Moderator

You can't put two things into a single field.

EITHER: You need to have another table higher than the 'images' table which will point to this table for a particular 'event'. Then each 'events' will have multiple 'images' and each 'images' will multiple 'child'.

OR: You have both the 'detail' field and the blob field on the same table.

David

Report message to a moderator

Re: Inserting more than one images in the same rerocd [message #293202 is a reply to message #292779]

Fri, 11 January 2008 03:34

gulljee78
Messages: 3
Registered: December 2007

Junior Member

Thank you very much for ur reply, Mr. David,
as per your instruction i have chosen option two (OR) i made the changes in the table now
i have only one table, and all feilds are on that (images)table,but problm remains there.

Regards,

Report message to a moderator

Re: Inserting more than one images in the same rerocd [message #293507 is a reply to message #293202]

Sun, 13 January 2008 19:08

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

Senior Member
Account Moderator

You still need two tables. One for the 'event' plus 'event details' and the second for the 'image' plus 'image details'.

David

Report message to a moderator

Previous Topic:	substitute for call built in in 10gAS
Next Topic:	it's possible to make Hierarchical Tree from multiple tables ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 21:20:00 CST 2025