Guest User

Untitled

a guest
Jan 18th, 2018
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.89 KB | None | 0 0
  1. while select count(recid) from amtExport
  2. group by billOfLadingId
  3. where amtExport.createddatetime1 >= utcDT
  4. {
  5. if (amtExport.RecId == 2)
  6. {
  7. while select amtExport1
  8. where amtExport1.billOfLadingId == amtExport.billOfLadingId
  9. {
  10. info(amtExport1.billOfLadingId);
  11. }
  12.  
  13. }
  14. }
  15.  
  16. AMTExport amtExport, amtExport1;
  17. ASCII asciiLetter;
  18.  
  19. while select count(RecId) from amtExport
  20. group by billOfLadingId
  21. {
  22. if (amtExport.RecId == 2) // Should this be .RecId > 1?
  23. {
  24. asciiLetter = 65; // Reset letter to 'A'
  25. while select amtExport1
  26. where amtExport1.billOfLadingId == amtExport.billOfLadingId
  27. {
  28. info(amtExport.billOfLadingId + num2char(asciiLetter));
  29. asciiLetter++; // Increase the ascii letter
  30. }
  31. }
  32. }
Add Comment
Please, Sign In to add comment