RE: Step through code of West Wind WebConnect

2011-03-30 Thread Steve Ellenoff
If you run WWC in File Mode and if the developer didn't customize the version, you can see the Version # of WWC on the application's title bar, as well as on the Status Dialog that pops up. You could also locate the wc.dll and check it's version ( although I'm not sure that version always

Variable name oddity?

2011-02-22 Thread Steve Ellenoff
I'm sure someone has a rational explanation for this odd behavior?? If I run the following code it fails with a syntax error on the method call, but if I use the variable x or y, for example it works just fine as expected. Other vars that failed were a,b,c,d,f. I didn't try any other than

Re: Variable name oddity?

2011-02-22 Thread Steve Ellenoff
.. LOL! -Steve At 02:16 PM 02/22/2011, you wrote: On Tue, Feb 22, 2011 at 2:12 PM, Steve Ellenoff sellen...@pinmame.com wrote: I'm sure someone has a rational explanation for this odd behavior?? By Design s. If I run the following code it fails with a syntax error on the method call

Re: Email thru VFP

2011-02-16 Thread Steve Ellenoff
What makes you say it's limited to text? I've been sending HTML emails out of WWIPSTUFF for 5+ years. You just need to change the content type property.. From the help file, which actually mentions HTML directly: cContentType Content type of the message allows you to send HTML messages for

RE: Email thru VFP

2011-02-16 Thread Steve Ellenoff
Director Sustainable Resources Industry Training Pty Ltd -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Steve Ellenoff Sent: Thursday, 17 February 2011 2:23 PM To: profox@leafe.com Subject: Re: Email thru VFP What makes you say it's

ConnectTimeOut not respected by Microsoft SQL Server for initial connection?

2011-02-14 Thread Steve Ellenoff
If I issue SQLSETPROP(0,ConnectTimeOut,1) to set the VFP global time out to 1 second, and then issue an SQLConnect() against an MS SQL Server back-end, it does not respect the 1 second time-out if the server cannot connect. Instead it takes about 30 seconds before it returns the appropriate -1

RE: ConnectTimeOut not respected by Microsoft SQL Server for initial connection?

2011-02-14 Thread Steve Ellenoff
[mailto:profoxtech- boun...@leafe.com] On Behalf Of Ted Roche Sent: Tuesday, February 15, 2011 12:03 AM To: profoxt...@leafe.com Subject: Re: ConnectTimeOut not respected by Microsoft SQL Server for initial connection? On Mon, Feb 14, 2011 at 4:54 PM, Steve Ellenoff sellen

Re: ConnectTimeOut not respected by Microsoft SQL Server for initial connection?

2011-02-14 Thread Steve Ellenoff
Great suggestion Ted, thanks!! Unfortunately, my quick tests showed that no VFP setting under 45 came in less than 45 seconds ( 5,10,15,20,25,30,35,45) all time-outed at ~42 seconds. A bit more odd was that any settings above 45 were up-wards of 80+ seconds, ie (50,55,60) all timed-out at ~84

Re: ConnectTimeOut not respected by Microsoft SQL Server for initial connection?

2011-02-14 Thread Steve Ellenoff
I don't see any specific settings in the ODBC DSN setup. I am using a connection string, but don't know where I'd go to find what setting to pass ( if there is one ) for this. -Steve At 05:16 PM 02/14/2011, you wrote: On Mon, Feb 14, 2011 at 5:08 PM, Steve Ellenoff sellen...@pinmame.com wrote

RE: ConnectTimeOut not respected by Microsoft SQL Server for initial connection?

2011-02-14 Thread Steve Ellenoff
Of Steve Ellenoff Sent: Monday, February 14, 2011 5:41 PM To: profoxt...@leafe.com Subject: Re: ConnectTimeOut not respected by Microsoft SQL Server for initial connection? I don't see any specific settings in the ODBC DSN setup. I am using a connection string, but don't know where I'd go to find what

Re: ConnectTimeOut not respected by Microsoft SQL Server for initial connection?

