Subject Cannot sot on column that does not exist - Interbase 5.6
Author Johannes Pretorius
Good day All

We have a funny error happening lately at our clinets. Some random tables Primary key goes corrupt and we get
the error Cannot sort on column that does not exist. If we do a select * from TABLE_A

If we DELETE the Primary key and then RE-CREATE it.. ALL is FINE.. No problems anymore.. until next time..

We kinda don't know where to start.. And want to know if somebody else has ever ran into this.


Johannes Pretorius
(Programeerings Departement- Promed)

Tel : +27 11 607-3300
Faks : +27 11 622-6939
webtuiste :

This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you are not the intended recipient, any review, re transmission,
disclosure, copying, modification or other use of this email message or
attachments is strictly forbidden. If you receive this email message in
error, please contact the author and delete the message and any
associated files from your computer. Also the contents of this e-mail
is considered confidential.
Thank you

No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.10.21/96 - Release Date: 10/09/2005