Hi Dmitriy,

According to theory, C/S application is independent of the Backend but fact
is something different. I have worked with SQL Server,ORACLE & VFP native databases as backend with the same application. my experiance says me that you
can not create 100% database transparent app. The problem you have faced is an
ideal example. I have also faced such problmes.

for example
Syntax of OUTER JOIN query is different in all the three backends
IIF() - VFP
DECODE - ORACLE
SQL SERVER -CASE

In short, You have rewrite you SQL somewhere on the line where necessary


Regards,
Jayesh