[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: TQuery
From:       "L. Stapinsky" <pinky () arcana ! bc ! ca>
Date:       1999-05-31 20:27:30
[Download RAW message or body]

my mistake, I think this may be more approporiate :

ALTER TABLE' syntax:

ADD UNIQUE [index_name] (index_col_name,...)


-----Original Message-----
From: Michael Farr <farrm@lion.cs.latrobe.edu.au>
To: MySQL <mysql@lists.mysql.com>
Date: Saturday, May 29, 1999 7:44 PM
Subject: TQuery


>I am using Borland Builder 4.0 to build a windows application that uses a
>MySQL database though the MyODBC connection.  When I try to execute a
>refresh method of a TQuery (iepersonQ->refresh(), I get a message saying
>that "Table does not support this operation because it is not uniquely
>indexed.".  What does "uniquely indexed" mean in this context, it cant be
>referring to the database because I set the first column to primary key
>here is the explain text
>
>mysql> explain Patient;
>+-----------------------+------------+------+-----+---------+--------------
--+
>
>| Field                 | Type       | Null | Key | Default |
>Extra          |
>+-----------------------+------------+------+-----+---------+--------------
--+
>
>| patientId             | int(11)    |      | PRI | 0       |auto_increment
|
>| title                 | char(4)    | YES  |     | NULL|                |
>| familyName            | char(20)   | YES  |     | NULL|                |
>| firstName             | char(20)   | YES  |     | NULL|                |
>| middleName            | char(20)   | YES  |     | NULL|                |
>
>Is there something I can do to make this table more uniquely indexed, or
>has someone got another idea?
>
>
>
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>posting. To request this thread, e-mail mysql-thread4154@lists.mysql.com
>
>To unsubscribe, send a message to the address shown in the
>List-Unsubscribe header of this message. If you cannot see it,
>e-mail mysql-unsubscribe@lists.mysql.com instead.
>


---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail mysql-thread4233@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail mysql-unsubscribe@lists.mysql.com instead.

[prev in list] [next in list] [prev in thread] [next in thread]