Recent content by HT3

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