Search results

Thanks @peterjudge that did the trick.

Hi All, I'm looking to run a script on a regular basis which imports data from another file. The first line of the import file contains headers and needs to be avoided, the attached error always appears. I just don't want the error appearing every time I ran it or I don't want to delete the...

Thank you @TomBascom, I've tried but what I've found is another Dev always tell me one way and another a different method :).

Thank you @x_jeferson that explains why I was only getting the one record.

Thank you so much.... they all display now. I thought telling it to display tt-item would have the same effect.

Hi All, I'm writing a script to do X but before I get to that stage, I've imported the ItemCode into a temp-table so that I can then use it further down the line. However I'm running into an issue with the data stored in the temp table. I think it's do with my understanding on the REPEAT...

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 ....