2011-02-14 Thread Steve Ellenoff
The book said to use Dabo instead of VFP ;) -Steve At 05:46 PM 02/14/2011, you wrote: On Feb 14, 2011, at 5:14 PM, Ted Roche wrote: The VFP Help file says: What's the Hacker's Guide say? g,dr Whatever it says, do the opposite. ;-P -- Ed Leafe [excessive quoting

Record Pointer after Insert

2011-02-04 Thread Steve Ellenoff
I'm re-factoring some code and was wondering if it's a 100% safe assumption that after an INSERT whether to a table or view/cursor, that the record pointer is sitting on the new record ( on the very next line of code ), so that code issuing a REPLACE would already be positioned on your new

Re: old dos program

2011-02-04 Thread Steve Ellenoff
If you're running Windows 7 ( I assume so since you said it's a new machine), it won't run 16 bit programs out of the box if I recall correctly. There was some chatter on this list about it a couple weeks ago. You'll need to install the Windows 7 Compatibility virtual machine (which

RE: [NF] Need a good starting point to get into ASP.NET

2011-02-03 Thread Steve Ellenoff
. :) -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech- boun...@leafe.com] On Behalf Of Steve Ellenoff Sent: Thursday, February 03, 2011 12:04 AM To: profoxt...@leafe.com Subject: Re: [NF] Need a good starting point to get into ASP.NET I also purchased a 1

Re: [NF] Need a good starting point to get into ASP.NET

2011-02-02 Thread Steve Ellenoff
I also purchased a 1 year subscription to LearnDevNow and have been very pleased, although I did not see a download link nor a lifetime subscription as others here have mentioned. Either way, it has been well worth the $ I spent on it. Good luck- -Steve At 04:38 PM 01/31/2011, you wrote: I

Differences between EXECSRIPT and Macro Expansion

2011-01-14 Thread Steve Ellenoff
Can someone explain why the following code fails to work using EXECSCRIPT but works in macro-expansion? tcSQL = [INSERT INTO webaccess (AENABLED,FKID,LASTMOD,LASTUSER,LOGIN,PASSWORD,PERSTYPE,UNIQUEID) VALUES (1,'_34I18SAUJ',{^2011-01-13

Re: Differences between EXECSRIPT and Macro Expansion

2011-01-14 Thread Steve Ellenoff
I forgot to mention that the problem is related to the funky characters of the password field. The password field is being encrypted, and that value is causing the EXECSCRIPT to fail. If you blank out that value in the INSERT string, EXECSCRIPT works fine.. I am wondering why? TIA- -Steve

RE: Differences between EXECSRIPT and Macro Expansion

2011-01-14 Thread Steve Ellenoff
that command. Maybe the value has an apostrophe in it now and then? -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech- boun...@leafe.com] On Behalf Of Steve Ellenoff Sent: Friday, January 14, 2011 6:30 PM To: profoxt...@leafe.com Subject: Re: Differences

Bug in Try..Catch?

2010-12-10 Thread Steve Ellenoff
The following code snippet seems to suggest a bug in Try Catch handling when accessing a collection's Item property with an invalid index argument. Can someone confirm as a bug or explain it to me? The help file is making me confused. I was under the impression the try catch ALWAYS has

Re: [NF] Calling website

2010-11-30 Thread Steve Ellenoff
The browser variable HTTP_REFERER should do what you want. -Steve At 09:09 PM 11/30/2010, you wrote: Let's say I have a web page. Is there a way to tell what url called it? Someone has my web page as a link on their site and I want to present them with a different page if my url was called by

Re: [NF] get Username using HTTP or ASP

2010-11-23 Thread Steve Ellenoff
Your code looks fine. I would check the IIS setings for directory security and make sure it's using integrated windows authentication and make sure anonymous access is turned off. My guess would be the empty logon_user is due to the fact that IIS is serving up the page to an unauthenticated

Re: [NF] Migrate DB from MySQL to PostgreSQL

2010-11-07 Thread Steve Ellenoff
Overall they are very similar, but there's a variety of differences that can be very annoying.. The biggest challenge would be stored procedures, so if you use those heavily, you're in for a lot of work. Aside from that data type differences and syntax differences will be the next issue. If you

Do you flush?

2010-10-07 Thread Steve Ellenoff
Hopefully the toilet yes, but I'm wondering how many people on the list have a manual flush command to force updates in your fox apps? I have an application that is occasionally just having data disappear. More accurately, the data seems to revert to a previous state, ie, a user pulls up a

Can this be done in a single select sql?

2010-09-16 Thread Steve Ellenoff
I have a login table that has a log_in field and a log_out field (both datetime) to record when the user enters and exits the application. Sometimes, the user's computer crashes (or the app) and does not record the log_out field, ie, it's empty. I am writing a report that needs to have all

Re: Can this be done in a single select sql?

2010-09-16 Thread Steve Ellenoff
that I was able to put back the l.lg_in comparison earlier, and it all works as expected. Thanks!! -Steve At 02:03 PM 09/16/2010, you wrote: On 16/09/10 11:34, Steve Ellenoff wrote: SELECT u.username, l.lg_in, l.lg_out, ; (SELECT MIN(lg2.lg_in)-1 ; FROM loginhis lg2

Re: Detecting user inactivity in your app (VFP9SP2)

2010-09-08 Thread Steve Ellenoff
If it was me, I would implement a timer and use a Win32API call. Depending on the value of the auto-save, would dictate the interval of the timer, i.e., autosave after 5 mintues, then make your timer 5 minutes long. Then, you can use the Win32API GetLastInputInfo() function to tell you if any

Re: [NF] Why Windows development is best

2010-08-31 Thread Steve Ellenoff
I would say your experience is typical for the normal (non-techie) user. ...but very a-typical for the experienced windows user at least from what I've seen. I almost never have issues like that and rarely need to reboot. Most windows developers I know are similar in that regards.. Then

Re: [NF] Why Windows development is best

2010-08-31 Thread Steve Ellenoff
For the non-techie user I would rank the choices as follows as far as easiest to use and least likelihood of issues: 1) Mac 2) Windows 3) Linux Appropriate is a broad term, so it would be in-appropriate for me to say if Windows is not appropriate for non-techie users! :) I think it's a decent

