Re: TDBRichViewEdit and MS SQL 2000

Author

Message

Christian Papaux

Posted: 04/17/2002 9:04:03

Hi,

After some more investigations, TDBRichViewEdit seems to work fine with an

'IMAGE' SQL Server 2000 datatype.

With this datatype, the TQuery create a TBlobField.

Thanks.

"Sergey Tkachenko" <[email protected]> wrote in message

> Hi,

> It's required that type of field object is TBlobField (or inherited from

> it), because the components uses blobfield.SaveToStream and LoadFromStream

> methods.

> May be there is a more appropriate field type in MS SQL?

> > Hi,

> >

> > I'm currently evaluating RichviewEdit in order to integrate it in our

> > products. TRichView and TRichViewEdit features are really astonishing

and

> up

> > to the standards we have settled.

> >

> > Testing TDBRichViewEdit, I am trying to link it with a SQL Server 2000

> > field.

> > When opening the form, an Exception EInvalidCast is generated ('Invalid

> > class typecast').

> > The problem come when the TDBRichviewEdit is linked to a 'BINARY' field

> > type. When linked to a 'TEXT' field it's working, but I would like to

> insert

> > pictures, controls and tables and it's not possible with this kind of

> field.

> >

> > What am I doing wrong ?

> >

> > The access to the database I use the following objects:

> >

> > TDBRichViewEdit: (rvfoSaveBinary = TRUE)

> > TDataSet

> > TQuery (on a TBytesField field)

> > TDatabase

> > Microsoft ODBC driver for MS SQL

> > MS SQL Server database

> >

> > Best regards

> > Christian Papaux

> >