Nope. Tried that also. What a PITA to be forced to use a SQL View or do it yourself with straight code. All 7 does is eliminate the need to do the following:
USE (dbf('MyCursor')) again in 0 alias crsNewCursor
use in MyCursor
select crsNewCursor
This will be an Enhancement Request for 8.
>Hi Mark,
>
>I wonder if the new undateable CURSORs in VFP7 provide relief with this?
>
>Just a thought.
>
>Cheers
>
>
>>I guess you can only do it for SPT cursors which, BTW, is where I have only done this because almost all my work is in Oracle. IMO, this is a really stupid restriction. I guess you could create a DSN-less connection to that table using SQLStringConnect(). This is sooo convoluted. IF you decide to go this way, get my ODBC_DSN class from UT Downloads.
>>
>SNIP
Mark McCasland
Midlothian, TX USA