Re: [NF] Wireless Router problem/life time

2012-08-16 Thread Alan Bourke
Defender was built by Microsoft while MSE was based on a product they purchased from somebody else. I think that's the wrong way round - Windows Defender was based on Giant AntiSpyware (written in VB6), MSE is an entirely in-house development. -- Alan Bourke alanpbourke (at) fastmail

Re: Foxweb?

2012-08-16 Thread Ted Roche
On Wed, Aug 15, 2012 at 11:27 PM, Mike Copeland m...@ggisoft.com wrote: Dunno if you have any experience with using PHP on a website, but using FoxWeb does remind me of that combo. A lot. Only with good performance with DBF files (which PHP admittedly doesn't handle well.) I'd like to hear

Re: Ed's leafe.com site error

2012-08-16 Thread Ed Leafe
On Aug 15, 2012, at 8:37 AM, Dave Crozier wrote: Tried to upload a file to the Leafe.com server for the other pProfoxers and every time I try it throws back n error: 400 Bad Request The server could not comply with the request since it is either malformed or otherwise incorrect. No

RE: just installed vfpro-9

2012-08-16 Thread Tracy Pearson
Fred Taylor wrote on 2012-08-15: Don't think that will work. The Init code will hang at the READ EVENTS. The usual way is to have a .PRG with: DO FORM yourform READ EVENTS and then have the CLEAR EVENTS in either the Quit button Click, or in the Form Destroy event. Fred

Re: just installed vfpro-9

2012-08-16 Thread Alan Bourke
On Thu, Aug 16, 2012, at 02:20 PM, Tracy Pearson wrote: You will want an ON ERROR statement to capture and handle errors. Or Try .. Catch -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___ Post Messages to: ProFox@leafe.com

RE: Pop-up form not showing in front of Top Level form

2012-08-16 Thread MB Software Solutions General Account
On Wed, August 15, 2012 5:40 pm, Tracy Pearson wrote: A Modal form? You need to set the ShowWindow in the Top Level Form instead of Screen. But per VFP Help regarding form.ShowWindow = 2: As Top-Level Form. The form is a top-level form in which child forms can be placed. Note that a top-level

RE: Pop-up form not showing in front of Top Level form

2012-08-16 Thread Kurt Wendt
Hey Mike - maybe I'm missing something about what your actual problem is. But, as for some suggestions. How about the Always On Top property for the pop-up Form, is that Set to True? As for the 2nd Form being behind the main Form - you actually SEE that occurring? Also - did you try setting this

Re: Foxweb?

2012-08-16 Thread Jeff Johnson
I am familiar with a company (hosting) that has been using Foxweb for many years to host VFP on 10's of websites. Maybe even a couple of hundred. It worked and still works very well with a couple of problems that are - in my opinion - user made. They run out of channels which appears to be

Query taking 4 minutes...ugh

2012-08-16 Thread MB Software Solutions General Account
VFP9SP2 - WinXP - dbfs on network I have to query 2 tables to populate a lookup list: SELECT x1.provnum ; FROM (ADDBS(this.cDataPath)+this.cClaimsTable) x1 ; UNION ; SELECT x2.provnum ; FROM (ADDBS(this.cDataPath)+this.cDischargeTable) x2 ; INTO CURSOR curTemp This query is taking forever (4

Re: Query taking 4 minutes...ugh

2012-08-16 Thread Alan Bourke
If you do: Use (ADDBS(this.cDataPath)+this.cClaimsTable) in 0 alias x1 Use (ADDBS(this.cDataPath)+this.cDischargeTable) in 0 alias x2 Select provnum from x1 Union select provnum from x2 Into Cursor curTemp ... is that any quicker? How big are these tables? -- Alan Bourke alanpbourke

Re: Query taking 4 minutes...ugh

2012-08-16 Thread Alan Bourke
On Thu, Aug 16, 2012, at 03:28 PM, MB Software Solutions General Account wrote: VFP9SP2 - WinXP - dbfs on network How fast is the network link? -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___ Post Messages to: ProFox@leafe.com

Re: Query taking 4 minutes...ugh

2012-08-16 Thread Peter Cushing
MB Software Solutions General Account wrote: VFP9SP2 - WinXP - dbfs on network I have to query 2 tables to populate a lookup list: SELECT x1.provnum ; FROM (ADDBS(this.cDataPath)+this.cClaimsTable) x1 ; UNION ; SELECT x2.provnum ; FROM (ADDBS(this.cDataPath)+this.cDischargeTable) x2 ;

RE: Query taking 4 minutes...ugh

2012-08-16 Thread Richard Kaye
You didn't say how many rows are in these tables. Go xBase. Try COPY TO and APPEND FROM. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions General Account Sent: Thursday, August 16, 2012 10:29 AM To:

Re: Query taking 4 minutes...ugh

2012-08-16 Thread MB Software Solutions General Account
On Thu, August 16, 2012 10:39 am, Alan Bourke wrote: How big are these tables? Yeah sorry...just realized I forgot that detail! Claims is 2.5 million rows, and Discharge is 65,000. Of course there's an index on provnum in both tables. Those tables record count will grow over time.

Re: Query taking 4 minutes...ugh

2012-08-16 Thread MB Software Solutions General Account
On Thu, August 16, 2012 10:39 am, Alan Bourke wrote: How fast is the network link? 100mb network ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list:

Re: Query taking 4 minutes...ugh

2012-08-16 Thread MB Software Solutions General Account
On Thu, August 16, 2012 10:51 am, Peter Cushing wrote: If all you are doing is checking if the provnum is valid you could just seek into both tables (assuming it is indexed). Should be quick enough. * assume open with above aliases and order set. if seek(mytestvalue,'X1') or

RE: Query taking 4 minutes...ugh

2012-08-16 Thread MB Software Solutions General Account
On Thu, August 16, 2012 10:57 am, Richard Kaye wrote: You didn't say how many rows are in these tables. Sorry. Sent just a bit ago. Go xBase. Try COPY TO and APPEND FROM. I'm using APPEND FROM to get the text files into the DBFs. I'll just add a function to make sure a local 'distinct

RE: Query taking 4 minutes...ugh

2012-08-16 Thread Dave Crozier
Mike, If you have lots of duplicate provnum fields in cClaimstable then have you tried select distinct in both the selects. This should be quicker (I think), especially in the 2.5m row table. Dave --- This communication and the

Re: VFP9: Automating sending a file to an FTP site.

2012-08-16 Thread M Jarvis
On Wed, Aug 15, 2012 at 6:30 AM, Dave Crozier da...@flexipol.co.uk wrote: Desmond, Just emailed you direct Dave snipped snipped some more snipped some more snipped some more --- and still snipped some more and finally snipped

Re: Christof's XML Excel files creation article is AWESOME!

2012-08-16 Thread Angel Dario Rodriguez
What language is that code for ? --- El mié, 15/8/12, MB Software Solutions General Account mbsoftwaresoluti...@mbsoftwaresolutions.com escribió: De: MB Software Solutions General Account mbsoftwaresoluti...@mbsoftwaresolutions.com Asunto: Christof's XML Excel files creation article is

RE: just installed vfpro-9

2012-08-16 Thread Gary Jeurink
I've never used either command before. I remember reading about them. The only problem I always struggled with is changing forms that use the same database and the data environment would not show up. I would put a menu like form in between to select one or the other and then they would function.

RE: just installed vfpro-9

2012-08-16 Thread Gary Jeurink
I need to add that to my skills. Is that covered in the Hackers Guide? Gary Jeurink -Original Message- From: Alan Bourke [mailto:alanpbou...@fastmail.fm] Sent: Thursday, August 16, 2012 8:42 AM To: profox@leafe.com Subject: Re: just installed vfpro-9 On Thu, Aug 16, 2012, at 02:20

RE: just installed vfpro-9

2012-08-16 Thread John Weller
No - it's a VFP9 function. John Weller 01380 723235 07976 393631 I need to add that to my skills. Is that covered in the Hackers Guide? ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox

Re: EDI, Hex VFP - Oh My...

2012-08-16 Thread Fred Taylor
Hex in VFP: constant number, just prefix with 0x : 0x5F (same as just 95) format number to string: TRANSFORM(95,@0) - 0x005F = 8digits after the 0x string to number: VAL(0x5F) or EVALUATE(0x5F) - 95 Fred On Thu, Aug 16, 2012 at 9:54 AM, Kurt Wendt kurtwe...@waitex.com wrote:

Re: Ed's leafe.com site error

2012-08-16 Thread Ed Leafe
On Aug 16, 2012, at 6:35 AM, Ed Leafe wrote: Tried to upload a file to the Leafe.com server for the other pProfoxers and every time I try it throws back n error: 400 Bad Request The server could not comply with the request since it is either malformed or otherwise incorrect. No file

RE: EDI, Hex VFP - Oh My...

2012-08-16 Thread Kurt Wendt
Matt - I tried to capture JUST that character - and then print it using your suggestion - but, it just didn't work. When I captured it - then tried to insert it between the Quotes as such: print ASC(put your char in here) It actually put Nothing between the quotes and return a value of

Re: just installed vfpro-9

2012-08-16 Thread Rafael Copquin
Read events is what you should use in your main program, right after the call to the menu do mymenu.mpr read events There is no need to use it anywhere else in your app. All forms called from the menu or from other forms will use this global read events call. When you are ready to leave the

Re: EDI, Hex VFP - Oh My...

2012-08-16 Thread kamcginnis
If this is for a ANSI 837 transaction set, for example: sending claims to Medicare: Element separator: 124 '|' Sub-element separator: 094 '^' Segment terminator 126 '~' Those are all ASCII, visible, printable codes so you should not have to use the hex value. - Original Message -

Re: Christof's XML Excel files creation article is AWESOME!

2012-08-16 Thread MB Software Solutions General Account
Angel, If you check out the link (http://www.foxpert.com/docs/excel.en.htm), you'll get the full description. It's logic to create Excel spreadsheets via the XML approach, which gets around the crap of dealing with XLS and XLSX differences. Cheers, --Mike On Thu, August 16, 2012 12:19 pm,

RE: Pop-up form not showing in front of Top Level form

2012-08-16 Thread MB Software Solutions General Account
On Thu, August 16, 2012 10:13 am, Kurt Wendt wrote: Hey Mike - maybe I'm missing something about what your actual problem is. But, as for some suggestions. How about the Always On Top property for the pop-up Form, is that Set to True? As for the 2nd Form being behind the main Form - you

RE: Pop-up form not showing in front of Top Level form

2012-08-16 Thread Kurt Wendt
Cool - I'm glad I got you on the right track!!! :-) -K- -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions General Account Sent: Thursday, August 16, 2012 2:08 PM On Thu, August 16, 2012 10:13 am, Kurt Wendt

RE: EDI, Hex VFP - Oh My...

2012-08-16 Thread Kurt Wendt
Honestly - I'm not sure why the character is Visible in the e-mail below, but, when I try to cutpaste it into VFP - its NOT Visible at all. Not sure about ANSI 837, but, I will assume its standard EDI - but, different from the type of stuff I deal with. Mine is for sales orders(850), Advance

Re: EDI, Hex VFP - Oh My...

2012-08-16 Thread M Jarvis
On Thu, Aug 16, 2012 at 11:34 AM, Kurt Wendt kurtwe...@waitex.com wrote: Actually - I find it VERY ODD that they are using this particular character - because, in other EDI files, its usually characters like you described below... if it's a mainframe you are talking to it doesn't really

Re: EDI, Hex VFP - Oh My...

2012-08-16 Thread Ted Roche
Most of the internet is speaking Unicode UTF-8 or -16 these days. ASCII is really only defined for the first 128 characters (7-bit) and the 'extended ASCII character set' from 128 to 255 is different from different vendors; IBM implemented the upper characters of foreign entities and line-and-box

Re: EDI, Hex VFP - Oh My...

2012-08-16 Thread M Jarvis
On Thu, Aug 16, 2012 at 11:48 AM, Ted Roche tedro...@gmail.com wrote: So, your vendor, in choosing an upper 8-bit character, is implementing a non-standard EDI format which I can't even type without lol. The nice thing about having very explicit STANDARDS is that there are so many to choose

RE: EDI, Hex VFP - Oh My...

2012-08-16 Thread Kurt Wendt
Matt - its SO TRUE - because, even though EDI is Supposed to be a Standard - all the Trading partners use or do it slightly differently - so we have to end up hard-coding all this Crap in our programs to make the EDI stuff work. Its NUTS! -K- -Original Message- From:

Re: EDI, Hex VFP - Oh My...

2012-08-16 Thread M Jarvis
On Thu, Aug 16, 2012 at 11:51 AM, Kurt Wendt kurtwe...@waitex.com wrote: Matt - its SO TRUE - because, even though EDI is Supposed to be a Standard - all the Trading partners use or do it slightly differently - so we have to end up hard-coding all this Crap in our programs to make the EDI

Re: Foxweb?

2012-08-16 Thread Mike Copeland
Sort of... I have a Windows XP machine that I abuse for such things. I installed Apache 2.2 on it. Then the latest Foxweb download. Also using VFP 9. The dbf files are on another machine (a Linux box running Samba) that is local to the WinXP box. That Linux box is also running MySQL, but

RE: EDI, Hex VFP - Oh My...

2012-08-16 Thread Kurt Wendt
Ted - thanks for that lengthy explanation - and for making me see the light as to why I can' see that character in VFP. And, Thanks ALSO for that humorous last line - as its always nice to get a chuckle here at work! Fred - I was also looking over your response - and in particular when you

RE: EDI, Hex VFP - Oh My...

2012-08-16 Thread Kurt Wendt
I hear ya. And, I know that Stephen has gotten on here and also ranted a bit about EDI. Yeah - not really fun stuff... -K- -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of M Jarvis Sent: Thursday, August 16, 2012 2:56 PM On Thu,

RE: EDI, Hex VFP - Oh My...

2012-08-16 Thread Richard Kaye
?INT(VAL(TRANSFORM(0x65))) :-) -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt Wendt Sent: Thursday, August 16, 2012 2:59 PM To: profoxt...@leafe.com Subject: RE: EDI, Hex VFP - Oh My... Then it dawned on me - and

Re: EDI, Hex VFP - Oh My...

2012-08-16 Thread kamcginnis
All Ansi formats that begin with ISA have the first record 106 characters in length. The separators are defined by the receiver so you (the submitter) must use those values or the receiver may refuse or be unable to read your transmissions. In that first record, you can look at positions 104,

Re: Foxweb?

2012-08-16 Thread Ted Roche
On Thu, Aug 16, 2012 at 2:59 PM, Mike Copeland m...@ggisoft.com wrote: My experience with PHP+DBF files is that PHP will open DBFs, but has absolutely no regard for file and/or record locking and I've heard rumors of index files getting out of whack if you use PHP to update DBF files. So,

Re: EDI, Hex VFP - Oh My...

2012-08-16 Thread Stephen Russell
On Thu, Aug 16, 2012 at 1:51 PM, Kurt Wendt kurtwe...@waitex.com wrote: Matt - its SO TRUE - because, even though EDI is Supposed to be a Standard - all the Trading partners use or do it slightly differently - so we have to end up hard-coding all this Crap in our programs to make the EDI stuff

Re: Foxweb?

2012-08-16 Thread Mike Copeland
Thanks Jeff! That's encouraging to hear. And, appreciate the things to watch out for. Mike Original Message Subject: Re: Foxweb? From: Jeff Johnson j...@san-dc.com To: profoxt...@leafe.com Date: 8/16/2012 9:25 AM I am familiar with a company (hosting) that has been using

Re: [NF] Wireless Router problem/life time

2012-08-16 Thread Mike Copeland
Am I sure? No. But with 150+ workstations to manage, I don't often have the luxury of proactive cleaning. It's all I can handle to keep people from installing programs they've downloaded... I just respond when someone does something stupid and clean up the mess. Most virus and trojan activity

Re: just installed vfpro-9

2012-08-16 Thread Dan Covill
On 08/16/12 09:37, Gary Jeurink wrote: Is the READ EVENTS CLEAR EVENTS mainly to compile to .exe? READ EVENTS and CLEAR EVENTS are mainly to start and stop non-modal windows. If you run from VFP you don't need them because you can just type QUIT in the command window. From an .exe

RE: Inno Setup help needed for Start group

2012-08-16 Thread Tracy Pearson
MB Software Solutions General Account wrote on 2012-08-16: WinXP I must be missing something but I don't have access to my other tried true scripts on my personal dev laptop. I'm using Inno Script Studio here at the day gig instead of ISTool like I do for MBSS stuff. Can you see

Re: Query taking 4 minutes...ugh

2012-08-16 Thread Bill Anderson
Store the AddBS() function and the cClaimsTable reference to variables, then use those variables in the SELECT statement. You're evaluating each expression with every row. Bill Anderson On Thursday, August 16, 2012, MB Software Solutions General Account wrote: VFP9SP2 - WinXP - dbfs on