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? It depends on application. I can imagine such situations: - variable sman is char(4) and it is used during preparing cursor - select statement is prepared from variable xxx string[100] and xxx[97,98,99,100]="BW|J" Michal Hajek -- -------------------------------------------------------------- Michal Hajek mailto:hajek@nspuh.cz Sprava NIS http://www.nspuh.cz NsP Uherske Hradiste phone : voice +420 0632 529 204 Purkynova 365 fax +420 0632 551 014 686 68 Uherske Hradiste Czech Republic --------------------------------------------------------------