A string parser for QBE fields (Java clone)?
Posted in 1999
Hi. Not strictly speaking an Informix question, but... Those of us who've been programming in Informix 4GL for the last 10 years++ have come to appreciate the sheer utility of the CONSTRUCT statement. Unfortunately, the attempts by Informix to provide a GUI equivalent to 4GL have failed dismally. Jury's out on D4GL, but I for one am putting no time or effort into learning it. Another proprietary 4GL? I don't think so. I'm far enough along on the Java push to think that it's going to do what I want, even without the database-aware components from 3rd party vendors such as Inprise, Symantec et al. For now, I've decided to bypass these as my previous experience has not been good; their rules of operation were frequently different from how I wanted my database activity to work. All I really need right now are Type 4 JDBC 2 drivers with at least scrollable ResultSet functionality. We've built a database currently over 30Gb using nothing but Java for data acquisition & maintenence. I've proven to my own satisfaction that I can with minimal tweaking switch database engines between Informix, Oracle & PostgreSQL. (The tweaking, BTW, is nearly all in the areas of timestamps). On to the reporting end and I want my Query by Example functionality. I've had a quick hack at it - 2 nights - and have come up with something that works, by extending JTextField. It works well enough that a second attempt incorporating the lessons from the first should give me pretty much what CONSTRUCT does, though I haven't figured out how to cluster the fields as elegantly yet. Now.... I don't really want to re-invent the wheel yet AGAIN and write another goddam string parser. I've already written enough JavaBeans to provide missing functionality in JTextField. Does anyone know where I can get the source code to one that does QBE already? Language is irrelevant; I can read/program in all the common ones & figure out most of the rest. Of course, a JavaBean with all the functionality already included would be a lot better, so I'm open to all offers. I'd prefer any replies to be to the n/g rather than to my email address, but I've listed one below that I check daily. The hotmail one, I check much less frequently. Thanks, Peter Wiley Email: peter_wil@antdiv.gov.au