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 --- _______________________________________________ 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/cajidmy+_jzj3j-qyu1i0nqoou6osdlzmnclrtgzy+k34uzj...@mail.gmail.com ** 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.

