Make your own free website on Tripod.com

InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: select not selecting correctly.


Matt

You could try dropping and rebuilding the primary key (that's if you haven't
already done that). Something like:

ALTER TABLE name DROP PRIMARY KEY
ALTER TABLE name ADD PRIMARY KEY (id)

If you still get problems, then try zipping up the database and mailing it
to me.

Regards

Peter Hearty
Instant Computer Solutions
-----Original Message-----
From: Matt <Matt@bishop.org>
To: instantdb@smartcard.co.uk <instantdb@smartcard.co.uk>
Date: 28 September 1999 09:05
Subject: select not selecting correctly.


>I just upgraded my database from 1.8.1 to 2.4.1.  I dropped all the
>indexes I could, performed a clean shutdown, and installed the new
>classes.  When I restarted the machine and checked the database, I found
>an oddity in the data.
>
>Two records with different ID values (I have an auto-incrementing integer
>field called ID) are being selected when I select on just one of their
>values.  The values are 3198 and 2680, but both hit on 2680.  Neither
>hits on 3198.
>
>Any ideas?
>
>
>
>-Matt Bishop
>matt@bishop.org
>
>EARTH FIRST--we'll screw up the other planets later.
>