Imagine this. <\/p>\n
You’re working your arse off in a form with multiple tabs with each tab having their own reports with spider-like relationship settings in the reports’ data environments.<\/p>\n
(You use RELATIONs instead of VIEWs because you feel like VIEWs are for lazy bummers and RELATIONs are cool because they’re ‘old school’)<\/p>\n
Now after hours of creating, re-aligning, adjusting your reports holding more than 10<\/font> normalized tables each. You found out that after going to Tab-02<\/font> and previewing the report, going to Tab-07<\/font> fires up this error:<\/p>\n Target table is already engaged in a relation.<\/font><\/p><\/blockquote>\n You already have SET RELATION TO in place but still the error shows.<\/p>\n And SET RELATION OFF won’t work. I wonder why it is even included in the help file. <\/p>\n You ‘google-d’ the ‘net. Taking you to places that list errors but with no definite answers because probably this was an easy problem and was solved years before.<\/p>\n You found a couple of links that are unrelated and refer to problems occuring only in version 4<\/font>. Now you wonder if there was really a version 4<\/font> out there hidden from the minds of the humans which will be used in the up coming alien invasion.<\/p>\n The closest you can get is a link to Microsoft’s MSDN site<\/a> which you can also find in your help file.<\/p>\n You got irked and you tried to CLOSE DATABASES and fire up your DatabaseInitialization() routine every time you execute the print command. <\/p>\n But then that’s too lame. Although VFP’s speed is legendary and the delay is negligible… you don’t want to tarnish FoxPro’s name with a lame code patch manuever.<\/p>\n Now in case in the future someone stumbles upon this problem, decides to search the ‘net, wants to join the old-school-frat (when database development tools were dedicated to speed and the proper use of resources and backward compatibility<\/a>) and is allergic to views, I hope the following steps could be of help.<\/p>\n Fire up LIST STATUS. If it scrolls too fast, dump it in a text file. <\/p>\n list status to file SEXYDUMP.txt<\/font><\/p><\/blockquote>\n Survey the tables with RELATIONs. Do a search on the word ‘RELATION’. Note each table name and do a SET RELATION TO in every table in your noted list.<\/p>\n