Where is the error handler for FPW 2.5 apperror stored? I can't find the source

2012-03-26 Thread Michael Madigan
Where is the error handler source for FPW 2.5's application generated programs,  apperror stored?  I can't find the source.  Is this included in another program or is it just built into the environment?  ___ Post Messages to: ProFox@leafe.com

RE: Outlook Automation - No wonder no one answered this question!

2012-03-26 Thread Richard Kaye
Hi Jeff, Care to share what you're doing with Outlook automation? I've had this request knocking around for a while to add events to a shared calendar and since it hasn't been a high priority, I've not put much thought into it. But maybe you have... vbg -- rk -Original Message- From:

Re: [JOB] VFP 9/8/SQL/WestWind Contract to Perm / Dallas/Plano

2012-03-26 Thread Desmond Lloyd
Is this THE Bill Sanders? Regards, Desmond Lloyd On 26 March 2012 07:20, William Sanders / EFG pro...@efgroup.net wrote: I'm on a site where we're using VFP 8 and 9, MS Sql Server, West Wind Web Connect and we're looking for new folk. Must be local to Dallas area - job is IN Plano. 1 to

RE: [JOB] VFP 9/8/SQL/WestWind Contract to Perm / Dallas/Plano

2012-03-26 Thread Richard Kaye
Would anyone else have Mondo Regards as his sig? g -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Desmond Lloyd Sent: Monday, March 26, 2012 8:47 AM To: profoxt...@leafe.com Subject: Re: [JOB] VFP 9/8/SQL/WestWind Contract

Re: Multiple cursors returned from Stored Procedure

2012-03-26 Thread Frank Cazabon
On 26/03/2012 12:58 AM, MB Software Solutions, LLC wrote: I wasn't going to bother trying that, as T-SQL is SQL Server and I am using MySQL. But, it didn't take much effort, so I did it since you offered. Nope. No good. No different. Thanks though for trying. I think Stephen was hinting

Re: Multiple cursors returned from Stored Procedure

2012-03-26 Thread Frank Cazabon
Just looked back and saw you were using the semi-colon to separate, but do you need to force a separate line in there too? Frank. Frank Cazabon On 26/03/2012 08:56 AM, Frank Cazabon wrote: On 26/03/2012 12:58 AM, MB Software Solutions, LLC wrote: I wasn't going to bother trying that, as

Re: Multiple cursors returned from Stored Procedure

2012-03-26 Thread Stephen Russell
On Sun, Mar 25, 2012 at 11:58 PM, MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: I wasn't going to bother trying that, as T-SQL is SQL Server and I am using MySQL.  But, it didn't take much effort, so I did it since you offered.  Nope.  No good.  No different.  

VFP9: Method Code Disappearing...

2012-03-26 Thread Jack Skelley
Good Morning All: I have a recurring issue in VFP9 SP2 that is starting to make me very unhappy. It seems when I recompile an application in to an exe I have random code blocks in either defined methods or events on an object get erased. The results is when a user clicks on (for example) the

RE: VFP9: Method Code Disappearing...

2012-03-26 Thread Dave Crozier
Jack, I had similar problems and the only way I found to cure it was to manually clear out the object code from the SCX before recompiling it in VFP9. For some reason just compiling the form in VFP9 never removed the possibility of the code disappearing and I just bit the bullet, wrote a

Re: [JOB] VFP 9/8/SQL/WestWind Contract to Perm / Dallas/Plano

2012-03-26 Thread Desmond Lloyd
Touche' 8-) Wanting to make sure it wasn't a flashback. On 26 March 2012 07:56, Richard Kaye rk...@artfact.com wrote: Would anyone else have Mondo Regards as his sig? g -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On

Re: VFP9: Method Code Disappearing...

2012-03-26 Thread Allen
Funny you should say that but I had code go wrong in something that had been working fine, but had worked on other code in the same class. This was in SP1 though, but I had code in the middle of a method just disappear. Al -Original Message- Good Morning All: I have a recurring issue

