locked
odbc foxpro problem RRS feed

  • Question

  • hi all
    I have some problems with odbc fox pro driver
    I am using Microsoft Visual FoxPro Driver 6.01.8629.01

    I run query

    SELECT count(*), posfunc
    FROM pos_funx
    WHERE posfunc='007'
    ORDER BY posfunc
    GROUP BY posfunc;

    and got result
    cnt    posfunc
        58    007

    I run

    SELECT count(*), posfunc
    FROM pos_funx
    ORDER BY posfunc
    GROUP BY posfunc;

    and got
    cnt    posfunc
    30    001
    18    002
    29    004
    194    005
    192    006
    273    007
    8    009
    10    010
    2    011
    1    012
    3    014
    16    016
    157    017
    8    018
    5    019
    1    020
    3    021
    1    024
    3    026
    7    027
    5    028
    206    031
    16    033

    I got two counts  for '007' 58 and 273 and 273 is correct ?
    Can I rely on Where clause?


    Friday, October 31, 2008 8:52 AM

Answers