Re: [NF] Why Windows development is best

2010-08-31 Thread Steve Ellenoff
To me, non-techie is someone who doesn't really understand what they are doing when using computers, and if something goes wrong has no idea what to do about it. With today's younger generation being really familiar with technology in general, the definition is different and would likely mean

Re: [NF] Why Windows development is best

2010-08-31 Thread Steve Ellenoff
-tech crowd. -Steve At 11:23 AM 08/31/2010, you wrote: On 31/08/2010 11:54 a.m., Steve Ellenoff wrote: For the non-techie user I would rank the choices as follows as far as easiest to use and least likelihood of issues: 1) Mac 2) Windows 3) Linux Hu have you used Linux

Re: Beware the evil DODEFAULT()

2010-08-25 Thread Steve Ellenoff
At 03:16 AM 08/25/2010, you wrote: ...and this is a bug because ? Because if you code it the wrong way, your code will not work as expected! :) I wasn't saying it was a VFP bug.. it's a programmer bug, which is far worse, since then we can't blame it on VFP. Lol! -Steve

Re: Beware the evil DODEFAULT()

2010-08-25 Thread Steve Ellenoff
I think Stephen was being intentionally sarcastic.. :) At 12:30 PM 08/25/2010, you wrote: On 8/25/10 6:30 AM, Stephen Russell wrote: On Wed, Aug 25, 2010 at 2:16 AM, Lew Schwartzlew1...@gmail.com wrote: ...and this is a bug because ? - The compiler didn't catch it.

Beware the evil DODEFAULT()

2010-08-24 Thread Steve Ellenoff
Thought I would remind everyone about this (sometimes not so obvious) bug... FUNCTION SomeFunc( tnVal ) *Call Parent DODEFAULT() ENDFUNC Should be: DODEFAULT(tnVal) .. IF the parent class takes a parameter ( which it may not depending on the parent class ). This bugger was the

Re: [NF] Picked up a virus/spyware that Avast/MalwareBytes can't detect/remove

2010-08-10 Thread Steve Ellenoff
It sounds similar to one I got a few weeks ago. I was surprised since I was running Firefox, but after reading about it, it's a security hole in Flash, so any browser is vulnerable, and you know how many pages use flash, right? From a separate computer I googled how to get rid of it, and was

Why no source code included in ASTACKINFO() sometimes?

2010-08-07 Thread Steve Ellenoff
According to VFP9 help file: ASTACKINFO( ) only populates the 6th array element if source line contents are available, otherwise it will be left empty. Does anyone know why the source line contents would not be available? I am running an .EXE ( normal, ie, not COM ) with an error handler that

What does @1,1 do?

2010-08-07 Thread Steve Ellenoff
Got the following error msg reported by an application earlier today... Error Msg: Row or column position is off the screen. Call Stack: sslg_app.onshutdown - Line #44 : @1,1 sslg_app.do - Line #73 : READ EVENTS main - Line #370 Looking at the code, I don't know what this does, and could not

Re: INTO TABLE vs INTO CURSOR READWRITE

2010-07-30 Thread Steve Ellenoff
be used in subsequent queries. So it would seem READWRITE NOFILTER is the proper equivalent to INTO TABLE.. -Steve At 09:56 PM 07/29/2010, you wrote: Steve Ellenoff wrote: Is there any difference between these two? I'm looking at some older code and I have remarks about the SELECT SQL

