I will throw in my two cents: a) in the case of the parent/child relationship I tend never to use set relation. It is so much easier to move the record in table 1 (the parent) and launch a select sql command to create a cursor for the second table (the child) and show all the records of this sql cursor in the grid. Now you can be showing a grid with, say, your customers (just account and company name) and put the following code in the afterrowcolchange of that grid:
local cAcc cAcc = customers.account thisform.grid2.recordsource = '' select * from invoicesdetail where acc = cAcc, etc, etc into cursor curDetails thisform.grid2.recordsource='curDetails' In this manner you will always see all the records in the child table that pertain to the one record in the parent, filtered by whatever conditions you want in the where clause of the select, and you will not have to use the set relation command at all, which can be very annoying at times. And you can do this (but without grids of course) in FP DOS as well, maybe using a browse window instead. b) as for FP DOS, I still have a couple of clients that use a huge app (invoicing, stock control, accounting, accounts payable, accounts receivable, the works..) They have been doing so for the last 15 years or so. They upgraded their PC's to XP Proffessional, the main server (Windows Server 2003) and run without major problems. And have no intention to change (darn it, I would just love to get the extra business to upgrade to VFP9 !! ) I am still very proficient in FP DOS, so if there is any need for work on old FP DOS apps, I am available too, even though I live at the end of the world, but what the heck, there is the Internet......and airplanes. So you can also contact me privately. (My apologies if this sounds like a Rafael add, but, you guys do the same, so...) Regards Rafael Copquin ----- Original Message ----- From: "John C. Gunvaldson" <[email protected]> To: <[email protected]> Sent: Thursday, September 03, 2009 3:32 AM Subject: RE: VFP9 - Set relation >>>> I work on a FoxPro DOS app at least once a week. > > I am working on a FoxPro 2.5 DOS app right now. I stage a lot of the data > the app uses with VFP 9, but the core application has been running FP2.5 > for > probably now close to 15 years... > > A while back we Virtualized the OS to Windows Professional 2000 running on > a > HP Blade Server. FoxPro DOS continues in this environment with several > long > running duties every day... > > It's a bit like that Netware Server in the closet everyone forgot about - > still running <g>.... > > Cheers, > > John C. Gunvaldson > San Diego, CA > www.fox-net.com > > > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/299554d993e3404dbb0b310a2142a...@rafanueva ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
