Crash when using Find Record in form

denisesmchan · General User Joined: 25 Oct 2005 Posts: 6

My Base always crash when I try to use Find Record function in form. It will crash even I just start the Find Record function and close the window without doing anything. Would anyone know why?

AndrewZ · Posted: Sun Oct 30, 2005 6:58 am Post subject:

The Base part of OpenOffice.org depends heavily on Java, which is installed by default much more often in Windows than Linux. You can use this to find out which JRE you are using:

1. Open OpenOffice.org Writer
2. In the menu: Tools->Options
3. On the left: OpenOffice.org->Java

Which JREs are installed? Which one is selected?

Which operating system are you using?

After the crash, do you see a dialog that allows you to report the crash? It looks similar to these:

http://www.openoffice.org/screenshots/images/crashreport%5B1%5D1_1rc.png
http://www.openoffice.org/screenshots/images/crashreport%5B2%5D1_1rc.png

denisesmchan · General User Joined: 25 Oct 2005 Posts: 6

I'm using JRE 1.5.0_04 in WinXP. I did error report before. But anyway, I just have another error reported

DrewJensen · Posted: Sun Oct 30, 2005 6:20 pm Post subject:

I was having a lot of problems with Base also.

I was switching lots of things around though so can't be sure this is really going to do it for you, but I switched to JRE 1.4.2_07 and all seems well.

I also tried 1.5.0_05 and seemed well also, but others have said that 1.4.2_07 is better for them...(kind of heard it thru the grape vine kind of thing however)

Anyway, I am on WinXP HE Sp2 also.

Oh and I am having no problems with Find record on a form what so ever.

Drew

denisesmchan · General User Joined: 25 Oct 2005 Posts: 6

I've just installed JRE 1.5.0_05 but the problem still exists.

BTW, my form contains multiple sub-forms. Would that be the problem source?

DrewJensen · Posted: Sun Oct 30, 2005 7:26 pm Post subject:

hmm...not a problem with multiple sub forms. I have a few with I suppose 4 subs.

However, there is an issue it seems with FormattedField controls for integers whent he column is null.

If you have any of these try changing them the NumericField Controls. It fixed a crashing problem on a couple of my forms and at least one form for another person.

denisesmchan · General User Joined: 25 Oct 2005 Posts: 6

Do you mean there would be problem if I've any field in Integer type?
I've only fields in Numeric type and Varchar type.

DrewJensen · Posted: Sun Oct 30, 2005 7:56 pm Post subject:

No, I mean if you use the Form wizard to create the form and you have an Integer column or numeric column in a table the wizard created a FormattedField UI control on the form. There seems to be a problem with this control handling NULL values (actually the problem seems to be with empty tables).

If you change the UI control type from FormattedField to NumericField (or Text or Pattern for that matter) the problem goes away.

I can't say it is it for sure, but it is somethig I would look for

denisesmchan · General User Joined: 25 Oct 2005 Posts: 6

I changed the fields to Text Box. But the problem still exists.

Any more idea?

DrewJensen · Posted: Sun Oct 30, 2005 8:36 pm Post subject:

Not off the top of my head.

Is this a Base embedded database or ?

AndrewZ · Posted: Sun Oct 30, 2005 8:37 pm Post subject:

denisesmchan · General User Joined: 25 Oct 2005 Posts: 6

Yes, it's a Base embedded database.