I'm having a problem with an application that has been running in VFP3 for over a year. MSSQL 6.5 with Foxpro as front-end. I am using parameterized views in the data environment of the forms and this works well for the majority of the app. I like to use SQLEXEC to return a cursor for specific data searches and for reporting. These are not updateable - they are meant to be read-only.

Since moving this app to VFP5, when using this SQLEXEC code to return a cursor with 'text' (Memo) fields, I am getting an error 'No update tables specified. Use the Tables property of the cursor.' Using =cursorgetprop('tables') I determine that the underlying table is not, in fact, specified. But even specifying it with =cursorsetprop('tables','tablename') does not clear the error. I am unable to access the cursor or the memo field without getting the error. I have tested the code pulling different fields that are not 'text/memo' fields and have no problem accessing the cursor or the fields in it. When I request a cursor with the text/memo fields, I cannot access the cursor fields by name in code, copy the cursor to a local table, or anything.

If I create a view in the .dbc for this instead of using SQL passthrough, it works also. I don't want to create extra views in my dbc that I have not needed up to now.

I spoke with Microsoft about this today and the representative indicated there may be something broken with ODBC but will be getting back to me. Has anyone else had this happen?

TIA
Gail