Been a long time since I did sbt, but if memory serves me correctly, the only changes between companies are the company number. You should be able to go to their central table (sys something or nother), and locate the appropriate company and then set your paths from that?
-----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Stephen Russell Sent: Friday, September 27, 2013 11:47 AM To: ProFox Email List Subject: Re: How do you fix a dbc that opens with an error? On Fri, Sep 27, 2013 at 11:34 AM, [email protected] <[email protected] > wrote: > They keep the view descriptions, rules, triggers, etc. If you don't > use any of that you can create your dbf as 'free'. > -------- > This was all to keep it simple for FedEx or UPS or DHL to get data to fill out the shipping data for an order at the shipping station. They scan barcode on the pick list, it passes that # to my views for header data on where this is going. At completion the write to my table weight, fee1, fuel surcharge, other fee2, and tracking number. I marry that to the order on a nightly batch that sends all data up to website. This has been in place for 10+ years. All this took was an ODBC connection on the shipping station to the DBC that held the views SEPARATE from the dbf files on the server. I think this is a good use of views for an app. Now they want to do same process for other company they started in same warehouse on a different belt. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.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.
