Yuri,
Specifying an alias makes no difference.
Did you delete/remove the original table? If it is in your path, VFP will find it and the SELECT SQL will work, but if the original file is deleted/moved/renamed (i.e. the only copy is the one build into the .app file), the SELECT SQL will fail with error message: "File 'testtable.dbf' is not found". However, you can still view the table, select() it, browse it, scan it, etc.
>It seems your puzzle is solved when:
>
>use testtable alias testtable
>
>Regards
Timothy D. Yeaney
MCSD, Charter Member
President, PAFOX (Potomac Area Fox User Group)
mailto:
tim@eagleeyeinc.com Vice President
Eagle Eye Publishers, Inc
Broaden Your Vision, Sharpen Your Focus