Re: udl files

2008-11-12 Thread Fred Taylor
Create an empty text file with a .UDL extension. Now just double click on it in Explorer and it will open a Data Link properties window. On Wed, Nov 12, 2008 at 10:41 AM, Rafael Copquin [EMAIL PROTECTED]wrote: Does anyone know how to make a udl file to test a SQLServer connection? Last week

Re: [NF] web presentation, do you like this or is it overload?

2008-11-13 Thread Fred Taylor
Even made my fan on my Dell laptop kick in (rarely happens). Something's definitely overloaded... On Thu, Nov 13, 2008 at 1:03 PM, Stephen Russell [EMAIL PROTECTED]wrote: http://now.sprint.com/widget/ I think that it looks cool, and wonder about tweaking the widgets displayed to fit a

Re: Fred Taylor: the VFP programmer returneth!!!! (was Re: [NF] web presentation, do you like this or is it overload?)

2008-11-13 Thread Fred Taylor
Hi Michael, Yeah, I'm still able to scratch out a few projects to work on in Fox. Some in VFP9, some in VFP6, some even in DOS shudder. Harder and harder to find though. What's new with you? On Thu, Nov 13, 2008 at 3:39 PM, MB Software Solutions, LLC [EMAIL PROTECTED] wrote: Fred Taylor

Re: [NF] Unacceptable verizon dsl service

2008-11-17 Thread Fred Taylor
More likely 192.168.1.1 for the IP address. On Mon, Nov 17, 2008 at 3:24 PM, Pete Theisen [EMAIL PROTECTED]wrote: Alan Bourke wrote: On Mon, 17 Nov 2008 12:40:13 -0500, Pete Theisen [EMAIL PROTECTED] said: How would you find it? Generally you either download a file from the website

Re: [OT] 25 billion won't do it?

2008-11-21 Thread Fred Taylor
I recently had a trip to the emergency room for what turned out to be kidney stones. Time spent in the emergency room, 3 hours. Bill was over $10K. A few days later, another trip to an emergency room and 2 days in the hospital. Bill was $15K. When the smoke clears away and all the

Re: [OT] 25 billion won't do it?

2008-11-21 Thread Fred Taylor
On Fri, Nov 21, 2008 at 9:18 AM, MB Software Solutions, LLC [EMAIL PROTECTED] wrote: Fred Taylor wrote: I recently had a trip to the emergency room for what turned out to be kidney stones. Time spent in the emergency room, 3 hours. Bill was over $10K. A few days later, another trip

Re: [OT] 25 billion won't do it?

2008-11-21 Thread Fred Taylor
Yeah, I had 3 doses of morphine the first trip to the ER, they charged $275 a pop, I think it was. I'm sure I could have gotten better stuff on the street for a lot less. What the hell they did to run up an over $10K bill, I have no idea, but Stephen was probably right, lots of tests and doctors

Re: TRANSFORM (VFP9) using formatting for dollar amounts

2008-12-04 Thread Fred Taylor
You need a space after the $. transform(vInvHdr.nAmount,'@$ 999,999,999.99') Fred On Thu, Dec 4, 2008 at 9:08 AM, MB Software Solutions General Account [EMAIL PROTECTED] wrote: I'm trying to add a dollar amount into a string using TRANSFORM. I could have swore I've done this before but I

Re: VFP index corruption

2008-12-09 Thread Fred Taylor
Make sure the size of your .CDX file isn't the issue. With 29 tags and that much data in the table, you may have gone over the 2GB file limit. Fred On Tue, Dec 9, 2008 at 12:11 PM, Jean Haidar [EMAIL PROTECTED]wrote: The data reside on Citrix Server and it is not eady to request changes

Re: VFP index corruption

2008-12-09 Thread Fred Taylor
No, the size should only be an issue if the .CDX file goes over the 2GB boundary. Fred On Tue, Dec 9, 2008 at 12:43 PM, Jean Haidar [EMAIL PROTECTED] wrote: the size of the .DBF is 1.1 gig and the cdx is 158 Mg that would be be an issue? Jean From: Fred

Re: [NF] Extreme Programming Such...

2009-01-05 Thread Fred Taylor
In a previous job that I worked with a guy for nearly 20 years over all, we worked extremely well together in an extreme programming environment long before we even knew such a term existed. It can work well as long as both people involved compliment each other's strengths and can make up for the

Re: Opening window size

2009-01-12 Thread Fred Taylor
You can change your code to make your main form's or _SCREEN.WindowState property to 2, maximized, or you can set the shortcut on your desktop to open full screen. Fred On Mon, Jan 12, 2009 at 1:31 PM, David Higgs davidpghi...@tiscali.co.ukwrote: Hi, Please excuse me as I've not done any

Re: dll init with parameters

