Re: RDBMS question on coding "expanding series-like fields"

2001-02-27 Thread Peter R. Wood - Mailing Lists
Hi Warren, What I personally would do is simply include some sort of 'ID' field. In other words, each question would have a unique ID. Question 1's ID would be 1, Question 2's ID would be 2, etc. Or however you wanted to number them. You could even set this up as an auto_increment and have t

RE: RDBMS question on coding "expanding series-like fields"

2001-02-27 Thread Julian Strickland
the tutorials at this site useful http://www.rd-robotics.com/accesscommunity/tutes/index.html although it is based on access I found it useful. > -Original Message- > From: WCBaker [SMTP:[EMAIL PROTECTED]] > Sent: 27 February 2001 16:25 > To: MySQL > Subject: RDBMS que

Re: RDBMS question on coding "expanding series-like fields"

2001-02-27 Thread Basil Hussain
Hi, > I have a Test Questions database. Right now I have a hard-coded limit of > 200 questions in it; I actually made a table with field names like Quest1, > Quest2. . . Quest200. However, I know that I am not using the power of > MySql in setting it up this way. This is more an example of m

RDBMS question on coding "expanding series-like fields"

2001-02-27 Thread WCBaker
Hi! I have a Test Questions database. Right now I have a hard-coded limit of 200 questions in it; I actually made a table with field names like Quest1, Quest2. . . Quest200. However, I know that I am not using the power of MySql in setting it up this way. This is more an example of my own ig