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