[NF] How many data base people does it take to change a light bulb?

2010-07-29 Thread Steve Ellenoff
My friend Michael Gutman send this joke my way.. Q:: How many data base people does it take to change a light bulb? A: Three: One to write the light bulb removal program, one to write the light bulb insertion program, and one to act as a light bulb administrator to make sure

INTO TABLE vs INTO CURSOR READWRITE

2010-07-29 Thread Steve Ellenoff
Is there any difference between these two? I'm looking at some older code and I have remarks about the SELECT SQL using INTO TABLE to avoid some VFP errors that says something like, Command cannot be issued on a cursor or something to that effect. Would changing my code to CURSOR READWRITE

Re: INTO TABLE vs INTO CURSOR READWRITE

2010-07-29 Thread Steve Ellenoff
Thanks Vince Lew! I just found this line in the VFP helpfile: NOFILTER creates a cursor that can be used in subsequent queries. So it would seem READWRITE NOFILTER is the proper equivalent to INTO TABLE.. -Steve At 09:56 PM 07/29/2010, you wrote: Steve Ellenoff wrote: Is there any

Re: Excel import

2010-07-26 Thread Steve Ellenoff
I ran into similar problems awhile back and the solution in my case was to get the users to save the data file in an earlier format from within Excel itself. In the Save As dialog, there's a Save As Type drop down, which if you scroll all the way down, shows older versions of Excel to save to.

Re: VFP and SQL (was Large Data Tables)

2010-07-19 Thread Steve Ellenoff
The only change would be the SERVER= section of your connection string. You would change that to the name of the remote sql server hosting the box. You may need to set some security settings on W2008, but since I don't have W2008 I can't assist with that. -Steve At 10:23 AM 07/19/2010, you

RE: VFP and SQL (was Large Data Tables)

2010-07-19 Thread Steve Ellenoff
Nice catch Richard, I totally missed that in my reply. -Steve At 11:39 AM 07/19/2010, you wrote: Hi Rafael, You say the server is Windows 2008 but don't specify the version of SQL installed. For testing purposes, can you create an ODBC connection using the ODBC Administrator to verify that

Re: [spam] RE: VFP and SQL (was Large Data Tables)

2010-07-19 Thread Steve Ellenoff
Or you could just use a VPN and avoid the port forwarding from the router... but I know you said you wanted to avoid it. -Steve You need to set up DNAT on the router, to forward incoming packets on the SQL Server port to the Server's address. Otherwise, there's no way to route to the server

Re: Large Data Tables

2010-07-16 Thread Steve Ellenoff
You don't need to manually configure a DSN entry on each client machine to access a SQL Server backend. You simply need to get the ODBC driver installed. This can be automated to kick in when a user logs in to their network or worst case, you send out an email with a link to the .exe and have

Re: Open source updates cost TIME instead of $$$

2010-04-27 Thread Steve Ellenoff
I've been using it and the experience has been fantastic. It's been rock solid in the 1.5 years it's been running for my customer. At 01:27 PM 04/27/2010, you wrote: On 4/27/2010 1:20 AM, Alan Bourke wrote: One of the main objections customers have is the DBF format, and I agree that it is

Re: VFP Studio - vapourware ?

2010-04-21 Thread Steve Ellenoff
Obviously I'm not Craig or Bo, so this is just my personal opinion (for what it's worth), but my impression the project exists is for these two reasons: 1) To extend the functionality of the VFP IDE and offer we developers more functionality than the VFP9 IDE offers.. Because what we have is

Re: Open source updates cost TIME instead of $$$

2010-04-21 Thread Steve Ellenoff
Maybe I was just not lucky, but my experiences with Ubuntu were pretty bad ( this was in 2008 ). Overall it worked just fine except that wireless networking would simply not work. I wasted several days of hair pulling and stress reading, researching and trying everything I could to get it to

RE: VFP Studio - vapourware ?

2010-04-21 Thread Steve Ellenoff
: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Steve Ellenoff Sent: Wednesday, April 21, 2010 03:41 PM To: profoxt...@leafe.com Subject: Re: VFP Studio - vapourware ? Obviously I'm not Craig or Bo, so this is just my personal opinion (for what it's worth), but my

Re: Open source updates cost TIME instead of $$$

2010-04-21 Thread Steve Ellenoff
Linux is a huge success now. It runs most of the Apache instances, which in turn runs most of the internet. It runs Google. It runs Twitter. It runs Amazon. Yes, sorry, I should have qualified my statement to mean a huge success as a Desktop OS replacement, since it's success in other roles is

