Re: Data on the Internet

2011-10-04 Thread Alan Bourke
On Monday, October 03, 2011 2:35 PM, Jeff Johnson j...@san-dc.com wrote: Has anyone written a VFP application that accesses data on the Internet instead of locally? A very bad idea for a lot of reasons - very slow, very prone to dropouts and errors, very insecure. You need to use a web

Re: Data on the Internet

2011-10-04 Thread Paul Hill
On Tue, Oct 4, 2011 at 9:09 AM, Alan Bourke alanpbou...@fastmail.fm wrote: On Monday, October 03, 2011 2:35 PM, Jeff Johnson j...@san-dc.com wrote: Has anyone written a VFP application that accesses data on the Internet instead of locally? A very bad idea for a lot of reasons - very slow,

Re: Data on the Internet

2011-10-04 Thread Alan Bourke
On Tuesday, October 04, 2011 9:33 AM, Paul Hill paulroberth...@gmail.com wrote: Or terminal services/remote desktop. Runs just like a local app. You don't need to provide the whole desktop to the user, you can just serve your app. We have many sites using TS - it is the only way we

Re: Data on the Internet

2011-10-04 Thread Ed Leafe
On Oct 4, 2011, at 3:09 AM, Alan Bourke wrote: Has anyone written a VFP application that accesses data on the Internet instead of locally? A very bad idea for a lot of reasons - very slow, very prone to dropouts and errors, very insecure. You need to use a web service. How is a

Re: Data on the Internet

2011-10-04 Thread Jeff Johnson
On 10/04/2011 03:08 AM, Alan Bourke wrote: On Tuesday, October 04, 2011 9:33 AM, Paul Hill paulroberth...@gmail.com wrote: Or terminal services/remote desktop. Runs just like a local app. You don't need to provide the whole desktop to the user, you can just serve your app. We have

Re: Data on the Internet

2011-10-04 Thread Stephen Russell
On Tue, Oct 4, 2011 at 7:07 AM, Jeff Johnson j...@san-dc.com wrote: I have a large customer on terminal services.  Although not perfect, it has been working great for about 10 years.  I also have a large application which is a desktop application that connects to a data file server on an

Re: Data on the Internet

2011-10-04 Thread Thierry Nivelet
Hi Jeff, Did you consider FoxInCloud? thn (FoxInCloud) Le 03/10/11 23:35, Jeff Johnson a écrit : Has anyone written a VFP application that accesses data on the Internet instead of locally? ___ Post Messages to: ProFox@leafe.com Subscription

Re: Data on the Internet

2011-10-04 Thread Jeff Johnson
On 10/04/2011 05:48 AM, Stephen Russell wrote: On Tue, Oct 4, 2011 at 7:07 AM, Jeff Johnsonj...@san-dc.com wrote: I have a large customer on terminal services. Although not perfect, it has been working great for about 10 years. I also have a large application which is a desktop application

[OT] Don't P*ss off cops in Seattle

2011-10-04 Thread Pete Theisen
Hi Everybody, Law and order gone wild? http://www.copblock.org/4308/cop-who-paralyzed-man-for-life-continues-to-be-violent/ -- Regards, Pete http://pete-theisen.com/ http://elect-pete-theisen.com/ ___ Post Messages to: ProFox@leafe.com Subscription

Re: Data on the Internet

2011-10-04 Thread Alan Bourke
On Tuesday, October 04, 2011 6:59 AM, Ed Leafe e...@leafe.com wrote: On Oct 4, 2011, at 3:09 AM, Alan Bourke wrote: I don't know exactly what you mean by dropouts and errors, but since this web service has to connect to the same data store, there would be no difference here,

[NF] Your experiences with MS SSIS 2005/2008

2011-10-04 Thread Malcolm Greene
Curious about your experiences with MS SSIS 2005/2008. In particular: Strong features, gotchas, and 3rd party tools that work well with these products. Thanks! Malcolm --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

Re: Data on the Internet

