while statement, temporary table

(0) Share

Report

Posted on by Community Member

Hello everyone,

i have some issue regarding multiple while statements in processReport() and insert data in same temporary table.

while select * FROM purchtbl
join purchlinetbl where purchtbl.purchid == purchlinetbl.purchid
join markuptranstbl where markuptranstbl.TRANSRECID == purchlinetbl.RECID
join marktbl where markuptranstbl.MARKUPCODE == marktbl.MARKUPCODE
&& marktbl.VENDPOSTING == 20
&& purchtbl.PURCHID == purid
{ lcTmpTable.dESCRIPTION = markuptranstbl.Txt;
lcTmpTable.MarkupValue = markuptranstbl.Value;
lcTmpTable.insert();
}

while select * from purchtbl
join purchlinetbl where purchtbl.purchid == purchlinetbl.purchid
join markuptranstbl where markuptranstbl.TRANSRECID == purchlinetbl.RECID
join marktbl where markuptranstbl.MARKUPCODE == marktbl.MARKUPCODE
&& marktbl.VENDPOSTING == 55
&& purchtbl.PURCHID == purid
{ lcTmpTable.Description1 = markuptranstbl.Txt;
lcTmpTable.markupValue1 = markuptranstbl.Value;
lcTmpTable.insert();
}

Thanks in advance

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (0)

PA-22040759-0 6,194 on at

Like (0)

Report
Copy link

Link copied!

You have posted this same issue twice, but you need to let us know what the issue actually is if we should be able to offer some help.

Was this reply helpful? Yes No
Suggested answer

udaY-ch 5,173 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Can you check the join condition that you used to link PurchLine <-> MarkupTrans and MarkupTrans <-> MarkupTable.

Check the table relation for reference.

Was this reply helpful? Yes No