[NF] Converting a MOV file

2008-10-02 Thread Garry Bettle
Media Converter Rocks!: http://www.mediaconverter.org/ G. On Wed, 1 Oct 2008 15:54:01 -0400, "Cathy Pountney" wrote: > I have a small clip taken with a digital camera and the extension is MOV. I > want to convert it to AVI or something better suited so I can edit it, make > it shorter, and post

Re: [NF] Secure SMTP with BLAT---that's not possible, is it?

2008-10-03 Thread Garry Bettle
On Thu, Oct 2, 2008 at 15:03:07 -0400 (EDT), "MB Software Solutions General Account" wrote: > > Jack Skelley wrote: >> Paul: >> Port 25 is the setting. >> No SSL. >> Authentication is required on Exchange. >> When I asked the question to the consultants as to why can't I use > Thunderbird the respo

Re: [NF] Secure SMTP with BLAT---that's not possible, is it?

2008-10-04 Thread Garry Bettle
On Fri, Oct 3, 2008 at 21:13:08 +1300, "Sytze de Boer" wrote: > > Whenever my client has an error in their system, or whenever they apply an > update of my system, it automatically emails me. > > I wanted to use Blat, but stopped using that since it requires yet more 3rd > party software like stunn

Re: Foxpro based scheduling application

2008-10-17 Thread Garry Bettle
On Fri, Oct 17, 2008 at 10:58, "Stephen Weeks" wrote: > That upload was a while ago, I have a more up to date version and will > gladly send you the source code. > > Regards > Steve Hi Steve, Hope this email finds you and the rest of the ProFoxers well - roll on the weekend. I'd love to this too

How to refresh the Desktop

2008-10-27 Thread Garry Bettle
Howdy all, Hope everyone had a good weekend. Does anyone know how to refresh a users desktop? This would be identical to pressing F5 when the desktop has focus. What I'm looking for is a winscript or api call to do the same within my VFP program. Many thanks! Cheers, Garry

Re: How to refresh the Desktop

2008-10-28 Thread Garry Bettle
On Tue, Oct 28, 2008 at 14:24, Fr?d?ric Steczycki wrote: > > >From my poor memory : > > DECLARE INTEGER InvalidateRect IN WIN32API INTEGER hwnd, INTEGER, INTEGER > DECLARE INTEGER UpdateWindow IN WINAPI32 INTEGER hwnd > > InvalidateRect(0,0,1) > UpdateWindow(0) > > Fred Thanks Fred. I'll give tha

Re: [OT] How to refresh the Desktop

2008-10-28 Thread Garry Bettle
On Tue, Oct 28, 2008 at 20:36, Michael Madigan wrote: > How do you refresh the desktop? > > Bring it a nice tall glass of Iced Tea. Indeed. LOL! Cheers, G. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/li

VFP 9 is starting off screen

2008-11-04 Thread Garry Bettle
Howdy, Hope this email finds you all well. When I start VFP - 9.0 SP1 - it starts minimized. If I right-click and select, "Restore" nothing happens. I have to select, "Maximize" to get VFP to show. "Move" or "Size" don't work either. Is there a command to recover the screen? Cheers, Garry

RE: VFPCompression.fll

2008-11-21 Thread Garry Bettle
On 2008-11-21, "John Weller" wrote: > Thanks - I knew it was something along those lines but couldn't put the > words to the initials! > > John Weller How about PICNIC? G. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leaf

Re: VFP9 - CSV files

2008-11-27 Thread Garry Bettle
Thu, 27 Nov 2008 21:23:56 +1300, Sytze de Boer wrote: > > Hi Folk > Once again, I am indebted to Profox and all you folk who try to help me > Hopefully, on elast question. > > How do you detect the presence of a carriage return and line feed, and > how do you strip out. > I think a carrigae return

Re: VFP and Least Squared Regression

2011-12-05 Thread Garry Bettle
On Tue, Nov 29, 2011 at 10:01 PM, G?rard Lochon wrote: > > > > > Anyone know of a VFP friendly Least Square Regression Routine?  Free is > > > good. > > > Sorry for the delay: LPARAMETERS tcTerms lnLinest = 0 lnTotTerms = GETWORDCOUNT( tcTerms, [,]) IF lnTotTerms < 3 RETURN lnLinest EN

Re: [NF] Net TV

2008-06-13 Thread Garry Bettle
On Fri, Jun 13, 2008 at 2:13 AM, Ricardo Araoz wrote: > I want to buy one of those "things you plug into the motherboard" (sorry > don't know the word in english) for watching TV, but I would also like > to access the TV from other stations in my local web. Is that possible? How? > > Cheers. Hi R

RE: [NF] Still want to use AVG ?

2008-07-04 Thread Garry Bettle
On Fri, Jul 4, 2008 at 9:36 AM, "Dave Crozier" wrote: > > Michael, > It isn't just the links in a Google search it is all the links on a page. I > turned it off completely and it now works much better. Unfortunately, > because you have this feature disabled you get the AVG status icon showing > an

Re: [OT] LHC opens BLACK HOLE

2008-09-14 Thread Garry Bettle
On Fri, Sep 12, 2008 at 12:46 PM, "Graham Brown" wrote: > > My daughter's school made an announcement on Tuesday to the pupils to > say they were all going to die when this experiment started at 8:30am UK > time > > She came home from school in floods of tears. > > Hows that for irresponsible. >

Re: SMS / Email / Desktop Alerts

2010-03-03 Thread Garry Bettle
On Tue, 02 Mar 2010 11:36:15 +, "Alan Bourke" wrote: > > Does anyone know any general-purpose solutions that could connect to VFP > or SQL Server data via OLEDB or whatever, and produce alerts based on > certain criteria that could be sent to recipients via SMS/Email/Desktop > pop-ups? > > TIA

Combobox question ...

2010-03-05 Thread Garry Bettle
Howdy all, Hope this finds everyone well - roll on the weekend. I'm trying to have a combo box with 2 columns, one hidden ( it's the key I want returned) and the other shown. The hidden key column would be something like: /horse-racing/2010-03-05/lingfield park/13-20/betting/ The shown column

Re: Combobox question ...

2010-03-05 Thread Garry Bettle
On Fri, Mar 5, 2010 at 16:14, Ken Kixmoeller f/h wrote: >> A sorted list would be something like: >> >> 2010-03-05 13:20 Lingfield Park >> 2010-03-05 13:50 Lingfield Park >> 2010-03-05 14:00 Doncaster >> 2010-03-05 14:10 Newbury >> 2010-03-05 14:25 Lingfield Park >> 2010-03-05 14:35 Doncaster >> et

Re: Combobox question ...

2010-03-05 Thread Garry Bettle
On Fri, Mar 5, 2010 at 16:14, Jack Skelley wrote: > Garry: > What is the controlsource of the combobox? If it is an sql select order by > the item you wish there. > If you build the combobox with an array use asort(). If you popular with a > table create an index on the field you wish. > In a sta

Missing Tooltips

2010-03-11 Thread Garry Bettle
Howdy all, Roll on the weekend. Hope this message finds everyone well. I have a form that I've set ShowTips = .T. but none of my Tooltips are showing. Theses I've setup on a grid such as: thisform.grdSelections.Columns( 8).Header1.ToolTiptext = [Average Odds] I thought ShowTips was Form level

Re: Need to replace word in sentence with *

2010-04-29 Thread Garry Bettle
What about this?: strtran( [ ] + alltirm( lcLine) + [ ], [ SES ], [*]) G. ___ 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/profoxte

Re: [NF] PyCon videos available online

2012-03-12 Thread Garry Bettle
On Sat, 10 Mar 2012 14:56:51 -0800, Ed Leafe wrote: > Subject: [NF] PyCon videos available online > Message-ID: > Content-Type: text/plain; charset=us-ascii > >http://pyvideo.org/category/17/pycon-us-2012 > >The videos there are just a start, as we're only halfway through > the c

List files in a Zip with vfpcompression.fll

2012-04-08 Thread Garry Bettle
Howdy all, Hope everyone is having a great Easter long weekend. I've got the following code to list a zip file's contents. It use Craig Boyd's wonderful vfpcompression.fll I thought the following code would be fine to just list files in a zip: * from http://www.sweetpotatosoftware.com/SPSBlog/

Re: Sending/Receiving email from an imap account

2012-04-08 Thread Garry Bettle
On Sun, 08 Apr 2012 08:41:00 -0400, Michael Savage wrote > > Has anybody done this? > > Can it be done? > > Any tips on how? > Mike > > Happy Easter Mike, Have you tried CDO? i.e. * http://fox.wikis.com/wc.dll?Wiki~CdoEmail * * http://www.portalfox.com/article.php?sid=2413 TRY LOCAL lcSchema,

Re: List files in a Zip with vfpcompression.fll

2012-04-10 Thread Garry Bettle
On 8 April 2012 19:04, Garry Bettle wrote: > Howdy all, > > Hope everyone is having a great Easter long weekend. > > I've got the following code to list a zip file's contents. > > It use Craig Boyd's wonderful vfpcompression.fll > > I thought the follo

RE: List files in a Zip with vfpcompression.fll (Dave Crozier)

2012-04-10 Thread Garry Bettle
On Tue, 10 Apr 2012 15:38:45 + Dave Crozier wrote: > > Gary, > I've just tried the "shell.application" out on a zip file with 3000 files > in at 600Mb and the speed is virtually instant. What speeds are you > experiencing? > > Dave > > Hi Dave, Hope you had a great Easter long weekend. My Zi

Re: List files in a Zip with vfpcompression.fll

2012-04-10 Thread Garry Bettle
On Tue, 10 Apr 2012 10:15:22 -0400, Ted Roche wrote: > I think you are on the right trac: byIndex counts from the first file, > all the way through to the end. It's the wrong function to be calling. > Looking through the page you referred to, it appears you can step > through the zip file by file

Re: ProFox Digest, Vol 108, Issue 46

2012-04-11 Thread Garry Bettle
On 11 April 2012 02:59, wrote: > Message: 2 > Date: Tue, 10 Apr 2012 17:26:54 -0400 > From: "Tracy Pearson" > > Garry, > > Is that code missing the first file in the Zip? > > Tracy Pearson > PowerChurch Software > > Doh! You're correct Tracy. Many thanks! Tested with a zip file with 0, 1 and n

RE: List files in a Zip with vfpcompression.fll

2012-04-11 Thread Garry Bettle
On 11 April 2012 02:59, wrote: > Message: 3 > Date: Tue, 10 Apr 2012 16:30:59 -0500 > From: "Jerry Foote" > > Hi guys is does the tool vfpcompression.fll unzip any zip. > Thanks Jerry > > Hi Jerry, I don't know. It's free, so download it and have a go. Cheers, Garry --- StripMime Report --

RE: List files in a Zip with vfpcompression.fll (Tracy Pearson)

2012-04-11 Thread Garry Bettle
Grrr ... and now with added Subject line! G. -- Forwarded message -- From: Garry Bettle Date: 11 April 2012 16:22 Subject: Re: ProFox Digest, Vol 108, Issue 46 To: profox@leafe.com On 11 April 2012 02:59, wrote: > Message: 2 > Date: Tue, 10 Apr 2012 17:26:54 -0400

Re: Why is the Application Data folder not visible in the My Documents folder?

2009-08-27 Thread Garry Bettle
On Thu, Aug 27, 2009 at 09:12:39 -0700, Paul McNett wrote: > I'm going to look into converting this code into Python, and doing it for all > 3 > platforms I support (Win, Mac, and Linux). Hi Paul, Care to share that python code when completed? Cheers, G. _

VFP SQL subquery error

2009-11-18 Thread Garry Bettle
Hi Everyone, Hope this email finds you all well - roll on the weekend. I have a query that isn't working at the moment - it returns, "SQL: Subquery is invalid" The subquery works fine on it's own: SELECT TOP 1 b.Cycle, b.DTime FROM LPMHistory b GROUP BY b.Cycle, b.DTime WHERE b.DTim

Re: VFP SQL subquery error

2009-11-18 Thread Garry Bettle
ATH( CURDIR())), 1) + [T] + STUFF( GETWORDNUM( JUSTSTEM( JUSTPATH( CURDIR())), 2), 3, 0, [:])) - 180 ORDER BY b.Cycle, b.DTime) G. On Wed, Nov 18, 2009 at 15:23, Garry Bettle wrote: > Hi Everyone, > > Hope this email finds you all well - roll on the weekend. > > I have a query that is

RE: VFP SQL subquery error

2009-11-18 Thread Garry Bettle
On Wed, Nov 18, 2009 at 15:47:57, "Dave Crozier" wrote: > Gary, > You can only have one field returned in the where "sub select" (i.e the > right hand side) because you are comparing it to one field A.Cycle in the > right hand side. > > Before giving a solution I need to get a feel for the data and

Re: [OT] Getting a camera for Christmas

2009-12-16 Thread Garry Bettle
On Wed, 16 Dec 2009 11:43:42 -0500, "MB Software Solutions, LLC" wrote: > > Was going to get cameras for me and the kids this Christmas.  Saw an > Olympus 12 megapixel from Target for $99...sounds good.  They had a > Polaroid 12MP for $79 but were out-of-stock on that one. > > Just wanted to ask

[NF] Task Bar Grouping

2008-03-19 Thread Garry Bettle
Howdy all, Roll on the weekend... I have a an VFP application that is copied and executed throughout the day. They run for ~40 mins and then close. They appear in the Task Bar as separate entries, even though they are all myapp.exe running - this is because my form caption changes for each inst

RE: [NF] Task Bar Grouping

2008-03-19 Thread Garry Bettle
On Wed, Mar 19, 2008 at 3:55 PM, Dave Crozier wrote: > > Garry, > Just found this free utility and it does just what you want. > > http://www.freewebs.com/nerdcave/taskbarshuffle.htm > > In she settings page, select the group tasks with this or more windows. > > That one's a keeper in the uti

Re: [NF] Anyone interact with camera and images off digital?

2008-04-23 Thread Garry Bettle
On Wed, Apr 23, 2008 at 12:34 AM, wrote: > I just got a scope grope on a project. They not only want to weight a > document at QA station, I now need to have a camera take a picture, and I > then have to grab that image from the camera. > > so the Question is any good cameras for setting up with

Re: Need a GOOD hex editor

2008-04-28 Thread Garry Bettle
Yuri Software HEdit 3.0 offers a rich set of features: * Overwrite, insert, or delete bytes in the file. * Jump to any offset within the file. * Search for data patterns. * Search-and-replace. * Support for files >2 GB in size. Files of any size open instantaneously. * EBCD

RE: VFP9 SP2: substring extraction

2008-05-08 Thread Garry Bettle
On Thu, May 8, 2008 at 12:28 AM, "Allen" wrote: > > Something like (bear in mind the wine has flowed :) > > Local retval, lText > Retval = "" > lText = strtran(lcIn,"[","["+chr(13+chr(10) > lText = strtran(lText,"]","]"+chr(13+chr(10) > For iicount = 1 to memlines(lText) > if left(ml

Re: [NF] disappointed with AVG 8, looking for an alternative

2008-05-15 Thread Garry Bettle
On Thu, May 15, 2008 at 2:18 PM, "David Smith" wrote: > I finally upgraded to the new AVG free version 8 and wow! It sucks! It would > seem they have chosen to go the Norton / McAfee self-promotion and bloat > route. The half dozen unasked for ?features? that I can?t turn off without > nag windows

Re: [NF] STunnel and GoDaddy Mail Server

2014-01-28 Thread Garry Bettle
On 27 January 2014 13:17, Frank Cazabon wrote: > > Is there something I have not added to the stunnel.conf to tell it to > use SSL/TLS? > > Hi Frank, Try adding logging to your stunnel.conf file: debug = 7 output = stunnel.log And under "; Service-level configuration" I have: protocol=smtp [

Re: [NF]HTML Editor

2014-06-10 Thread Garry Bettle
Hi Jeff, In the past I found Html-Kit pretty good: http://www.htmlkit.com/ Cheers, Garry --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com S

How to insert a lot of rows into Oracle

2009-04-08 Thread Garry Bettle
Howdy all, Hope this finds everyone well - roll on the weekend. I'm trying to find some information regarding VFP inserting into Oracle tables. I'd like to create the table Oracle from VFP if possible too. My VFP 9 table contains character, datetime, date and numeric field types. I can connect

Re: In God We Trust

2009-05-22 Thread Garry Bettle
Wow, that's old news. True, but first spotted 2002: http://www.snopes.com/inboxer/outrage/motto.asp G. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFo

Normal Distribution - Any FoxPro code?

2009-08-14 Thread Garry Bettle
Hi Everyone, Hope this email finds you well - roll on the weekend! I've been tasked with replicating an Excel spreadsheet in VFP 9 SP2. The spreadsheet contains cells that use Excels' NORMDIST() function. I have all 3 variables required - value, mean and standard deviation - but does anyone alr

Re: Easiest mail merge for simple XLS or CSV or DBF file

2009-08-21 Thread Garry Bettle
On Wed, 19 Aug 2009 21:44:31 -0400, "MB Software Solutions, LLC" wrote: > > Thanks.  I think that's what I'll do.  The only problem is that I don't > think blat will work for the folks who need SSL (like gmail, yahoo > users...probably hotmail too).  Does BLAT work for SSL email accounts? Hi Mik

Re: What's easiest way to send email with pdf attachments from FPW 2.5?

2008-12-19 Thread Garry Bettle
On Thu, 18 Dec 2008 20:05:01 -0800 (PST), Michael Madigan wrote: > Thanks Malcolm. > > I'll check with my client tomorrow if I can get his email information. > > It used to be soo easy. > > It's blocked from my Comcast account too. I don't even have a comcast email > address, I don't think. >

Re: What's easiest way to send email with pdf attachments from FPW 2.5?

2008-12-19 Thread Garry Bettle
On Fri, Dec 19, 2008 at 15:39, Garry Bettle wrote: > Hi Michael, > > It sounds like you have pdf options. Here's my 2p regarding the emailing ... > > I've had success with Blat - I wrote an article for the last VFUG > newsletter - but was blown away by how simple the

RE: Merry Christmas

2008-12-23 Thread Garry Bettle
On Tue, Dec 23, 20:53:19 -, "John Weller" wrote: > Merry Christmas and Happy New Year (or local equivalents ) to all > Profoxers and, once again, a big Thank You to Ed for all his efforts in > hosting the list. I second what John has just wrote... A big thanks to Ed for all his hard work in

RE: [JOB] VFP 8 dev - New Orleans

2008-12-30 Thread Garry Bettle
On Tue, Mon, 29 Dec 2008 15:07:05 -0800, "Matt Jarvis" wrote: > > It ain't the years - it's the mileage that counts "Youth is the gift of nature, but age is a work of art." - Garson Kanin G. ___ Post Messages to: ProFox@leafe.com Subscription

Re: Programmatically place text into the clipboard?

2009-01-29 Thread Garry Bettle
On Thu, 29 Jan 2009 17:12:00 -0500, Steve Ellenoff wrote: > > Thanks everyone for your help, this is perfect. And, if you want to stick a load of records onto the clipboard, check out: _vfp.DataToClip() G. ___ Post Messages to: ProFox@leafe.com Subsc

Re: Determining clipboard content

2007-12-07 Thread Garry Bettle
On Dec 7, 2007 3:56 AM, Paul Newton wrote: > > Hi all > > A propos of my recent post regarding RTF bloat - I'm wondering if there > is way to determine the content of the clipboard from VFP. > > Let's say that in some unknown/indeterminate application something is > pasted to the clipboard - it mi

Re: [NF] Apple's rising popularity lures hackers

2007-12-09 Thread Garry Bettle
On Dec 7, 2007 9:23 PM, Rob Anderson wrote: > > My IP is 127.0.0.1 do ya think I'm vunerable? :-> > > Robbo > > Ha! http://tinyurl.com/3bx9hd Cheers, Garry --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

RE: Send text file to default printer

2008-01-03 Thread Garry Bettle
On Jan 3, 2008 4:26 PM, Dave Crozier wrote: > * API Call to print out or OPEN a document > > Declare Integer ShellExecute In Shell32.Dll ; > INTEGER nWinHandle,; > STRING cOperation,; > STRING cFileName,; > STRING cParameters,; > STRING cDirectory,; >

Re: Send text file to default printer

2008-01-03 Thread Garry Bettle
Hi Grigore\Paul, Thanks to you both. I was trying to use VFP 9 help for lcase instead of icase - duh! Cheers, Garry ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this lis

Re: [NF] ASUS Eee PC

2008-01-10 Thread Garry Bettle
Eee PCs get larger screens and WiMax: http://www.pcpro.co.uk/CES2008/153144/eee-pcs-get-larger-screens-and-wimax.html or http://tinyurl.com/26377a Cheers, G. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/

Andy Kramek: Advantage Database Server V9.0 released as Beta

2008-01-10 Thread Garry Bettle
http://weblogs.foxite.com/andykramek/archive/2008/01/05/5530.aspx or http://tinyurl.com/2opy87 Cheers, G. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://

Re: [OT] Is expensive wine better then cheap wine?

2008-01-15 Thread Garry Bettle
On Jan 14, 2008 11:01 PM, "Paul Hill" wrote: > LOL! One bottle here lasts at least an hour... > > -- > Paul The missus and I threw out our wine rack years ago for the same reason. G. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

RE: [NF] Windows XP OR Windows Vista ???

2008-01-17 Thread Garry Bettle
Windows XP outshines Vista in benchmarking test. New tests have revealed that Windows XP with the beta Service Pack 3 has twice the performance of Vista, even with its long-awaited Service Pack 1: http://news.zdnet.com/2100-9590_22-6220201.html?tag=nl.e550 or http://tinyurl.com/343j9d G. ___

RE: [NF] charges on my bank card - solved

2008-01-22 Thread Garry Bettle
On Jan 21, 2008 9:43 PM, Michael Madigan wrote: > OK, > > I subscribe to youbet.com, which is a horse racing > site for watching live racing via streaming video. > It's also a betting site, but NJ doesn't allow betting > out of state. > > Of course they just can't bill me as youbet.com, no, > they

Quick SQL question ...

2008-01-24 Thread Garry Bettle
Howdy all, Hope this email finds everyone well - roll on the weekend. I'm trying to work out how to select the latest row from a database, based on the latest datetime field. So, if I have something like: IdDatetime --- --- 1412554 24/01/2008 14:09:10 1412554 2

Re: Quick SQL question ... SOLVED

2008-01-24 Thread Garry Bettle
Doh! Sorry, please move along, nothing to see here: SELECT SelectId, MAX( DTime) FROM DBF() TO SCREEN GROUP BY 1 Boy, did I pick a bad week to stop sniffing glue. G. On Jan 24, 2008 5:18 PM, Garry Bettle <[EMAIL PROTECTED]> wrote: > Howdy all, > > Hope this email finds every

RE: Backing up data from a running application

2008-02-07 Thread Garry Bettle
On Feb 7, 2008 12:32 PM, Dave Crozier wrote: > I can quite happily post up the code if required after a little bit of work > > Picture of running live program as of about 10 minutes ago whilst in mid > backup at: > > www.replacement-software.co.uk/temp/Flexispec_Backup.png > > Dave Crozier > H

Re: [NF] HTML editor

2008-02-07 Thread Garry Bettle
Howdy all, I'd like to recommend HTML Kit. "HTML Kit is a full-featured free editor for HTML, XHTML, XML, CSS, JavaScript, PHP and other text files. Over 400 plugins are available for it, including HTML Tidy for creating standards -compliant web pages. HTML-Kit has been downloaded by millions of

RE: [NF] HTML editor

2008-02-08 Thread Garry Bettle
On Feb 7, 2008 10:13 PM, "NickC" wrote: > > Last time I tried HTML kit it was text only, no WYSIWYG screen. > "Is there a way to start creating simple web pages in visual / WYSIWYG mode? Prototype Pad Looking for a quick and easy way to start creating web pages without hand coding in HTML? Sele

[OT] BBC Refuses to use the word Muslim once in this article

2008-02-12 Thread Garry Bettle
On Feb 12, 2008 5:53 AM, Michael Madigan wrote: > > All the perpetrators are Muslim, but the BBC doesn't > think it's worth mentioning. > > http://news.bbc.co.uk/2/hi/uk_news/7238127.stm > Hi Michael, Where did you read that all the perpetrators where Muslim? Cheers, Garry ___

VFP Desktop Alerts

2008-02-12 Thread Garry Bettle
Howdy all, Has anyone used VFP Desktop Alerts from: http://www.codeplex.com/VFPX/Release/ProjectReleases.aspx?ReleaseId=1644 It looks the biz, but I can't seem to get it to work. I've downloaded the beta, but when I run the sample Program1.prg, all I get is: OLE error code 0x80070002: The syst

RE: VFP Desktop Alerts

2008-02-14 Thread Garry Bettle
On Wed, Feb 13, 2008 at 4:29 PM, "Dave Crozier" wrote: > Gary and others, > I've uploaded the Alert classes and a small demo form onto Ed's download > section for anyone to look at. I guess it will be online when Ed gets chance > to do it. > > Nothing special in the demo form, but it shows ho

RE: VFP Desktop Alerts

2008-02-14 Thread Garry Bettle
On Thu, Feb 14, 2008 at 11:34 AM, "Dave Crozier" wrote: > > Gary, > Just compile the project as a com server. This will automatically register > it. > > Dave Crozier > > Many, many thanks Dave. It works fine now. Nothing more humbling than feeling like a newbie after 20+ yrs... Maybe I sho

Final output code - where should it go?

2008-02-20 Thread Garry Bettle
Howdy all, I have a bit of code that outputs some summary information to a XLS file. The normal way that this happens, is when a response from an API call indicates that a market is closed. What I'd like to do is shift this logic somewhat, so that if the user closes the form - click the top righ

Re: Final output code - where should it go?

2008-02-20 Thread Garry Bettle
PS: Destroy contains: CLEAR EVENTS G. On Wed, Feb 20, 2008 at 5:37 PM, Garry Bettle <[EMAIL PROTECTED]> wrote: > On Wed, Feb 20, 2008 at 3:18 PM, "Dave Crozier" wrote: > > > > Garry, > > Definitely QueryUnload as this is ALLWAYS called however you u

RE: Final output code - where should it go?

2008-02-20 Thread Garry Bettle
On Wed, Feb 20, 2008 at 3:18 PM, "Dave Crozier" wrote: > > Garry, > Definitely QueryUnload as this is ALLWAYS called however you unload the > form. > > Dave Crozier Hi Dave, Thanks to you and everyone else for the replies. I've moved my output code from a timer into a separate form method c

Re: Final output code - where should it go?

2008-02-20 Thread Garry Bettle
Many thanks again to Dave and everyone else you contributed to this thread. It's working now, in both situations - user clicks top-right X or the market returns closed. The solution was: In my timer code, I have Release instead of Destroy. And in the Destroy method, it's now: thisform.CloseDo

Grids - How to keep row position but update all rows.

2008-02-22 Thread Garry Bettle
Howdy all, Roll on the weekend... I have a grid, which is updated, via a timer, from the response of an webservice API. What I'd like to do is to be able for the user to be viewing any row\column of the grid, while the other rows are updated. At the moment, if the timer fires and the grid is re

Re: Grids - How to keep row position but update all rows.

2008-02-22 Thread Garry Bettle
On Fri, Feb 22, 2008 at 9:25 PM, "Sytze de Boer" wrote: > I may be missing something here, but what about: > backhere=recno() > do whateveryoudowhenthe timerfires > go backhere > > > On Sat, Feb 23, 2008 at 1:14 AM, Garry Bettle <[EMAIL PROTECTED]> > wro

Quick Duplicate check ...

2006-12-18 Thread Garry Bettle
Howdy, Hope you all had a good weekend. I'm trying to do a quick reality check for duplicates: select id from file1 where id in ; (select id, count(*) as count from file1 group by 1 having count(*) > 1) but the above only gives me "SQL: Subquery is invalid." error. G. Any ideas? Cheers,

Re: CABuilder for Access databases (Graham Brown (CompSYS))

2006-12-29 Thread Garry Bettle
/wc.dll?LevelExtreme~9,7,10,1295 or How to import table structures and data from Microsoft Access to Visual FoxPro: http://support.microsoft.com/kb/260405 or MDBtoDBC Conversion Utility: http://www.inspironix.com/mdbtodbc.htm Cheers, Garry Bettle MCP, Security+, MCTS SQL 2005 --- StripMime

Re: CABuilder for Access databases

2006-12-29 Thread Garry Bettle
Graham, I've used something similiar to this (but I thought it was from Herman Tan): MDB2DBC - Access to VFP Data Migrator http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,9848 Cheers, Garry Bettle MCP, Security+, MCTS SQL 2005 On 12/29/06, Garry Bettle <[EMAIL P

Array of Arrays - Example Request

2007-01-03 Thread Garry Bettle
Howdy all! Hope everyone has had a good break. Does anyone have an example of an Array of arrays? I'm stumped as to how to Dimension\Declare the array. Many thanks. Cheers, Garry -- MCP, Security+, MCTS SQL 2005 --- StripMime Report -- processed MIME parts --- multipart/alternative text

RE: Array of Arrays - Example Request

2007-01-03 Thread Garry Bettle
I thought as much, that you can't do that in VFP. I've worked around the problem by passing the arrays to a procedure by reference. Thanks everyone, Garry -- MCP, Security+, MCTS SQL 2005 ___ Post Messages to: ProFox@leafe.com Subscription Maintenan

IntelliSense Custom Scripts - Add vars to LOCAL

2007-01-05 Thread Garry Bettle
Howdy all, Roll on the weekend! Does anyone have an example of an IntelliSense Custom Script where if you had selected a variable (i.e. lcVar1) you could add it automagically to a LOCAL declaration at the top of your prg? I'm sure I've seen something like this before. I thought Andy Kramek migh

Re: IntelliSense Custom Scripts - Add vars to LOCAL

2007-01-05 Thread Garry Bettle
On 1/5/07, "Dave Crozier" wrote: > Gary, > I've just loaded a script on onto my site: > > www.replacement-software.co.uk/vfp/VFP_Local_Definition.zip > > Dave Crozier > Thanks Dave! - G. On 1/5/07, "Michael Hawksworth" wrote: > Do a search in the vfp downloads section on www.universalthread.com

RE: Foxpro VM? :)

2007-01-08 Thread Garry Bettle
http://tinyurl.com/y96shn ___ 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 ** All postings, unless explicitly stated othe

Calendar Control

2007-01-08 Thread Garry Bettle
Howdy all, Hope you all had a good weekend. I've placed an ole calendar on a form for a user to select. I'd like to then use that date in a method, but for the life of me, I can't see a property (i.e. Value) or method (i.e. GetDate). Any ideas\work arounds\alternatives? Cheers, Garry -- MCP

RE: Calendar Control

2007-01-08 Thread Garry Bettle
On 1/8/07, Bill Arnold wrote: > Try > > this.object.Value > > In the control's methods > > > Bill > Picked a bad week to stop sniffing glue... Thanks Bill. It's been awhile since I was doing form development. Cheers, Garry ___ Post Messages to: Pro

Anyone have any experience with a SOAP API from BetFair.com?

2007-01-12 Thread Garry Bettle
Howdy all, I'm trying to use an API from BetFair.com and I thought the S in SOAP stood for Simple...? The WSDL file is: https://api.betfair.com/global/v3/BFGlobalService.wsdl I even downloaded Rick's wwSOAP and it doesn't work either (NB: I'm by no means dissing Rick - it's probably badly form

Re: Anyone have any experience with a SOAP API from BetFair.com?

2007-01-12 Thread Garry Bettle
On 1/12/07, Casey McGuire wrote: > Garry Bettle wrote: > > Howdy all, > > > > I'm trying to use an API from BetFair.com and I thought the S in SOAP > > stood for Simple...? > > > > The WSDL file is: > > > > https://api.betfair.com/global/

Wierd Label behaviour

2007-01-24 Thread Garry Bettle
Howdy all, Roll on the weekend. I have a fairly simple Project: one form with one button. Above the button, I'm using a label to brief the user as to what will happen when they click the button. But when the user clicks the button, the label disappers because a MESSAGEBOX is shown - over the la

Re: Wierd Label behaviour

2007-01-24 Thread Garry Bettle
ws-1250" > > What is triggering the MessageBox? Is it the button.click method or > something called by that method? > > John Weller > 01380 723235 > 07976 393631 > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTE

Re: Wierd Label behaviour

2007-01-24 Thread Garry Bettle
On 1/24/07, Kevin Cully wrote: > > > Is a "THISFORM.lockscreen=.T." being set somewhere that isn't being unset? > > -Kevin > > Garry Bettle wrote: > > Howdy all, > > > > Roll on the weekend. > > > > I have a fairly simple Project:

Re: Wierd Label behaviour

2007-01-24 Thread Garry Bettle
to:[EMAIL PROTECTED] On Behalf > Of Garry Bettle > Sent: 24 January 2007 14:04 > To: profox@leafe.com > Subject: Re: Wierd Label behaviour > > On 1/24/07, John Weller wrote: > > > > Message: 3 > > Date: Wed, 24 Jan 2007 12:48:27 - > > From: "J

RE: Wierd Label behaviour

2007-01-24 Thread Garry Bettle
On 1/24/07, Tracy Pearson wrote: > > > And if the refresh doesn't work > THISFORM.Cls() > > Tracy > > > > Can you do a THISFORM.Refresh() after returning from the > > MESSAGEBOX() ? > > > > Garry Bettle wrote: > > > Hi Dave, > >

RE: Wierd Label behaviour

2007-01-24 Thread Garry Bettle
On 1/24/07, Dave Crozier wrote: > > > Gary, > Send it and I'll have a look. > > [EMAIL PROTECTED] > > Dave Crozier > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of Garry Bettle > Sent: 24 January 200

Re: InDbc and Free Table

2007-01-24 Thread Garry Bettle
On 1/24/07, henry.dagher wrote: > > INDBC() can tell me if a table is part of this database. > > FREE TABLE can disconnect the table from a database. > > How can I tell if this table has a link to a DB that I need to remove? > > Issuing FREE TABLE blindly will generate an error if no DB link exists

RE: Wierd Label behaviour

2007-01-25 Thread Garry Bettle
; As it says in Hackers, "clear is not to be used in forms" > > Dave Crozier > > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of Garry Bettle > Sent: 24 January 2007 17:41 > To: profox@leafe.com > Subject: RE: Wierd La

Re: ProFox Digest, Vol 45, Issue 197

2007-01-25 Thread Garry Bettle
On 1/25/07, Michael J. Babcock wrote: > > > Garry -- please learn how to trim your messages! I'm lazy and don't > like to scroll 3 pages down to see your 1 line answer! ;-) > > Sorry Michael. Point taken. Cheers, Garry -- MCP, Security+, MCTS SQL 2005 --- StripMime Report -- processed

Excel Chart to VFP

2007-01-26 Thread Garry Bettle
Howdy all, Has anyone ever created a chart via automation in MS Excel and returned the chart to VFP? I was hoping to use the _clipboard but it's not working in VFP (9.0 SP2). If pushed, I'd be happy saving the chart in Excel as a temporary image file, which VFP could then import. Many thanks,

Re: Excel Chart to VFP

2007-01-26 Thread Garry Bettle
On 1/26/07, Garry Bettle <[EMAIL PROTECTED]> wrote: > Has anyone ever created a chart via automation in MS Excel and returned the > chart to VFP? Nevermind, How To Pass Data to Microsoft Graph Programatically: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q129533 and from

Refresh all open forms

2007-01-29 Thread Garry Bettle
Howdy all, I'm testing a form, which contains an instance of IE. What I'd like to do is to run several instances of this form - each with a different webpage loaded - and refresh them all at once. Does anyone know of a quick way to refresh every open form? Cheers, Garry -- MCP, Security+, MC

Re: Refresh all open forms

2007-01-30 Thread Garry Bettle
On 1/30/07, Eugene Vital wrote: > > Does anyone know of a quick way to refresh every open form? > > FOR EACH oFrm as Form IN _screen.Forms > oFrm.Refresh() > ENDFOR Thanks Eugene. On 1/30/07, "john harvey" wrote: > Give each form a name when you create it, then drill down the object. > > John

  1   2   >