Sometime it's good to start over. I created the report anew and added my code into the init of the datenv. and it works.
Sorry for the confusion.
Peter
Are you going to be in Arizona for the SW conference?




>>still it does not work for me
>>I put

SELECT * FROM diary WHERE claim_id=49142 AND UPPER(doctype)<>"DIARY" ORDER BY 1 DESC INTO CURSOR Query

>>into the init of the dataenvironment and it errors out.
>>in the command window it returns a cursor just fine
>
>
>What error are you getting??
>
>
>Also, you have to set This.InitialSelectedAlias to the name of your cursor.