Hi Terry,

A point unrelated to your question - be careful with the use of Deleted() on multi-table queries. You may get unexpected results.

Regards,

Liam





>I am composing a somewhat complicated report and am using multiple SQL Cursors to generate raw data from which I extract the data I wish to report.
>
>The SQL statements follow:
>
>SELECT Child.id AS ChildID, Child.full_name AS ChildName, ;
> Child.last_first AS ChildLF, Child.Last_Name AS ChildLast, ;
> Child.First_Name AS ChildFirst, Child.intake, Child.int_reason, ;
> Child.terminate, Child.term_reas, Child.home_id, Child.move_in_dt, ;
> Child.county AS ChCounty, Child.case_num, Child.Sex, Child.Birthday, ;
> Placing_agent.region AS PaRegion, Placing_agent.full_name AS PaName, ;
> Placing_agent.lastfirst AS PaLF, Agency.name AS AName, ;
> Agency.county AS ACounty, Agency.typeagency ;
> FROM main!child LEFT OUTER JOIN main!placing_agent ;
> LEFT OUTER JOIN main!agency ;
> ON Placing_agent.agencyid = Agency.id ;
> ON Child.cnty_wrkr = Placing_agent.id ;
> WHERE DELETED("Child") = .F. AND DELETED("Placing_Agent") = .F. AND ;
> DELETED("Agency") = .F. ;
> INTO CURSOR Clients
>
>SELECT SELECT(1)
>SELECT Clients.*, Movehst.in_date, Movehst.out_date, Movehst.home, ;
> Movehst.in_type, Movehst.out_type, Home.address, Home.city, ;
> Home.state, Home.zip, Home.h_full_nm, Home.last_first, ;
> Home.Home_phone, Employee.office, Misc_tables.region ;
> FROM clients LEFT OUTER JOIN main!movehst ;
> LEFT OUTER JOIN main!home ;
> LEFT OUTER JOIN main!employee ;
> LEFT OUTER JOIN main!misc_tables ;
> ON Employee.office = Misc_tables.desc_20 ;
> ON Home.sw_code = Employee.id ;
> ON Movehst.home = Home.id ;
> ON Clients.childid = Movehst.id ;
> WHERE DELETED("MoveHst") = .F. ;
> AND DELETED("Home") = .F. ;
> AND DELETED("Employee") = .F. ;
> AND DELETED("Misc_Tables") = .F. ;
> AND Misc_tables.type = "OFFICE" ;
> INTO CURSOR ClientPlacementRaw
>
>
>
>These generate data just fine untill I run the report in a private data session and then the second cursor is empty. Turn off the private session and all is fine. I don't understand.
>
>Thanks in advance for any help
>
>Terry