Re: Strange QBE problem

In article <6a4shj$5c6$1@news.abs.net>, "Mark S. Winsor" <wmark@pvar.com> writes >In article <34C5EE6A.46CE5897@informix.com>, > "Mark D. Stock" <mdstock@informix.com> writes: > >>> 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, > >Sorry about that. It is 4gl, and I have recompiled this program and still have >the problem. I also recompiled another program that works and it still works. >The only thing I haven't done (that I can think of) is to recompile the form >of the program that works to see if it stops working. > Make the variable used to hold the where clause char(10000) and then display where_clause clipped sleep 4 and see what comes out, possibly the variable is too small. > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care