I'm finding it hard work making allowances for JDBCs fussiness. All my code accepts search criteria such as:
nsw And finds records that contain: nsw, NSW, and even nSw. Not with JDBC. IT MUST BE EXACT! At present I am making a new field for every field that is searched and making it equal to a lowercase version. I append 'LC' onto the field name. Then when I search it I user the <@LOWER> tag on the arg. Hence it will work as it always used to. This is fine on a search that looks at four fields but a tad arduous (and damn annoying) on one that searches 100 fields. I'm pretty sure I'm not the first to face this frustration. What are the methods used to cope with this and why is JDBC more primitive that FileMaker? Wayne Irvine ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe witango-talk" in the body.
