 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Powell Benedict
Guest
|
 Posted: Tue Jul 20, 2004 2:16 am Post subject: TADOQuery and BlobStreams |
 |
|
All,
I have a table which has two blob fields. I have located code that shows
how to use a TADOTable component to insert new records into this table, but
my questions is this: what if I want to update one of those records?
My preference would be to use a TADOQuery. I have seen code to read blob
data from a TADOQuery, but how would I do an update? I'd like to issue a
SQL Update to do this, is it possible?
Is there a better way?
Thanks!!
Powell
|
|
| Back to top |
|
 |
Powell Benedict
Guest
|
| Posted: Thu Jul 22, 2004 3:02 am Post subject: Re: TADOQuery and BlobStreams |
|
|
Worked like a champ, THANKS!!!
"Brian Bushay TeamB" <BBushay (AT) Nmpls (DOT) com> wrote
| Quote: |
I have a table which has two blob fields. I have located code that shows
how to use a TADOTable component to insert new records into this table,
but
my questions is this: what if I want to update one of those records?
My preference would be to use a TADOQuery. I have seen code to read blob
data from a TADOQuery, but how would I do an update? I'd like to issue a
SQL Update to do this, is it possible?
If you want to do an Update query TadoCommand is a better choice than
TADOQuery.
For blobFields create parameters in the update query. You can use
Tparameter.loadfromFile or Tparameter.LoadfromStream to set the value of
the
parameters with your blob value
--
Brian Bushay (TeamB)
[email]Bbushay (AT) NMPLS (DOT) com[/email]
|
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
