Posted by --CELKO-- on 01/31/08 11:35

>> The end result would increment the variable "somevalue" by one and then create the next table (ie: TESTTEST2). <<

This design flaw is called attribute splitting. A table models a set
of the same kind of things. The <some value> should be in a column
of a single table. That is why you have a Personnel table and not
MalePersonnel and FemnalePersonnel tables (split on gender values).

What you have done is mimic a 1950's magnetic tape file system in SQL.
Right down to the labeling convention! You made the classic newbie
mistakes of confusing files with tables and columns with fields. If
you learn the right terms, you will find it is easy to avoid a lot of
problems.

• Next in forum: Re: Create Table with Variable included in Table Name
• Prev in forum: Re: Join 4 tables - can it be done?
• Thread view: Re: Create Table with Variable included in Table Name

[Reply to this message]