2,845
In dexterity coding I have written a trigger for scroll window line fill. The line fill firing properly, in that I have written dexterity coding to get particular table value. I have passed key fields of that table and written get table statement. The problem is "get table" statement not get that table's record, also the err() statement returns "0" only. I don't why Please help?
Thanks
Manikandan.S
*This post is locked for comments
Hi thanks to all,
I have found the solution, Actually I have inserted values to the TABLE1 by copying from the excel sheet. It was added some additional space with field values. So that it was not retrieved properly.
Thanks,
Manikandan.S
Mani,
Use the below "range where" condition to set range and check whether it is working or not.
range table SOP_LINE_TEMP where physicalname ( 'Item Number' of table TABLE1)+ " = '"+ 'Item Number' of table IV_Serial_MSTR +"' and "+ physicalname (Bin of table TABLE1 )+ " = '"+ 'Bin of table IV_Serial_MSTR +"' and "+ physicalname ('Serial Number' of table TABLE1)+ " = '"+ 'Serial Number' of table IV_Serial_MSTR +"'";
Hope this helps!!!
Hi Naga,
At first I have tried with windows fields, but it was empty value. Only table had the correct value. That is why I have chosen the table values.
Thanks
Manikandan.S
Hi Manikandan,
So I see you are setting the data based on the scroll table IV_Serial_MSTR. I suggest you to set the TABLE1's key fields from the Scroll window fields, instead of the Table IV_Serial_MSTR.
Hope it works.
Hi Naga,
Thanks for your response, I have not run the SQL profiler, Could you explain how SQL profiler useful in this case. Here is my coding
release table TABLE1 ;
clear table TABLE1 ;
range clear table TABLE1 ;
'Item Number' of table TABLE1 = 'Item Number' of table IV_Serial_MSTR;
Bin of table TABLE1 = Bin of table IV_Serial_MSTR;
'Serial Number' of table TABLE1 = 'Serial Number' of table IV_Serial_MSTR;
get table TABLE1 by MB_YSL_Serial_Key1;
if err(table TABLE1 ) = OKAY then
'MB Manifest Number' of window IV_Serial_Number_Inquiry_Scroll of form IV_Serial_Number_Inquiry = 'MB Manifest Number' of table TABLE1 ;
end if;
Did you check in SQL Profiler when the get table statement executed. Could you post the script you have written.
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
Share
Report
All responses (
Answers (