Problem with BLOB

[brittoalexis]

Hai friends,

I had a problem while i am using vb and oracle.
I had a field with blob datatype in oracle. I have to insert as well as select record from that field.

How can ,

thanks in advance.


Brits.

 

[sunaj]

Hi,

I haven't tried that with an Orccle, but with SQL and it must be the same through ADO.
Use .Appendchunk (

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthappchunk.asp)

to write to the field and .GetChuck (

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthgetchunk.asp)

to read from the field.
Sunaj
'The gap between theory and practice is not as wide in theory as it is in practice'

 

[Moka44]

HI
Perhaps a similar problem, I have an Access 2k where a form displays employee info and picture. I used the OnCurrent event and a Picture field with the path to the employees'pictures which are stored in C\. Now the pictures have been moved to Blob on SQL Server. Can I still use the path method to display pictures on my form or do I need a totally new solution?
Thanks

 

[johnwm]

If they are stored in Blobs then you won't get the paths to them. Suggest you look at articles referred in Sunaj's answer above Let me know if this helps
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'There are 10 kinds of people in the world: those who understand binary, and those who don't.'