Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SELECT-SQL with distinct doesnt work
Message
From
08/11/2002 22:46:57
Peter Wagner
Point Informática Ltda.
Limeira, Brazil
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
SELECT-SQL with distinct doesnt work
Miscellaneous
Thread ID:
00720590
Message ID:
00720590
Views:
57
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
Next
Reply
Map
View

Click here to load this message in the networking platform