8 Replies Latest reply: Jun 8, 2015 6:11 AM by Robert Ögren RSS

    mystically different values?

      Hi all!

      A couldnt understand one thing  - i have a connection to a  *.mdb file, which has a tuned query ('index_all') (smth like average values gpopped by smth). If I execute this query in Access - i recieve a dataset.   But, If i try to do this:


      data_index:

      LIB CONNECT TO '*.mdb';

      LOAD `Avg-Avg-metr`,

          `Avg-Avg-price`,

          `Count-Avg-metr`,

          `Max-data`,

          `StDev-Avg-metr`;

      SQL SELECT `Avg-Avg-metr`,

          `Avg-Avg-price`,

          `Count-Avg-metr`,

          `Max-data`,

          `StDev-Avg-metr`

      FROM `index_all`;


      I recieve dataset with slightly different values. (the structure is the same, but values are different!)

      Why does it happen?


      Thanx a lot!