[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.