Dennis Marks wrote:
I have never worked with Base but I am experienced with large scale databases. Before I start digging into programming Base I would like to know if this is possible. Can a program or macro be written that will search a database for a specific record based on one field and return the data for another field? Can I sequentially read the file from that point? I would like to use the found data to search and read another file. When records are found in that file I want to recursively begin the process over again. I am searching a network of train stations and routes looking for paths between stations. The recursive depth is unknown since there can be many possible paths to follow.
It's certainly possible. OOo allows you to script tasks such as opening recordsets and walking through them, ie similar to an ADODB recordset. I've used this functionality, and it appears to work fine. Recursion is also supported.
What language do I use and where can I find information on it?
OOo has a number of languages you can use to script things. It has OOBasic, which is what I'm doing our macros in. I believe you can also write scripts in Java and Python. Down the bottom of http://support.openoffice.org/index.html there are some links to documentation. There's also http://www.oooforum.org/ which has been invaluable for me.
-- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
