CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2

Thread: SQL standards?

  1. August 12th, 2003, 10:00 AM #1
    Winni
    Winni is offline Junior Member
    Join Date
    Feb 2001
    Location
    Germany
    Posts
    20

    Question SQL standards?

    Hi,

    we currently try to develop an application, which is capable to work with different databases. The interface is ADO.
    The problem is that the some providers (native ADO Access 2000, SQL Server, ODBC for MySql,...) behave different in the SQL syntax, they accept. For example in a SQL-join, some providers accept a field name only with addiotional leading table name, while others accept them only without.

    Is there any standard, what SQL syntax will be accepted by any provider?

    Thanks,

    Christian
    Reply With Quote Reply With Quote
  2. August 14th, 2003, 10:50 AM #2
    womalley
    womalley is offline Member
    Join Date
    May 2003
    Location
    upstate NY
    Posts
    168
    give this book a look

    http://www.oreillynet.com/pub/a/netw...oracleian.html

    will
    --------------------------------------------
    Tell me and I will forget
    Show me and I will remember
    Teach me and I will learn
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules




Click Here to Expand Forum to Full Width

Featured