On Tue, May 25, 2010 at 9:33 AM, Ed Leafe <[email protected]> wrote: > On May 25, 2010, at 9:14 AM, Stephen Russell wrote: > >> Make a share off a server and put a folder there. >> Open VFP and make a DBC there and ADD a table from another drive. >> Make a view off that table. > > > Just because VFP allows you to do stupid things (like put DBCs and its > tables on different drives), doesn't mean that it sucks because someone was > foolish enough to actually do that. ----------------------
Yeah you learn only from mistakes. This was done back in 2003 or so and it only has one table to catch the transactions from the shipper. I removed over 500000 rows from the table last night in a maintenance experience. Just kept transactions from 2010 on. I was amazed that when the odbc knows it is calling E:\shipping.dbc it can find the shiptrans table in f:\sbtpro\custom\ but same dbc referenced in an odbc as g:\shipping cannot work the backlink for the same view of the table. #FAIL The DBC was acting as just a pointer. Where I put it was fine. Changing the path to it screwed the pooch! Sorry dude but that is a load of crap from a deployment perspective. 100% f'ed that one M$ I am just warning others here if they have the same thing happen to them. I 100% hand scripted the dbc from g: and it failed when referenced from E in the ODBC driver. create view lvSOHEADER as ......... -- Stephen Russell Sr. Production Systems Programmer CIMSgts 901.246-0159 cell _______________________________________________ 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/[email protected] ** 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.