2010-01-28 Thread Fred Taylor
See this link: http://msdn.microsoft.com/en-us/library/ms947579.aspx You can't use the .Init of a COM object and pass parameters. Create a new method on your object with parameters and invoke that new method after you've created your object. Fred On Thu, Jan 28, 2010 at 8:34 AM, Allen

Re: dll init with parameters

2010-01-28 Thread Fred Taylor
On Thu, Jan 28, 2010 at 11:53 AM, MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: Fred Taylor wrote: See this link: http://msdn.microsoft.com/en-us/library/ms947579.aspx You can't use the .Init of a COM object and pass parameters. Create a new method

Re: VFP9: mousewheel and combobox

2010-02-04 Thread Fred Taylor
Is there any place in Windows that works that way? I can't think of any. Once it's dropped down, you pick with the mouse or you scroll with the arrows/thumb on the right. Fred On Thu, Feb 4, 2010 at 2:56 PM, Jack Skelley jskel...@newjerseydevils.comwrote: Good Afternoon All: When a combobox

Re: VFP9: mousewheel and combobox - Spam detected

2010-02-04 Thread Fred Taylor
in this instance. Regards, Jack From: profoxtech-boun...@leafe.com [profoxtech-boun...@leafe.com] On Behalf Of Fred Taylor [fbtay...@gmail.com] Sent: Thursday, February 04, 2010 5:09 PM To: profoxt...@leafe.com Subject: Re: VFP9: mousewheel and combobox - Spam

Re: VFP9: mousewheel and combobox - Spam detected

2010-02-04 Thread Fred Taylor
. Regards, Jack From: profoxtech-boun...@leafe.com [profoxtech-boun...@leafe.com] On Behalf Of Fred Taylor [fbtay...@gmail.com] Sent: Thursday, February 04, 2010 5:09 PM To: profoxt...@leafe.com Subject: Re: VFP9: mousewheel and combobox - Spam

Re: VFP9: mousewheel and combobox - Spam detected

2010-02-04 Thread Fred Taylor
. And I am not sure I know how to intercept wm_mousewheel and make it work in this instance. Regards, Jack From: profoxtech-boun...@leafe.com [profoxtech-boun...@leafe.com] On Behalf Of Fred Taylor [fbtay...@gmail.com] Sent: Thursday, February 04

Re: [NF] Windows Scripting and/or Windows Scheduled Tasks problem

2010-02-15 Thread Fred Taylor
IF DIRECTORY(x:\) * exists ELSE * does not exist ENDIF Fred On Mon, Feb 15, 2010 at 12:00 PM, Jarvis, Matthew mat...@mckweb.com wrote: -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Michael Madigan Sent: Monday,

Re:

2010-02-22 Thread Fred Taylor
Nothing shows for that .com at whois.net, but for the IP you can use http://tools.whois.net/whoisbyip/, at least that shows something. Fred On Sun, Feb 21, 2010 at 6:56 PM, Jihan Haidar jh4ip3_r...@sbcglobal.netwrote: I am just wondering if someone know this: If you have a domain and IP

Re: Conflicker.B Infection Alert

2010-02-22 Thread Fred Taylor
Microsoft has never attached files in a generic email. Probably a virus from some other suspect source. Fred On Mon, Feb 22, 2010 at 2:27 PM, Kurt Wendt kurtwe...@waitex.com wrote: How does a message like this actually make it to our mailing list? IS this real - or some kinda scam? And, I

Re: Windows 7 and existing VFP 7 / InstallShield applications

2010-02-22 Thread Fred Taylor
On Mon, Feb 22, 2010 at 3:50 PM, Ted Roche tedro...@gmail.com wrote: On Mon, Feb 22, 2010 at 5:24 PM, Tracy Pearson tr...@powerchurch.com wrote: This process was done because some workstations, even here at the office running different anti-virus and even testing with no anti-virus caused

Re: [NF] FORMAT CODE M

2010-02-24 Thread Fred Taylor
TextBox.Format=M TextBox.InputMask=One,Two,Three,Four Fred On Wed, Feb 24, 2010 at 3:20 PM, gerald foote geraldfo...@bellsouth.netwrote: Does anybody remember how the M in the format of a textbox is used? I know I have used the M and been able to step thru a number of options with the

Re: [NF] FORMAT CODE M

2010-02-24 Thread Fred Taylor
...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Fred Taylor Sent: Wednesday, February 24, 2010 4:37 PM To: ProFox Email List Subject: Re: [NF] FORMAT CODE M TextBox.Format=M TextBox.InputMask=One,Two,Three,Four Fred On Wed, Feb 24, 2010 at 3:20 PM, gerald foote geraldfo

Re: Detect whether an application is being run under Terminal Services/Remote Desktop/Citrix

2010-03-03 Thread Fred Taylor
I think under terminal services you have a CLIENTNAME environment variable that you don't have on a regular logon. Also, there is a SESSIONNAME that has Console when you're local, and RDP-Tcp# some number when you're Remote desktop. Fred On Wed, Mar 3, 2010 at 2:55 PM, Malcolm Greene

