Re: Client--Server via Internet

2013-06-05 Thread Alan Bourke
On Tue, Jun 4, 2013, at 11:00 PM, Mike Copeland wrote: > > > Thanks for any wisdom or opinions. > My €0.02 is that exposing any database server to the public internet is a bad idea, and web services are the way to go. ___ Post Messages to: ProFox@

MLINE

2013-06-05 Thread Allen
Hi gang A warning. I use mline to get lines from an email. Seems mline does not recognise chr(10) as a new line without chr(13) first. Took me ages to find it because the messages forwarded were correct with both CR and linefeed. Al ___ Post Messages to

Re: MLINE

2013-06-05 Thread Ted Roche
Is it possible messages were all forwarded from a Windows machine, but the originals were from different OSes? Windows, Linux and Mac disagree on which combination of linefeed and carriage return constitute an end-of-line. On Wed, Jun 5, 2013 at 7:31 AM, Allen wrote: > Hi gang > A warning. I u

RE: MLINE

2013-06-05 Thread Allen
Yes, including one with throws in =0A= instead which is a pain. Pity Mline cant realise that though. No don't expect it to work with =0A= I know. So much for standards in email. Al -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche Sent: 05 Jun

RE: MLINE

2013-06-05 Thread Jack Skelley
Al: How does ALINES() behave? I read a while ago the chr(13) or chr(10) could be in any order with alines(). But I bet it would not see the =0A= either. But I am guessing you could strtran() =0A= to chr(10) +chr(13) Jack Jack Skelley Senior Director, Programming/Computer Operations New Jersey D

RE: MLINE

2013-06-05 Thread Allen
Well that's what I ended up with. Strtran of chr(10) to chr(13) + chr(10), then remove double chr(13) and then =0A= to "". Works but what a mess. My mail was really a warning to others. Al -Original Message- Al: How does ALINES() behave? I read a while ago the chr(13) or chr(10) could be

[NF] Web Services [was: Client--Server via Internet]

2013-06-05 Thread Tracy Pearson
Alan Bourke wrote on 2013-06-05: > > > On Tue, Jun 4, 2013, at 11:00 PM, Mike Copeland wrote: > > > Thanks for any wisdom or opinions. > > > > My €0.02 is that exposing any database server to the public internet is > a bad idea, and web services are the way to go. > Alan, Since y

Re: [NF] Web Services [was: Client--Server via Internet]

2013-06-05 Thread Alan Bourke
Me neitherin terms of current .NET This might help: http://www.codeproject.com/Articles/148762/NET-4-0-RESTful-Web-Service-Introduction ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

Re: [NF] Web Services [was: Client--Server via Internet]

2013-06-05 Thread Stephen Russell
I tend to separate my projects for this type of solution into the class functionality I need. Your presentation of the link had code. The [ServiceContract] to me is an entire set of classes that create presentation data for outsiders. I separate, in the solution, this data from what internally

RE: [NF] Google Calendar API - Solved!

2013-06-05 Thread Joe Yoder
Jeff, I too am interested in any Google Calendar API code that you are willing to share. I have been watching for further postings and not seen any. I expect either a delivery glitch or lack of available time is the explanation but thought I'd express my interest in case I've missed something.

RE: [NF] Google Calendar API - Solved!

2013-06-05 Thread Allen
A me too. Not sure quite why yet but you never know Al -Original Message- Jeff, I too am interested in any Google Calendar API code that you are willing to share. I have been watching for further postings and not seen any. I expect either a delivery glitch or lack of available time is

something wrong with Ed's mailing system

2013-06-05 Thread Rafael Copquin
I started receiving posts from this forum 5 TIMES each. Ed, please check the system Rafael Copquin ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail

Re: [NF] Google Calendar API - Solved!

2013-06-05 Thread Jeff Johnson
I have been tied up with codenflaggen all week. I will still get it to you. Thanks, Jeff --- Jeff Johnson j...@san-dc.com (623) 582-0323 www.san-dc.com www.arelationshipmanager.com On 06/05/2013 08:27 AM, Joe Yoder wrote: Jeff, I too am interested in any Google Calendar API co

Re: something wrong with Ed's mailing system

