Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 4 of 4 total |
8965 Error updating Memo data |
Wed, Dec 18 2013 2:16 PM | Permanent 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 PM | Permanent 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 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 |
This web page was last updated on Wednesday, March 27, 2024 at 05:29 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |