Hi Tore
I do work with Oracle and I know from experience what kind of problem VFP7 and earlier SQL can cause. But I have an application that was written in VFP 5 with many SQL that's working fine. As they say in Texas, If it ain't broken don't fix it
>Be careful with Set Enginebehavior! This command is NOT an easy way to convert your program, but it makes it easier to fix one select statement at a time. They discovered that VFP7 amd VFP8 could give wrong result in some cases, and changed the SQL engine to fix this. And at the same time they also changed the SQL syntax to comply with SQL ANSI satndards,
>
>This important change means that you must change all the select statements which reports error with enginebehavior 90. If you don't, you risk wrong results from your select statements!!!
>
>>Hi
>>
>>At last I am porting my application to VFP9. is there a document with tips,tricks, or gotchas before deploying the application.
>>
>>So far, it looks painless as long as the EngineBehavior set right.
>>
>>thanks
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only