Re: Detect whether an application is being run under Terminal Services/Remote Desktop/Citrix

2010-03-03 Thread Fred Taylor
http://news2news.com/vfp/index.php?group=-1function=117 Fred On Wed, Mar 3, 2010 at 7:15 PM, Sytze de Boer sytze.k...@gmail.com wrote: Hi Malcolm How do you make such a API call ? S On Thu, Mar 4, 2010 at 12:56 PM, Malcolm Greene pro...@bdurham.com wrote: Paul, There's also an

Re: Can a cursor created with SELECT... INTO CURSOR have multiple indexes?

2010-03-04 Thread Fred Taylor
Add the READWRITE clause to the SELECT statement. Fred On Thu, Mar 4, 2010 at 3:14 PM, Jon Westcot j...@westcot.net wrote: Hi all: The subject line kind of says it all. I'm trying to create a temporary cursor that has two indexes. I'm using the SELECT... INTO CURSOR option to create

Re: Shortcut menus in VFP9SP2

2010-03-11 Thread Fred Taylor
Try: _SCREEN.ActiveForm.EditTeacher() Fred On Thu, Mar 11, 2010 at 4:12 PM, MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: I've not written shortcut menus into my apps before, but was going to this time for a small one. Apparently, I can't do the following:

Re: Shortcut menus in VFP9SP2

2010-03-12 Thread Fred Taylor
, not the VFP form. Fred On Fri, Mar 12, 2010 at 11:27 AM, Bill Anderson billan...@gmail.com wrote: On Thu, Mar 11, 2010 at 5:05 PM, MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: Fred Taylor wrote: Try: _SCREEN.ActiveForm.EditTeacher() WINNER! Thanks

Re: Shortcut menus in VFP9SP2

2010-03-19 Thread Fred Taylor
On Fri, Mar 19, 2010 at 10:28 AM, Bill Anderson billan...@gmail.com wrote: If it's a right click shortcut on the form or a control on the form, it shouldn't matter, does it? As soon as you attempt to click on the form it's the ActiveForm. The only issue I've ever seen with this is if your

Re: How did you get your start in FoxPro?

2010-04-01 Thread Fred Taylor
I'd been working as professional programmer in mostly Fortran for about 5 years when I first had to do a data job in dBase][ in 1984. From there to dBaseIII, then someone suggested FoxBase. Did that and SCO FoxBase for years, and never looked back. From SBT roots on both DOS and XENIX, worked

Re: Running EXE Name

2010-04-01 Thread Fred Taylor
You can use _VFP.ServerName to get a full path of the running .EXE, or JUSTFNAME(_VFP.ServerName) for the .EXE name only. Fred On Tue, Mar 30, 2010 at 1:50 PM, Philip Borkholder plbor...@netzero.netwrote: Hey all, Anyone know the VFP code or Windows API to be able to find out what runtime

Re: How did you get your start in FoxPro?

2010-04-01 Thread Fred Taylor
here... Who would have thought grin On 4/1/2010 1:18 AM, Fred Taylor wrote: I'd been working as professional programmer in mostly Fortran for about 5 years when I first had to do a data job in dBase][ in 1984. From there to dBaseIII, then someone suggested FoxBase. Did that and SCO

Re: Report Writer bug FIXED!!!

2010-04-06 Thread Fred Taylor
I just did mine and it came out the same 892K in size. Did you open the project in the ReportBuilder folder under ...\xSource\VFPSource\ReportBuilder\reportbuilder.PJX and build the .APP? Fred On Tue, Apr 6, 2010 at 1:03 PM, Sytze de Boer sytze.k...@gmail.com wrote: I've followed the

Re: [OT] - I can't believe it....

2010-04-09 Thread Fred Taylor
What I do in those situations is: 1) print it out 2) fill out the information 3) scan it back in as PDF 4) email it back You now have a hardcopy for your files, too. Sometimes the PDF can actually have enterable text boxes, too, so it can be filled out and saved. Fred On Fri, Apr 9, 2010 at

Re: [OT] Has Washington become a dramatically more dangerous place to work?

2010-04-12 Thread Fred Taylor
No, it's not. Just went there a moment ago. Fred On Mon, Apr 12, 2010 at 2:30 PM, Nicholas Geti ng...@optonline.net wrote: That link is dead. - Original Message - From: Michael Oke, II oke...@gmail.com To: ProFox Email List profox@leafe.com Sent: Monday, April 12, 2010 4:35 PM

Re: VFP9SP2 - Clicking on Memo in grid does NOT bring up a memo window

2010-04-12 Thread Fred Taylor
It should. Do you have code in any of the grid, columns, or text1 DblClick method up the inheritance? A plain old base grid object (.ColumnCount=-1) works. Fred On Mon, Apr 12, 2010 at 10:34 PM, MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: In one of my

Re: Interesting XLS File

