Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SELECT-SQL with distinct doesnt work
Message
De
08/11/2002 22:46:57
Peter Wagner
Point Informática Ltda.
Limeira, Brésil
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
SELECT-SQL with distinct doesnt work
Divers
Thread ID:
00720590
Message ID:
00720590
Vues:
58
I have some SELECT-SQL Commands that worked fine in previous version of VFP ,
but it doesnt work in VFP 8 Beta.

It doesnt work when I have a memo field and the DISTINCT clause in a Select SQL.

Sample:
SELECT DISTINCT EMP_ID, notes FROM EMPLOYEE WHERE COUNTRY = 'UK'
Returns this error:
STRING IS TO LONG TO FIT

or
SELECT DISTINCT * FROM EMPLOYEE WHERE COUNTRY = 'UK'
Returns this error:
Operation is invalid for Memo, General, or Picture field

Could someone explain-me why ?
What changed in SELECT-SQL ?
I have applications whit this kind of code... Will it be possibel to upgrade ?
If YES, how ?

PS: I readed the SELECT-SQL in VFP 8.0 Beta Help and it doesnt says something about it.

TIA

Peter
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform