Re: Mutivalued datatypes considered harmful

As for the query (for selecting people with specific multiple hobbies),
wouldn't it be logical that the following would work:

select * from file where Hobby = "Fishing" and Hobby = "Chess"

I'm not quite sure what the resultant query would return though!! Using
standard RD theory, this would return two rows, with all the fields being
identical except for the "Hobby" field... I'm not a massive expert in
SQL, but wouldn't the "DISTINCT" modifier then restrict this to one row ?
If so I wonder what would happen to the Hobbies field!

Well, in normal systems, you don't have muti valued fields. what that
article FAILS TO MENTION is that the sql
in ms-access NOW SUPPORTS this....

So, the above query is perfectly legal!!!, and WILL WORK on multi-value
fields...

then presumably the SQL language needs modifying to cope

The sql in ms-access has been modified. Not only that, both the DAO, and ADO
object model have been also extended...

So, those people in the article were NOT aware that you can do this, and the
supposed problems of multi-value fields does work!!

As I point out in the other thread, in some ways, the sql extensions are
easier to use then the pick query language...

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@xxxxxxx
http://www.members.shaw.ca/AlbertKallal


.

Relevant Pages

  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: Mutivalued datatypes considered harmful
    ... query return if you brought back the "hobbies" field in an sql query - say ... sql does not - so the mysql/oracle feature was never consided multi-vlaued. ... The extensions to ms-access are real and signcivnetly in this matter. ... transloates to a lookup table, the same would be done for ms-access. ...
    (comp.databases.pick)
  • Re: Mutivalued datatypes considered harmful
    ... query return if you brought back the "hobbies" field in an sql query - say ... sql does not - so the mysql/oracle feature was never consider multi-valued. ... The extensions to ms-access are real and significant in this matter. ... translates to a lookup table, the same would be done for ms-access. ...
    (comp.databases.pick)
  • Re: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)
  • How do I do Paging through a large dataset via Stored Procedures
    ... Paging by dynamically altering the SQL Query ... Create stored procedures ... SELECT * FROM STUDENTS ...
    (microsoft.public.dotnet.framework.adonet)