Search results

  1. A

    Back ups

    Hi everyone, I'm looking for a little help with back up routines. I am running SX.enterprise 5.6.063 on Progress 9.1E (well, I'm fairly sure it's E - perhaps someone can help me find that out while we're on the job) running on Linux Redhat and the tape drive back up we have been using is...
  2. A

    Linux batch file to call SQL

    Ah. This will be an 'in' joke that I am unaware of :o
  3. A

    Linux batch file to call SQL

    Thanks, I'll look that up when I'm back in the office. Version One support advised me to attempt it this way.
  4. A

    Searching in a array field

    I'm no expert, but perhaps the extract from the SQL-92 reference could help: Array fields are created using the Progress 4GL Dictionary. Progress SQL-92 provides a mechanism for referencing and updating these arrays. Subscripted references are not supported. Progress SQL-92 manages the arrays...
  5. A

    Linux batch file to call SQL

    Well, I ran a really simple query on the command line using a .sql file with some basic SQL, and returned the data to a .log file. That returned the expected data, so that worked a treat. Now I need to pass a variable into that query somehow. Easy example, I would like to pass an order number...
  6. A

    Linux batch file to call SQL

    Do you know what? Scrub what I said before, I've just found an email stating that we will be using 10.2B for the latest version of SX.e. Thank you both very much, I really do appreciate the advice.
  7. A

    Linux batch file to call SQL

    What can I say? Thank you for your quick response. I believe I can work with this information, I've found the executable, if I have any more trouble I know where to come! As for upgrading Progress, as I say, if we move to SX.e 5.7.060, we'll be on (I'm fairly certain) Open Edge 10.1, so...
  8. A

    Linux batch file to call SQL

    Hi all, I'm looking for some help with writing batch file to call an SQL Query on Linux Red Hat with Progress 10.1 OE. I've struggled to find anything on the forum, but like so many questions, there could be all sorts of keywords, so I hope I'm not duplicating anything. Basically, we currently...
  9. A

    Problem with IF variable IS NULL

    Thank you very much all, a little trial and error with the date format, but problem solved now!:rolleyes:
  10. A

    Problem with IF variable IS NULL

    Thanks for the quick response, unfortunately, I get: ** Incompatible data types in expression or assignment. (223) ** Could not understand line 13. (196) It's line 13 because I added some criteria to restrict the effect to limited records.
  11. A

    Problem with IF variable IS NULL

    Hi, everyone. I am trying to find and replace blank instances of a date field with the date I want it to read. I know absolutely nothing about programming in Progress, so I'm just attempting to edit a procedure of someone elses. This is what I've ended up with: DEF VAR a AS INT LABEL "records...
Back
Top