'Could not find PRIMARY KEY... 
Author Message
 'Could not find PRIMARY KEY...

Ok, I have this in a file:

CREATE TABLE ...
  (...
   THEDATE     DATE NOT NULL,
   PANEL       CHAR(1) NOT NULL REFERENCES ...,
   ...
   PRIMARY KEY (THEDATE, PANEL));

and the result is:

Statement failed, SQLCODE = -607
unsuccessful metadata update

-could not find PRIMARY KEY index in specified table

And I *THINK* it might be because one of the two is a reserved word.
Any speculation? Is this a bug, or what?

The error messages on this thing could be a **BIT** more descriptive, yes?
Oh, and the online SQL reference could us:
1) a bigger typeface
2) a complete keyword/reserved-word list

Aloha from Vancouver, BC!

--
E ola mau ka `olelo Hawai`i!

Vote YES for Soc.Culture.Hawaii (Moderated)!
Strike a blow AGAINST Net-Terrorism!

Michael J. Wise
Vancouver, BC Canada
PGP Fingerprint = [80 FA 44 6B - C8 86 C1 2B - 70 0D 71 DE - A9 0C 62 85]



Fri, 20 Feb 1998 03:00:00 GMT  
 'Could not find PRIMARY KEY...

: Ok, I have this in a file:

: CREATE TABLE ...
:   (...
:    THEDATE     DATE NOT NULL,
:    PANEL       CHAR(1) NOT NULL REFERENCES ...,
:    ...
:    PRIMARY KEY (THEDATE, PANEL));

: and the result is:

: Statement failed, SQLCODE = -607
: unsuccessful metadata update

: -could not find PRIMARY KEY index in specified table

: And I *THINK* it might be because one of the two is a reserved word.
: Any speculation? Is this a bug, or what?

: The error messages on this thing could be a **BIT** more descriptive, yes?
: Oh, and the online SQL reference could us:
: 1) a bigger typeface
: 2) a complete keyword/reserved-word list

Not enough information provided. I successfully used...

  CREATE TABLE MJWISE
  (
    THEDATE DATE NOT NULL,
    PANEL CHAR(1) NOT NULL REFERENCES AAA (KEYFIELD)
    PRIMARY KEY (THEDATE, PANEL)
  )

...where AAA is a table with a primary key based on the column KEYFIELD.
Some more information about the table and column on which the dependency
is based? Its metadata?

--
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
_/ Steve Koterski               _/   The opinions expressed here are    _/

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/



Sat, 21 Feb 1998 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. How to find your primary key in interface

2. find primary key against database server table?

3. finding primary key fields in ORACLE database

4. Finding Primary Key of a table

5. Interbase - Can't add primary key to table

6. RegenIndexes doesn't works with Primary Keys

7. Sorting a PDox Table that doesn't have a primary key

8. Field 'PHYSICALTYPE' not found

9. BDE 'Could not find object'

10. Query:Field 'fieldname' not found

11. Findkey won't find key

12. Findkey won't find key

 

 
Powered by phpBB® Forum Software