2010-04-29 Thread Fred Taylor
Not even worth trying if it's in Excel 2007 format. Just save it as a CSV file and get it into VFP that way. Fred On Thu, Apr 29, 2010 at 4:45 PM, Paul McNett p...@ulmcnett.com wrote: On 4/29/10 4:36 PM, G Gambill wrote: I have been sent an XLS file that I can't import with the Import

Re: VFP Rounding

2010-05-04 Thread Fred Taylor
You can try this. SET DECIMALS TO 1 more than you're formatting, in your case 3. Then use TRANSFORM(your number,9.99) to get it as a string. As long as the SET DECIMAL is at least 1 more than you're formatting to, it will truncate, not round. Fred On Tue, May 4, 2010 at 3:00

Re: [OT] Wall Street Meltown

2010-05-07 Thread Fred Taylor
On Fri, May 7, 2010 at 3:13 PM, Pete Theisen petethei...@verizon.netwrote: Stephen Russell wrote: Most of my dad's clients do not have to take their own toilet paper to work, but neither are they fabulously wealthy Oh. Well, your father would have told them that anything they can't

Re: vfp and sql function equivalence

2010-05-28 Thread Fred Taylor
http://fox.wikis.com/wc.dll?Wiki~VFPSQL-TSQL-Mapping Fred On Fri, May 28, 2010 at 4:11 PM, Rafael Copquin rcopq...@ciudad.com.arwrote: Where can I find a list of VFP functions and their equivalent T-SQL functions? Please post a good URL to check. TIA and have a nice weekend Rafael

Re: Word Automation: OLE exception error 5981 in Windows 7

2010-06-08 Thread Fred Taylor
resource=x:\folder\name_of _foxuser_table Fred On Tue, Jun 8, 2010 at 2:10 PM, Ken Dibble krdib...@frontiernet.net wrote: A Google search suggests the Visual Basic may not be working correctly. http://www.endnote.com/support/faqs/CWYW/faq8.asp Can you open the Visual Basic editor in Word

Re: VFP OLEDRAGDROP not working in dev mode

2010-06-09 Thread Fred Taylor
Maybe you're ISP is filtering Dave's address? I saw his original. Fred On Wed, Jun 9, 2010 at 10:31 AM, Rick Schummer pro...@whitelightcomputing.com wrote: I have not seen an original Dave email for ages, only get to see them when it is included in some else's replay. I thought this was

Re: Maximum number of files in a single folder?

2009-02-19 Thread Fred Taylor
I used to have to deal with many WAV files in folders. As long as there wasn't too many more than about 5K files per folder, things worked very well. After that, it got to be pretty sluggish. Fred On Wed, Feb 18, 2009 at 12:59 PM, Matt Slay matts...@jordanmachine.comwrote: Is there any

Re: [NF] M$ wants their layoff $$ back

2009-02-23 Thread Fred Taylor
Looks like M$ may have a heart after all. http://www.msnbc.msn.com/id/29353191 Fred On Mon, Feb 23, 2009 at 4:55 PM, m...@mikewohlrab.com wrote: Thanks for noting that but i am 18 and do understand how severance packages work. Sent from my Verizon Wireless BlackBerry -Original

Re: [NF] M$ wants their layoff $$ back

2009-02-24 Thread Fred Taylor
Yeah, I think you're right. That's about the only way big business will do the right thing. Damage control! Fred On Mon, Feb 23, 2009 at 9:19 PM, Michael Madigan mmadi10...@yahoo.comwrote: It wasn't their heart, it was because they were embarrassed. --- On Mon, 2/23/09, Fred Taylor

Re: [OT] Fighting your credit report blotches

2009-02-24 Thread Fred Taylor
Maybe this one has less pitfalls? https://www.annualcreditreport.com/cra/index.jsp Fred On Tue, Feb 24, 2009 at 7:59 AM, Stephen Russell srussell...@gmail.comwrote: On Tue, Feb 24, 2009 at 6:47 AM, MB Software Solutions General Account mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:

Re: Autoincrement field

2009-03-11 Thread Fred Taylor
It's in VFP6, so it surely is in VFP7. Fred On Wed, Mar 11, 2009 at 8:44 AM, Peter Cushing pcush...@rajan-group.co.ukwrote: John Weller wrote: True - the job I was thinking of was that of replacing APPEND BLANK, GATHER MEMVAR Been using INSERT INTO xxx FROM MEMVAR for years but when

Re: Autoincrement field

2009-03-11 Thread Fred Taylor
Wait, that's SCATTER/GATHER NAME in VFP6, not INSERT INTO ... NAME. Fred On Wed, Mar 11, 2009 at 6:06 PM, Fred Taylor fbtay...@gmail.com wrote: It's in VFP6, so it surely is in VFP7. Fred On Wed, Mar 11, 2009 at 8:44 AM, Peter Cushing pcush...@rajan-group.co.uk wrote: John Weller

