One more suggestion - please add ability in the configuration utility to highlight multiple objects. I need to remove several objects from the Data Dictionary (they are empty tables) and I have to do it one by one.
Downloading new version fixed some of my problems.
But I now can not edit SQL in the VFP window. There is no zoom option (it was in the previous version).
This SQL
select PEOPLE.LNAME,PEOPLE.FNAME, Phones_Home.Home_Phone,Phones_Office.Office_PHONE from People LEFT JOIN (select People.cID, Phones.Phone as Home_Phone from People LEFT join Phones on People.CID = Phones.CID and Phones.Type IN (space(20),'Home') ) Phones_Home ON People.cID = Phones_Home.cID LEFT JOIN (select People.cID, Phones.Phone as Office_Phone from People LEFT JOIN Phones on People.CID = Phones.CID and Phones.Type = 'Office' ) Phones_Office on People.cID = Phones_Office.cID order by 1, 2
produces a syntax error. Do you know what may be wrong?
Ysterday at home I realized, that I was trying to make everything too complex again.
The simpler select should be
select P.LastName,P.FirstName, Ph1.Home_Phone, Ph2.Office_Phone... from People P
Left JOIN (select cID, Phone as Home_Phone from Phones
where Type in ... and Phone <> space(60)) Ph1
on P.cID = Ph1.cID LEFT JOIN () Ph2 ...
So, perhaps I can go with subtables if they allow to introduce filter condition.
If it's not broken, fix it until it is.
My Blog