Re: VFP Studio - vapourware ?

2010-04-19 Thread Steve Ellenoff
I asked Craig about the project at SWFOX last year and he had said the project was not dead but was on hold since Microsoft had made some big changes to the technology used. I don't recall what specifically it was, nor when he said it might come out so they could resume. I would still

Re: VFP Studio - vapourware ?

2010-04-19 Thread Steve Ellenoff
wrote: Steve Ellenoff wrote: I asked Craig about the project at SWFOX last year and he had said the project was not dead but was on hold since Microsoft had made some big changes to the technology used. I don't recall what specifically it was, nor when he said it might come out so they could

Re: [NF] ASP pages not running

2010-03-16 Thread Steve Ellenoff
I'm no expert on ASP, but my first thought is that it sounds like IIS on the server is not configured properly to handle the pages. Are you sure ASP is installed on the server? Check under the IIS settings, in the Home Directory tab, click the Configuration button and check for the ASP

Re: [NF] anyone heard of Firebird DB server?

2010-02-23 Thread Steve Ellenoff
I've got a VFP9 app that's been running with PostgreSQL for over a year and have been thrilled with it!! At 05:51 PM 02/23/2010, you wrote: On 02/23/2010 02:44 PM, MB Software Solutions, LLC wrote: Jarvis, Matthew wrote: I am being told (I am dubious though) that Firebird bogs down at

Re: Windows 7 and existing VFP 7 / InstallShield applications

2010-02-22 Thread Steve Ellenoff
1) See if you are able to copy to the current user's temp directory. I believe that should always work regardless of UAC. 2) Check UAC settings on your machine vs. the client machine, ie, make sure they match. 3) Are you running your app in compatibility mode? 4) If not, is the application

Re: .NET and other languages for a VFP developer

2010-02-14 Thread Steve Ellenoff
Do you have a source for this interview, I'd like to read the rest. David Parnas explained in an interview: Q: What is the most often-overlooked risk in software engineering? A: Incompetent programmers. There are estimates that the number of programmers needed in the U.S. exceeds 200,000. This

Re: [NF] java error dump can anyone point out what failed?

2010-02-12 Thread Steve Ellenoff
The SocketException suggests to me that a network connection got dropped during some processing, that's about all I can tell from this log. At 04:02 PM 02/12/2010, Stephen Russell wrote: From the Java Blows division of CIMS: I have a java workflow tool with 2 scripts that preset a printjob. I

Re: .NET and other languages for a VFP developer

2010-02-11 Thread Steve Ellenoff
While python may be a great language to learn, I am curious how many opportunities exist out there. Surely there's no shortage of .NET jobs, but is the same true of Python? Can Ed or someone else chime in? TIA- Steve At 01:16 PM 02/11/2010, you wrote: John, I encourage you to think out of

How to find out why UPDATE SQL statement is failing

2010-02-05 Thread Steve Ellenoff
I have a biz object that is occasionally failing to save data and I'm trying to understand why. Here's an example of the SQL command it generates: UPDATE webaccess SET lastmod={^2010-02-05 15:07:11}, nloginfail=0 WHERE uniqueid=='_2UX13CCKE' AND nloginfail==1 The biz object uses _TALLY when

Re: I can't believe this

2010-02-01 Thread Steve Ellenoff
Your test is misleading. Take the same 80 gig hd, put a fresh copy of XP on there, and then compare the speed. After two years of accumulated crap, windows will no doubt run far slower than when first installed. I remember reading somewhere that a test was done on the same hardware, and XP

Re: Storing passwords -- best practice

2010-01-13 Thread Steve Ellenoff
I suggest googling for salt passwords, or just start here: http://en.wikipedia.org/wiki/Salt_%28cryptography%29 Although I don't salt passwords in my apps, it sounds like a good idea. Steve At 02:31 PM 01/13/2010, MB Software Solutions, wrote: Obviously storing passwords in plain text is

Re: Is a FoxPro Generated Exe an IPC enabled application?

2010-01-05 Thread Steve Ellenoff
The question isn't really worded very clearly, so I'll answer what I assume is meant.. Yes, Foxpro EXE applications can participate (when written to do so) in IPC communications, depending on what IPC methods are used. I've written Fox apps that communicated with each other via IPC and demoed

Re: [NF] Recommendations for text search utility?