Re: Multiple cursors returned from Stored Procedure

2012-03-26 Thread Ted Roche
On Sat, Mar 24, 2012 at 10:55 AM, MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: VFP9SP2 calling a stored procedure in MariaDB (MySQL) My stored procedure returns 6 cursors.  Can the Fox handle getting multiple cursors back?  I thought so, by my SQLEXEC call

Re: VFP9: Method Code Disappearing...

2012-03-26 Thread Jeff Johnson
On 03/26/2012 06:52 AM, Jack Skelley wrote: Good Morning All: I have a recurring issue in VFP9 SP2 that is starting to make me very unhappy. It seems when I recompile an application in to an exe I have random code blocks in either defined methods or events on an object get erased. The

Re: VFP9: Method Code Disappearing...

2012-03-26 Thread Eurico Chagas Filho
Never happened to me, but you can create in a prg subroutines and call them from the button to execute your code.  HTH, E. Good Morning All: I have a recurring issue in VFP9 SP2 that is starting to make me very unhappy. It seems when I recompile an application in to an exe I have random code

RE: VFP9: Method Code Disappearing...

2012-03-26 Thread Jack Skelley
Good Afternoon Dave: Thanks for the speedy reply. I am both alarmed and pleased that this happened to someone else! Alarmed because there must be a bug in either the saving of the form's method code or the compilation process and pleased that it is not some behavior that I am doing and that it

Re: VFP9: Method Code Disappearing...

2012-03-26 Thread Alan Bourke
I would guess it is an issue with metadata corruption (i.e. the index files belonging to the VCX or whatever) rather than a bug in VFP. Is your source local to your machine or on a network drive ? -- Alan Bourke alanpbourke (at) fastmail (dot) fm

Re: VFP9: Method Code Disappearing...

2012-03-26 Thread Paul Hill
On Mon, Mar 26, 2012 at 3:29 PM, Alan Bourke alanpbou...@fastmail.fm wrote: I would guess it is an issue with metadata corruption (i.e. the index files belonging to the VCX or whatever) rather than a bug in VFP. Is your source local to your machine or on a network drive ? That's what I would

RE: VFP9: Method Code Disappearing...

2012-03-26 Thread Jack Skelley
Alan: The source is on a local drive. Jack Jack Skelley Senior Director, Programming/Computer Operations New Jersey Devils (973)757-6164 jskel...@newjerseydevils.com From: profoxtech-boun...@leafe.com [profoxtech-boun...@leafe.com] on behalf of Alan

Re: Method Code Disappearing...

2012-03-26 Thread Allen
Is in my case too. But the local machine is Win7 64 bit Al -Original Message- From: Jack Skelley Sent: Monday, March 26, 2012 4:36 PM To: profoxt...@leafe.com Subject: RE: VFP9: Method Code Disappearing... Alan: The source is on a local drive. Jack

Re: VFP9: Method Code Disappearing...

2012-03-26 Thread Christof Wollenhaupt
Reasons for code disappearing in a form method: a) pre-processor command mismatch b) saving the form c) virus scanners d) object memory corruption e) object code corruption a) Code for an object is stored in a single memo field, one record for every object added to the form. When you save a

[OT] Bammer to sell out to reds after election

2012-03-26 Thread Pete Theisen
Hi Everybody, What else does flexibility with commies mean? http://www.foxnews.com/politics/2012/03/26/obama-tells-medvedev-hell-have-more-flexibility-after-election-during-missile/ -- Regards, Pete http://pete-theisen.com/ http://elect-pete-theisen.com/

RE: VFP9: Method Code Disappearing...

2012-03-26 Thread Dave Crozier
Jack... Only run one time it seems to reset the form so that the problem never occurs don't ask me why but Dave -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Jack Skelley Sent: 26 March 2012 15:14 To: profox@leafe.com

