Search results

  1. H

    Understanding IF NOT AVAILABLE STATEMENT

    Thank you @peterjudge and @tamhas, reading both your replies together helped me understand. Yes I need to work on that.... :)
  2. H

    Understanding IF NOT AVAILABLE STATEMENT

    Sorry I'm still not getting it :confused:, I don't satisfy my FOR EACH query but then the very next line I say if it's not available then message me... so should it not display the message?
  3. 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...
  4. H

    OS-COMMAND Won't Run With a Variable Path

    Thank you so much @TomBascom, I've always put quotes against paths...... I've just tried it without quotes and it worked. Thank you for clarifying the VALUE functionality.
  5. H

    OS-COMMAND Won't Run With a Variable Path

    Thank you @Osborne , just so I've got this right anytime I have variable and want to achieve anything with it using another statement I have to use VALUE? I've previously done this but only when outputting to a stream.
  6. 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...
  7. H

    Skipping An Unavailable Record

    Thanks @Rob Fitzpatrick and @Patrice Perrot. I've resolved the issue.... icbccnt = 0. FOR each ttcbc no-lock: lv_size = "". lv_back = "". lv_cup = "". IF item.backsize <> "" THEN DO: FIND FIRST...
  8. H

    Skipping An Unavailable Record

    Hi @Stefan, Screen Shot One Screen Shot Two icbccnt = 0. FOR each ttcbc no-lock: lv_size = "". lv_back = "". lv_cup = "". IF item.backsize <> "" THEN DO: DISPLAY ITEM.ItemCode. FIND FIRST...
  9. H

    Skipping An Unavailable Record

    Hi @WinningJr, "The item table seems to come out of nowhere." This is just a block of a much larger piece of code, which is why it seems the item table appears from no where (There are around 500 items). "You are checking if ttcbc is available when inside a FOR EACH ttcbc (it is always...
  10. 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...
  11. H

    DB Parameters -S

    Hi @Rob Fitzpatrick , thank you for the extra information.
  12. H

    DB Parameters -S

    Thank you @Cringer, I know where that file is located. Will have a look at it.
  13. 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
  14. H

    Avoid First Line of Import

    Thanks @peterjudge that did the trick.
  15. 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...
  16. H

    Understanding Temp-Table Records

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

    Understanding Temp-Table Records

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

    Understanding Temp-Table Records

    Thank you so much.... they all display now. I thought telling it to display tt-item would have the same effect.
  19. 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...
  20. H

    Understanding A Block Of Code

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