Thats the way big enterprise solutions do it with VFP frontends - efiiciently scoped passthrough cursors.

I have retrieved cursors from MySQL on Linnux using SQLEXEC() through the desktop ODBC connection. THat worked well. I experiemented with ADO but could not retrieve a recordset. Never figured out why not.

>Hi Terry,
>
>Gotta tell you... I'm still struggling a bit with the buffering issues with views. What I'd like to do with Visual Foxpro is use it as a front end to a MySQL Database running under Linux. Should I dump remote views and stick with SPT for the flexibility ?
>
>Also I've noticed and reported a bug with the odbc driver that the recordset isn't reflecting autoincrement fields properly.... Would you know where one can find a patch, fix or work around for this ?
>
>
>thanks again,
>
>Don