Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread DBISAM memo.assign causes refresh?
Tue, Dec 11 2007 10:27 AMPermanent Link

"Monte Etherton"
Maybe this is a known "issue", but I can't figure out how to deal with it
easily.

I am reading data from a vCard file into db fields. One vCard property is
TStrings, and I assign it to a TMemo during an insert.

If there the TStrings is null, all is OK, but if it is not, the TMemo.assign
seems to cause a refresh-or something-which then causes a 8708 error on
post. The 8708 is trapped in a try/finally construct and ignored.

Anybody got any ideas on a workaround?  Or am I doing something duhmb?

thanks,

Monte

D7/DBISAM 4.25b7/XPPro

Tue, Dec 11 2007 1:55 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Monte,

<< If there the TStrings is null, all is OK, but if it is not, the
TMemo.assign seems to cause a refresh-or something-which then causes a 8708
error on post. The 8708 is trapped in a try/finally construct and ignored.
>>

This is normal if the BLOB field that the TDBMemo component is hooked up to
has been changed by another user/session or another query/table component in
the same application.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thu, Dec 13 2007 12:25 PMPermanent Link

"Monte Etherton"
Thanks Tim, but this is occuring when I run the app with one user (ie *ME*),
and there is no other active cursor that I am aware of.

Here's a flow example:

dbVendor.Empty
dbVendor.Index=RecordID //try to assure BLOB assign will not force
flyaway(?)
dbVendor.Open
vcfFile.Open
while not vcfFile.eof do
begin
 dbVendor.Insert
 vcfFile.ReadNextRecord
 ...
 tmpStrings.add(vcfFile.Memo)
 dbVendor_Memo.Assign(tmpStrings)
 try
     dbVendor.Post
 except
     {only if dbVendor_Memo was assigned data then 8708 error occurs}
 end;
end;

Could it have something to do with adding muliple line data (ie LFs) into
the BLOB field?  Otherwise I will try to get a better understanding of my
problem and post back.

Thanks again,

Monte


"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:3C200A1B-FA2D-443E-8E4E-B51A26A9CFF2@news.elevatesoft.com...
> Monte,
>
> << If there the TStrings is null, all is OK, but if it is not, the
> TMemo.assign seems to cause a refresh-or something-which then causes a
> 8708 error on post. The 8708 is trapped in a try/finally construct and
> ignored.
> >>
>
> This is normal if the BLOB field that the TDBMemo component is hooked up
> to has been changed by another user/session or another query/table
> component in the same application.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

Fri, Dec 14 2007 12:24 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Monte,

<< Thanks Tim, but this is occuring when I run the app with one user (ie
*ME*), and there is no other active cursor that I am aware of. >>

You don't have the same table open anywhere else in the application ?  If
not, then you should try to repair the table because it may be corrupted.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image