RE: Microsoft Jet SQL Reference
- From: "'69 Camaro" <ForwardZERO_SPAM.To.69Camaro@xxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 13 Oct 2005 13:31:08 -0700
Hi, Chris.
>I can locate help with subject topic in my local Access 2003 documentation,
> but it's nowhere to be found on msdn.microsoft.com. Please send link.
The entire Jet 4.0 SQL Reference is on your hard drive in the following
location if you installed MS Office in the default directories (watch out for
word wrap):
"C:\Program Files\Common Files\Microsoft Shared\OFFICE11\1033\JETSQL40.CHM"
For more insight on using DDL for Jet 4.0 (and a few more examples), read
the SQL Server BOL. One can download it from this Web page:
http://www.microsoft.com/downloads/details.aspx?FamilyID=a6f79cb1-a420-445f-8a4b-bd77a7da194b&DisplayLang=en
> I'm quite challenged by the CONSTRAINT clause documentation. In particular,
> this example from the documentation doesn't seem to work:
One must set the SQL Server Compatible Syntax (ANSI SQL-92) option for the
current database before this syntax will work in the SQL View pane.
> CREATE TABLE Orders (OrderId INTEGER PRIMARY KEY, CustId INTEGER, OrderNotes
> NCHAR VARYING (255), CONSTRAINT FKOrdersCustId FOREIGN KEY (CustId)
> REFERENCES Customers ON UPDATE CASCADE ON DELETE CASCADE)
One must set the SQL Server Compatible Syntax (ANSI SQL-92) option for the
current database before this syntax will work in the SQL View pane, too.
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
"Chris Smith" wrote:
> I can locate help with subject topic in my local Access 2003 documentation,
> but it's nowhere to be found on msdn.microsoft.com. Please send link.
> Lots of non-relevant stuff when I searched on MSDN, though.
> I'm quite challenged by the CONSTRAINT clause documentation. In particular,
> this example from the documentation doesn't seem to work:
> -8<--------8<------
> You can specify actions to be performed on the foreign table based on a
> corresponding action performed on a primary key in the table on which the
> CONSTRAINT is defined. For example, consider the following definition for the
> table Customers:
> CREATE TABLE Customers (CustId INTEGER PRIMARY KEY, CLstNm NCHAR VARYING
> (50))
>
>
> Consider the following definition of the table Orders, which defines a
> foreign key relationship referencing the primary key of the Customers table:
>
> CREATE TABLE Orders (OrderId INTEGER PRIMARY KEY, CustId INTEGER, OrderNotes
> NCHAR VARYING (255), CONSTRAINT FKOrdersCustId FOREIGN KEY (CustId)
> REFERENCES Customers ON UPDATE CASCADE ON DELETE CASCADE
> ---8<-------8<-----
>
> Even s/NCHAR VARYING (255)/VARCHAR(255)/ just got me to a parse error in
> the constraint clause.
> Basically, I'm writing my database as a text file, and doing some
> hack-tackular stuff to it in a script, such that it builds against MSAccess,
> or SQLServer, but the Jet4.0 SQL DDL seems to suffer from a popularity
> deficit...
> Thanks,
> Chris
>
>
.
- Prev by Date: Re: Very complex query
- Next by Date: Re: "Effective Date" Criteria for Rates
- Previous by thread: Re: Problem with adding new records to a table
- Next by thread: Re: Microsoft Jet SQL Reference
- Index(es):
Relevant Pages
|
