Posted by Jerry Stuckle on 11/11/07 22:47

AnrDaemon wrote:
> Greetings, Jerry Stuckle.
> In reply to Your message dated Sunday, November 11, 2007, 17:05:47,
>
>> Why complicate things by putting SQL statements in a different file
>> where you can't see them?
>
> It may be not that clear for You, but I actually support one project
> runned on 2 different databases at the same time. (MySQL and MS SQL server)
> And that schema was found better in all cases.
>

Nope, what a confusion. I can think of much easier ways of doing that.
Including using ANSI-standard SQL.

>> And why go to all that hassle when you can
>> use ANSI-compliant SQL and have it work on virtually every database
>> (except MS Access)? Complicates things unnecessarily, IMHO.
>
> Well, can You translate cross-databse reference like [db1].[dbo].[table1] ?
>

When I see the possibility of multiple RDBMS's, I use standard SQL.

>> There has been nothing in this thread which is non-ANSWI SQL - except
>> for the use of a reserved word in a column name.
>
> I know.
>
>

But then I also have database access in classes. I have no SQL
statements or other database specific code in the web pages' code.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]