Check if you're using the latest version of VFP ODBC driver (6.01.8629.01). Also try

csql = [Select * from accounting!datacenter where STR(dcno) = STR(1)]

>I already tried this command
>
>csql = [Select * from accounting!datacenter where dcno = 1]
>
>
>the field dcno has a data type I(4). The value one exist in the base table and is being displayed when the following command is executed.
>
>csql = [Select * from accounting!datacenter]
>
>It's kinda weird and I can't seem to find an explanation why it does not work with the first command.
>
>I tried to filter it with other field that exist in the table and it works.
>
>csql = [Select * from accounting!datacenter where abbrev = 'ES']
>
>this command displayed a single record with the DCNO = 1 that I am trying to display with the first command...