Home » Developer & Programmer » Forms » display blob column in a form (not image)
display blob column in a form (not image) [message #526714] Wed, 12 October 2011 10:36 Go to next message
Noesha
Messages: 3
Registered: October 2011
Junior Member
My english is not good!! but i'll try...

I have a blob column in one table. I need to show it in my form (6i). If i put an image file in the column, it works (because i show it in a Image item type) but if i put a txt file in the blob column, it doesn´t work.

Any idea??

Thanks!!
Re: display blob column in a form (not image) [message #526717 is a reply to message #526714] Wed, 12 October 2011 11:02 Go to previous messageGo to next message
cookiemonster
Messages: 13931
Registered: September 2008
Location: Rainy Manchester
Senior Member
What do you expect it to display? The contents of the .txt? That's not going to happen.
You should put the text in a CLOB instead.
Re: display blob column in a form (not image) [message #526721 is a reply to message #526717] Wed, 12 October 2011 11:16 Go to previous messageGo to next message
Noesha
Messages: 3
Registered: October 2011
Junior Member
I need to save a txt file in a cliente local directory, then i thought to store the file in a form's item and then, write it in the disk through the follow instruction

write_image_file(lDestination, 'any','COGS_FILE.DAT_FICHERO',maximize_compression,original_depth);

With images it works, i want to try with other type file (.xls, .pdf, etc).

thanks for your quick response!

Noella

[Updated on: Wed, 12 October 2011 11:17]

Report message to a moderator

Re: display blob column in a form (not image) [message #526746 is a reply to message #526721] Wed, 12 October 2011 14:32 Go to previous messageGo to next message
Littlefoot
Messages: 21817
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
A TXT file is just plain text; it is not a BLOB (Binary large object), it is a CLOB (Character large object). Quite often text fits ordinary VARCHAR2(4000) columns.
Re: display blob column in a form (not image) [message #526852 is a reply to message #526746] Thu, 13 October 2011 06:18 Go to previous message
Noesha
Messages: 3
Registered: October 2011
Junior Member
If i save my txt file ina clob column, can i show it in a char item of my form???
Actually a need to save the file in the table, and after that, i need to save it in a client local directory.

Also I do not know the type, I need to handle different file types...

Thanks!!
Previous Topic: Setting the update_allowed property of specifc record in a block to false
Next Topic: Capture Key press in Oracle Forms
Goto Forum:
  


Current Time: Sun Aug 11 11:18:25 CDT 2024