2013-06-05 Thread Peter Cushing
Rafael Copquin wrote: I started receiving posts from this forum 5 TIMES each. Ed, please check the system It's alright for me It's alright for me It's alright for me It's alright for me It's alright for me ;-) Rajan Imports

RE: something wrong with Ed's mailing system

2013-06-05 Thread Kurt Wendt
Hate to say it - but, I believe the problem is on your own end. I don't have this problem at all. But, here where I work - we have had a similar problem - but, it our own problem with our own service provider or the settings on our local Outlook - some kind of timing issue - that causes repeat pull

Re: something wrong with Ed's mailing system

2013-06-05 Thread Ed Leafe
On Jun 5, 2013, at 11:42 AM, Rafael Copquin wrote: > I started receiving posts from this forum 5 TIMES each. > Ed, please check the system Here are the log entries for all mail going to your address today: Jun 5 01:18:17 mail postfix/smtp[3930]: 81E8118088: to=, relay=mx1.fibertel.com

Re: Client--Server via Internet

2013-06-05 Thread Mike Copeland
Agreed, Alan. Thanks! Currently my server is locked down... only accepts connections from specified IP addresses, extremely convoluted and long password for login, connections are encrypted. Mike Original Message Subject: Re: Client--Server via Internet From: Alan Bourke To:

Re: something wrong with Ed's mailing system

2013-06-05 Thread Rafael Copquin
OK, I'll check. My apologies for any inconvenience Rafael Copquin El 05/06/2013 01:52 p.m., Ed Leafe escribió: On Jun 5, 2013, at 11:42 AM, Rafael Copquin wrote: I started receiving posts from this forum 5 TIMES each. Ed, please check the system Here are the log entries for all mai

Re: something wrong with Ed's mailing system

2013-06-05 Thread Nicholas Geti
This happens if a corrupted message gets stuck in your email client and you download again. That is, if you are using a client like Outlook Express to get messages from the service provider. You have to go to the service provider system and locate the corrupted email then delete it. Nick Geti

Re: Client--Server via Internet

2013-06-05 Thread Gene Wirchenko
At 23:33 2013-06-04, Mike Copeland wrote: [snip] Is there a way to test an existing sqlstringconnect() connection handle to see if it's valid, without throwing an error? Or should I just trap for the 1466 error and deal with it accordingly? Trap the error. A point to keep in mind

Problems with List

2013-06-05 Thread Gene Wirchenko
Dear Vixens and Reynards: I did not have the five times problem either. One problem that I have noted from time to time is that the bodies of some messages come crunched together with text from different messages on the same line. I have seen some today. For example, one message

Re: Client--Server via Internet

2013-06-05 Thread Mike Copeland
Thanks Gene, point well taken. Appreciate the input! Mike Original Message Subject: Re: Client--Server via Internet From: Gene Wirchenko To: profoxt...@leafe.com Date: 6/5/2013 1:09 PM At 23:33 2013-06-04, Mike Copeland wrote: [snip] Is there a way to test an existing sqls

Re: Client--Server via Internet

2013-06-05 Thread M Jarvis
On Wed, Jun 5, 2013 at 11:25 AM, Mike Copeland wrote: > Thanks Gene, point well taken. Appreciate the input! > > Mike As was mentioned already, you gotta double check your connection status each time you want to talk back to the mothership... As to whether or not to maintain one connection or e

Re: Client--Server via Internet

2013-06-05 Thread Mike Copeland
Yeppers, leaning that way pretty hard right now. But I do like the idea of keeping the connection (unless it throws a 1466 error) until such time as the user goes idle for a length of X minutes/seconds. There are a few places in my app that the user might be browsing around, skipping from one

Re: Client--Server via Internet

2013-06-05 Thread MB Software Solutions, LLC
On 6/4/2013 6:00 PM, Mike Copeland wrote: My VFP app connects to a MYSQL (soon to be a MariaDB) server running on a dedicated Linux box via the Internet. My current design is that when the app starts up it connects to the MySQL server and then keeps that connection 'live' by using a timer every 1

Re: Client--Server via Internet