2011-10-04 Thread Ed Leafe
On Oct 4, 2011, at 10:15 AM, Alan Bourke wrote: I don't know exactly what you mean by dropouts and errors, but since this web service has to connect to the same data store, there would be no difference here, but perhaps you have something more specific in mind. Well, when using web

Re: Data on the Internet

2011-10-04 Thread Paul Hill
On Tue, Oct 4, 2011 at 5:07 PM, Ed Leafe e...@leafe.com wrote:        With a desktop app that uses an internet-based data server, if the data suddenly disappears, the app will not work. With a desktop app that calls a web service to get the data, if the web service suddenly disappears, the

RE: Data on the Internet

2011-10-04 Thread Jarvis, Matthew
Has anyone written a VFP application that accesses data on the Internet instead of locally? -- Jeff Jeff- I've kinda lost track in the discussion of what it is you are trying to accomplish... Are you referring to 'data on the internet' as in My app is here, my data is THERE and how to

Re: Data on the Internet

2011-10-04 Thread Ed Leafe
On Oct 4, 2011, at 12:06 PM, Paul Hill wrote: With a desktop app that uses an internet-based data server, if the data suddenly disappears, the app will not work. With a desktop app that calls a web service to get the data, if the web service suddenly disappears, the app will not

Re: [NF] Your experiences with MS SSIS 2005/2008

2011-10-04 Thread Stephen Russell
Found it very robust in all data munge requirements. You can Put in the code to run or call sprocs. I had jobs that ran for 15 plus min in it Never needed outside tools Sent from my iPhone Stephen Russell 901.246-0159 On Oct 4, 2011, at 10:25 AM, Malcolm Greene pro...@bdurham.com wrote:

Re: Data on the Internet

2011-10-04 Thread Jeff Johnson
Has anyone written a VFP application that accesses data on the Internet instead of locally? -- Jeff Jeff- I've kinda lost track in the discussion of what it is you are trying to accomplish... Are you referring to 'data on the internet' as in My app is here, my data is THERE and how

RE: Data on the Internet

2011-10-04 Thread Jarvis, Matthew
Matthew: That describes what I would like to try. Having a desktop application access data files that reside on a remote server using the Internet as the connection between the two. That's what I thought... For me it was easy-peasy since Paul did all the work... g I believe you just

VFP Command Window

2011-10-04 Thread Fred Taylor
Interesting discovery about the Command Window I never knew before: Drag a file from Windows Explorer into the VFP Command Window. The file will be opened in it's designated application. I know, I know, not any different than double clicking the file in Windows Explorer, just thought it was

Re: Data on the Internet

2011-10-04 Thread Paul McNett
On 10/4/11 10:43 AM, Jarvis, Matthew wrote: I sent him my DB schema and he put it in place on the back end, and I filled it with my data from there on. Yah bud and I hate to call you out in public and all, but are you still using the database? If so, cool, but I haven't noticed you connecting

Re: Data on the Internet

2011-10-04 Thread MB Software Solutions, LLC
On 10/4/2011 1:43 PM, Jarvis, Matthew wrote: Matthew: That describes what I would like to try. Having a desktop application access data files that reside on a remote server using the Internet as the connection between the two. That's what I thought... For me it was easy-peasy since Paul

Re: Data on the Internet

2011-10-04 Thread Thierry Nivelet
Steff, With FoxInCloud you move both app and data to the server. FoxInCloud comes with a VFP database sync class between LAN and web data so users can work either LAN or web without loss of data. Otherwise, the best choice would probably be to move your data to a PostGreSql database and

RE: Data on the Internet

2011-10-04 Thread Jarvis, Matthew
On 10/4/11 10:43 AM, Jarvis, Matthew wrote: I sent him my DB schema and he put it in place on the back end, and I filled it with my data from there on. Yah bud and I hate to call you out in public and all, but are you still using the database? If so, cool, but I haven't noticed you

RE: Data on the Internet

