List:General Discussion« Previous MessageNext Message »
From:Pat Sherrill Date:May 30 1999 2:07pm
Subject:Re: TQuery
View as plain text  
Try adding a timestamp column/field to your table.

I hope this helps...

Pat...

----- Original Message -----
From: Michael Farr <farrm@stripped>
To: MySQL <mysql@stripped>
Sent: Saturday, May 29, 1999 10:36 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@stripped
>
> 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@stripped instead.
>
>

Thread
TQueryMichael Farr30 May
  • Re: TQueryPat Sherrill30 May
Re: TQueryL. Stapinsky1 Jun
Re: TQueryL. Stapinsky1 Jun
  • Re: TQueryDave1 Jun