MB Software Solutions <> wrote: > Stephen the Cook wrote: >> Ed Leafe <> wrote: >> >>> On Jan 8, 2007, at 9:42 AM, MB Software Solutions wrote: >>> >>> >>>> Well, I wouldn't say it so brashly, but I've felt that way somewhat >>>> about the VFP DE for some time, as I thought it tied you into a VFP >>>> backend pretty much. Using a different approach (like n-tier in my >>>> case) allows me much more flexibility, imo. >>>> >>> Well, sure; it doesn't make sense to lock in your design to one >>> thing. You can define a connection to MySQL, and if later you want >>> to change to an MS SQL Server backend, all you have to do is update >>> the connection information, and everything will still work. >>> >> >> You still need to adjust code per backend for joins, date math and >> such. Oracle / DB2 / MySQL are all different in these cases. >> > > Yes, but the variations are not great. In the open source n-tier > project I posted on Ed's OpenTech forum, I used a simple DBF that > listed the default SQL, specific backend SQL (for overriding the > default SQL), primary key, candidate keys, updatable fields, etc. and > that design was pretty easy, imo. Sure, there are subtle > differences, but no show stoppers or big deals, imo.
Date math is the biggest problem I have faced. I currently work with M$, Oracle and DB2 databases and each has their own special way. Joins are much easier. Stephen Russell DBA / .Net Developer Memphis TN 38115 901.246-0159 "Our scientific power has outrun our spiritual power. We have guided missiles and misguided men." Dr. Martin Luther King Jr. http://spaces.msn.com/members/srussell/ -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.16.7/619 - Release Date: 1/7/2007 6:29 PM _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
