| View previous topic :: View next topic |
| Author |
Message |
Dave Smith Guest
|
Posted: Sat Feb 21, 2004 7:34 pm Post subject: How does one append text to a memo blob field? |
|
|
I'd like to append text to an already existing memo record. Can it be done
without reading the text into a memo control than using the stringList
properties?
|
|
| Back to top |
|
 |
Dave Smith Guest
|
Posted: Sat Feb 21, 2004 7:36 pm Post subject: missing info from first post supplied here |
|
|
sorry. I'm using D6 w/ Advantage db drivers v.7 but I'll accept any answer
for BDE since Advantage is modelled after BDE. Thanks.
Dave
"Dave Smith" <djsmith9 (AT) pacbell (DOT) net> wrote
| Quote: | I'd like to append text to an already existing memo record. Can it be done
without reading the text into a memo control than using the stringList
properties?
|
|
|
| Back to top |
|
 |
Bill Todd (TeamB) Guest
|
Posted: Sat Feb 21, 2004 7:37 pm Post subject: Re: How does one append text to a memo blob field? |
|
|
What database are you using? Have you tried accessing the blob as a
string and concatenating the text you want to append?
--
Bill (TeamB)
(TeamB cannot respond to questions received via email)
|
|
| Back to top |
|
 |
Bill Todd (TeamB) Guest
|
Posted: Sat Feb 21, 2004 8:56 pm Post subject: Re: missing info from first post supplied here |
|
|
Then something like
var
S: String;
begin
S := Table1.FieldByName('TheBlob').AsString;
S := S + 'Some new text';
should work.
--
Bill (TeamB)
(TeamB cannot respond to questions received via email)
|
|
| Back to top |
|
 |
Dave Smith Guest
|
Posted: Sun Feb 22, 2004 10:29 pm Post subject: Re: missing info from first post supplied here |
|
|
Using D6, Advantage DB (very similar to BDE).
I forgot to mention that Im storing OLE objects there too (a major oversight
I realize /// . The Richedit isn't data aware and I'm storing to the db
using:
Table1MemoField.Assign(RichEdit.Lines);
and reading by:
RichEdit.Lines.Assign(TableMemoField);
This works great even for OLE objects or graphics objects in the memo
but I don't know how to add to the data already there. This obviously
wouldn't work so I'd have to maybe stream it in? Every scenario I've seen
there assumes you are replacing, not appending.. Thanks for the reply.
Dave S.
"Bill Todd (TeamB)" <no (AT) no (DOT) com> wrote
| Quote: | Then something like
var
S: String;
begin
S := Table1.FieldByName('TheBlob').AsString;
S := S + 'Some new text';
should work.
--
Bill (TeamB)
(TeamB cannot respond to questions received via email)
|
|
|
| Back to top |
|
 |
Bill Todd (TeamB) Guest
|
Posted: Sun Feb 22, 2004 11:28 pm Post subject: Re: missing info from first post supplied here |
|
|
You can put binary data in a string variable.
--
Bill (TeamB)
(TeamB cannot respond to questions received via email)
|
|
| Back to top |
|
 |
Dave Smith Guest
|
Posted: Mon Feb 23, 2004 1:39 am Post subject: Re: missing info from first post supplied here |
|
|
hmmm. I didn't know that. I'll give that a try and let you know what
happens.
Thanks for the quick reply each time, even on Sunday! You Borland guys
are dedicated..
Dave S.
P.S. Is this a real email addee? ---> <no (AT) no (DOT) com>
|
|
| Back to top |
|
 |
Bill Todd (TeamB) Guest
|
Posted: Mon Feb 23, 2004 2:31 am Post subject: Re: missing info from first post supplied here |
|
|
On Sun, 22 Feb 2004 17:39:43 -0800, "Dave Smith"
<djsmith9 (AT) pacbell (DOT) net> wrote:
| Quote: | Thanks for the quick reply each time, even on Sunday! You Borland guys
are dedicated..
|
All TeamB members are volunteers, not Borland employees. For more
information see teamb.borland.com.
--
Bill (TeamB)
(TeamB cannot respond to questions received via email)
|
|
| Back to top |
|
 |
|