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