odbc foxpro problem

• Friday, October 31, 2008 8:52 AM

   

   
  

  0
  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?
  
  
  
  • Reply
  • Quote