Re: Good reasons to upgrade (was Re: FW: Autoincrement field)

2009-03-12 Thread Fred Taylor
That's what the .Anchor property is for. A value of 5 (top and bottom absolute) might be what you need. Fred On Thu, Mar 12, 2009 at 5:03 PM, MB Software Solutions General Account mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: Kevin Cully wrote: I've been just calling the

Re: Extract a control from a VCX class?

2009-03-17 Thread Fred Taylor
Create a dummy form and drop the container class on the form. Now select just your class that you want and use the Save as class from the File menu. Fred On Tue, Mar 17, 2009 at 8:20 PM, Matt Slay foxst...@jordanmachine.comwrote: I have a container class in a VCX, where I added a combobox

Re: VFP9-convert a number to month

2009-03-18 Thread Fred Taylor
Here's one way: ?CMONTH(EVALUATE({^++/+mm+/01})) convert your year and month as needed to character or if they're numeric: ?CMONTH(DATE(,mm,1)) On Wed, Mar 18, 2009 at 4:37 PM, Sytze de Boer sy...@kiss.co.nz wrote: Hi I know how to do cmonth(date()) and various derivatives thereof

Re: VFP9-convert a number to month

2009-03-18 Thread Fred Taylor
Between(saleperiod,psdate1,psdate2) And trantype $ CI And client=windebs.Code Group By 1,2 Order By 1,2 Into Table myfile This causes a problem on the group and order by If I group and order by 1 its ok On Thu, Mar 19, 2009 at 12:53 PM, Fred Taylor fbtay...@gmail.com wrote: Here's one

Re: VFP9-convert a number to month

2009-03-19 Thread Fred Taylor
a problem on the group and order by If I group and order by 1 its ok On Thu, Mar 19, 2009 at 12:53 PM, Fred Taylor fbtay...@gmail.com wrote: Here's one way: ?CMONTH(EVALUATE({^++/+mm+/01})) convert your year and month as needed to character or if they're

Re: VFP9-convert a number to month

2009-03-19 Thread Fred Taylor
.. didn't choke for me. Do you have any records where the numeric field with the year/month is 0? Maybe that is causing the problem. Cathy -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Fred Taylor Sent: Thursday, March 19

Re: Update field value

2009-03-26 Thread Fred Taylor
On Thu, Mar 26, 2009 at 12:29 PM, Vince Teachout tea...@taconic.net wrote: MB Software Solutions General Account wrote: Vince -- you meant ThisForm.MyMethod(this) (...not just the name attribute, but the actual object) right? No, in my example (again, assuming I understood the question)

Re: [NF] Excel Query

2009-03-31 Thread Fred Taylor
On Tue, Mar 31, 2009 at 10:17 AM, Ken Kixmoeller/fh foxh...@information-architecture.com wrote: On Mar 31, 2009, at 12:06 PM, John Weller wrote: I have just been teaching a class in Excel 2003. One of the students noticed that some of the cells had a green corner, similar to the red

Re: MySql Insert fro VFP9

2009-04-02 Thread Fred Taylor
Not sure if MySQL supports parameters like SQL Server, but try this instead: try= SQLEXEC(junk, insert into sec values(?mid,?mlnam,?mfnam,?musrnam,?mpzwd,?mlvl)) junk is the connection handle What you provided was all strings with no quoted values so it didn't know what to make of it. try=

Re: [NF] Adobe AIR

2009-04-10 Thread Fred Taylor
On Fri, Apr 10, 2009 at 10:26 AM, Ed Leafe e...@leafe.com wrote: On Apr 10, 2009, at 12:17 PM, Stephen Russell wrote: In our industry you have to take change for what it is worth. IT pushes the envelope to do things faster and better. I believe that his point, and those of many

Re: getautoincvalue and @@identity (VFP 9 and SQLServer)

2009-04-10 Thread Fred Taylor
You can return the value in a batch of sql commands like this: nStat = SQLEXEC(nHandle,[insert into junk (f1) values ('abc');select @@identity]) The identity field value will be returned in cursor named sqlresult or you can name the result set like this: nStat = SQLEXEC(nHandle,[insert into

Re: set bell and wav files

2009-04-11 Thread Fred Taylor
Works for me in VFP6/SP5 and VFP9/SP2, XP/SP3. Fred On Thu, Apr 9, 2009 at 5:39 PM, Gerald Foote geraldfo...@bellsouth.netwrote: I am calling this code in a procedure file, nothing happens when I call, it just falls right thru with no sound.. If I enable the set step on and I resume

Re: date format differs from VFP vs EXE

2009-04-23 Thread Fred Taylor
1) Check your settings for SET MARK and SET SYSFORMATS 2) Open the debugger. From the main VFP menu, open Tools/Options.. Hold down shift and click OK The output goes to the debug output window in the debugger, and you can cut and paste from there. Fred On Thu, Apr 23, 2009 at 2:47

