Re: multiple values
From: Joe Celko (jcelko212_at_earthlink.net)
Date: 08/16/04
- Next message: Jason Moore: "Multiple joins"
- Previous message: Joe Celko: "Re: T-SQL block is not running"
- In reply to: Ezekiël: "multiple values"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 16 Aug 2004 14:22:29 -0700
>> Does anyone has a some good advice/example how to store multiple
values for a field [sic]. <<
Let's get back to the basics of an RDBMS. Rows are not records; fields
are not columns; tables are not files; there is no sequential access or
ordering in an RDBMS, so "first", "next" and "last" are totally
meaningless. BY DEFINITION a column holds scalar values.
You have completely missed the most basic ideas of an RDBMS and are now
hunting for kludges.
>> For single choice fields [sic], i use a combobox in access and the
value will be an integer number, but how about when a field [sic] has
multiple choices? Should i
use a listbox with multiple select enabled for visual appearance. <<
Next mistake; you do not know about physical and logical levels in a
system. There is no such thing as a combobox in SQL; that is front end
stuff and has nothign to do with the database.
>>I'm running out of ideas, can anyone help me on this? <<
I'll bet you have never read a book on RDBMS; you might want to start
with that. You are so completely off-base that a newsgroup cannot
really help you. The best we can do is throw out a kludge or try to do
your job for you.
--CELKO--
===========================
Please post DDL, so that people do not have to guess what the keys,
constraints, Declarative Referential Integrity, datatypes, etc. in your
schema are.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
- Next message: Jason Moore: "Multiple joins"
- Previous message: Joe Celko: "Re: T-SQL block is not running"
- In reply to: Ezekiël: "multiple values"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
