Re: QBE problem help ?

Posted in 1992

Dave Snyder — Fri, 26 Jun 92 11:30:09 EDT — source: Informix-list mailing list archive (1991-1998)

Quoting mak... > A customer of ours is having a problem with QBE. The product has a code field > that whilst no format is specified the customer has adopted a format of > A/NN/NNNN and since this is not enforced they have ended up with a number of > non comformist :-) entries. When using "?/??/????" in the QBE they get all > those that match the format but using "<>?/??/????" returns all rows ! I had the same problems with a social security field on a customer screen. What I found out was that the pattern matching in a form is pretty lame. The solution was to use Query Language which supports full-blown regular expression. DAS -- David A. Snyder @ Snide Inc. - Folcroft, PA Current Release is db4glgen-3.7 UUCP: ..!uunet!das13!dave INTERNET: dave.snyder@snide.com