Re: VFP8: Record Lock

2009-04-24 Thread Fred Taylor
Fundamental error. ISRLOCK() doesn't tell you if someone else has it locked, only if YOU have it locked within this session of VFP. Won't even tell you if another instance of VFP on your own machine has a lock or not. Fred On Fri, Apr 24, 2009 at 1:04 PM, Jack Skelley

Re: VFP8: Record Lock

2009-04-28 Thread Fred Taylor
missed it. Thanks for all the suggestions. Regards, Jack From: profoxtech-boun...@leafe.com [profoxtech-boun...@leafe.com] On Behalf Of Fred Taylor [fbtay...@gmail.com] Sent: Friday, April 24, 2009 7:57 PM To: profoxt...@leafe.com Subject: Re: VFP8

Re: [OT] Life on Mars ending.

2009-05-04 Thread Fred Taylor
I did. I was surprised that after they announced it would be cancelled, they let them wrap the story up. Though I do think the series was intended to be 2-3 years, not just the one. Great music and great cars! Fred On Mon, May 4, 2009 at 8:06 AM, Stephen Russell srussell...@gmail.comwrote:

Re: Programmatically open a PRG for editing at a particular line ...

2009-05-13 Thread Fred Taylor
You could use the EDITSOURCE() function if you're using VFP9. Fred On Wed, May 13, 2009 at 2:13 PM, Paul Newton p...@foxpertise.com wrote: Hi all I have a number of prgs that I want to programatically open for editing at a particular line such as Define Class MyClass As blah or

Re: VFP 9 Runtime installer

2009-05-18 Thread Fred Taylor
http://ftp.prolib.de/public/ Fred On Mon, May 18, 2009 at 7:40 AM, James Roark(The Dogstar Group) jrro...@dogstargroup.com wrote: I haven't needed them for awhile but can somebody point me ot the vfp9 runtime files installer? Lost all my notes. Thanks Jim [excessive quoting removed

Re: FPW 2.6 Won't Load

2009-05-20 Thread Fred Taylor
I ran into this along time ago on NT systems. In my case, it was FPW wouldn't run at ANY time after AutoCAD was run. I believe it had something to do with fragmented memory. The only way we resolved it was that we simply could not run AutoCAD and our FPW apps on the same computer. It also

Re: Help with Formula

2009-06-10 Thread Fred Taylor
On Wed, Jun 10, 2009 at 12:24 PM, Paul Hill paulroberth...@gmail.comwrote: On Wed, Jun 10, 2009 at 3:38 PM, Kent Belankbe...@mchsi.com wrote: Hello, I need help with a Formula. I have a message of variable length and need to calculate the message header. Here is the formula: The

Re: TRY...CATCH...ENDTRY

2009-06-13 Thread Fred Taylor
Did you initialize lErr to .F. before your SCAN loop? Fred On Sat, Jun 13, 2009 at 3:48 PM, Eurico Chagas Filho echagas...@terra.com.br wrote: Hi I am trying to built a structure like the following... SCAN . TRY CATCH TO oErr WHEN oErr.ErrorNo = 1705 lErr

Re: VFP controlling IE; works in CW; DW, not in program

2009-07-14 Thread Fred Taylor
The ReadyState doesn't seem to change from 4 when you do the button.Click, so the code just falls through. Waiting some period of time before processing the results of the click works, so something other than ReadyState would have to be checked. Fred On Tue, Jul 14, 2009 at 3:48 PM, Bill

Re: [NF] Trying to configure Yahoo email account to Outlook Express

2009-07-17 Thread Fred Taylor
I don't hink the freebie Yahoo account allows access except through the web interface. They changed that a few years back, because it used to work. They wanted to hit me up for $19.95 a year if I wanted to continue using it that way. Fred On Fri, Jul 17, 2009 at 7:51 AM, MB Software Solutions,

Re: VFP9-SUMming

