Share
Reportggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggg
*This post is locked for comments
You’re offline. This is a read only version of the page.
100
ggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggg
*This post is locked for comments
Try this.
Change your field sequence in such way all fields which available in 'InventTable' comes first and than put InventSiteID. Now while selecting add relation to InventDim to select InventSiteId.
That must work.
Here is example .
Insert_Recordset inventStockCardTmpLine (f1, f2, f3, InventSiteId)
select f1, f2, f3
from InventTable
join InventSiteId from InventDim
where InventDIm.inventDimId == <table>InventDimId
you need to identify the right relation for inventDim as InventTable doenst contain inventDimID.
Also in your code you are putting condition on inventStockCardTmpLine.recID==0 while the buffer you are using to insert record. You can not use same table buffer to insert and in where condition. Anyways its a temp table which does nt contain record out of this buffer for a rec id.
Yes, I know that. So, if you try to select such field from InventTable it won't work.
Could you please start by sharing your functional requirement with us. I'm sure it would help us to help you.
InventTable doesn't contain a field called InventSiteId. This has nothing to do with insert_recordset.
The error is solved by using only such fields that exist in the table. Then your statement will compile succesfully.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (