Database independent is a lofty goal, but, IMO, it's not a good one. It means all your SQL has to be very generic and prohibits you from taking advantage of specialized processing, commands, datatypes, etc. You are prohbited from using stored procs and have to do all the SQL statements yourself inside the application.
>The intention was to do that soon, but be database independent (I know some outfits here run serious business using VFP over MySQL, and at least one with Postgress - and whatever you may say about the cost, the economy is different here, a cost of a SQL server license may be someone's annual salary), so triggers and stored procedures are to be avoided.
>
>Anyway - my friend is reading this and he thanks you all.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer