Re: [NF] Wireless Router problem/life time
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 (dot) fm ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1345103699.32640.140661115518141.39014...@webmail.messagingengine.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Foxweb?
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 more about this; did you get Apache + PHP + ODBC working with VFP DBFs on a Windows platform? While it's not my first (nor likely second nor third) choice, I'd like to know pros and cons and what kind of experience you had. I've had a lot of experience with PHP, mostly as part of a LAMP stack, and ran into a few problems getting it working on Windows using SQL Server. -- Ted Roche Ted Roche Associates, LLC http://www.tedroche.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cacw6n4s8x8ncdcokuercl3mak3c+y8pycvsvg1h5q9vbmwm...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Ed's leafe.com site error
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 file specified Just thought I'd let you know. Thanks - I'll look into it and let you know what I find. -- Ed Leafe ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/8bd268f6-73eb-4538-84d7-e59bbd17d...@leafe.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: just installed vfpro-9
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 On Wed, Aug 15, 2012 at 4:29 PM, Gary Jeurink g.jeur...@charter.net wrote: So I will put READ EVENTS in the init method and then the CLEAR EVENTS in the quit form button. Right now I just have a main form that calls any forms that I need. I've never had any formal instruction other than books. Gary Jeurink Gary, I agree with Fred. Read the Main Files in Applications topic in the VFP 9 help. Follow it with How to: Control the Event Loop. You will want an ON ERROR statement to capture and handle errors. Tracy Pearson PowerChurch Software ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/000c01cd7bb1$dda99a00$98fcce00$@powerchurch.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: just installed vfpro-9
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 Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1345124495.11586.140661115628813.57f7f...@webmail.messagingengine.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Pop-up form not showing in front of Top Level form
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 form is always modeless, regardless of the WindowType property setting. ...so I can't seem to make it modal if I'm using 2. I tried 1 but that ran right by my .Show(1) code too. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/33c8b773c0acc50c6d9cc35eafa60dd2.squir...@webmail.dssco.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Pop-up form not showing in front of Top Level form
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 Pop-Up form ShowWindow property to 1-In Top-Level Form as Tracy suggested, since, in theory - I think that should do it... -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 10:00 AM 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 form is always modeless, regardless of the WindowType property setting. ...so I can't seem to make it modal if I'm using 2. I tried 1 but that ran right by my .Show(1) code too. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/289ea162f5642645b5cf64d624c66a140e260...@us-ny-mail-002.waitex.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Foxweb?
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 due to licensing / configuration. The other issue is index does not match database. which is due to the prg not working perfectly in a multi-user environment. They would occasionally get a foxweb.dll not found. In my opinion these would not be issues with one site running foxweb - which sounds like what you are trying to do. HTH Jeff --- Jeff Johnson j...@san-dc.com (623) 582-0323 www.san-dc.com On 08/15/2012 12:27 PM, Mike Copeland wrote: With full acknowledgement and due respect to Thierry and FoxInCloud... Does anyone have any experience using FoxWeb? I've been playing with FoxWeb the last couple of days and it fits my need very well...I'm just concerned whether there are any gotcha's or weak spots before moving ahead and putting it into service for 50+ users. I just need to search a large Fox table (300MB containing sales history info) via the Internet with respectable response time. Plus, this solution is only needed for about 6 months as all data is being moved to an SQL backend server. One area of concern I have is that FoxWeb seems to have had trouble in the past with going dark (my phrase) under heavy load where it just stops responding and has to be restarted. And yes, I'm aware of and have used West Wind and Foxisapi, too. My goal here is to patch in a quick fix for my remote search problem...that will be discarded by the end of the year. Any advice welcome. Mike Copeland [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/502d02ef.7010...@san-dc.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Query taking 4 minutes...ugh
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 minutes!). There's no WHERE clause so it's not optimizable. But is there a better way? My current plan now is to create logic that extracts the provnums into a separate table and just query that. That makes complete sense to me. (These tables are basically input files from a vendor, with the provnum built in and not sent in a separate lookup table.) Other ideas? tia, --Mike ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/03138d749b4ec6bc16dc9f751990dd7a.squir...@webmail.dssco.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Query taking 4 minutes...ugh
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 (at) fastmail (dot) fm ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1345127944.25832.140661115652869.44611...@webmail.messagingengine.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Query taking 4 minutes...ugh
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 Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1345127973.25910.140661115653565.2925a...@webmail.messagingengine.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Query taking 4 minutes...ugh
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 ; INTO CURSOR curTemp This query is taking forever (4 minutes!). There's no WHERE clause so it's not optimizable. But is there a better way? My current plan now is to create logic that extracts the provnums into a separate table and just query that. That makes complete sense to me. (These tables are basically input files from a vendor, with the provnum built in and not sent in a separate lookup table.) Other ideas? 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 seek(mytestvalue,'X2') * value is ok else * value not ok endif Peter Rajan Imports has changed - we are now Whispering Smith Ltd. For more information see our website at www.whisperingsmith.com Please update your address book with my new email address: pcush...@whisperingsmith.com . This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email. www.whisperingsmith.com Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715 London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/502d08e3.3000...@whisperingsmith.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Query taking 4 minutes...ugh
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: profoxt...@leafe.com Subject: Query taking 4 minutes...ugh 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 minutes!). There's no WHERE clause so it's not optimizable. But is there a better way? My current plan now is to create logic that extracts the provnums into a separate table and just query that. That makes complete sense to me. (These tables are basically input files from a vendor, with the provnum built in and not sent in a separate lookup table.) Other ideas? tia, --Mike ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/DF1EEF11E586A64FB54A97F22A8BD044216907E295@ACKBWDDQH1.artfact.local ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Query taking 4 minutes...ugh
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. Currently, there are 116 distinct provnums in Claims and 76 distinct provnums in Discharge. I'm going to program this so that when text file data is loaded into the tables, a distinct updated list is set into another separate lookup table in that folder. Then, my code will query that lookup table which--by definition of process--should contain all of the unique providers. I'll use candidate indexes to ensure no duplicates in my lookup free table. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/6a3104f26d08fe617806ee6cc2d7b0e6.squir...@webmail.dssco.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Query taking 4 minutes...ugh
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: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/12d807a2dc7e9c7fb6fc855cc48da5e1.squir...@webmail.dssco.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Query taking 4 minutes...ugh
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 seek(mytestvalue,'X2') * value is ok else * value not ok endif No, because I need these to populate a dropdown combobox for the user to select a provnum for querying. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/461710e3cb502f2cb10cf08f141b0a1b.squir...@webmail.dssco.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Query taking 4 minutes...ugh
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 list of provnums' is kept up to date on every import. Thanks guys! Sometimes it just takes talking it out to realize your own answer. --Mike ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/d7b15fd47aa4d464738298d3294f6e4e.squir...@webmail.dssco.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Query taking 4 minutes...ugh
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 information it contains is intended for the person or organisation to whom it is addressed. Its contents are confidential and may be protected in law. If you have received this e-mail in error you must not copy, distribute or take any action in reliance on it. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email. Flexipol Packaging Ltd. has taken every reasonable precaution to minimise the risk of virus transmission through email and therefore any files sent via e-mail will have been checked for known viruses. However, you are advised to run your own virus check before opening any attachments received as Flexipol Packaging Ltd will not in any event accept any liability whatsoever once an e-mail and/or any attachment is received. It is the responsibility of the recipient to ensure that they have adequate virus protection. Flexipol Packaging Ltd. Unit 14 Bentwood Road Carrs Industrial Estate Haslingden Rossendale Lancashire BB4 5HH Tel:01706-222792 Fax: 01706-224683 www.Flexipol.co.uk --- Terms Conditions: Notwithstanding delivery and the passing of risk in the goods, the property in the goods shall not pass to the buyer until the seller Flexipol Packaging Ltd. (The Company) has received in cash or cleared funds payment in full of the price of the goods and all other goods agreed to be sold by the seller to the buyer for which payment is then due. Until such time as the property in the goods passes to the buyer, the buyer shall hold the goods as the seller's fiduciary agent and bailee and keep the goods separate from those of the buyer and third parties and properly stored protected and insured and identified as the seller's property but shall be entitled to resell or use the goods in the ordinary course of its business. Until such time as the property in the goods passes to the buyer the seller shall be entitled at any time -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of MB Software Solutions General Account Sent: 16 August 2012 15:29 To: profox@leafe.com Subject: Query taking 4 minutes...ugh 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 minutes!). There's no WHERE clause so it's not optimizable. But is there a better way? My current plan now is to create logic that extracts the provnums into a separate table and just query that. That makes complete sense to me. (These tables are basically input files from a vendor, with the provnum built in and not sent in a separate lookup table.) Other ideas? tia, --Mike [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/bd031ecabf2b60499200aab3dbb4a999f125c...@ex-a-fpl.fpl.LOCAL ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: VFP9: Automating sending a file to an FTP site.
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 ProFox stuff Good grief Dave - think you can get a longer signature ?? g -- Matt Jarvis Eugene, Oregon USA ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAPT54raNgNyxvby-h_rJnGaoYnRDH=svr8ko+lgakukhbzx...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Christof's XML Excel files creation article is AWESOME!
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 AWESOME! Para: profox@leafe.com Fecha: miércoles, 15 de agosto, 2012 16:05 VFP9SP2 -- http://www.foxpert.com/docs/excel.en.htm Just finished implementing Christof Wollenhaupt's logic for creating Excel spreadsheets with data from my queries and I have to say...I love it so much that I'm thinking of retooling other things I did years ago to use this approach instead of the VFP report writer. Of course...this requires the user to have Microsoft Excel, but I think this is an attractive option for many. Thanks, Christof [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1345133991.66229.yahoomailclas...@web132504.mail.ird.yahoo.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: just installed vfpro-9
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. Is the READ EVENTS CLEAR EVENTS mainly to compile to .exe? Gary Jeurink -Original Message- From: Tracy Pearson [mailto:tr...@powerchurch.com] Sent: Thursday, August 16, 2012 8:20 AM To: profox@leafe.com Subject: RE: just installed vfpro-9 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 On Wed, Aug 15, 2012 at 4:29 PM, Gary Jeurink g.jeur...@charter.net wrote: So I will put READ EVENTS in the init method and then the CLEAR EVENTS in the quit form button. Right now I just have a main form that calls any forms that I need. I've never had any formal instruction other than books. Gary Jeurink Gary, I agree with Fred. Read the Main Files in Applications topic in the VFP 9 help. Follow it with How to: Control the Event Loop. You will want an ON ERROR statement to capture and handle errors. Tracy Pearson PowerChurch Software ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/BA3E01CD8BE0408BB165E3783122B09F@OwnerPC ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: just installed vfpro-9
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 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 Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/76DA3F087BCF44B09113EE9B205BA6E8@OwnerPC ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: just installed vfpro-9
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 OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/001401cd7bd0$ab097470$011c5d50$@johnweller.co.uk ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: EDI, Hex VFP - Oh My...
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: Hey folks, I'm a little stumped on something. Here at my day job, I have to deal with EDI stuff - and I do it all the time. But, a new upgrade for this one Trading Partner is requiring a strange code to be sent back - as displayed in the line below. Strangely enough, I was surprised to see the character appear below (after the to and before the or) - since, when I tried to insert this Text into VFP - just to print on-screen, the character shown below does not appear - but, instead a blank space appears in VFP. So - of course, I am having difficulty figuring how to send back this character. Here is the line of instructions on this particular EDI upgrade: oISA11 needs to be changed to ¬ or Hex 5F As such, I figured I would try to implement via the Hexcode. But, how exactly do I use HexCodes in VFP. I know the ASC() and CHR() commands, but, AFAIK - that's for purely Ascii code and NOT for Hex code. Any advice would be greatly appreciated! Thanks, -K- Senior Developer Waitex Information System, Inc. P Save a tree. Don't print this e-mail unless it's really necessary. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJCBksqAVAre009TY=e84n1psa2pqfwahxaqoq2bnax8enc...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Ed's leafe.com site error
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 specified Just thought I'd let you know. Thanks - I'll look into it and let you know what I find. OK, I think I've found the problem. Try again. -- Ed Leafe ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/c9141550-2a07-4699-9d1a-cd66378d7...@leafe.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: EDI, Hex VFP - Oh My...
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 Zero! AT this point - I'm going to try some of Fred's suggestions - after I get back from my lunch break... Thanks, -K- -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of M Jarvis Sent: Thursday, August 16, 2012 1:22 PM To: profoxt...@leafe.com Subject: Re: EDI, Hex VFP - Oh My... On Thu, Aug 16, 2012 at 9:54 AM, Kurt Wendt kurtwe...@waitex.com wrote: As such, I figured I would try to implement via the Hexcode. But, how exactly do I use HexCodes in VFP. I know the ASC() and CHR() commands, but, AFAIK - that's for purely Ascii code and NOT for Hex code. Copy the char to the clipboard. In VFP command window, type (good grief it's been a long time) print ASC(put your char in here) This will tell you the ascii code that makes the character. Let's just say its number 67. In your code, when you want to print the code to the file as text, use CHR(67) Does that answer your question? -- Matt Jarvis Eugene, Oregon USA [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/289ea162f5642645b5cf64d624c66a140e260...@us-ny-mail-002.waitex.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: just installed vfpro-9
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 app, you can use the API call in the following program to exit safely: PROCEDURE ENDAPP ** to ensure all open transactions are closed with no consequences (nothing is saved to the tables) if txnlevel() 0 ROLLBACK endif **to close all open tables and databases properly Close Tables all Close Databases ** to finally exit to Windows DECLARE ExitProcess IN kernel32 INTEGER uExitCode ExitProcess(0) ENDPROC Rafael Copquin El 16/08/2012 01:37 p.m., Gary Jeurink escribió: 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. Is the READ EVENTS CLEAR EVENTS mainly to compile to .exe? Gary Jeurink -Original Message- From: Tracy Pearson [mailto:tr...@powerchurch.com] Sent: Thursday, August 16, 2012 8:20 AM To: profox@leafe.com Subject: RE: just installed vfpro-9 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 On Wed, Aug 15, 2012 at 4:29 PM, Gary Jeurink g.jeur...@charter.net wrote: So I will put READ EVENTS in the init method and then the CLEAR EVENTS in the quit form button. Right now I just have a main form that calls any forms that I need. I've never had any formal instruction other than books. Gary Jeurink Gary, I agree with Fred. Read the Main Files in Applications topic in the VFP 9 help. Follow it with How to: Control the Event Loop. You will want an ON ERROR statement to capture and handle errors. Tracy Pearson PowerChurch Software [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/502d2ea0.8040...@fibertel.com.ar ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: EDI, Hex VFP - Oh My...
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 - From: Kurt Wendt kurtwe...@waitex.com To: profox@leafe.com Sent: Thursday, August 16, 2012 9:54 AM Subject: EDI, Hex VFP - Oh My... Hey folks, I'm a little stumped on something. Here at my day job, I have to deal with EDI stuff - and I do it all the time. But, a new upgrade for this one Trading Partner is requiring a strange code to be sent back - as displayed in the line below. Strangely enough, I was surprised to see the character appear below (after the to and before the or) - since, when I tried to insert this Text into VFP - just to print on-screen, the character shown below does not appear - but, instead a blank space appears in VFP. So - of course, I am having difficulty figuring how to send back this character. Here is the line of instructions on this particular EDI upgrade: oISA11 needs to be changed to ¬ or Hex 5F As such, I figured I would try to implement via the Hexcode. But, how exactly do I use HexCodes in VFP. I know the ASC() and CHR() commands, but, AFAIK - that's for purely Ascii code and NOT for Hex code. Any advice would be greatly appreciated! Thanks, -K- Senior Developer Waitex Information System, Inc. P Save a tree. Don't print this e-mail unless it's really necessary. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/163801cd7bd6$bb487c40$7a00a8c0@w2k3s02 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Christof's XML Excel files creation article is AWESOME!
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, Angel Dario Rodriguez wrote: 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 AWESOME! Para: profox@leafe.com Fecha: miércoles, 15 de agosto, 2012 16:05 VFP9SP2 -- http://www.foxpert.com/docs/excel.en.htm Just finished implementing Christof Wollenhaupt's logic for creating Excel spreadsheets with data from my queries and I have to say...I love it so much that I'm thinking of retooling other things I did years ago to use this approach instead of the VFP report writer. Of course...this requires the user to have Microsoft Excel, but I think this is an attractive option for many. Thanks, Christof [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/40f9b8242b25fb5b1710596766847d4b.squir...@webmail.dssco.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Pop-up form not showing in front of Top Level form
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 actually SEE that occurring? Also - did you try setting this Pop-Up form ShowWindow property to 1-In Top-Level Form as Tracy suggested, since, in theory - I think that should do it... Winner! Setting the frmMain to AlwaysOnBottom and frmFolders to AlwaysOnTop fixed it. frmFolders.ShowWindow = 1 too. Thanks! --Mike ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/60b05b90745f60efe18b38f680326932.squir...@webmail.dssco.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Pop-up form not showing in front of Top Level form
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 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 actually SEE that occurring? Also - did you try setting this Pop-Up form ShowWindow property to 1-In Top-Level Form as Tracy suggested, since, in theory - I think that should do it... Winner! Setting the frmMain to AlwaysOnBottom and frmFolders to AlwaysOnTop fixed it. frmFolders.ShowWindow = 1 too. Thanks! --Mike ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/289ea162f5642645b5cf64d624c66a140e260...@us-ny-mail-002.waitex.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: EDI, Hex VFP - Oh My...
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 Ship Notice/ASN(856) and Invoices (810). 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... -K- -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of kamcgin...@gmail.com Sent: Thursday, August 16, 2012 1:44 PM To: profoxt...@leafe.com Subject: Re: EDI, Hex VFP - Oh My... 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 - From: Kurt Wendt kurtwe...@waitex.com To: profox@leafe.com Sent: Thursday, August 16, 2012 9:54 AM Subject: EDI, Hex VFP - Oh My... Hey folks, I'm a little stumped on something. Here at my day job, I have to deal with EDI stuff - and I do it all the time. But, a new upgrade for this one Trading Partner is requiring a strange code to be sent back - as displayed in the line below. Strangely enough, I was surprised to see the character appear below (after the to and before the or) - since, when I tried to insert this Text into VFP - just to print on-screen, the character shown below does not appear - but, instead a blank space appears in VFP. So - of course, I am having difficulty figuring how to send back this character. Here is the line of instructions on this particular EDI upgrade: oISA11 needs to be changed to ¬ or Hex 5F As such, I figured I would try to implement via the Hexcode. But, how exactly do I use HexCodes in VFP. I know the ASC() and CHR() commands, but, AFAIK - that's for purely Ascii code and NOT for Hex code. Any advice would be greatly appreciated! Thanks, -K- Senior Developer Waitex Information System, Inc. P Save a tree. Don't print this e-mail unless it's really necessary. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/289ea162f5642645b5cf64d624c66a140e260...@us-ny-mail-002.waitex.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: EDI, Hex VFP - Oh My...
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 surprise me... ours kicks out some *really* odd choices for column separators sometimes... -- Matt Jarvis Eugene, Oregon USA ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/capt54ryikx2fna76qzmkbdt0s0gmieqk1tvjzz06z3-kves...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: EDI, Hex VFP - Oh My...
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 characters one way, Microsoft another, and so forth. Microsoft uses an ANSI character set. DOS implemented code pages as a kludge. Try some of those characters in FoxFont and in Arial and you'll see the difference. So, that's the long way of saying that the reason you can't cut and paste from email (ANSI or Unicode) into VFP is that the two are speaking incompatible dialects. 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. On Thu, Aug 16, 2012 at 2:34 PM, Kurt Wendt kurtwe...@waitex.com wrote: 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 Ship Notice/ASN(856) and Invoices (810). 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... -K- -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of kamcgin...@gmail.com Sent: Thursday, August 16, 2012 1:44 PM To: profoxt...@leafe.com Subject: Re: EDI, Hex VFP - Oh My... 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 - From: Kurt Wendt kurtwe...@waitex.com To: profox@leafe.com Sent: Thursday, August 16, 2012 9:54 AM Subject: EDI, Hex VFP - Oh My... Hey folks, I'm a little stumped on something. Here at my day job, I have to deal with EDI stuff - and I do it all the time. But, a new upgrade for this one Trading Partner is requiring a strange code to be sent back - as displayed in the line below. Strangely enough, I was surprised to see the character appear below (after the to and before the or) - since, when I tried to insert this Text into VFP - just to print on-screen, the character shown below does not appear - but, instead a blank space appears in VFP. So - of course, I am having difficulty figuring how to send back this character. Here is the line of instructions on this particular EDI upgrade: oISA11 needs to be changed to ¬ or Hex 5F As such, I figured I would try to implement via the Hexcode. But, how exactly do I use HexCodes in VFP. I know the ASC() and CHR() commands, but, AFAIK - that's for purely Ascii code and NOT for Hex code. Any advice would be greatly appreciated! Thanks, -K- Senior Developer Waitex Information System, Inc. P Save a tree. Don't print this e-mail unless it's really necessary. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CACW6n4ukoLYcC0G8GQqZ1RkeAo=rnhf+gvba2pvn6+dc5-k...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: EDI, Hex VFP - Oh My...
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 from g -- Matt Jarvis Eugene, Oregon USA ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAPT54rbJgrNW-9mY_SazoLKOXg7ojUUQ+bnDkjC81=rg+gg...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: EDI, Hex VFP - Oh My...
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: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of M Jarvis Sent: Thursday, August 16, 2012 2:53 PM To: profoxt...@leafe.com Subject: Re: EDI, Hex VFP - Oh My... 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 from g -- Matt Jarvis Eugene, Oregon USA ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/289ea162f5642645b5cf64d624c66a140e260...@us-ny-mail-002.waitex.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: EDI, Hex VFP - Oh My...
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 stuff work. Its NUTS! dood - that's why everyone hates EDI in the first place and like Ted mentioned, your vendors implementation is just plain stoopid -- Matt Jarvis Eugene, Oregon USA ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/capt54ry0rxr4dmqo+oeeaddhpz8obk1pags8baajovlg-vj...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Foxweb?
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 that's not part of the pie in this situation. While I have used PHP a lot with web pages (on standard websites), I'm not using PHP with this FoxWeb situation. 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, I've never put any code into use that accessed DBFs from PHP code. Not even just reading a DBF. I played briefly with PHP on a Windows box and it worked, but I doubt I spent more than 15 minutes with it as I prefer to test it on the LAMP box it will be used on. For FoxWeb, I'm testing with the above WinXP machine responding to a VFP9 app on my Win7 Pro development system. I have a table of sales records that has 500,000+ records and the response times are outstanding. For example, I searched for all records containing a serial number containing 123 (serial numbers are text strings, alpha+numeric, from 5 to 20 length, not unique.) I got back a response string containing three fields (6 digit document number, 8 digit customer number, serial number) for 15,000 records in about 5 seconds. I don't think I'm using any ODBC (except for the connection to the MySQL server from VFP9). The FoxWeb connection to the Apache server uses CGI and was drop-dead easy to set up. The FoxWeb documentation requires careful reading (and re-reading), and I had to search for some errors on their support Forum, but once I grokked the configuration concept FoxWeb uses, it began working like a charm. For example, FoxWeb defaults to specifying a script folder where FoxWeb will look for scripts over in the Windows User area. But Apache prefers (and the FoxWeb docs point out) that all CGI files are in a sub folder below the folder Apache manages for all websites. But, after you get FoxWeb set to find the scripts where it should, all is well. One nice part of using FoxWeb is that they provide an Error Log panel with lots of very helpful logging info. Probably the toughest part of using Fox with a web server is that if you don't get the response you expect, your debugging tools are pretty limited. My comment about FoxWeb use reminding me of PHP+HTML is that the FoxWeb code (VFP code) is inserted in what is essentially an HTML file (with FWX extension) using delimeters of % foxcode here %. In between those delimeters, any Foxcode goes...even comments using * and . The one gotcha I think I've discovered is that you have to use to set off strings, not ', and FoxWeb seems to prefer nice spaces. nVar-nVar2=nVar3 may not produce what you want...but nVar - nVar2 = nVar3 will probably work. Unfortunately, due to years of habit, I write code with no extra spaces. Of course, this is all being done on a local area network (1GB), so it won't be as snappy on the Internet. But the same routine with a fat client (VFP9) accessing the same tables over the Internet (no FoxWeb) took 10 minutes, with Windows 7 complaining that the application had stopped responding (screen turned milky white). Not surprising with the amount of bits that had to be sucked down the pipe! The only time I've found using DBFs across the Internet acceptable is when the files are kept very small...like below 4k. But the best part of FoxWeb for me so far is that with probably 3 or 4 hours invested from the moment I hit their web page for the first time, I've removed a huge obstacle for my app, even if the solution is only used for a few months. Hope this helps. Mike Original Message Subject: Re: Foxweb? From: Ted Roche tedro...@gmail.com To: profoxt...@leafe.com Date: 8/16/2012 6:28 AM 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 more about this; did you get Apache + PHP + ODBC working with VFP DBFs on a Windows platform? While it's not my first (nor likely second nor third) choice, I'd like to know pros and cons and what kind of experience you had. I've had a lot of experience with PHP, mostly as part of a LAMP stack, and ran into a few problems getting it working on Windows using SQL Server. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message:
RE: EDI, Hex VFP - Oh My...
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 wrote: string to number: VAL(0x5F) or EVALUATE(0x5F) - 95 Then it dawned on me - and somebody should have smacked me in the head on that one. Since, they gave me a Hex number, I should simply have converted it into a Decimal number - and any programmer with even a Half a Brain should know how to convert it - and then use that decimal number with the CHR() function to give me what I needed. Of course, your command to convert the Hex # into a Dec. # also does the job. Although, it should be more fun to actually convert the number on my own. Actually - about 1.5 years ago, when my son was 9 - one evening I started telling him about Binary and Hexadecimal number systems, and showing him how to convert numbers between Hex Dec, or Bin Dec - and then even showed him how to do Hex or Bin Math Addition. He loved it - and for days after - would beg me to give him math problems based upon Hex or Bin! OK - back to work for me... Thank you ALL for your input - as usual - the ProFox list ROCKS!!! -K- -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche Sent: Thursday, August 16, 2012 2:49 PM To: profoxt...@leafe.com Subject: Re: EDI, Hex VFP - Oh My... 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 characters one way, Microsoft another, and so forth. Microsoft uses an ANSI character set. DOS implemented code pages as a kludge. Try some of those characters in FoxFont and in Arial and you'll see the difference. So, that's the long way of saying that the reason you can't cut and paste from email (ANSI or Unicode) into VFP is that the two are speaking incompatible dialects. 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. On Thu, Aug 16, 2012 at 2:34 PM, Kurt Wendt kurtwe...@waitex.com wrote: 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 Ship Notice/ASN(856) and Invoices (810). 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... -K- -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of kamcgin...@gmail.com Sent: Thursday, August 16, 2012 1:44 PM To: profoxt...@leafe.com Subject: Re: EDI, Hex VFP - Oh My... 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 - From: Kurt Wendt kurtwe...@waitex.com To: profox@leafe.com Sent: Thursday, August 16, 2012 9:54 AM Subject: EDI, Hex VFP - Oh My... Hey folks, I'm a little stumped on something. Here at my day job, I have to deal with EDI stuff - and I do it all the time. But, a new upgrade for this one Trading Partner is requiring a strange code to be sent back - as displayed in the line below. Strangely enough, I was surprised to see the character appear below (after the to and before the or) - since, when I tried to insert this Text into VFP - just to print on-screen, the character shown below does not appear - but, instead a blank space appears in VFP. So - of course, I am having difficulty figuring how to send back this character. Here is the line of instructions on this particular EDI upgrade: oISA11 needs to be changed to ¬ or Hex 5F As such, I figured I would try to implement via the Hexcode. But, how exactly do I use HexCodes in VFP. I know the ASC() and CHR() commands, but, AFAIK - that's for purely Ascii code and NOT for Hex code. Any advice would be greatly appreciated! Thanks, -K- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message:
RE: EDI, Hex VFP - Oh My...
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, 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 stuff work. Its NUTS! dood - that's why everyone hates EDI in the first place and like Ted mentioned, your vendors implementation is just plain stoopid -- Matt Jarvis ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/289ea162f5642645b5cf64d624c66a140e260...@us-ny-mail-002.waitex.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: EDI, Hex VFP - Oh My...
?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 somebody should have smacked me in the head on that one. Since, they gave me a Hex number, I should simply have converted it into a Decimal number - and any programmer with even a Half a Brain should know how to convert it - and then use that decimal number with the CHR() function to give me what I needed. Of course, your command to convert the Hex # into a Dec. # also does the job. Although, it should be more fun to actually convert the number on my own. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/DF1EEF11E586A64FB54A97F22A8BD044216907E327@ACKBWDDQH1.artfact.local ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: EDI, Hex VFP - Oh My...
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, 105, 106 to get the separators that are used (if you have a sample transmission that you know the receiver accepted.) position 104 = Element separator position 105 = Sub-element separator position 106 = Segment terminator This is easy to remember because the segment terminator terminates the 1st record. All other records are variable length. Warning: I have seen documents that use control codes like CR and LF and others so your document might not be easy to read. HIPAA is supposed to make all healthcare claims standardized so you won't see control codes anymore. The record (segment) that begins with ST tells you the name of the transaction set: ST|837 is a provider healthcare claim sent to a payer. - Original Message - From: Kurt Wendt kurtwe...@waitex.com To: profox@leafe.com Sent: Thursday, August 16, 2012 11:34 AM Subject: RE: EDI, Hex VFP - Oh My... 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 Ship Notice/ASN(856) and Invoices (810). 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... -K- -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of kamcgin...@gmail.com Sent: Thursday, August 16, 2012 1:44 PM To: profoxt...@leafe.com Subject: Re: EDI, Hex VFP - Oh My... 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 - From: Kurt Wendt kurtwe...@waitex.com To: profox@leafe.com Sent: Thursday, August 16, 2012 9:54 AM Subject: EDI, Hex VFP - Oh My... Hey folks, I'm a little stumped on something. Here at my day job, I have to deal with EDI stuff - and I do it all the time. But, a new upgrade for this one Trading Partner is requiring a strange code to be sent back - as displayed in the line below. Strangely enough, I was surprised to see the character appear below (after the to and before the or) - since, when I tried to insert this Text into VFP - just to print on-screen, the character shown below does not appear - but, instead a blank space appears in VFP. So - of course, I am having difficulty figuring how to send back this character. Here is the line of instructions on this particular EDI upgrade: oISA11 needs to be changed to ¬ or Hex 5F As such, I figured I would try to implement via the Hexcode. But, how exactly do I use HexCodes in VFP. I know the ASC() and CHR() commands, but, AFAIK - that's for purely Ascii code and NOT for Hex code. Any advice would be greatly appreciated! Thanks, -K- Senior Developer Waitex Information System, Inc. P Save a tree. Don't print this e-mail unless it's really necessary. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/165e01cd7be4$06e037d0$7a00a8c0@w2k3s02 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Foxweb?
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, I've never put any code into use that accessed DBFs from PHP code. Not even just reading a DBF. Yeah, okay. There are several libraries around for PHP that support 'DBF' access, but understand DBF is even less of a standard that EDI - it is just the three letter suffix used to end the name of an ISAM file produced from xBASE, dBASE, Recital, Excel, askSam and a whole bunch of other incompatible applications. You really want to avoid PHP libraries that claim to read DBF. OTOH, PHP on Apache on Windows does a decent job with ODBC and I've worked on a couple of projects that used that. You MUST run on Windows, since you are using the Microsoft-proprietary VFP drivers (essentially, the VFP runtimes with ODBC APIs) to access the Fox tables. And since MS dumped support for VFP ODBC around version 6, you'll find insufficient support for many of the newer features of VFP. (BTW, in case anyone has their VFP chip on their shoulder, I have to say that the PHP story on Windows isn't much better with other databases, like SQL Server. I have war stories.) -- Ted Roche Ted Roche Associates, LLC http://www.tedroche.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cacw6n4tzmokrkwhecdxa36o_koc7vsbb3wsk1ad5kzjc+jn...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: EDI, Hex VFP - Oh My...
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 work. Its NUTS! -- 4010 and 5010. Yeah I wear the EDI hard hat here as well. Putting in that separator is pretty easy. I just make the asci character and put it into the string I am building. When I read it in it looks like this: Select Case rootElements(0) Case ISA cMessage.ISA.ISA01 = rootElements(1) cMessage.ISA.ISA02 = rootElements(2) cMessage.ISA.ISA03 = rootElements(3) cMessage.ISA.ISA04 = rootElements(4) cMessage.ISA.ISA05 = rootElements(5) cMessage.ISA.ISA06 = rootElements(6) cMessage.ISA.ISA07 = rootElements(7) cMessage.ISA.ISA08 = rootElements(8) cMessage.ISA.ISA09 = rootElements(9) cMessage.ISA.ISA10 = rootElements(10) cMessage.ISA.ISA11 = rootElements(11) cMessage.ISA.ISA12 = rootElements(12) cMessage.ISA.ISA13 = rootElements(13) cMessage.ISA.ISA14 = rootElements(14) cMessage.ISA.ISA15 = rootElements(15) cMessage.ISA.ISA16 = rootElements(16) Writing it out I have it mapped via data to fit the partner. ISA08 = TP.ReceiverID ISA09 = NumericDate -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJidMYJvc2=4KHVfcoxdzzqM7HMweanZJ8zRXnsKeH=igtm...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Foxweb?
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 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 due to licensing / configuration. The other issue is index does not match database. which is due to the prg not working perfectly in a multi-user environment. They would occasionally get a foxweb.dll not found. In my opinion these would not be issues with one site running foxweb - which sounds like what you are trying to do. HTH Jeff --- Jeff Johnson j...@san-dc.com (623) 582-0323 www.san-dc.com On 08/15/2012 12:27 PM, Mike Copeland wrote: With full acknowledgement and due respect to Thierry and FoxInCloud... Does anyone have any experience using FoxWeb? I've been playing with FoxWeb the last couple of days and it fits my need very well...I'm just concerned whether there are any gotcha's or weak spots before moving ahead and putting it into service for 50+ users. I just need to search a large Fox table (300MB containing sales history info) via the Internet with respectable response time. Plus, this solution is only needed for about 6 months as all data is being moved to an SQL backend server. One area of concern I have is that FoxWeb seems to have had trouble in the past with going dark (my phrase) under heavy load where it just stops responding and has to be restarted. And yes, I'm aware of and have used West Wind and Foxisapi, too. My goal here is to patch in a quick fix for my remote search problem...that will be discarded by the end of the year. Any advice welcome. Mike Copeland [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/502d5934.8060...@ggisoft.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Wireless Router problem/life time
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 is pretty hard to miss...the guys who write the good stuff (that's hard to detect) are usually after bigger fish (DOD, IRS, USA GOV) than consumer desktops. I've also found that using OpenDNS helps a lot by preventing people from wandering (trying to give them the benefit of the doubt) into websites that they shouldn't be on. Which brings me to the most important point about virus' and trojans and things that go bump in the night...end user education and people action management are the best and most important part of virus avoidance. Get a PDF attachment from someone you don't know with a vague message about opening the attachment as soon as possible? Delete it. No, it doesn't matter who sent it or why. Just delete it! NO, we don't need to make sure it wasn't sent by someone who we DO know but is stupid. Just delete it. The same for IRS emails, and emails claiming to need you to verify your email account is valid...DELETE KEY IS YOUR BEST FRIEND! Sorry, got on a rant. Mike Original Message Subject: Re: [NF] Wireless Router problem/life time From: Nicholas Geti ng...@optonline.net To: profoxt...@leafe.com Date: 8/15/2012 8:25 PM Yes. I rechecked my references. It was Defender and I assumed that MS Security stuff was a post successor to it. If it was a complete rewrite then I have to back off my comments. The Avast prompts don't require acknowledgement. I just tell my customers that they will come up every time the PC boots and often during the day. The advantage being Avast is updating their library of viruses every day. MS and Norton do it only on a weekly or monthly basis. I have never got the special announcement until the license has run out. As I said before I have put Avast on over 400 PCs and the only confusion is when they don't read the renewal menu and have to call me about problems updating the license. Only a dozen or so people had this problem. Are you sure that no virii have gotten by MS Security? It would be interesting to run Malwarebytes and Spybot once in a while to double check. - Original Message - From: Mike Copeland m...@ggisoft.com To: profox@leafe.com Sent: Wednesday, August 15, 2012 3:40 PM Subject: Re: [NF] Wireless Router problem/life time Got tired of the constant prompts to upgrade and update. Seems like nothing can happen in Avast without end user's involvement. I don't want the end user updating anything. I don't want to be notified that Avast Upgrades are now on special! All that does is cause my end users to contact me wanting to know what to do. All I want my AV solution to do is a) block viri b) update itself without being told to c) keep off the screen Avast was pretty good with a, not at all with b, and terrible with calthough your mileage may vary. And yes, I even bought 10 Avast licenses for one client and they still had pop ups on the screen down by the system tray. I am s tired of answering What was that blue box there for down by the clock this morning when I turned on my monitor? MSE, is excellent on all three points...it JUST WORKS and I don't have to deal with it. I think you might be thinking about the Microsoft Defender which was installed by default since XP (I think). MSE automatically disables Defender when MSE is installed. Defender reminded me of a half-blind 2-legged dog... Mike Copeland Original Message Subject: Re: [NF] Wireless Router problem/life time From: Nicholas Geti ng...@optonline.net To: profoxt...@leafe.com Date: 8/15/2012 2:02 PM Why? - Original Message - From: Mike Copeland m...@ggisoft.com To: profox@leafe.com Sent: Wednesday, August 15, 2012 1:51 PM Subject: Re: [NF] Wireless Router problem/life time +1 In fact, I've been removing Avast from every workstation I manage. Mike Original Message Subject: Re: [NF] Wireless Router problem/life time From: Allen pro...@gatwicksoftware.com To: profoxt...@leafe.com Date: 8/15/2012 5:32 AM A me too here Al -Original Message- You surprise me. All the feedback I have had says that it as good as any other. I use it in conjunction with Spybot SD and have never had any trouble (touch wood :-) ). [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/502d5bd8.3070...@ggisoft.com ** All postings, unless explicitly stated
Re: just installed vfpro-9
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 there's no command window you need them. If your windows are all modal (most of mine are) then you don't need them either, because you exit from the window by Release()ing it. Yes, you usually find out you need them when you compile the .exe, but they're really needed because of the non-modal form, not because of the .exe. Dan Covill ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/502d5d58.5050...@san.rr.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Inno Setup help needed for Start group
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 what I'm missing to make the it appear in the Start/All Programs section? Here's my script: Mike, In the [Icons] section, you need to also put an icon in the {group}. Name: {group}\Hospital Import and Reporting Tool; Filename: {app}\hospital_import.exe; WorkingDir: {app}; Flags: runmaximized; IconFilename: {app}\hospital_import.exe Tracy Pearson PowerChurch Software ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/001d01cd7bf3$9d3889d0$d7a99d70$@powerchurch.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Query taking 4 minutes...ugh
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 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 minutes!). There's no WHERE clause so it's not optimizable. But is there a better way? My current plan now is to create logic that extracts the provnums into a separate table and just query that. That makes complete sense to me. (These tables are basically input files from a vendor, with the provnum built in and not sent in a separate lookup table.) Other ideas? tia, --Mike [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/ca+o1engwqnoi80ohupv1n27zwvqww4uelco6i74hqtkb_fw...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.