topic Re: Error while Fetching data from BUT0ID data its urgent in Application Development and Automation Discussions

Error while Fetching data from BUT0ID data its urgent

Former Member — Fri, 18 Jul 2008 12:28:00 GMT

hi all,

SElECT SINGLE partner FROM but0id INTO l_bp

WHERE type EQ 'BUP008' AND

idnumber EQ edid4-sdata+45(10).

this is my select statement its not working i have to fetch partner number with the help of sdata.

when i give 69093 instead of edid4-sdata+45(10) then i am getting the output

when i specify edid4-sdata+45(10) then it is not working

please tell me any one its urgent

Thanks & regards

Vardhan

Former Member — Fri, 18 Jul 2008 12:31:09 GMT

Hi,

Move this edid4-sdata+45(10) to a range or a field and then select your data.

If the hint is usefulu2026 Say thanks by rewardu2026.

Regards,

Prabhu Rajesh

Former Member — Fri, 18 Jul 2008 12:31:35 GMT

Hi,

Try doing this.Take the offset of sdata and move it into a varaiable and then check the condition in the query.

Regards,

Sharath

Former Member — Fri, 18 Jul 2008 12:41:31 GMT

Even I Tried by the way you people said . Its not working any other solutions please