2009-12-15 Thread Steve Ellenoff
I too use Agent Ransack and have always been happy with it. @ Paul - what does the pro version features offer? At 04:58 PM 12/15/2009, Paul Hill wrote: On Tue, Dec 15, 2009 at 6:08 PM, Alan Bourke alanpbou...@fastmail.fm wrote: I swear by Agent Ransack (http://www.mythicsoft.com/agentransack/)

[NF] Crystal reports expert needed

2009-11-27 Thread Steve Ellenoff
I know someone who is looking for a person familiar with the latest version of Crystal reports to convert some reports from the older version. If you're interested let me know and I'll forward on the info.. Regards- Steve ___ Post Messages to:

Re: [NF] Crystal reports expert needed

2009-11-27 Thread Steve Ellenoff
I don't know the location, but I got the impression the work could be done remotely. At 03:34 PM 11/27/2009, you wrote: What is the location? On 11/27/09, Steve Ellenoff sellen...@pinmame.com wrote: I know someone who is looking for a person familiar with the latest version of Crystal

Re: Possible to run 16-bit FoxPro for Windows in a 32-bit VM running on a 64-bit PC?

2009-11-09 Thread Steve Ellenoff
Although I've never tried it myself, that should work fine, yes. At 10:19 PM 11/08/2009, you wrote: I have a customer still using FoxPro for Windows 2.6 apps in production. These are 16 bit apps that will not run on the 64 bit versions of Vista or Windows 7. Would it be possible for these

Re: [ADMIN] Folks, just email pro...@leafe.com....not profoxtech!!! (was Re: Typical screen resolution)

2009-10-30 Thread Steve Ellenoff
Sorry, it was that evil Reply To All button I didn't even notice it until you pointed it out. At 04:11 PM 10/29/2009, you wrote: Steve Ellenoff wrote: ROTFL Bzzt...foul! Steve, don't post to both profox and profoxtech. Folks, just send to ProFox@leafe.com only. Ed's server

Re: Typical screen resolution

2009-10-29 Thread Steve Ellenoff
ROTFL Please allow your users the choice. NO!!! HOSTILE INTERFACES RULE MUHAHAHAHAHA! -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 [excessive quoting

Re: Typical screen resolution

2009-10-29 Thread Steve Ellenoff
ROTFL Please allow your users the choice. NO!!! HOSTILE INTERFACES RULE MUHAHAHAHAHA! -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 [excessive quoting

Typical screen resolution

2009-10-28 Thread Steve Ellenoff
Looking for your opinions on the current default screen resolution that most users are running these days, ie, what should be the minimum size I code for? I am using 800x600 as the minimum size I code for, but perhaps the number is bigger nowadays, ie, maybe nobody runs this resolution

Re: VFP9 SP2 Memo File xxxx is missing or is invalid - Avast problem with 'Standard Shield'

2009-10-23 Thread Steve Ellenoff
Sorry, I accidentally clicked the report OT abuse link for this thread.. please ignore Ed! At 02:21 PM 10/23/2009, you wrote: I have been getting this error anytime I 'modify form'. The first time I save changes, I get that message. The second time I save/close the form, it crashes VFP. I

How to hide 0 values for exported VFP data in Excel and still sum the column

2009-09-17 Thread Steve Ellenoff
I have an app that exports a bunch of data to excel using the COPY TO XL5 command. The client recently asked if the numeric fields could be blank when the value was zero for easy reading. I couldn't find any easy way to do this in Excel through formatting... so I changed the exported data to a

Re: How to hide 0 values for exported VFP data in Excel and still sum the column

2009-09-17 Thread Steve Ellenoff
:56 PM, Steve Ellenoff sellen...@pinmame.com wrote: I have an app that exports a bunch of data to excel using the COPY TO XL5 command. The client recently asked if the numeric fields could be blank when the value was zero for easy reading. I couldn't find any easy way to do this in Excel

Re: How to hide 0 values for exported VFP data in Excel and still sum the column

2009-09-17 Thread Steve Ellenoff
Awesome suggestion Dave. I tried it and it works great! Now the pain will be to reconvert some 50 fields back to numerics instead of chars... sigh.. At 04:26 PM 09/17/2009, you wrote: On Thu, Sep 17, 2009 at 1:56 PM, Steve Ellenoff sellen...@pinmame.com wrote: I have an app that exports

RE: How to hide 0 values for exported VFP data in Excel and still sum the column

2009-09-17 Thread Steve Ellenoff
. Help Blank if zero should give you the correct way for the version of Excel you are using. Be aware that there can be a problem with excel if you save a changed sheet using OLE as it may prompt with a save as dialogue. Cheers Peter Peter Hart Computers On Behalf Of Steve Ellenoff Sent: 17

Re: [NF] Those nasty TCP/IP security holes won't be fixed in XP.

2009-09-15 Thread Steve Ellenoff
Actually I think it's a firefox issue, and has nothing to do with Vista. Until version 3.5 I had to reboot frequently (XP SP2) as a result of massive memory usage (leaks?) in Firefox. It's likely because I leave like twenty tabs open sometimes. Although 3.5 is still too new for me to really

Re: [NF] Quality Control / Beta Test position wanted

2009-09-12 Thread Steve Ellenoff
Sorry gang, I hit reply all to a different message when I sent my original post. It must have added both lists and I didn't notice. At 07:28 PM 09/11/2009, Ed Leafe wrote: All ProFoxTech messages get routed to 'profox@leafe.com'. Sending to both will result in two messages. Nothing much can be

Re: [NF] Quality Control / Beta Test position wanted

2009-09-11 Thread Steve Ellenoff
Thanks Ed, I'll pass the info along. At 10:06 PM 09/10/2009, Ed Leafe wrote: On Sep 10, 2009, at 8:24 PM, Steve Ellenoff wrote: I ran into a friend of mine today who is looking for some work in Quality Control / Beta Testing. He's open to anything from a short contract position to full

Re: vfp and OpenOffice automation

2009-09-11 Thread Steve Ellenoff
If OpenOffice is not the default application for XLS files, your code can still be used provided the application knew where the OO application was installed. Simply change the ShellExecute command to launch the OO program and pass the file name of the XLS file to it as a parameter. Although

[NF] Quality Control / Beta Test position wanted

2009-09-10 Thread Steve Ellenoff
Hi Everyone- I ran into a friend of mine today who is looking for some work in Quality Control / Beta Testing. He's open to anything from a short contract position to full time permanent position. He lives here in Atlanta. I don't know if he's willing to travel or relocate. If anyone knows of

New Discounts announced for SWFOX Conference

2009-09-09 Thread Steve Ellenoff
I just learned of some new discounts being offered for attending the amazing Southwest Fox Conference which is just over a month away, so I thought I would share the info. If you work with Foxpro, this is the place to be! Come show your support! Learn tons of great coding techniques and hear

RE: Keyboard Clear

2009-09-01 Thread Steve Ellenoff
You can't blame that on getting old!! How can you expect to remember a command you only need to use once every 8 years and only in rare circumstances? GRIN -Steve At 02:08 PM 09/01/2009, Kent Belan wrote: Arg ... thanks Sucks getting old Is CLEAR TYPEAHEAD what you are looking for?

Disable UI elements?

2009-08-06 Thread Steve Ellenoff
I'm having a senior moment.. Isn't there a way to turn off UI elements in VFP for programs that will not have any UI, and thus, you don't want vfp popping up a messagebox if an error occurs and so forth? Any help appreciated- Thanks- Steve ___

RE: Disable UI elements?

2009-08-06 Thread Steve Ellenoff
Yes, I think that was it, thanks so much Tracy! At 04:21 PM 08/06/2009, Tracy Pearson wrote: Might you be looking for: Sys(2335) -Original Message- From: Steve Ellenoff Sent: Thursday, August 06, 2009 3:53 PM I'm having a senior moment.. Isn't there a way to turn off UI elements in VFP

Re: Need to produce mass emails (VFP9SP1)

2009-08-04 Thread Steve Ellenoff
I wrote an emailer application years ago which uses the wwipstuff tools from West Wind since it came free with West Wind's Web Connection. It basically keeps a database of email records, and sends out records not already flagged as sent. The code to send the email is really simple as their

Re: Oh you're a programmer (so you should be able to program in this other language no problem, right?)

2009-08-04 Thread Steve Ellenoff
I would try to explain that a computer language is just like a spoken language, and so have him imagine hiring two people to write a book. One person writes the book in Japaneese, the other in Russian. Then ask him how well he thinks it would be to have the writers swap books and continue

Re: Need to produce mass emails (VFP9SP1)

2009-08-04 Thread Steve Ellenoff
Good to know...thanks. Hmmm...I think we have wwIPStuff here at Sylvan. Are there published docs for this? Here's the example from the wwc doc: o=CREATEOBJECT(wwIPStuff) o.cMailServer=mail.yourmailserver.net o.cSenderEmail=rstr...@west-wind.com o.cSenderName=Rick Strahl *** Optional

Re: How would you read a tracking notice from UPS (email)

2009-08-04 Thread Steve Ellenoff
If you're hitting a POP3 mail server, it's all going to come back as text with no simple way to convert it into XML afaik. You'll need to manually parse the string into subject, from, to, body, and so forth. Since you're already going to be doing that, you might as well just scrape once you

[NF] Anyone have experience with Adobe Flex Builder?

2009-08-04 Thread Steve Ellenoff
Watched a few free videos on it the other night and thought it looked pretty good and easy to do. I've toyed with some DHTML/Ajax and Flex looked a lot easier. Was looking to see if anyone here has some first hand experience and thoughts on using it.

Re: Oh you're a programmer (so you should be able to program in this other language no problem, right?)

2009-08-04 Thread Steve Ellenoff
So you can learn other RDBMS languages like MySQL and how to interact with them, but something as BIG and widely used as VB you cannot? This is what they have in their head. So tread lightly, or just learn it. Certainly good advice to be careful when dealing with people who don't appreciate

Re: Oh you're a programmer (so you should be able to program in this other language no problem, right?)

2009-08-04 Thread Steve Ellenoff
At 12:31 PM 08/04/2009, you wrote: Aah the joys of being labeled a computer guy. Usually it's oh you're a computer guy? Then you can fix my computer problems (even though software is my focus and I leave hardware/networking usually to those pros who do that stuff). I also hate this when it

Re: C functions

2009-07-29 Thread Steve Ellenoff
At 11:07 AM 07/29/2009, you wrote: On Wed, Jul 29, 2009 at 10:53, Jerry Footeje...@footegroup.com wrote: Does anyone know of a table that lists C functions with similar functions to VFP? Or maybe basic Right now I'm struggling with this code if ( strcmp( _item,T123 ) != 0) I want

Prevent Grid from scrolling to top on refresh?

2009-07-23 Thread Steve Ellenoff
I have a grid on a form bound to a cursor. Let's say the cursor has 20 records, but the grid is sized to show only 10 at time. When you issue a refresh on the grid, the scroll bars are always reset to the top. *Is there a way to avoid this behavior so that if a user had scrolled to the middle,

RE: PDF Creation Crashing FoxPro!

2009-07-16 Thread Steve Ellenoff
I've had this problem also cause strange things to happen to my vfp apps in the past and saving the path and restoring it as Rob suggested definitely solved it. Hope it does for you also. -Steve At 10:02 AM 07/16/2009, you wrote: It is changing the default path I think. Preserve it before

Re: Generating GUIDs for primary keys in your app (VFP9SP2)

2009-06-24 Thread Steve Ellenoff
Funny, I too started with SYS(2015). For me though, I have never stopped. I had thought about moving to integer keys since everything in the vfp and sql server world suggested it, but I never got around to implementing it. Glad I skipped it, as to me, the GUID makes the most sense, whether

Re: Generating GUIDs for primary keys in your app (VFP9SP2)

2009-06-23 Thread Steve Ellenoff
What kind of performance penalty is there compared to integers when doing joins? At 07:32 PM 06/23/2009, you wrote: MB Software Solutions, LLC wrote: I like to design in n-tier fashion, so that I can use either a VFP or non-VFP (like MySQL) backend on the flip of a switch. I'm creating a

Re: NF: Anyone (else) seen Eudora handling junkmail wrong?

2009-06-08 Thread Steve Ellenoff
Found it ! (after a year :)) Wow! Thanks for the persistence! Delete (or rename) the file PLUGINS\UserJunkDB.txt Somehow after millions of mails it does not work as expected... Ironically, about 3 months ago, it just started working fine again.. I don't think I did anything to cause it to

Pull Active Directory(ADS) information for authentication?

2009-06-05 Thread Steve Ellenoff
One of my clients wants to authenticate their VFP app through ADS rather than storing the username password as it currently does. Does anyone have info on how I can do that through VFP, and/or some links on how to communicate to ADS ie get a list of the users for example? Thanks- Steve

[NF] You know you're a geek when...

2009-04-30 Thread Steve Ellenoff
I bought some new hard drives recently, and noticed the manufactured date for 2 of them happened to be my birthday this past year. Call me a geek, but I thought that was really cool! The other 2 drives I bought were off by 2 days, and I was actually bummed!! Time to get a life, eh? -Steve

Re: Connecting To MySql

2009-04-02 Thread Steve Ellenoff
Not to defend Yahoo or anyone else, but I would guess from their perspective, the point is: most developers are using php or some other web hosted language to access the mysql database (often on the very same host as the database itself). So from their perspective, remote support is just

  1   2   3   4   >