🚀 go-pugleaf

Nevermind.....I was using the wrong Variant type in the Locate method just
before this, thats where the error was.....duh.......
Thanks Anyway
Albert
"Albert Fowler" <webmaster@codegeneration.com> wrote in message
news:3daab499$1@newsgroups.borland.com...
> I am using an access dbase "mdb". I have some fields that are defined as
> Memo fields. MS docs say they can contain text data up to 64k. Fields are
> defined in BCB6 as type ftMemo. When I create a new record I get an
> exception saying "Invaild Variant operation".
>
> From what I have read, it seems as this type is a blob type field designed
> for exactly what I am using it for, to contain strings longer than 255
> characters.
>
> I have tried using the AppendRecord() and Append() with FiledValues[] to
set
> the data, but I always get the same error. Am I missing something? How do
I
> access the data in those fields? Seems the Borland docs are saying to just
> use AsString, if thats the case, why cant data be set in the same manner?
>
> All I really need is a field that will hold up to 1024 text characters.
> I am considering using a char type field and always padding and trimming
> during data access, but this sounds very innefficient.
>
> BTW I am using TAdoConnection,TAdoSource and TAdoDataSet, DBase is created
> in Access97.
>
> Any ideas, answers welcome.
> Thanks,
> Albert Fowler
>
>