Jim,
I have a PRG to load views in the DE BeforeOpenTables where I can use Sys(3099,70). I guess I should have asked if there are any solutions other than using VFP7 behavior. Obviously there are valid reasons behind the standard, including accuracy of the result set.
What I am looking for is a solution for now, and a discussion which could lead to to a more real world standard.
Thanks for the reply.
>No guru here, Steve, but SET ENGINEBEHAVIOR 70 will get you out of the catch-22.
>
>good luck
>
Steve Buttress, MCP
ProMatrix MVP - Life
ProSysPlus Developer