Re: Review of the the DM pre CR version (Re: Final round of Direct Mapping spec changes; please review to prepare for CR)

Hi, Juan, all --

On Jan 24, 2012, at 12:38 PM, Juan Sequeda wrote:
> On Tue, Jan 24, 2012 at 12:01 PM, Ivan Herman <ivan@w3.org> wrote:
>> Thanks Ted. This makes it pretty clear and changes should be done. Juan?
> 
> Done!


I should have read more carefully.  The *table* identifiers 
in the INSERT statements *also* need wrapping, because they 
were so wrapped in the CREATE TABLE statements.

The example I quoted should now read...


> >   CREATE TABLE "Addresses" (
> >      "ID" INT, PRIMARY KEY("ID"),
> >      "city" CHAR(10),
> >      "state" CHAR(2)
> >   )
> >
> >   CREATE TABLE "People" (
> >      "ID" INT, PRIMARY KEY("ID"),
> >      "fname" CHAR(10),
> >      "addr" INT,
> >      FOREIGN KEY("addr") REFERENCES "Addresses"("ID")
> >   )
> >
> >   INSERT INTO "Addresses" ("ID", "city", "state") 
> >      VALUES (18, 'Cambridge', 'MA')
> >   INSERT INTO "People" ("ID", "fname", "addr")
> >      VALUES (7, 'Bob', 18)
> >   INSERT INTO "People" ("ID", "fname", "addr")
> >      VALUES (8, 'Sue', NULL)


Similar must be done throughout.


Be seeing you,

Ted


--
A: Yes.                      http://www.guckes.net/faq/attribution.html
| Q: Are you sure?
| | A: Because it reverses the logical flow of conversation.
| | | Q: Why is top posting frowned upon?

Ted Thibodeau, Jr.           //               voice +1-781-273-0900 x32
Evangelism & Support         //        mailto:tthibodeau@openlinksw.com
                             //              http://twitter.com/TallTed
OpenLink Software, Inc.      //              http://www.openlinksw.com/
         10 Burlington Mall Road, Suite 265, Burlington MA 01803
     Weblog   -- http://www.openlinksw.com/blogs/
     LinkedIn -- http://www.linkedin.com/company/openlink-software/
     Twitter  -- http://twitter.com/OpenLink
     Google+  -- http://plus.google.com/100570109519069333827/
     Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers