select distinct allt(baseclass) as descript from (lcVCXFile)>In VFP5.0a I cant seem to select a distinct field if it's a memo field? If I do -
>SELECT DISTINCT baseclass FROM (lcVCXfile) INTO CURSOR (lcTempFile) >>I get Error 34, Operation is invalid for a Memo, General, or Picture field. (baseclass is a memo field) Yet I can do the same query without the DISTINCT clause and it is just fine. I also tried some string manipulation stuff, but it still doesnt seem to want to mix and match DISTINCT with a memo. Any ideas on how I can do this without writing multiple statements? TIA!