The PADR(ALLTRIM(details),40) is comming out of a memo field but that's the only one.
>Is any field in the list a memo field? VFP8 wouldn't allow to group on it.
>>I made the folowing changes and I still get the same error:
>>
>>SELECT recordtype, importaccountid, DTOS({06/04/2003}) AS postdate, ;
>> effectivedate, transactiontype, dbcr, ;
>> SUM(IIF(dbcr = 'C', -1 * VAL(amount), VAL(amount))) AS amount, ;
>> ref1, ref2, ref3, ref4, ref5, PADR(ALLTRIM(details),40) AS details, ;
>> scvind, name, company, phone, SPACE(20) AS email, SPACE(15) AS fax, ;
>> property, address1, address2, city, state, filler, zip, country, ;
>> filler2 ;
>> FROM cwtsdata ;
>> GROUP BY recordtype, importaccountid, postdate, effectivedate, ;
>> transactiontype, dbcr, ref1, ref2, ref3, ref4, ref5, ;
>> details, scvind, name, company, phone, email, ;
>> fax, property, address1, address2, city, state, filler, zip, ;
>> country, filler2 ;
>> INTO CURSOR CashwiseTerminalServicesData
Thanx,
Bill Elvin