Re: SDK 2.81.TC3 and query with two conditions it will not work???

Muthana.AL-Temimi@tu-harburg.hamburg.de said: > > Dear Sir, > > I have installed the I-SQL 7.32, 4GL 7.32 on Linux (Debain) , and SDK > 2.81.TC3 on Window Server 2003. > I found that when I send query into the DB through MS-Access using ODBC > the question will not work if I have two conditions > But if I have one condition it will work well! > > For example here it will not work because I select lab.mtknr and order by > also, therefore will not work: > > SELECT soshh_lab.mtknr, soshh_lab.pnr > FROM soshh_lab > WHERE (((soshh_lab.mtknr)=27255)) > ORDER BY soshh_lab.pnr;> > I get the following: > > > > Is there something that I must do to solve the Problem? I think that this > Problem is with the SDK 2.81.TC3? What? What error message do you get? What is forcing you to put all those brackets in? What precludes you from saying: SELECT soshh_lab.mtknr, soshh_lab.pnr FROM soshh_lab WHERE soshh_lab.mtknr=27255 ORDER BY soshh_lab.pnr; ? -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco You are better at sex than anyone. Now all you need is a partner. I went to the airport to check in and they asked what I did because I looked like a terrorist. I said I was a comedian. They said, "Say something funny then." I told them I had just graduated from flying school. -- Ahmed Ahmed http://members.rogers.com/2remedy/images/smilies/banners/RTFM.gif sending to informix-list