On Wed, Mar 10, 2010 at 10:23 AM, Virgil Bierschwale <[email protected]> wrote: > That's why the business side go outside of the IT side... > They are only interested in data to do their whatif's. > > I see it both ways, probably because I worked in MIS most of my life, but my > heart has always been on the business side -------------------
>From the post: The problem: Corporate doesn't want to expose a database on the web. They'd rather I use a web service and have that be the public-facing object. I don't know DotNet but am very good with VFP9, and I need this to come up quick (within 2 months), Other: Target/Backend database here at Corporate can be a SQL Server 2005 database or VFP9 (most likely free tables). -------------------- Seems like there is no direction on what the storage is going to be at this point. Target is going to be SQL Server? Will they need to have a separate db for each retail location? Will it have a single db and everything identified by a column of ownership? No biggie here. It will need a lot of code as a guess. This is what Web Services was designed to do. Exposing corporate data to whomever they want. Corp is now in control of WHAT is going in and out and they can control GIGO at the onset. Just passing tables is well pretty lame especially when PKeys may be duplicated. That becomes the real show stopper for why the just pass a table is a potential for real problems. Could this functionality be done in VFP in making a WS ? I am sure it could. Can it be secured? Somehow I am sure it can, how it is done hmmm???? Why would you want to send duplicate data time and again? I know that a former boss did this all in WestWind back in the 98-99 on all transactions hitting the local tables were also sent to corporate. -- 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.
