Hi Again

Sorry to be such a bother...
But if i use the SQLEXEC and get the result in the cursor. How would I then run the report using the cursor as the source???

Thanks again
Fida


>Hi!
>
>If you still want to use data enviroment, than create view. You can include view in data environment as a usual table.
>
>>thanks for the reply
>>can you give me an example of this please?
>>My problem is the report is setup and in the data environment of the report
>>how do i say its this particular cursor?
>>
>>Thanks
>>Fida
>>
>>
>>>Hi!
>>>
>>>Use SQLConnect and SQLExec functions. SQLExec returns cursor with name you specify in third parameter, than you ca show report based on that cursor.
>>>
>>>>Hi All
>>>>
>>>>Can anyone please help with this :
>>>>
>>>>I use this statement e.g
>>>>
>>>>select assets.asnum, assets.sub, assets.price, assets.group_, group.desc_
>>>>from baud!assets inner join baud!group ;
>>>>on assets.group_ = group.gcode ;
>>>>order by group.desc_ ;
>>>>into cursor aspurch.
>>>>
>>>>How do i use this output as a source for a report???
>>>>Or do i do this differently