>SQL Select for different platforms
There are a few approches... Here is one approach:
http://fox.wikis.com/wc.dll?Wiki~TightlineDataClasses~VFPThe other approach is to USE SP's for all your data access. While most of the SP's will be the same for both systems, where they are different will be in the SP on the data layer. So, running the GetCustomerByID SP will accept the same parameters and return the same results in both your SQL and Oracle databases.
BOb
