BorlandTalk.com Forum Index BorlandTalk.com
Borland discussion newsgroups
 
Archives   FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

How does one append text to a memo blob field?

 
Post new topic   Reply to topic    BorlandTalk.com Forum Index -> Delphi Databases (Desktop)
View previous topic :: View next topic  
Author Message
Dave Smith
Guest





PostPosted: Sat Feb 21, 2004 7:34 pm    Post subject: How does one append text to a memo blob field? Reply with 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
Dave Smith
Guest





PostPosted: Sat Feb 21, 2004 7:36 pm    Post subject: missing info from first post supplied here Reply with quote



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





PostPosted: Sat Feb 21, 2004 7:37 pm    Post subject: Re: How does one append text to a memo blob field? Reply with quote



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





PostPosted: Sat Feb 21, 2004 8:56 pm    Post subject: Re: missing info from first post supplied here Reply with 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
Dave Smith
Guest





PostPosted: Sun Feb 22, 2004 10:29 pm    Post subject: Re: missing info from first post supplied here Reply with quote

Using D6, Advantage DB (very similar to BDE).

I forgot to mention that Im storing OLE objects there too (a major oversight
I realize ///Smile. 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





PostPosted: Sun Feb 22, 2004 11:28 pm    Post subject: Re: missing info from first post supplied here Reply with quote

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





PostPosted: Mon Feb 23, 2004 1:39 am    Post subject: Re: missing info from first post supplied here Reply with quote

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





PostPosted: Mon Feb 23, 2004 2:31 am    Post subject: Re: missing info from first post supplied here Reply with quote

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
Display posts from previous:   
Post new topic   Reply to topic    BorlandTalk.com Forum Index -> Delphi Databases (Desktop) All times are GMT
Page 1 of 1

 
Jump to:  
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


Powered by phpBB © 2001, 2006 phpBB Group
SEO toolkit © 2004-2006 webmedic.