The WHERE cluases are for filtering, I just tried them out in the opentables function hoping they would do the job on calling requery(). I was trying to re-create the data environment as I want it, instead of how VFP insists it be. Life would be so much easier if VFP would recoqnise index/forieng keys in remote tables! Oh, and Yes, the table structure is the same with or without data loaded, and is the same as the source tables, which were originaly written in VFP, then exported to Oracle via the Upsizing wizard. It was no fun to be nearly ready to roll out a beta of the app and then have the back-end changed to Oracle, now, no training, don't whine, just do all your databases in Oracle from now on!
Anyway, even without the WHERE clause, on the three problem tables, even from the command line, I get "no result set returned" . I can however, browse them, select them into a cursor and browse it, do anything except use them in the data entry form!