2011-10-04 Thread Jarvis, Matthew
I sent him my DB schema and he put it in place on the back end, and I filled it with my data from there on. Yah bud and I hate to call you out in public and all, but are you still using the database? If so, cool, but I haven't noticed you connecting recently and the latest recipe date

ODBC write error in call from FedEx station

2011-10-04 Thread Stephen Russell
I have a dbc that has views from SBT company 3 that work. The insert statement is simple and correct. Error comes back as Cannot resolve backlink. I have validated the dbc and it says that everything is good. If I open it up and look at the row for the actual table I see a fully qualified

Re: Data on the Internet

2011-10-04 Thread Stephen Russell
On Tue, Oct 4, 2011 at 11:07 AM, Ed Leafe e...@leafe.com wrote:        With a desktop app that uses an internet-based data server, if the data suddenly disappears, the app will not work. With a desktop app that calls a web service to get the data, if the web service suddenly disappears,

RE: ODBC write error in call from FedEx station

2011-10-04 Thread Jarvis, Matthew
I have a dbc that has views from SBT company 3 that work. The insert statement is simple and correct. Error comes back as Cannot resolve backlink. I have validated the dbc and it says that everything is good. If I open it up and look at the row for the actual table I see a fully

RE: ODBC write error in call from FedEx station

2011-10-04 Thread Richard Kaye
What does VALI DATA say? Do you have exclusive access to the DBC? Do you know what table is giving you this error? -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Tuesday, October 04, 2011 2:09 PM

Re: ODBC write error in call from FedEx station

2011-10-04 Thread Stephen Russell
On Tue, Oct 4, 2011 at 1:14 PM, Jarvis, Matthew mat...@mckweb.com wrote: I have a dbc that has views from SBT company 3 that work.  The insert statement is simple and correct. Error comes back as   Cannot resolve backlink. I have validated the dbc and it says that everything is good.  If I

RE: Data on the Internet

2011-10-04 Thread Lou Syracuse
Jeez Matt I thought it had been a while since _I_ brewed up a batch, but 2003? Must have been a big batch. lol Lou Actually my last 3 batches all went bad and I'm about to give up on the process... -Original Message- From: profoxtech-boun...@leafe.com

Re: ODBC write error in call from FedEx station

2011-10-04 Thread Stephen Russell
On Tue, Oct 4, 2011 at 1:18 PM, Richard Kaye rk...@artfact.com wrote: What does VALI DATA say? Do you have exclusive access to the DBC?  Do you know what table is giving you this error? -- Validate Datbase Shipping: Rebuilding structural index. Index rebuilt. Database container

RE: ODBC write error in call from FedEx station

2011-10-04 Thread Richard Kaye
If you simply try to USE this table at the command line, do you get the backlink error? Assuming you have a dev environment available... If so, make a backup of the DBF/CDX/FPT. Try FREEing the table and then ADDing it back. Keep in mind that if you do that, you will lose any DBC metadata about

Re: Data on the Internet

2011-10-04 Thread Paul McNett
On 10/4/11 11:00 AM, Jarvis, Matthew wrote: Maybe as a continued public service you could leave it open and let Jeff play with it? host: paulmcnett.com user: brewdomain pass: domainbrew db: brewdomain Someone else can post the DSN - been too long for me to remember how to format those! Paul

Re: Data on the Internet

2011-10-04 Thread Paul McNett
On 10/4/11 11:02 AM, Jarvis, Matthew wrote: p.s. Now that I think about it a bit more, I wouldn't mind having that in place for when I eventually get around to doing some Python... but by then I could just send you (or someone) a DB schema and go from there rather than leaving your port open

Re: ODBC write error in call from FedEx station

2011-10-04 Thread Stephen Russell
On Tue, Oct 4, 2011 at 1:27 PM, Richard Kaye rk...@artfact.com wrote: If you simply try to USE this table at the command line, do you get the backlink error? Assuming you have a dev environment available... If so, make a backup of the DBF/CDX/FPT. Try FREEing the table and then ADDing it

Re: Data on the Internet

