I knew I should NOT have done this: fix what ain't broken.

I got enticed by the beauty of the non-concatanated query string. and changed to text-end to create the selectCmd. Now it does not work. I assume it has to to with the string length.
if I copy the content of the string to the command window the query works.
but in the adapter it does not....

well back to the old way...

Peter

>Hi Peter
>
>Just FYI, but check out text...endtext. I think it's much better than adding all the ' and +. You can just copy and paste a working sample right between the TEXT...ENDTEXT - no formatting.
>
>

o=CREATEOBJECT('cursoradapter')
>TEXT TO o.SelectCmd TEXTMERGE NOSHOW PRETEXT 15
>SELECT Dactauth.actauth_id,;
>Dactauth.actsect_id,;
>Dactauth.fund_id,;
>Dactauth.counsel_id,;
>Dactauth.date AS AuthorizationDate,;
>Dactauth.amount AS AuthorizationAmount,;
>Dactauth.allocamt AS AllocationAmount,;
>Dactauth.allocdate AS AllocationDate,;
>Dactauth.closed,;
>Dactauth.comments,;
>Dactauth.insdttm,;
>Dactauth.insuser_id,;
>Dactauth.upddttm,;
>Dactauth.upduser_id,;
>Dfund.fundno,;
>Dfund.fintype_id,;
>Dcounsel.bndconcd,;
>Dact.act,;
>Dactsect.sectname AS sectionname,;
>Dactsect.amount AS sectionamount,;
>Dact.act_id ;
> FROM ;
>   kba_data!dact ;
>  INNER JOIN kba_data!dactsect ;
> ON  Dact.act_id = Dactsect.act_id ;
>  INNER JOIN kba_data!dactauth ;
> ON  Dactsect.actsect_id = Dactauth.actsect_id ;
>  INNER JOIN kba_data!dfund ;
> ON  Dfund.fund_id = Dactauth.fund_id ;
>  INNER JOIN kba_data!dcounsel ;
> ON  Dcounsel.counsel_id = Dactauth.counsel_id
>ENDTEXT