Visual FoxPro 8 vs. MySQL (dynamic views)

[Jan Klufa]

Hi
I have problem with CREATE SQL VIEW qqq REMOTE... in VFP8
If creates VIEW
"Create SQL View test remote connectio mysql as select * from table where key=1"
than in myodbc.log is

-- Query logging
--
-- Driver name: MySQL ODBC 3.51 Driver Version: 03.51.09
-- Timestamp: 040924 12:44:26

;
select * from table where key=1;
;
SELECT * FROM table;
SHOW KEYS FROM `table`;

I read any mail lists, but I i change and compile MyODBC DLL, it dont help me
Maybe VFP sents command for SELECT ALL data from table if creates REMOTE View???
I need creates dynamic Views, and it is not possible !!!