Search results

  1. B

    ODBC returning different totals to 4GL

    Well the 4GL code looks like this.... /* INTRANET_S_Base_Values_Analysis.p */ /* last print date 110407 */ /* RUNTIME ~ 7 min. */ /********************************************************/ /* PROGRESS Base Values Analysis - csv file re Intranet */...
  2. B

    ODBC returning different totals to 4GL

    Thanks for the reply, I suspect you will probably be right when I run a count query also. But no really knowing how the Progress SQL works with the 4GL brokers etc, what causes should I be looking at, considering I know the data is correct and I am running the same query just in SQL and not 4GL...
  3. B

    ODBC returning different totals to 4GL

    I've recently been given access to our databases with ODBC and a playing around. Our sales figures are held in a table called D2_Move, when I run a query to select all the sales figures in a database and add them up it returns a smaller figure than when run against 4GL, I can't work out what...
  4. B

    Nested SQL Queries

    Hi Guys, this is my first foray into the SQL side of progress, we're running 9.1c on an AIX box, I connect it using the merrant ODBC drivers and I'm trying to write a nested query that shows our sales figures for the month. I've crafted this.... Select * FROM[ Select PUB.D2_MOVE.trad_code...
  5. B

    Connect to AIX Server from Windows using ODBC

    Hi Guys, I'm currently working in a company who uses progress for it Stock control and I have been asked to come up with a nice front end for some figure we need to get out of it. I've never used progress before and I've searched and searched but can't come up with an answer. On our server...
Back
Top