You must Assign to the Field, not to the Query:

IBOQuery1.FieldsByName( 'YourField' ).Assign( ...

Artur Trindade Anjos
http://www.arsoft.pt

----- Original Message -----
From: Adriano Urbano
To: IBObjects@yahoogroups.com
Sent: Saturday, September 29, 2001 3:57 PM
Subject: RES: [IBO] How to save rich text into blob fields



I am using TIBOQuery...

I have tried to save the contents of the rich text using Assign:

IBOQuery1.Assign(RichEdit1.Lines);


and using SaveToFile/LoadFromFile as well:

RichEdit1.Lines.SaveToFile('temp.txt');
TBlobField(IBOQuery1.FieldByName('CONTENT')).LoadFromFile('temp.txt');
DeleteFile('temp.txt');


but, in both cases, I have got an error message:

"Access violation at address 405C6FOE in module 'VCLDB50.BPL'. Read of
address FFFFFFFF."


The IBOQuery1.EditSql property is defined as follow:


update
GROUP
set
DESCRIPTION = :DESCRIPTION
CONTENT = :CONTENT <--- This is the BLOB field
where
GROUP = :OLD_GROUP


What I am doing wrong?


When saving either images or rich texts, what should I do?


Thanks in advance

Adriano

-----Mensagem original-----
De: Helen Borrie [mailto:helebor@...]
Enviada em: sexta-feira, 28 de setembro de 2001 22:07
Para: IBObjects@yahoogroups.com
Assunto: Re: [IBO] How to save rich text into blob fields


At 06:41 PM 28-09-01 -0300, Adriano wrote:

>Hi all,
>
>I would like to know how may I save the contents of a rich text into a BLOB
>field?

Are you using the TIBO* data access or the native TIB_* components?

Helen


All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________




Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/




Yahoo! Groups Sponsor
ADVERTISEMENT




Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]