Thanks, going to do so now.

base is SO close to being great. The bugs get knocked out and the macro side gets better documented and I think it will honestly give FileMaker a run for its money. At its core, base is a better database.

Hi Guys, I have a display table on my form that shows the results of a query. Two of the fields in the query results are fields from the tables that were queried. When I try to click on those fields to input new values, nothing happens. Is it possible to edit "through" a query to the table...

A descriptive title for posts helps others who are searching for solutions. Macro Confusion also tells no one anything useful about the thread contents. Im nto sure that this added anything useful either. "macro Confusion" tells you I'm having trouble with writing a macro. The context tel...

One more stupid question... Sicne the related data doesnt exist until just before theya re displayed, do I need to the Join in a script and then add the fields to the form in the script? or is there a way to tie a form table to a join such that it knwos it needs to re-run the join when the underlyin...

Ah right, ofcourse. A join makes sense, thanks.

On the first though, I really want it to refresh as part of the script. Is there a script way to invoke that refresh command?

Hi All, Well, my script finally works. Based on the change of a field on my form it looks up the relevant information from one table and writes it to another. (Explaining the how and why of what I'm doing would be a long post so forgive me if i cut to the chase.) Two problems left: (1) The updated d...

Im using OO 3.0 base on the mac. its ALMOST stable... but when it crashes its bad. It loses my macro, Even though I have saved it half a dozen times. When it comes back up, its pretty much empty again. Thats bad. A program should not lose *saved* work on a crash. I'm about to try to re-write it for ...

Okay i ALMOSt have this solved. With the help of various wep sites I have figured out the balc art of optaining an event, a form from the event, and a databse connection from the form. I have succeeded in querying the DB for my data. Now all I need to figure out is how to insert it into the right ta...

Okay, Im trying to write an OO3.0 Base macro that does a query on one table, then uses the returned set to calculate and add fields to another table. A few questions have come up while reading Andrew's document: (1) Do I have to do this with SQl? Is there really no object-level wrapper for manipulat...

Thanks much!

Alright, I found it.

It was in build-uno-impl.xml

I went in and repalced the variable with my hardcoded path to the OO3 executable. Not elegant, but it works

Is there a scripting guide/manual somewhere for Base?

I found stuff on the wiki for the other OO apps but not for base. (It seemed like it was written before base was a separate app.)

Base's scripting is a key issue in a shoot out right now between it and Filemaker.

Thanks

I found guides on the wiki for the other parts of OO, but not for scripting base

Is it hiding somewhere? Base's scriptability is key in a shoot out right now between it and FileMaker...

Hi, Im trying to use this to get the Netbenas plugin to work on mac OSX 10.5 It got rid of my big exception trace, but I still ge this error on run of the skeleton prgoram: com.sun.star.lib.loader.Loader::getCustomLoader: exec unoinfo: java.io.IOException: Cannot run program "${office.program.d...

Well, its ALMOST solved... It builds the sample skeleton app fine, but when I try to run it it generates this error: com.sun.star.lib.loader.Loader::getCustomLoader: exec unoinfo: java.io.IOException: Cannot run program "${office.program.dir}/unoinfo": error=2, No such file or directory co...

Okay, i fixed it. The OpenOffice library the plug-in installs is wrong for mac OSX. The proper Jar directories are /Applications/OpenOffice.org.app/Contents/basis-link/ure-link/share/java and /Applications/OpenOffice.org.app/Contents/basis-link/program/classes HOWEVER Netbeans gets confused by the m...

Hi, I'm building some tools for non technical folk to edit info in our MySql database. My big question is this... is there a way to run an OO 3.0 Base app as an application? Kind of like what some other DBs call "Kiosk mode"? i dont want my untechnical users to be able to get into form-edi...

Hi Guys, I'm trying to get the Netbeans plugin working for OO 3.0 development on Max OSX 10.5 I have teh plug-in installed, and its seems happy when I point it at my OO install and my SDK install HOWEVER... When i generate a project, the OO Library it has in its libraries consists of a set of refere...