- From: Ted Thibodeau Jr <tthibodeau@openlinksw.com>
- Date: Tue, 24 Jan 2012 14:39:23 -0500
- To: Juan Sequeda <juanfederico@gmail.com>
- Cc: Ivan Herman <ivan@w3.org>, "Eric Prud'hommeaux" <eric@w3.org>, Alexandre Bertails <bertails@w3.org>, W3C RDB2RDF <public-rdb2rdf-wg@w3.org>
- Message-Id: <F6D1E799-1538-48F4-8C53-11779783A295@openlinksw.com>
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
Attachments
- application/pkcs7-signature attachment: smime.p7s
Received on Tuesday, 24 January 2012 19:39:52 UTC