Search results

Thanks @TomBascom This code isn't mine, t-bomcomp is a temp table and I'm not sure about the range either but It's not hurting anything so I'm going to leave it in for now. I will remove the FIRST keywords :).

for each t-bomcomp no-lock. if t-bomcomp.qty-req-per + t-bomcomp.qty-req-scrap = 0 then do: delete t-bomcomp. next. end. find first bfgitem where bfgitem.inentity = p-inentity and bfgitem.itemcode =...

@Stefan would it not only go to the end if a record wasn't available due to the "IF NOT AVAILABLE"? I know there are records due to the export I entered.

Thank you Stefan.... that makes so much more sense. https://docs.progress.com/bundle/abl-reference/page/NEXT-statement.html I tried reading the above but I wasn't getting it.

Hi Guys, I'm just looking at section of code and I think my understanding isn't a 100%. find first bfgitem where bfgitem.inentity = p-inentity and bfgitem.itemcode = t-bomcomp.itemcode no-lock no-error. if not available bfgitem then next. find first...

Thank you @TomBascom and @Jean-Christophe Cardot. Can't wait to use TABLE-SCAN more.

Hi Guys, I've got a field (Item.Description) that has a type of CHAR and format of x(80). We've got a few records exceeding the character length and I would like to identify those records as they're causing issues. All I've got so far FOR EACH Item WHERE Item.Description...

Thank you both, will have a look.

Thank you @Rob Fitzpatrick, got it to work after a while, realised the parameter needs to be in upper case.

Hi, Thanks @Rob Fitzpatrick , I've gone down the path of DataDigger and have set it up successfully but ran into an issue with security. The database doesn't allow you to login with a blank userid, so when I launch DataDigger using my -pf file I get the following error. (See attached error)...

Hi All, Just need some guidance. Where I currently work, to view the records in the database we currently use an ODBC connection and use Excel as the front end interface. However it's very very slow and full off issues that I'd rather not go into. When I first started working at my current...

Hi @Rob Fitzpatrick I'll keep your advice in mind :).

Thank you, @Stefan and @DOKTORF ... TO VALUE (cFileName)... worked. I will look at the below - also look at iso-date( now ) - also do not rely on time but use a guid

@DOKTORF When you say Progress has created a cFileName at it's root what do you mean. Is it stored else where? besides the path I specified ....

Thanks @DOKTORF but no joy with the above.

Hi Guys, My first post on here (Treat me like I've got no idea). Long story short, I'm looking at existing code that was coded to write and read from multiple files and on occasions from the same files. This is causing issues as users a free to schedule the task\job when ever they want. After...