Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi,
I got the above error in the following query
select a.* from Table1 a where a.field1="xxx" and ;
!exists (select * from Table1 b where b.field1="yyy" and b.field2=a.field2)
I discovered the error is caused by field2 having length 254. Obviously, VFP is trying to generate an index on theis field, then discovering the key is too long. (over 240)
Is there a remedy for this? In my case I could use another field, and also use part of the field, but generally I see a problem here. And what if I had an existing query that suddenly went wrong because I lengthened a field?
Auke
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement