RECEIVED ALERT (oaib) AT QUERY GENERATOR...

[Former Member]

hi..

This error is comming at qury generator may i know what is this error and how can i solve this one

What i had done is i had written below code in sql and just copy ,paste in query generator..

[if i want to do  select from the query generator it is possible  , but i had not done..

i think both are same, if it is same why this error ]

Need your valuable sugeestions............

select T0.[docentry],T0.[docdate],T0.[ cardcode],T1.[itemcode],T1.[whscode]

from

ordr T0 inner join rdr1  T1

on

T0.[docentry]=T1.[docentry]

where T0.[docentry]=[%0]

      and T0.[cardcode]=[%1]

      and T0.[itemcode]=[%2]

      and T0.[whscode]=[%3]

[KennedyT21 · Accepted solution]

Hi Mr Seenu

Try This

select T0.docentry,T0.docdate,T0.cardcode,T1.itemcode,T1.whscode

From ordr T0

inner join rdr1  T1 on T0.docentry=T1.docentry

where T0.docentry='[%0]'

      and T0.cardcode='[%1]'

      and T1.itemcode='[%2]'

      and T1.whscode='[%3]'

Regards

Kennedy

[Former Member · Accepted solution]

Thank u working good ..

i had done a mistake....

[jones_joseph · Accepted solution]

Amazing ; it happens when you dont qualify the table name.

[agustin_marcoscividanes]

Hi

you wrote T0.[itemcode], you have to write T1.[itemcode]. The itemcode is rdr1 table.

Idem for whscode.

Try again.

Kind regards.

Agustín Marcos Cividanes