Hello to all, I could use some help, please!
What I am asking for is about 10 minutes of your time to test a small Base database on more configurations. This weekend I passed a milestone - actually I should say the developers passed a milestone with me....or maybe it was me....doesn't really matter~ The milestone I am talking about is the ability to: A) Actually use, productively, a 64 bit version of OOo on Kubuntu. B) Create a simple, focused database as an example that would be reasonably assured to run on the full breadth of OOo installations. Well, I definitely succeeded with A, and with your help am getting close to B. For the first half of that milestone, I installed Kubuntu 7.04 on my HP AMD 3300 system four days ago and after swapping out the distro version of OOo for the 64 bit version of OOo 2.3m_211 and installing the SUN 64 bit JRE 1.6...well, I haven't used WinXP accept to transfer some files to Kubuntu and do some testing. It isn't perfect, there is a couple of real bugs, but overall OOo is running quite smoothly in 64 bits. So much so that yesterday in responding to a question at the Forum I decided to build a small database entirely on 'Kingjumper' my kubuntu system. Now, that in it self is no big thing. But I have also been busy of late setting up a real test environment for my work - this allowed be do the following: Build the database on a 64 bit linux platform. Test the database under all of the following: OOo 2.3 Kubunutu 7.04 ( M_211, JRE 1.6 ) [ 1600 X 1200 display ] WinXP SP2 ( M_210, SUN JRE 1.6, 1.5, 1.4 ) [ 1280 X 1024 display ] OOo 2.2 WinXP SP2 ( M_210, SUN JRE 1.6, 1.5, 1.4 ) [ 1024 X 768 display ] OOo 2.1 Not Tested OOo 2.0.4 Ubuntu 6.10 ( Distro build 4, Distro JRE 1.42, Sun JRE 1.5 ) [ 1024 X 768 display ] OOo 2.0.3 Windows 98 ( Pentium II, 266 MHz, 128M Ram, SUN JRE 1.5 ) [ 800 X 640 display ] [[ OOo view setting to 80% ]] Now testing included: Mailing the base file from each machine to the other, then running that database. If there was any problems with the screen not displaying all the data fields or strings properly then the form was edited on that platform and mailed back to all the other machines. The database consists of: Just one table. Three forms for data entry, and one for informational purposes. Eleven queries. Two reports - one very simple, one slightly more complicated. Two macros - total of 22 lines of Basic. On these machines it is down to three problems: Using 2.3m_211 on Kubuntu Occasionally OOo will crash on the InsertRow command in the macro. It will always crash if you insert a new row in a grid and step of the row downward to the insert row. Using 2.0.4 on Ubuntu : the second report will not run - it opens, but fails to load the data. Using 2.0.3 on Win98: the second report will not run - it opens but fails to load the data. The macro called on the form DailyLog_Extra causes an error on MoveToInsertRow. I know that this is because 2.0.3 does not mark the qryDatesList rowset as updateable. All other platforms and versions do, I don't know a way around this one. For all other platforms: There are no errors when I either run the database or follow the steps I outline for creating the database from scratch. The screens all display accurately on the different screen resolutions. You would be surprised how big a deal that is to me... :>) The database and a file with basic the macros will be available for downloaded form my ftp server at in the next hour or so: www.paintedfrogceramics.com/OpenOffice/exerciselog/ExerciseLog_Step_4odb.tar.gz If you can spare the time, please grad this file. Copy and paste the two sub procedures into the Standard library and run the database. Let me know if there are problems. My goal is too get that list of OOo configurations as complete as possible using this single Base file. Thanks in advance. Drew Jensen --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