2011-10-04 Thread Malcolm Greene
Jeff, That describes what I would like to try. Having a desktop application access data files that reside on a remote server using the Internet as the connection between the two. Why not use Python's urllib module to grab files off a server where the files are specified by URLs. This will

Re: Data on the Internet

2011-10-04 Thread Jeff Johnson
Thank you Malcolm. I am doing several Python utilities I've set up this way. Jeff --- Jeff Johnson j...@san-dc.com (623) 582-0323 www.san-dc.com Jeff, That describes what I would like to try. Having a desktop application access data files that reside on a remote

Re: ODBC write error in call from FedEx station

2011-10-04 Thread Fred Taylor
What DBC does the backlink point to? Fred On Tue, Oct 4, 2011 at 11:53 AM, Stephen Russell srussell...@gmail.comwrote: On Tue, Oct 4, 2011 at 1:27 PM, Richard Kaye rk...@artfact.com wrote: If you simply try to USE this table at the command line, do you get the backlink error? Assuming you

Re: ODBC write error in call from FedEx station

2011-10-04 Thread Stephen Russell
On Tue, Oct 4, 2011 at 2:23 PM, Fred Taylor fbtay...@gmail.com wrote: What DBC does the backlink point to? k:\shipping.dbc. -- Stephen Russell 901.246-0159 cell ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: ODBC write error in call from FedEx station

2011-10-04 Thread Fred Taylor
And that is the same folder as all the actual data tables, etc.? Seems you mentioned a subfolder earlier. Fred On Tue, Oct 4, 2011 at 12:25 PM, Stephen Russell srussell...@gmail.comwrote: On Tue, Oct 4, 2011 at 2:23 PM, Fred Taylor fbtay...@gmail.com wrote: What DBC does the backlink point

[OT] Alive today because she wasn't a Brit?

2011-10-04 Thread Pete Theisen
Hi Everybody, Oh, right. There would have been a Bobby just outside her door who would have been strong enough to take the crowbar away from the dude. http://www.dispatch.com/content/stories/local/2011/09/26/woman-says-she-killed-estranged-boyfriend-in-self-defense.html -- Regards, Pete

Re: ODBC write error in call from FedEx station

2011-10-04 Thread Stephen Russell
On Tue, Oct 4, 2011 at 2:29 PM, Fred Taylor fbtay...@gmail.com wrote: And that is the same folder as all the actual data tables, etc.? Seems you mentioned a subfolder earlier. -- I had Mikey change the map of the mapped folder on the machine and it is working as expected. Took a long

Re: Data on the Internet

2011-10-04 Thread MB Software Solutions, LLC
On 10/4/2011 2:39 PM, Paul McNett wrote: On 10/4/11 11:00 AM, Jarvis, Matthew wrote: Maybe as a continued public service you could leave it open and let Jeff play with it? host: paulmcnett.com user: brewdomain pass: domainbrew db: brewdomain Someone else can post the DSN - been too long

Re: Data on the Internet

2011-10-04 Thread Ed Leafe
On Oct 4, 2011, at 2:49 PM, MB Software Solutions, LLC wrote: For the record, it would be better to store the hash# instead of the actual password, so don't waste bytes chastising me on this example. :-) At least change the comment for that column to like Nothing to see here; move

Re: Data on the Internet

2011-10-04 Thread MB Software Solutions, LLC
On 10/4/2011 4:02 PM, Ed Leafe wrote: At least change the comment for that column to like Nothing to see here; move along so the bad guys don't figure out what it is. :) LOL! -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect

Re: Data on the Internet

2011-10-04 Thread Paul McNett
On 10/4/11 12:49 PM, MB Software Solutions, LLC wrote: Can you add this table (below)? I'll put together a demo of how my framework accesses a MySQL database over the web and this table is good for a basic example. Done. Paul ___ Post Messages

[OT] Univision who?

2011-10-04 Thread Pete Theisen
Hi Everybody, http://www.foxnews.com/politics/2011/10/04/gop-presidential-candidates-threaten-to-boycott-univision-debate-over-rubio/ At least four Republican presidential candidates are threatening to boycott a proposed Univision debate following allegations that the Spanish-language network

