Search results

  1. H

    Understanding IF NOT AVAILABLE STATEMENT

    Hi Guys, I'm very confused and not sure why my "IF NOT AVAILABLE" statement isn't working under certain scenarios. For example when I use the FIND function in the working code with the "IF NOT AVAILABLE" statement, the "UNAVAILABLE COLOUR" message is displayed as I expect. I can then amend the...
  2. H

    OS-COMMAND Won't Run With a Variable Path

    Hi, I've got an application which runs a .bat file using the OS-COMMAND statement, it's called a number of times within in the application. The path was hardcoded previously, however due the number of times it's called and now that I want it to run a different .bat file depending on the value...
  3. H

    Skipping An Unavailable Record

    Hi Guys, I've have a block of code which falls over because it's unable to find the cupbackconv.prodgroup. icbccnt = 0. FOR each ttcbc no-lock: lv_size = "". lv_back = "". lv_cup = "". IF item.backsize <> "" THEN DO...
  4. H

    DB Parameters -S

    Hi, I'm setting up an application and in the .PF file I've specified the database parameters (See screen shot). My question is what does the -S parameter point to and what does it do? I've tried looking in OpenEdge Explorer and can't find it against the database configuration. Thanks
  5. H

    Avoid First Line of Import

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

    Understanding Temp-Table Records

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

    Understanding A Block Of Code

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

    Counting All Characters in a String

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

    Prg DB Viewer & Data Digger

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

    OUTPUT STERAM WITH UNIQUE FILE NAME

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