2013-06-05 Thread MB Software Solutions, LLC
On 6/4/2013 9:16 PM, Ted Roche wrote: Oops. Hit 'Send' too soon. Mike, Here's my GetHandle routine: PROTECTED FUNCTION GetHandle(tlForce as Logical) as Integer * Returns connection handle to caller. LOCAL liHandle as Integer, lcDSN as String, loException as Exception, liRe

Re: Client--Server via Internet

2013-06-05 Thread Stephen Russell
Do you ever destroy the connection? Leave the form could be a reason or kill the app. On Wed, Jun 5, 2013 at 4:42 PM, MB Software Solutions, LLC < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > On 6/4/2013 9:16 PM, Ted Roche wrote: > >> Oops. Hit 'Send' too soon. >> > > > Mike, > > Here'

Re: Client--Server via Internet

2013-06-05 Thread MB Software Solutions, LLC
On 6/5/2013 12:56 PM, Mike Copeland wrote: only accepts connections from specified IP addresses, extremely convoluted and long password for login, connections are encrypted. This is another reason I feel fine with my VFP/MySQL approach, despite the outcry from others for web services. Grant

Re: Client--Server via Internet

2013-06-05 Thread Stephen Russell
Can you search your exe and find your connection string in raw text? On Wed, Jun 5, 2013 at 4:47 PM, MB Software Solutions, LLC < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > On 6/5/2013 12:56 PM, Mike Copeland wrote: > >> only accepts connections from specified IP addresses, extremely

Re: Client--Server via Internet

2013-06-05 Thread Mike Copeland
Thanks for the thumbs up, Mike! I agree that practically anything and everything can be hacked into, eventually, with enough effort and intelligence, but at some point we all have to take a risk, suck it up, and step outside the front door. Balance the risk vs. reward as best you can, given a

Re: Upgrading Fox to WIN 7 64Bit OS

2013-06-05 Thread Charles Hart Enzer, M.D., FAACP
Good reminder: Keep It Simple -- *Charles Hart Enzer, M.D., FAACAP -- Volunteer Associate Professor of Psychiatry University of Cincinnati Medical Center*-- Website:***http://homepages.uc.edu/~enzerch/ * *Dare We Dream the Dream Which Is Impossible? * *On

Re: something wrong with Ed's mailing system

2013-06-05 Thread Paul McNett
On 6/5/13 10:52 AM, Nicholas Geti wrote: > This happens if a corrupted message gets stuck in your email client and you > download > again. That is, if you are using a client like Outlook Express to get > messages from > the service provider. You have to go to the service provider system and > lo

Interactive change event

2013-06-05 Thread Sytze de Boer
I'm having a problem with editing a memo file My code says trcask603=LEN(ALLTRIM(this.value)) thisform.label9.Caption="Description of project ("+ALLTRIM(STR(trcask603))+" size)" lines)" thisform.label9.Refresh For some reason, this then does not allow me to press the ENTER key The cursor

Re: Problems with List

2013-06-05 Thread Ken Dibble
One problem that I have noted from time to time is that the bodies of some messages come crunched together with text from different messages on the same line. I have seen some today. For example, one message body from Tracy Pearson today was: I see that rather often, but not only on Ed

Re: Problems with List

2013-06-05 Thread Tracy Pearson
Ken Dibble wrote: > >> One problem that I have noted from time to time is that the >bodies of >> some messages come crunched together with text from different >messages on >> the same line. I have seen some today. For example, one message >body >> from Tracy Pearson today was: > >I see t

Re: Interactive change event

2013-06-05 Thread Ken Dibble
I'm having a problem with editing a memo file My code says trcask603=LEN(ALLTRIM(this.value)) thisform.label9.Caption="Description of project ("+ALLTRIM(STR(trcask603))+" size)" lines)" thisform.label9.Refresh For some reason, this then does not allow me to press the ENTER key The cur

Re: Interactive change event

2013-06-05 Thread Sytze de Boer
My apologies The interactive change event is indeed related to a EDIT/memo event and it should then display the number of characters The ENTER key is a reference to start a NEW LINE I have this working elsewhere without any issues, but in that instance, I do not ever want to start a new line beca

Re: Client--Server via Internet

2013-06-05 Thread Mike Copeland
DOH! Okay, this isn't your first rodeo, is it Stephen? Not to worry, I'll move the passcode to an encrypted file I use for managing subscriptions on each workstation. Thanks for the eye-opener! Darned pseudo-code... Mike Original Message Subject: Re: Client--Server via Int

