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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement