Re: 4GL Query problem !

Simply. You have somewhere in your module a variable named insp_autho. If you put in your query the @ sign in front of insp_autho it is interpretted as a column name, and if you remove it - as a local variable name (if there is one in the current context). Best Regards, Octav On Wed, Jul 21, 1999 at 10:24:19AM +0530, NayAn JaiN wrote: > Hi all, > > I have a silly question, but wasnt able to figure out what is happening > and how is it happening. > > Here is a query statement that is written in a 4gl program. > > SELECT insp_periodicity > INTO g_insp_periodicity > FROM smm_insp_period > WHERE @insp_autho = gr_smrpm01.sti_iii_cd> > Please notice there is a "@" sign before field "insp_autho" > > now if this "@" sign is there then this query gives status = 0 > and if i remove this then it gives status = 100. > > What does this "@" sign means and how does this affect the query. > > BTW, I wrote a dummy program with the same query. There it works in both > the cases...means...with or without "@" sign, i get status = 0. > > But when i run the same query in dbaccess, i get a syntax error at "@" > sign. > > Cant figure out. > > TIA, > > With Regards > Nayan Jain ! > > > > - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - > Ye Lamhe, Ye pal ham baraso yaad karenge ... -- Octav Chiriac Phone: (373) 2 22 99 67 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 22 84 88 Moldova, Republic of mailto:com@netinfo-moldova.com