Re: Interactive change event

2013-06-05 Thread Ken Dibble
My apologies The interactive change event is indeed related to a EDIT/memo event and it should then display the number of characters The ENTER key is a reference to start a NEW LINE I have this working elsewhere without any issues, but in that instance, I do not ever want to start a new line b

Email from foxpro

2013-06-05 Thread José Olavo Cerávolo
Hi All, I was trying to find information about emailing from foxpro. A customer requested a confirmation email to be sent to their clients when they enroll for an event. I tried searching the archives but I did not get any hits. I don't want to be locked into using Outlook. Thanks in advance, O

Re: Interactive change event

2013-06-05 Thread Ken Dibble
DEFINE CLASS MemoBox AS EditBox PROCEDURE InteractiveChange trcask603=LEN(ALLTRIM(this.value)) * Your original code below; it throws a Syntax error because * you have an uneven number of double quotes and/or a missing * plus (+) sign. *this

Re: Interactive change event

2013-06-05 Thread Sytze de Boer
Ken First, I don't know how my email changed this thisform.label9.Caption="Description of project ("+ALLTRIM(STR(trcask603))+" size)" to thisform.label9.Caption="Description of project ("+ALLTRIM(STR(trcask603))+" size)" lines)" But, anyhow, when I run your code, it is fine. In my instance,

Re: Email from foxpro

2013-06-05 Thread Mike Copeland
There are several ways, but my preference is BLAT. Search for "blat vfp" and you'll have a wealth of info. Mike Original Message Subject: Email from foxpro From: José Olavo Cerávolo To: profoxt...@leafe.com Date: 6/5/2013 9:30 PM Hi All, I was trying to find information abo

Re: Email from foxpro

2013-06-05 Thread Sytze de Boer
There are several options 1 Use Blat (Google it and you will see) I used for a long time and then many of clients reported it was no longer working because they installed Ultra Fast Broadband 2 So I switched to CDO method go tohttp://fox.wikis.com/wc.dll?Wiki~CdoEmail~VFP for help 3 and if

Re: Email from foxpro

2013-06-05 Thread Tracy Pearson
"José Olavo Cerávolo" wrote: >Hi All, > >I was trying to find information about emailing from foxpro. >A customer requested a confirmation email to be sent to their clients >when they enroll for an event. >I tried searching the archives but I did not get any hits. >I don't want to be locked into

Re: [NF] Google Calendar API - Solved!

2013-06-05 Thread Michael Savage
I too, would like to see your source. Mike On 05/06/2013 11:27 AM, Joe Yoder wrote: Jeff, I too am interested in any Google Calendar API code that you are willing to share. I have been watching for further postings and not seen any. I expect either a delivery glitch or lack of available time

Re: Email from foxpro

2013-06-05 Thread Jean MAURICE
José, you can try VFPWinsock, an opensource project driven by a french MVP Francis FAURE. I use it for a long time and it works like a charm. As the code is given, I think it is easily understandable although I can translate main things to you ... http://www.vfpwinsock.com/ In french, 'downl

Re: Email from foxpro

2013-06-05 Thread Michael Madigan
I use blat, it's easy to set up and use.   http://www.blat.net/ From: José Olavo Cerávolo To: "profoxt...@leafe.com" Sent: Wednesday, June 5, 2013 10:30 PM Subject: Email from foxpro Hi All, I was trying to find information about emailing from foxpro. A cu

RE: Email from foxpro

2013-06-05 Thread Christina Bull
I'm up against it with time at the moment, so have just copied and pasted some code in here. Rejig it to suit what you need to do DECLARE INTEGER ShellExecute IN shell32.dll ; INTEGER hndWin, STRING cAction, STRING cFileName, ; STRING cParams, STRING cDir, INTEGER nShowWi

RE: something wrong with Ed's mailing system

2013-06-05 Thread Allen
Do you mean it has big brother built in? Lol BTW outlook express has gone Al -Original Message- Not saying Thunderbird doesn't have its share of problems, but at this point Thunderbird is to Outlook Express as 1994 is to 1979. Paul ___ Post