>Well I'm sure it's something stupid but...
>
>This select will not run because it says the group by clause is missing or invalid. If someone would be so kind as to tell me what I'm missing I would really appreciate it.
>
>SELECT recordtype, importaccountid, DTOS({06/04/2003}) postdate, ;
> effectivedate, transactiontype, dbcr, ;
> SUM(IIF(dbcr = 'C', -1 * VAL(amount), VAL(amount))) amount, ;
> ref1, ref2, ref3, ref4, ref5, PADR(ALLTRIM(details),40) details, ;
> scvind, name, company, phone, SPACE(20) email, SPACE(15) fax, ;
> property, address1, address2, city, state, filler, zip, country, ;
> filler2 ;
> FROM cwtsdata ;
> GROUP BY recordtype, importaccountid, DTOS({06/04/2003}), effectivedate, ;
> transactiontype, dbcr, ref1, ref2, ref3, ref4, ref5, ;
> PADR(ALLTRIM(details),40), scvind, name, company, phone, SPACE(20), ;
> SPACE(15), property, address1, address2, city, state, filler, zip, ;
> country, filler2 ;
> INTO CURSOR CashwiseTerminalServicesData
It looks like you've included a column in the select statement that isn't in either an aggregate function or the group by clause. The simplest work around is to use SET ENGINEBEHAVIOR 70, then after the query is run SET ENGINEBEHAVIOR 80. Otherwise, you'll have to re-write the query and exclude those columns.
George
Ubi caritas et amor, deus ibi est