Speed and complexity of report

2011-10-04 Thread Michael Savage
I have an invoice table, which is related to a detail table. The invoice table is also related to the order entry table. The order entry table is linked to to tables one is bill codes, the other is,dept codes Finally I have a table that is the history of the work being done, linked to dept

[NF] Need 32-bit Windows7 OEM Computer

2011-10-04 Thread Paul McNett
Apparently, Dell isn't selling 32-bit Windows 7 computers anymore, but I need one for a customer that is running older software (MAS90 and Act) that will run on 32-bit but not 64-bit, even (according to the vendor) in compatability mode. Recommendations for an online seller of such a system?

Re: [NF] Need 32-bit Windows7 OEM Computer

2011-10-04 Thread Dan Covill
Hi, Paul AFAIK, the only difference between 32-bit and 64-bit windows 7 (on a machine capable of 64-bit) is which one you choose to install from the Win 7 CD. Which leads to two or three possibilities: a. Talk Dell into providing you the Windows 7 CD, and load the 32-bit version yourself if

Re: Speed and complexity of report

2011-10-04 Thread Dan Covill
On 10/04/11 15:37, Michael Savage wrote: Also, the simple report of the first query takes a long time to display... How Can I speed it up? Mike By 'the first query' do you mean just the invoice and its detail? Or do you mean a query producing the entire hierarchy you showed? What is the

Re: [NF] Need 32-bit Windows7 OEM Computer

2011-10-04 Thread Paul McNett
On 10/4/11 7:59 PM, Dan Covill wrote: AFAIK, the only difference between 32-bit and 64-bit windows 7 (on a machine capable of 64-bit) is which one you choose to install from the Win 7 CD. Which leads to two or three possibilities: a. Talk Dell into providing you the Windows 7 CD, and load

[OT] New UN building? NO!

2011-10-04 Thread Pete Theisen
Hi Everybody, With little attention from national media or Congress, the pieces are falling into place for the United Nations to build a brand-new building next door to its current 39-story tower. See them damned first . . .

Hide VFP Command Window

2011-10-04 Thread Angel Dario Rodriguez
How can I hide the VFP command window when I run an .app file ? De: Fred Taylor fbtay...@gmail.com Para: ProFox Email List profox@leafe.com Enviado: martes 4 de octubre de 2011 14:45 Asunto: VFP Command Window Interesting discovery about the Command Window I

Re: Hide VFP Command Window

2011-10-04 Thread Fred Taylor
1) Use the runtime for your app, probably needs to be an .EXE, at least as the starting program that can call your .APP. 2) READ EVENTS (#1 above will need this ,too) The Command Window is only visible when running in the IDE and READ EVENTS has not been used. Fred On Tue, Oct 4, 2011 at 9:25

Re: [NF] Need 32-bit Windows7 OEM Computer

2011-10-04 Thread MB Software Solutions, LLC
On 10/4/2011 8:12 PM, Paul McNett wrote: Apparently, Dell isn't selling 32-bit Windows 7 computers anymore, but I need one for a customer that is running older software (MAS90 and Act) that will run on 32-bit but not 64-bit, even (according to the vendor) in compatability mode. Not an

[NF]When nycap.rr.com mail server bounces messages

2011-10-04 Thread PabloSr
This may be a question for Ed Leafe, or for some other list member that has the same email server as I do. What is the response that is returned by that server system. I would like to provide my ISP provider with exact feedback, or possible copies of the type of feedback received by leafe.com

Re: Hide VFP Command Window

2011-10-04 Thread Grigore Dolghin
Hide Window Command On Wed, Oct 5, 2011 at 7:55 AM, Fred Taylor fbtay...@gmail.com wrote: 1) Use the runtime for your app, probably needs to be an .EXE, at least as the starting program that can call your .APP. 2) READ EVENTS (#1 above will need this ,too) The Command Window is only visible