more then one Long Raw fields in a table

[tyb]

dear frends

is there any restriction on more than one LongRaw fields in a table as i've to save four images in my table for each record but when i try to create the table it returns the message " a table may contain only one column of type Long"

plz help
thanks in advance

 

[sem]

Yes, this is known restriction and one of the main reasons for getting rid of LONG RAW and switching to BLOB.

Regards, Dima

http://seminihin.narod.ru

 

[SantaMufasa]

Tyb,

I agree with Sem/Dima...get rid of antiquated data types. If, however, something is forcing you to use LONG RAW, and you need more than one such column for a table, then create a <table_name>_IMAGES table that has foreign keys back to the row to which the image applies. You can then add an indicator that identifies which of the four images one is (if necessary). In fact, with this method, you can have as many (or few) images as you want for a particular row.

Even if you convert to BLOBs, I highly recommend isolating images off to their own table.

Mufasa
(aka Dave of Sandy, Utah, USA @ 16:45 (25Jun04) UTC (aka "GMT" and "Zulu"), 09:45 (25Jun04) Mountain Time)

 

[tyb]

thanks dima & mufasa for ur responses.

Dima, i'm using forms-5 with oracle-8, when i tried to use the blob for images and tried to create the data block the forms give me error message that's may be like can't read the table (some thing like this, can u plz help me with this error.)


and MUSAFA, for the time being i've the only option to act upon ur advice.

many thanks again.