Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread 8965 Error updating Memo data
Wed, Dec 18 2013 2:16 PMPermanent Link

Owen

I'm in the process of developing a program.  The program updates memo column just fine, but if I clear out the memo data and do an SQL update I get an 8965 error.  If I do a repair on the table and try the process again, I get the same error.  If I get the error and then try to just update the memo data with a change it works fine.  Has something to do with nulls I think.

Column is defined  - Name=comment, Datatype=Memo, Size=0, Required=no, details=no  

I am using the same SQL to update with or without nulls.  Is there something I need to do differenntly?
Thu, Dec 19 2013 3:07 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Owen,

<< I'm in the process of developing a program.  The program updates memo
column just fine, but if I clear out the memo data and do an SQL update I
get an 8965 error.  If I do a repair on the table and try the process again,
I get the same error.  If I get the error and then try to just update the
memo data with a change it works fine.  Has something to do with nulls I
think.  >>

How are you clearing out the memo data ?  Are you using code, or SQL ?

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com
Thu, Dec 19 2013 7:03 PMPermanent Link

Owen

"Tim Young [Elevate Software]" wrote:

Owen,

<< I'm in the process of developing a program.  The program updates memo
column just fine, but if I clear out the memo data and do an SQL update I
get an 8965 error.  If I do a repair on the table and try the process again,
I get the same error.  If I get the error and then try to just update the
memo data with a change it works fine.  Has something to do with nulls I
think.  >>

How are you clearing out the memo data ?  Are you using code, or SQL ?

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com


Tim,
My application basically runs on clientdatasets and data aware controls.  A DBISAMquery is defined  that gets data and everything gets populated via the clientdataset.  Updates are made in the controls by the user and then when a record gets posted the clientdataset record gets updated. When the user tries to quit, save or cancel or scroll in the applicator, SQL gets created, in this case an Update and the sql gets populated with clientdataset fields and the database gets updated - and 8965 Error code.

The actual statement that I am using to delete data for the Memo is - dbmMemo.Clear;  My theory is that this clears the dbmMemo control and when I post the clientdataset this updates the clientdataset appropriately.  Then of course I do the SQL thing.  

I don't know if this is good or bad.  Feedback would be appreciated.  
Fri, Dec 20 2013 5:53 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Owen,

<< My application basically runs on clientdatasets and data aware controls.
A DBISAMquery is defined  that gets data and everything gets populated via
the clientdataset.  Updates are made in the controls by the user and then
when a record gets posted the clientdataset record gets updated. When the
user tries to quit, save or cancel or scroll in the applicator, SQL gets
created, in this case an Update and the sql gets populated with
clientdataset fields and the database gets updated - and 8965 Error code.

The actual statement that I am using to delete data for the Memo is -
dbmMemo.Clear;  My theory is that this clears the dbmMemo control and when I
post the clientdataset this updates the clientdataset appropriately.  Then
of course I do the SQL thing. >>

Okay, I'll see what I can find out.

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com
Image