[ZDP] BackTalk to Document The Zope Book (2.5 Edition)/Relational Database Connectivity
webmaster@zope.org
webmaster@zope.org
Sat, 16 Nov 2002 19:02:21 -0500
A comment to the paragraph below was recently added via http://www.zope.org/Documentation/Books/ZopeBook/current/RelationalDatabases.stx#2-20
---------------
To ensure that the employee id is a unique number you can create
an index on your table. Type the following SQL code in the *Test*
view::
CREATE UNIQUE INDEX emp_id ON employees
(
emp_id
)
% Anonymous User - Nov. 16, 2002 7:02 pm:
emp_id is already the field. Name the index something like emp_id_idx or you will generate an error, and you
are not using a good naming convention.