RE: VFP9: Method Code Disappearing...

2012-03-26 Thread Dave Crozier
I bow to Christof's greater internal knowledge but it worked for me and as I say, I have no idea why don't forget to back up the forms first of course! Dave -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Dave Crozier Sent: 26 March

Re: VFP9: Method Code Disappearing...

2012-03-26 Thread Christof Wollenhaupt
it worked for me and as I say, I have no idea why don't forget to back up the forms first of course! Clearing the OBJCODE field and recompiling is actually something I do frequently for other reasons. When using text based source control such as SVN, one needs to re-generate binary files

Re: Multiple cursors returned from Stored Procedure

2012-03-26 Thread MB Software Solutions, LLC
On 3/26/2012 8:56 AM, Frank Cazabon wrote: I think Stephen was hinting that you need to make sure that you are using the correct syntax for your backend database. It looks to me like you build up a string of selects without any sort of indication that they are separate selects. In effect you

Re: Multiple cursors returned from Stored Procedure

2012-03-26 Thread MB Software Solutions, LLC
On 3/26/2012 9:06 AM, Frank Cazabon wrote: Just looked back and saw you were using the semi-colon to separate, but do you need to force a separate line in there too? No, you shouldn't need to do that. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect

Re: [OT] Race Hustling the latest tragedy

2012-03-26 Thread Michael Madigan
Spike Lee wants to lynch an uncharged man.  - Original Message - From: Pete Theisen petethei...@verizon.net To: ProFox Email List profox@leafe.com Cc: Sent: Monday, March 26, 2012 11:19 AM Subject: [OT] Race Hustling the latest tragedy Hi Everybody, As always . . .

RE: VFP9: Method Code Disappearing...

2012-03-26 Thread Jack Skelley
Good Afternoon Christof: Wow! a) I don't think applies because I only use the VFP editor to manipulate the code b) I have not noticed any files crashing when the form is saved and have not noticed any formname.tmp files in the project folder c) Very interesting. So what you are saying is that

[OT] Don't report anything the Bammer doesn't want reported?

2012-03-26 Thread Pete Theisen
Hi Everybody, http://www.aljazeera.com/programmes/listeningpost/2012/03/2012323201744332607.html -- Regards, Pete http://pete-theisen.com/ http://elect-pete-theisen.com/ ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: VFP9: Method Code Disappearing...

2012-03-26 Thread Christof Wollenhaupt
b) I have not noticed any files crashing when the form is saved and have not noticed any formname.tmp files in the project folder It's actually a SYS(3) value, not the real form name (12345678.TMP). c) Very interesting. So what you are saying is that any VFP file that has code should be

Re: Multiple cursors returned from Stored Procedure

2012-03-26 Thread Christof Wollenhaupt
My stored procedure returns 6 cursors. Can the Fox handle getting multiple cursors back? I thought so, by my SQLEXEC call fails with nothing showing when I do AERROR(laError). I'm not sure if it's relevant. The following knowledgebase article seems to imply that you need to use the CALL

Re: [JOB] VFP 9/8/SQL/WestWind Contract to Perm / Dallas/Plano

2012-03-26 Thread MB Software Solutions, LLC
On 3/26/2012 8:47 AM, Desmond Lloyd wrote: Is this THE Bill Sanders? Not even a Hello! Just straight to it. lol Good to see you here, Mr. Bill. Good luck with your search. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com

Re: [JOB] VFP 9/8/SQL/WestWind Contract to Perm / Dallas/Plano

2012-03-26 Thread MB Software Solutions, LLC
On 3/26/2012 8:56 AM, Richard Kaye wrote: Would anyone else have Mondo Regards as his sig?g LOL! -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16

Re: [OT] Is this the new Madigan?

2012-03-26 Thread Michael Madigan
Thanks Rev, Al.  - Original Message - From: Stephen Russell srussell...@gmail.com To: ProFox Email List profox@leafe.com Cc: Sent: Monday, March 26, 2012 4:23 PM Subject: [OT] Is this the new Madigan? http://www.youtube.com/watch?v=3Dr7XdvEk0k -- Stephen Russell 901.246-0159 cell

