OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Crash when using Find Record in form

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
denisesmchan
General User
General User


Joined: 25 Oct 2005
Posts: 6

PostPosted: Tue Oct 25, 2005 8:37 pm    Post subject: Crash when using Find Record in form Reply with quote

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?
Back to top
View user's profile Send private message
AndrewZ
Moderator
Moderator


Joined: 21 Jun 2004
Posts: 4140
Location: Colorado, USA

PostPosted: Sun Oct 30, 2005 6:58 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Visit poster's website
denisesmchan
General User
General User


Joined: 25 Oct 2005
Posts: 6

PostPosted: Sun Oct 30, 2005 5:36 pm    Post subject: Reply with quote

I'm using JRE 1.5.0_04 in WinXP. I did error report before. But anyway, I just have another error reported
Back to top
View user's profile Send private message
DrewJensen
Super User
Super User


Joined: 06 Jul 2005
Posts: 2616
Location: Cumberland, MD

PostPosted: Sun Oct 30, 2005 6:20 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail Visit poster's website
denisesmchan
General User
General User


Joined: 25 Oct 2005
Posts: 6

PostPosted: Sun Oct 30, 2005 7:01 pm    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message
DrewJensen
Super User
Super User


Joined: 06 Jul 2005
Posts: 2616
Location: Cumberland, MD

PostPosted: Sun Oct 30, 2005 7:26 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message Send e-mail Visit poster's website
denisesmchan
General User
General User


Joined: 25 Oct 2005
Posts: 6

PostPosted: Sun Oct 30, 2005 7:50 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
DrewJensen
Super User
Super User


Joined: 06 Jul 2005
Posts: 2616
Location: Cumberland, MD

PostPosted: Sun Oct 30, 2005 7:56 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail Visit poster's website
denisesmchan
General User
General User


Joined: 25 Oct 2005
Posts: 6

PostPosted: Sun Oct 30, 2005 8:26 pm    Post subject: Reply with quote

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

Any more idea?
Back to top
View user's profile Send private message
DrewJensen
Super User
Super User


Joined: 06 Jul 2005
Posts: 2616
Location: Cumberland, MD

PostPosted: Sun Oct 30, 2005 8:36 pm    Post subject: Reply with quote

Not off the top of my head.

Is this a Base embedded database or ?
Back to top
View user's profile Send private message Send e-mail Visit poster's website
AndrewZ
Moderator
Moderator


Joined: 21 Jun 2004
Posts: 4140
Location: Colorado, USA

PostPosted: Sun Oct 30, 2005 8:37 pm    Post subject: Reply with quote

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


There are a few advantages to opening a bug report yourself at <http://qa.openoffice.org>.

The Crash Report tool has a button labeled something like "details" which contains an XML file that you should attach to your bug report.
Back to top
View user's profile Send private message Visit poster's website
denisesmchan
General User
General User


Joined: 25 Oct 2005
Posts: 6

PostPosted: Sun Oct 30, 2005 8:56 pm    Post subject: Reply with quote

Yes, it's a Base embedded database.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group