Re: New Era 3.0 select stmt being weird

On 23 Aug 97 at 22:01, M.J. Holley wrote: } I went into DBACCESS and did the select using the actual values and } the data I am looking for is there. Now this same select worked in } plain old 4GL (I am rewriting a 4GL prog in NE - sigh). Am I being } dense here? } } variable x1 smallint } variable x2 char(4) } variable x3 char(10) } } select modeltype into x3 from carmodels where manunum=x1 WORKS } FINE select modeltype into x3 from carmodels where modelcode =x2 } BOMBS } } in the carmodel table, manunum is a smallint and modelcode is } char(4) In my test case, both should return valid info and there } are no dups or anything. } } Thoughts? Quotes? -- Ciao, Billy Nose to the ear in Johannesburg, Murder Capital of the World. For a good time, call: http://www.iiug.org/techinfo/faq/faq_top.html