On Sun, 2006-02-05 at 08:40 -0800, 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.
This sounds suspiciously like a GROUP BY requirement, and I don't think the HSQL engine has that functionality. Someone will hopefully confirm or deny that. Of course, you can install one of the many free database backends available such as MySQL or PostgreSQL if HSQL isn't adequate. > What language do I use and where can I find information on it? This is just > for fun and I am not using if for any type of business so I don't care to > know that I can do the same thing at the Amtrak web site. SQL at the query level. A choice of languages at the macro level - BASIC, Python, Beanshell or JavaScript. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
