Re: Strange QBE problem

Mark S. Winsor wrote: > > I have a problem that I've never seen before. In a query by example, > if > the user enters a value that overflows the field down to the prompt > line, > the where clause is truncated. For example, I have a field that allows > 4 > characters in it. The user wants to search for 2 salesman so they > enter > BW|JW in the field. The field only shows BW|J as you would expect, and > the > prompt line at the bottom shows BW|JW as you also would expect. > However, > the where clause has this value "salesman in ('BW', 'J')". Other > programs > in this system work fine, what could be going on here? You don't give us a lot to go on here, but I assume this is 4GL. I think there was a 'feature' that exhibited your symptoms in version 4.something. What product are you using? What version? The answer will probably be; "upgrade to the latest version". :-) Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //| | +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+