Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- while select count(recid) from amtExport
- group by billOfLadingId
- where amtExport.createddatetime1 >= utcDT
- {
- if (amtExport.RecId == 2)
- {
- while select amtExport1
- where amtExport1.billOfLadingId == amtExport.billOfLadingId
- {
- info(amtExport1.billOfLadingId);
- }
- }
- }
- AMTExport amtExport, amtExport1;
- ASCII asciiLetter;
- while select count(RecId) from amtExport
- group by billOfLadingId
- {
- if (amtExport.RecId == 2) // Should this be .RecId > 1?
- {
- asciiLetter = 65; // Reset letter to 'A'
- while select amtExport1
- where amtExport1.billOfLadingId == amtExport.billOfLadingId
- {
- info(amtExport.billOfLadingId + num2char(asciiLetter));
- asciiLetter++; // Increase the ascii letter
- }
- }
- }
Add Comment
Please, Sign In to add comment