Apache OpenOffice (AOO) Bugzilla – Issue 25875
Ooo crash if I try to insert data using Memo[LONGCHAR] fields
Last modified: 2006-05-31 14:29:06 UTC
Hi. I'm using my DataSource to modify some data in my database (MsAccess) but when I try to insert some data in a field Memo[LONGCHAR] the Ooo crash... In my case what happened: I have a .mdb database with a table with a some data... I made a filter in and drop to my Calc document... I deleted the records shown by the filter... I make some changes in some records (in Calc document) and then try to reinsert it in my table, making the drag and dropt into 'Tables' and choosing 'attach data'... After some errors messages I notice that one field of my table is Memo [LONGCHAR] (I can see ask the 'Edit Table') and notice that one record (in my Calc doc) have data that should be insert in the field Memo. So I remove the data and everything works... So I think that the filed Memo[LONGCHAR] is causing the crash... It easy to me reproduce here, so if you want that I post the crash report here or/and send my database to you, plz ask me... Thanx Hwoarang
mine
CLU->hwoarang: yes, please send report and add report id to this task - please attach a data source if you think it could help to reproduce the task - please write a step by step description (the shorter the better) CLU: not to repro in current condition
works fine for me - needs further investigation
CLU: Well, I'm attaching a database and a sxc file with some data to your make your tests... try to insert the range data to the table... the Ooo will crash... Like I said in issue #23992 the crash just happens if the table has a Memo field Let me ask your one more thing, try to delete the query "Consulta1" that exist in my database? Here I receive the error: "[Microsft][Driver ODBC for Microsoft Access] Sintaxy error in DROP TABLE or DROP INDEX." thanx in advance.
Created attachment 13579 [details] My database that make Ooo crash
Created attachment 13580 [details] my document to make tests with the database
CLU-> hwoarang: for your question: at the first look it seems to be a driver problem, but here is not the right place for such things - one task one bug - and for questions you better ask the community experts by using the mailing lists thx
can repro
CLU->OJ: i can repro that - your turn short repro: 1. create a data source with attached data soure in attatches calc document 2. mark the calc table and d&d it on table container in database beamer 3. attatch data to bugtable & create -> [Microsoft][ODBC Driver manager] Function Sequence error continue -> yes => crash
set target
Fixed in cws insight01
Created attachment 15228 [details] 1. part of the patch
Created attachment 15229 [details] 2. part of the patch
reopen
reassign
fixed in cws insight01 -> please verify
cannot verify until issue 30345 is fixed
*** Issue 29092 has been marked as a duplicate of this issue. ***
CLU: d&d in beamer does not work in cws (issue 31151) - bug not to verify till this is fixed
CLU: d&d into beamer not more supported in new db ui concept change repro: 2.mark the calc table and d&d it on the table container in database document
CLU->OJ: still crashes (in current cws: insight01) with small change in handling crash report on the way:
clu->hwoarang: cannot repro anymore in current version, but a lot stuff changes, so please acknowledge: http://download.openoffice.org/680/index.html
hwoarang->clu: thank you... but, the problem now is: "How to create a connection with my mdb file in m54 release?" I tried File -> New -> Database... nothing... I tried View -> DataSources... nothing... Where I can find instructins to make a connection with my mdb file ? Thank you. Hwoarang
HI Hwoarang, what do you mean with File->New -> Database nothing? Normaly a SaveAs dialog appears which forces you to save a database document. After that a wizard like dialog appears (will be replaced in a later version) which allows you to define the kind of connection you want like (Ado, ODBC,...). For ODBC you have on the next page the browse button where you can select the ODBC Data source you want to connect. The spec for the wizard can be found here http://dba.openoffice.org/specifications/Wizard_Database.sxw And the current format can be found here http://dba.openoffice.org/specifications/Data_Source_Property_Dialog.sxw Best regards, Ocke
hwoarang->oj: sorry, my fault... I did´nt read the fully process to create a new connection... I´ll make some tests today with data... Thank you. Hwo
Please care for this one. Thx.
described problem fixed
verified in master (version m50 because of issue 38141)
close