2009-07-19 Thread Fred Taylor
On Sat, Jul 18, 2009 at 9:55 PM, Sytze de Boer sytze.k...@gmail.com wrote: Can I SUM data without changing the record position e.g I'm on row 10 in a 20 record table I issue the command SUM ALL AMOUNT TO MY_TOTALS But I son't want to shift the record position (I know I could do it as

Re: VFP9 SP2 mouseclick strangeness

2009-07-21 Thread Fred Taylor
Ted, I ran into something similar to this. I don't have the code immediately available, but I think the solution was in the pageframe.Init was to run through all the pages (set the .ActivePage) then finally set the page you want to be displayed. If that doesn't work, I'll try to hunt up the

Re: VFP9 SP2 mouseclick strangeness

2009-07-21 Thread Fred Taylor
Found the code. Knew I had posted it somewhere. LOCAL OrigLS, x m.OrigLS = thisform.LockScreen thisform.LockScreen = .t. FOR m.x=this.PageCount TO 1 STEP -1 this.ActivePage=m.x ENDFOR thisform.LockScreen = m.OrigLS Fred On Tue, Jul 21, 2009 at 11:37 AM, Fred Taylor fbtay...@gmail.com wrote

Re: [NF] Gmail integration with local mail client

2009-07-31 Thread Fred Taylor
Outlook Express. No problem with retreiving/sending mail through gmail via OE. Fred On Fri, Jul 31, 2009 at 11:24 AM, MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: Trying to setup gmail with local mail client so our Sylvan app can use local mail client for

Re: VFP9-Word/Excel licence

2009-08-12 Thread Fred Taylor
Can you do oWord.Visible = .t. and see it in your Windows task bar after you create the oWord object? If you can't, you may not have Word installed correctly. Fred On Wed, Aug 12, 2009 at 3:34 PM, Sytze de Boer sytze.k...@gmail.com wrote: Richard, I know I'm iggarant but I know that one (big

Re: Reverse DTOS?

2009-08-25 Thread Fred Taylor
Here's one that doesn't require VFP9: ?EVALUATE({^+TRANSFORM(DTOS(DATE()),@R /99/99)+}) Fred On Tue, Aug 25, 2009 at 7:03 AM, Dave Thayer davetha...@gmail.com wrote: On Mon, Aug 24, 2009 at 3:53 AM, Mark Stantonm...@vowleyfarm.co.uk wrote: Is there really no VFP function that is the

Re: VFP9 - Set relation

2009-09-03 Thread Fred Taylor
I've got a client that has heavily invested in modifications to an AccountMate accounting system over the years that's in FPD. They still have me adding new functionality, but wherever I can, I try to do the new things in VFP. Seems to run fine on XP and Vista workstations. Fred On Wed, Sep

Re: [OT] Vista Mail and Yahoo

2009-09-10 Thread Fred Taylor
You have to be using the pay version of Yahoo mail to do that. I think it's $19.95 a year. Fred On Thu, Sep 10, 2009 at 11:18 AM, Rafael Copquin rcopq...@ciudad.com.arwrote: I wouuld like to receive my yahoo mail, using my Vista Mail, directly into my notebook. How do I set up the account

Re: Excel optimization

2009-09-18 Thread Fred Taylor
You should be able to use _VFP.DataToClip() and then Paste the data into a specific starting cell via automation. Fred 2009/9/18 Ricardo Aráoz ricar...@gmail.com I'm currently writing reports to excel worksheets (VFP6 - excel2000). I used to do this through automation but sometimes the

Re: Excel optimization

2009-09-18 Thread Fred Taylor
I had to try it again, it's been awhile. _VFP.DataToClip(,,3) oExcel.Cells(5,5).Select() oExcel.Selection.PasteSpecial() I copied several 000's of records in a fraction of a second. You do get your field names in the first row, but it's a simple matter to remove that. Fred 2009/9/18 Ricardo

Re: Excel optimization

2009-09-19 Thread Fred Taylor
Hi Christof, Are you sure about that? I just tried it in VFP9/SP2 and it works fine in a Private DataSession. Fred On Sat, Sep 19, 2009 at 2:27 AM, Christof Wollenhaupt foxp...@gmx.dewrote: Hi Fred, _VFP.DataToClip(,,3) DataToClip is limited to the default datasession. In a private

Re: VFP 9: Get Rid of Toolbar Area

2009-10-08 Thread Fred Taylor
Menu View/Toolbars... and uncheck all toolbars. Fred On Thu, Oct 8, 2009 at 5:00 PM, Gene Wirchenko ge...@ocis.net wrote: Hello: I just had to clobber my foxuser.*. In getting things back to what they should be, I find I have forgotten how to get rid of the toolbar area just under

Re: VFP 9: Get Rid of Toolbar Area

2009-10-09 Thread Fred Taylor
On Thu, Oct 8, 2009 at 8:23 PM, Gene Wirchenko ge...@ocis.net wrote: At 17:32 2009-10-08, Fred Taylor fbtay...@gmail.com wrote: Menu View/Toolbars... and uncheck all toolbars. I had already done that, but since you suggested the area, I took another look. There were no toolbars checked

Re: Way to abort shutdown routine? (VFP9SP1)

2009-10-13 Thread Fred Taylor
If you just do a RETURN in your ON SHUTDOWN routine (ON SHUTDOWN DO myshutdown) before you do any CLEAR EVENTS or anything else it seems to stay in there, doesn't it? Fred On Tue, Oct 13, 2009 at 10:48 AM, MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: If I

Re: WAIT

2009-11-23 Thread Fred Taylor
I agree with the others, email the text. But if you must have a screenshot, you can use MESSAGEBOX() and have 1024 charqcters. Fred On Mon, Nov 23, 2009 at 10:02 PM, Sytze de Boer sytze.k...@gmail.comwrote: I have a routine that really works well for me. It goes like this Error occurs I

Re: Network IP Addresses

2010-01-03 Thread Fred Taylor
For Windows, IPCONFIG from a CMD window. Fred On Sun, Jan 3, 2010 at 10:54 AM, Ken Kixmoeller f/h foxh...@information-architecture.com wrote: Hey - -- -- - - - -- Anyone hanging around the office this morning?? One of my wireless routers is misbehaving. The IP address I wrote down for

Re: Removing the vertical column freeze/lock thingee

2010-01-14 Thread Fred Taylor
grid.LockColumns and grid.LockColumnsLeft, depending on which panel you're locking the columns in. Fred On Thu, Jan 14, 2010 at 8:55 AM, MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: Well, I asked awhile back about something to keep my leftmost 'n' # of cells

Re: Removing the vertical column freeze/lock thingee

2010-01-14 Thread Fred Taylor
Just noticed if you right click the mouse between the column headers, it will set/reset the .LockColumns property at runtime. Learn something new everyday. :) Fred On Thu, Jan 14, 2010 at 8:55 AM, MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: Well, I asked

Re: VFP9 SP3 Pageframe page caption

2010-01-15 Thread Fred Taylor
Try setting the Page captions in each Page.Init or in the PageFrame.Init. Fred On Fri, Jan 15, 2010 at 1:10 PM, Sytze de Boer sytze.k...@gmail.com wrote: Can someone confirm the following behaviour I have a form with a pageframe and 3 pages For each of the page captions, I type in Page 1

Re: [OT] Drinking game for the Obama speech?

2010-06-15 Thread Fred Taylor
I don't think I can drink that much. hic Fred On Tue, Jun 15, 2010 at 2:40 PM, Stephen Russell srussell...@gmail.comwrote: Words to drink on Environment Responsible Disaster Capture Barrel Devastating deepwater oil companies coastal area coastline Divdend Anyone up for this.

Re: I'm being lazy - any already built DTOS() -- STOD() function for a form?

2010-06-16 Thread Fred Taylor
?EVALUATE(+{^+TRANSFORM(20100616,@R /99/99)+}) Fred On Wed, Jun 16, 2010 at 7:06 AM, Vincent Teachout tea...@taconic.netwrote: Stephen Russell wrote: I just had to play that game DTOS and STOD. Are you going to always get 8 digits in MM DD format? Or could they be a real

Re: I'm being lazy - any already built DTOS() -- STOD() function for a form?

2010-06-16 Thread Fred Taylor
: (I am pretty sure we got this on this list years ago.) FUNCTION StoD LPARAMETERS tcDateInDtoSFormat SET CENTURY on RETURN EVALUATE(+{^+TRANSFORM(tcDateInDtoSFormat,@R /99/99)+}) - Original Message - From: Fred Taylor fbtay...@gmail.com To: ProFox Email List profox@leafe.com

Re: [NF] I believe that this got the OK from FAA yesterday

2010-06-30 Thread Fred Taylor
Not sure of the requirements for a sports license, but there's not much chance of anything like this ever becoming a for the masses mode of transportation. People can barely drive properly in 2D, let alone maneuver in 3D space. And believe me, there's already enough people that fly that have no

Re: [NF] I believe that this got the OK from FAA yesterday

2010-07-01 Thread Fred Taylor
comments would, I expect, be better informed. Dave C -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Fred Taylor Sent: 30 June 2010 18:28 To: ProFox Email List Subject: Re: [NF] I believe that this got the OK from FAA yesterday

Re: directory to table

2010-07-12 Thread Fred Taylor
If you need any of the other values of the ADIR() statement, create a cursor/table with these fields: ADIR(ax) CREATE CURSOR yourfiles (filename c(50), filesize i, filedate d, filetime c(8), fileatribs c(5)) APPEND FROM ARRAY ax Fred On Mon, Jul 12, 2010 at 9:36 AM, Gary Jeurink

Re: directory to table

2010-07-12 Thread Fred Taylor
Also beware of using the ADIR() statement if you have more than 13,000 files in the folder, as an array is limited in VFP versions prior to VFP9. For those versions, 65K elements is all you can have in the the array (13000*5=65000), for VFP9, there's no such limit. Fred On Mon, Jul 12, 2010 at

Re: [OT] art or not?

2010-07-28 Thread Fred Taylor
On Wed, Jul 28, 2010 at 5:46 AM, Stephen Russell srussell...@gmail.com wrote: So what is your vote, art or porn? Art. Fred ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of

Re: [NF] Resetting Gmail password

2010-07-28 Thread Fred Taylor
Gmail uses the name portion of the email address, so that's minus the @gmail.com as the username. Fred On Wed, Jul 28, 2010 at 7:18 AM, Pete Theisen petethei...@verizon.net wrote: Hi Everybody, I am trying to set up gmail in thunderbird. I had it working fine on another machine that

  1   2   3   4   5   6   7   8   9   10   >