RE: using VFP as middle tier to do all the lifting versus storedprocs on RDBMS

2006-07-31 Thread David Crooks
On Monday, July 31, 2006 9:28 AM Stephen Russell wrote From: Michael Babcock [EMAIL PROTECTED] snipped How best would you use VFP as the middle tier? Only with a VFP front end. It is funny that I first thought the same thing. Then I asked myself, that a VFP middle tier really should work

Re: using VFP as middle tier to do all the lifting versus storedprocs on RDBMS

2006-07-31 Thread Michael Babcock
David Crooks wrote: On Monday, July 31, 2006 9:28 AM Stephen Russell wrote From: Michael Babcock [EMAIL PROTECTED] snipped How best would you use VFP as the middle tier? Only with a VFP front end. It is funny that I first thought the same thing. Then I

RE: using VFP as middle tier to do all the lifting versus storedprocs on RDBMS

2006-07-31 Thread stephen . russell
From: David Crooks [EMAIL PROTECTED] Only with a VFP front end. It is funny that I first thought the same thing. Then I asked myself, that a VFP middle tier really should work with any front end. Right? How does VFP interact with messages from a VB client, and how do you pass back munged

RE: using VFP as middle tier to do all the lifting versus storedprocs on RDBMS

2006-07-31 Thread stephen . russell
From: Michael Hawksworth [EMAIL PROTECTED] Try turning it around! If you were using c# for the middle tier what would you pass? Depends totaly on what is the receiving code compiled in. VB6, VB.NET, c++, java, python? XML sounds great, but at what volume and what distance are you

Re: using VFP as middle tier to do all the lifting versus storedprocs on RDBMS

2006-07-31 Thread Ed Leafe
On Jul 31, 2006, at 9:32 AM, David Crooks wrote: How best would you use VFP as the middle tier? Only with a VFP front end. It is funny that I first thought the same thing. Then I asked myself, that a VFP middle tier really should work with any front end. Right? You have to approach

RE: using VFP as middle tier to do all the lifting versus storedprocs on RDBMS

2006-07-31 Thread David Stevenson
Stephen, It's been a long time since I did any XML from VFP. Can VFP pull schema and determine that there is a small combination of tables in an xml file? Or do you have to parse that out yourself? VFP's XMLAdapter can handle it if the schema isn't too complicated. In general, anything output