Re: Multiple cursors returned from Stored Procedure

2012-03-26 Thread MB Software Solutions, LLC
On 3/26/2012 9:19 AM, Stephen Russell wrote: On Sun, Mar 25, 2012 at 11:58 PM, MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: I wasn't going to bother trying that, as T-SQL is SQL Server and I am using MySQL. But, it didn't take much effort, so I did it since

Re: Multiple cursors returned from Stored Procedure (SOLVED, courtesy Mr. Ted Roche!)

2012-03-26 Thread MB Software Solutions, LLC
On 3/26/2012 10:00 AM, Ted Roche wrote: Michael: Which ODBC driver are you using? The Official Oracle/SUN/MySQL driver added support for multiple statements (which I'd think you'd need for multiple cursor return support, though I haven't tested it) in version 3.51.22, according to

RE: VFP9: Method Code Disappearing...

2012-03-26 Thread Jack Skelley
Good Afternoon: First, thanks to all that responded. I appreciate all the input. Christof, thanks for such a complete explanation. I have excluded all VFP extensions from the antivirus software (Sophos) And I will not compile an app in the same session as program/form modifications. I did write a

Re: VFP9: Method Code Disappearing...

2012-03-26 Thread Michael Savage
I read this with interest... How did you implement the email portion? Also does anyone done SMS from inside VFP? Mike On 26/03/2012 5:48 PM, Jack Skelley wrote: Good Afternoon: First, thanks to all that responded. I appreciate all the input. Christof, thanks for such a complete explanation.

Re: VFP9: Method Code Disappearing...

2012-03-26 Thread Ted Roche
Jack: It looks like you have a pile of great suggestions! If it's not already in there, I strongly suggest: 1) Make a backup ;) 2) browse the project as a DBF and note if there are any deleted records 3) If so, PACK. I've had lots of stability problems with projects with lots of deleted

Re: VFP9: Method Code Disappearing...

2012-03-26 Thread Paul Hill
Not VFP, but I've used ClickaTell in the past: http://www.clickatell.com/ They support HTTP, SOAP a COM DLL. Should be easy to get one of these working with Fox. Paul On Mon, Mar 26, 2012 at 10:58 PM, Michael Savage msav...@golden.net wrote: I read this with interest... How did you implement

RE: VFP9: Method Code Disappearing...

2012-03-26 Thread Jack Skelley
Good Evening Mike: The email portion runs against a table of contacts with checkboxes to determine who gets what mail. I do a tomato mailing about 6 times a year that basically talks about my hose timer controlled drip fertigation system where the tomato plants are in 5 gallon spackle buckets.

RE: VFP9: Method Code Disappearing...

2012-03-26 Thread Jack Skelley
Good Evening Ted: The response to this issue was incredible! I appreciate all input received. That's what makes this group special! I have backups in multiple locations. The code that runs in this app is staggering. It keeps track of: * up to 64 players on the ice and tabulates ice and shift

Using CDO for email from VFP (was Re: VFP9: Method Code Disappearing...)

2012-03-26 Thread MB Software Solutions, LLC
Just renamed for archive searching purposes...Thanks for sharing, Jack! On 3/26/2012 6:40 PM, Jack Skelley wrote: Good Evening Mike: The email portion runs against a table of contacts with checkboxes to determine who gets what mail. I do a tomato mailing about 6 times a year that basically

Re: VFP9: Method Code Disappearing...

2012-03-26 Thread MB Software Solutions, LLC
On 3/26/2012 6:52 PM, Jack Skelley wrote: Good Evening Ted: The response to this issue was incredible! I appreciate all input received. That's what makes this group special! I have backups in multiple locations. The code that runs in this app is staggering. It keeps track of: * up to 64