RE: Does opp locks on clients need to be turned off too to prevent index corruption?

2012-04-18 Thread Richard Kaye
http://www.dataaccess.com/whitepapers/opportunlockingreadcaching.html -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank Cazabon Sent: Tuesday, April 17, 2012 7:09 PM To: profoxt...@leafe.com Subject: Re: Does opp locks o

RE: How do i determine what "set refresh" is set to?

2012-04-18 Thread Richard Kaye
SET("Refresh",1) seems to do the trick. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Michael Madigan Sent: Wednesday, April 18, 2012 7:11 AM To: profoxt...@leafe.com Subject: How do i determine what "set refresh" is set to

RE: lockng issues

2012-04-25 Thread Richard Kaye
Hi Rick, Isn't the use of ALL redundant when using the FOR scope in a REPLACE statement as the FOR scope will force the replace to evaluate each row, right? Unless you use FOR with REST? What is the locking scheme under those conditions - header or record? -- rk -Original Message- Fro

RE: lockng issues

2012-04-25 Thread Richard Kaye
Rick's point earlier in the thread indicated that using ALL with REPLACE will result in a header lock. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Sytze de Boer Sent: Wednesday, April 25, 2012 4:56 PM To: profoxt...@lea

RE: lockng issues

2012-04-25 Thread Richard Kaye
Also mentioned earlier in the thread, I think. Each REPLACE statement will result in a row lock. So a good refactoring strategy might be to combine your separate statements to one once you've finished troubleshooting. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:

RE: [NF] Program the car/truck computer for safety (Allen)

2012-05-01 Thread Richard Kaye
Welcome to Profox, Glen. [NF] is the list convention for what ostensibly is a technical discussion which is Not Fox related. [OT] stands for Off Topic and is generally a delightful stew of politics, religion and other time-wasting but entertaining (to some) threads. You can subscribe to

RE: Systems

2012-05-10 Thread Richard Kaye
The other two are the runtime engine for the 9.x report engine. If you use the XFRX previewer class or use REPORTENGINE 90 in your application , it makes use of those. So the short answer is you should distribute all 3 together and not delete them. -- rk -Original Message- From: profox

RE: testing 123

2012-05-11 Thread Richard Kaye
Interesting. This one came right through. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Friday, May 11, 2012 9:19 AM To: profoxt...@leafe.com Subject: testing 123 I sent a message out to the list about

RE: testing 123

2012-05-11 Thread Richard Kaye
he Sent: Friday, May 11, 2012 9:33 AM To: profoxt...@leafe.com Subject: Re: testing 123 Got it here! On Fri, May 11, 2012 at 9:23 AM, Richard Kaye wrote: > Interesting. This one came right through. > > -- > rk > > -Original Message- > From: profoxtech-boun...@leafe.com

RE: testing 123

2012-05-11 Thread Richard Kaye
: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche Sent: Friday, May 11, 2012 10:41 AM To: profoxt...@leafe.com Subject: Re: testing 123 On Fri, May 11, 2012 at 9:45 AM, Richard Kaye wrote: > I'm always honored when I say something and you get it, Ted... ;)

RE: testing 123

2012-05-11 Thread Richard Kaye
This is the link that mentions the list I used: http://www.outlook-tips.net/outlook-calendar/missing-holidays It has quite a 88 countries in it (assuming my search regex is right) so that may be a good source for you. Look for outlook.hol on your system, assuming you have it installed. I repla

RE: stream video ActiveX control ezvidc60.ocx

2012-05-11 Thread Richard Kaye
W7 security, iirc. There's some kind of magical folder redirection going on. Sorry I don't recall the details of how you actually have to make this work. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of James Harvey Sent: Fr

RE: testing 123

2012-05-14 Thread Richard Kaye
com] On Behalf Of Ed Leafe Sent: Saturday, May 12, 2012 10:50 AM To: profoxt...@leafe.com Subject: Re: testing 123 On May 11, 2012, at 8:19 AM, Richard Kaye wrote: > I sent a message out to the list about 10 minutes ago and it hasn't shown up > yet. Looking for clues... :)

RE: How do I determine what service pack I'm currently using for VFP 9.0?

2012-05-14 Thread Richard Kaye
?VERSION() SP2 is 9...7423 -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Michael Madigan Sent: Monday, May 14, 2012 1:51 AM To: profoxt...@leafe.com Subject: How do I determine what service pack I'm currently using for VF

RE: Need Cosessions

2012-05-14 Thread Richard Kaye
Lantastic!? I haven't heard that one in many years. We used to use a competing LAN product - Invisible LAN, iirc. http://www.invisiblesoft.com/invlan/index.shtml Yep, I remembered correctly... -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.

RE: Need Cosessions

2012-05-14 Thread Richard Kaye
Sorry if I misled you Jerry. Lantastic's primary product was an inexpensive LAN operating system in the days before network support was ubiquitous. Invisible was a competitor in that space; not remote access. I was just indulging in a bit of nostalgia. -- rk -Original Message- From: p

RE: Excel Class

2012-05-15 Thread Richard Kaye
And then there's Craig Boyd's library - http://www.sweetpotatosoftware.com/spsblog/2008/09/30/UsingExcel2007FileFormatsInVFP90.aspx -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Tuesday, M

Holiday list in standard data format?

2012-05-15 Thread Richard Kaye
While I wrestle with the google, does anyone out there know of a source for holidays in a format that I can quickly toss into a DBF? (I'm implementing some business day date calculation stuff.) TIA -- rk ___ Post Messages to: ProFox@leafe.com Subscri

RE: Holiday list in standard data format?

2012-05-15 Thread Richard Kaye
- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Tuesday, May 15, 2012 10:27 AM To: profoxt...@leafe.com Subject: Holiday list in standard data format? While I wrestle with the google, does anyone out there know of a source for holidays in a for

RE: Holiday list in standard data format?

2012-05-15 Thread Richard Kaye
Ed had me send a fresh copy and he found it in his spam filter. The original seems to have landed in the Bermuda Triangle; no evidence that it ever existed according to him. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of T

RE: Memo Fields in SQL [was...RE: SQL Server Import & VFP Data Source]

2012-05-15 Thread Richard Kaye
SQL<->VFP CHAR=CHARACTER (fixed width column definition) VARCHAR=VARCHAR (variable width column definition although VFP fakes it) TEXT=MEMO (unlimited width for most practical purposes) VARCHAR and NVARCHAR can work in place of TEXT and are more efficient in terms of storage in SQL land. You can

RE: Memo Fields in SQL [was...RE: SQL Server Import & VFP Data Source]

2012-05-15 Thread Richard Kaye
Definitely not in 2000. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul Hill Sent: Tuesday, May 15, 2012 3:51 PM To: profoxt...@leafe.com Subject: Re: Memo Fields in SQL [was...RE: SQL Server Import & VFP Data Source] I

RE: Memo Fields in SQL [was...RE: SQL Server Import & VFP Data Source]

2012-05-15 Thread Richard Kaye
At the risk of stating the obvious, note that Stephen's code for temporarily turning off logging means you can't restore the table to the state it was in before you added your data so make a backup before you start if recovery is important. -- rk -Original Message- From: profoxtech-bo

RE: select question

2012-05-16 Thread Richard Kaye
The AS clause on a column definition is optional so the parser is trying to alias your column name as "top" when you don't have the AS clause in place. I always put the TOP keyword right after the SELECT. This should work: SELECT TOP 5 hip_no, amount, name horse FROM stnhorse WHERE amount <> 0 A

RE: μ Micro symbol

2012-05-16 Thread Richard Kaye
Try the old Symbol font. Both the micron and ohm character are in there. Of course, then you don't have the full alphabet so it's a question of what you need to store in this particular column. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.

RE: Excel Class

2012-05-16 Thread Richard Kaye
Or if you're just looking for the basics of COM automation with Office, there's always the very fine Hentzenworke book - Microsoft Automation with Visual FoxPro. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ken Kixmoelle

RE: select question

2012-05-16 Thread Richard Kaye
When it's going to cost you the most pain, of course... ;) As Murphy states, "The perversity of the universe tends to a maximum." -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Michael Madigan Sent: Wednesday, May 16, 2012

RE: Excel Class

2012-05-16 Thread Richard Kaye
I'll make sure Whil sends me my sales commission. Another great way to learn automation is to just play with it at the command line. Create an Excel object. Figure out how to add a document and play with it. Intellisense is your best friend... -- rk -Original Message- From: profoxtec

RE: Stumbling block... Comparing indexes

2012-05-22 Thread Richard Kaye
Do you really have the ! in your destination file() test? I do stuff like this when I'm comparing 2 lookup tables. IF FILE(lcSource) USE (lcSource) IN SELECT([source]) ALIAS source endif IF FILE(lcDestination) USE (lcDestination) IN SELECT([destination]) ALIAS destination ENDIF The

RE: Stumbling block... Comparing indexes

2012-05-22 Thread Richard Kaye
...@leafe.com Subject: Re: Stumbling block... Comparing indexes oops no... I gave you the wrong expression there. Mike On 22/05/2012 3:37 PM, Richard Kaye wrote: > IF FILE(lcSource) > USE (lcSource) IN SELECT([source]) ALIAS source endif > > IF FILE(lcDestination) > USE

RE: how best to scroll results

2012-05-22 Thread Richard Kaye
There's always the old INKEY() trick for making things pause temporarily. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of James Harvey Sent: Tuesday, May 22, 2012 3:16 PM To: profoxt...@leafe.com Subject: RE: how best to scr

RE: IMAGES IN REPORT

2012-05-25 Thread Richard Kaye
Using your favorite image editor, remove the metadata in the JPG (EXIF). If you need to do this often, you might want to invest in a tool to do it. I used a program called ExifCleaner some years ago when I needed to do this to thousands of pictures. http://www.superutils.com/products/exifclea

RE: Grid Print

2012-05-25 Thread Richard Kaye
I have this vague recollection that there are "viewport" properties that give you the coordinates of the viewable portion of the grid. So some calculation of the viewing area divided by the row height should give you the number of visible rows. From there it should be possible to extract the dat

RE: Problem upgrading project from VFP6 to VFP9

2012-05-30 Thread Richard Kaye
If the project opens OK, you can try the clean up project command on the project menu and see if that fixes your problem. Use COPY TO... or a SQL SELECT statement to make a new copy. Remember you may need to rename the file extensions since VFP expects PJ? Michael's suggestion to create a new p

RE: cannot get past prerequisites in vfp9 install

2012-05-30 Thread Richard Kaye
Are you running the installer as administrator? -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of jerry foote Sent: Wednesday, May 30, 2012 4:01 PM To: profoxt...@leafe.com Subject: cannot get past prerequisites in vfp9 instal

RE: cannot get past prerequisites in vfp9 install (solved)

2012-05-31 Thread Richard Kaye
Ah. Right. The other way to do it is copy the everything to your local hard drive and run the install from there. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of jerry foote Sent: Wednesday, May 30, 2012 5:26 PM To: profoxt.

RE: Screen resolution, scroll bars, etc

2012-06-13 Thread Richard Kaye
Look at SYSMETRIC() in the VFP help. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt Wendt Sent: Wednesday, June 13, 2012 4:49 PM To: profoxt...@leafe.com Subject: RE: Screen resolution, scroll bars, etc Hey Folks, I k

RE: Accessing Form Objects Numerically...

2012-06-21 Thread Richard Kaye
PEMSTATUS is also your friend when you're iterating through a controls collection. For example, non-visual controls may not have a Visible property. So you can test for the existence of the PEM before trying to manipulate something that isn't there. -- rk -Original Message- From: profo

RE: Accessing Form Objects Numerically...

2012-06-21 Thread Richard Kaye
ep along the lines of the KISS rule... -K- -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Thursday, June 21, 2012 11:08 AM PEMSTATUS is also your friend when you're iterating through a controls collection. Fo

RE: fuzzy on return

2012-06-22 Thread Richard Kaye
Does CALLRemote return a value? If so, you might be able to do something like this: PRIVATE returnValue DO c:\alldat2\programs\CALLRemote WITH 'c:\alldat\irctrl\amp-volup.ir' TO returnValue IF returnValue REPLACE mediaindex.volume WITH mediaindex.volume -0.5 ELSE MESSAGEBOX([I'm

RE: fuzzy on return

2012-06-22 Thread Richard Kaye
I hate it when you correct me, Tracy. Even if you are right... ;) Mea culpa, Gary. As Tracy says, you would need to use SET PROCEDURE and then call your routine as a function. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of

RE: fuzzy on return

2012-06-25 Thread Richard Kaye
And just in case I've added to the confusion with my pseudo-code, you don't have to put up the messagebox when your function call does not return .t. SET PROCEDURE TO "c:\alldat2\programs\CALLRemote" ADDITIVE Local returnValue returnValue = CALLRemote('c:\alldat\irctrl\amp-volup.ir') IF returnVal

RE: [NF] Business Notebook Recommendations

2012-06-26 Thread Richard Kaye
IIRC Asus OEMs a good chunk of Dell's systems. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff Johnson Sent: Tuesday, June 26, 2012 12:45 PM Subject: Re: [NF] Business Notebook Recommendations On 06/26/2012 08:41 AM, Te

RE: Repair vcx

2012-06-27 Thread Richard Kaye
It depends on the type of corruption. Can you open the VCX as a table? -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Graham Brown Sent: Wednesday, June 27, 2012 8:59 AM To: profoxt...@leafe.com Subject: Repair vcx Hi all

RE: Repair vcx

2012-06-27 Thread Richard Kaye
That means the memo portion of the table has a problem. You're going to need a more sophisticated tool such as Abri Recover to repair memo corruption and restoring from a recent backup, if you have one, will be the fastest route. -- rk -Original Message- From: profoxtech-boun...@leafe.

RE: [NF] Buying software online (grumble)

2012-06-27 Thread Richard Kaye
I've upgraded my Parallels a few times. If you don't get that, you have a relatively limited window for downloading the installer and no recovery option once that window passes. It's basically insurance and IIRC you can just uncheck the box before finalizing your purchase. -- rk -Original

RE: Sending E-mails from VFP

2012-06-29 Thread Richard Kaye
The Fox wiki has some good articles summarizing the various options for programmatically sending email. http://fox.wikis.com/wc.dll?Wiki~AutomatedEmail~VFP -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of John Harvey Sent: F

RE: [NF] Kids toy becomes real

2012-07-02 Thread Richard Kaye
I've got to make time to watch this... -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Monday, July 02, 2012 11:54 AM To: profoxt...@leafe.com Subject: [NF] Kids toy becomes real

RE: [NF] Look what we found

2012-07-02 Thread Richard Kaye
Pete, you've sunk to a new low. This is one "kike" who really doesn't appreciate your use of that term. Keep your slurs to yourself. Better yet, why don't you go just hang out somewhere else when you feel the urge to share your personal prejudices. I'm sure that Iranian website where Stephen fou

RE: [NF] Look what we found

2012-07-02 Thread Richard Kaye
Pete Theisen Sent: Monday, July 02, 2012 3:48 PM To: profoxt...@leafe.com Subject: Re: [NF] Look what we found On 07/02/2012 03:30 PM, Richard Kaye wrote: Hi Richard, ROFL! Don't you know by now this is all in fun? ___ Post Messages to: ProFox@

RE: [ADMIN] Abuse on the lists

2012-07-02 Thread Richard Kaye
Thanks. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ed Leafe Sent: Monday, July 02, 2012 5:01 PM To: profoxt...@leafe.com Subject: [ADMIN] Abuse on the lists I have received a flood of complaints from list member

RE: [ADMIN] Abuse on the lists

2012-07-02 Thread Richard Kaye
I don't know if he does know better, Ted. People who regularly spew like that rarely do seem to understand why others are less amused. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche Sent: Monday, July 02, 2012 5:0

RE: [NF] Look what we found

2012-07-03 Thread Richard Kaye
I've had one for a while but somehow he still creeps back in. Probably my lack of expertise with, as I like to call it, Stupid Outlook. IAC it's being handled at the front gate now. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Beh

RE: report problem

2012-07-10 Thread Richard Kaye
And since no one has mentioned it yet, if the printer environment is saved in the FRX, this can result in the reported behavior when the stored printer reference does not exist. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf

RE: report problem

2012-07-10 Thread Richard Kaye
And it is spelled "irate", with one R. (Brought to you by the spelling and grammar matter department. ) :) -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Michael Oke, II Sent: Tuesday, July 10, 2012 2:37 PM To: profoxt...

RE: report problem

2012-07-10 Thread Richard Kaye
One more thing occurs to me about this. And it actually happened to me on my work network. Some kind of glitch at the domain level kept resetting my default printer. IIRC at least once it got set to a file based printer (i.e. the Windows equivalent of a PDF driver). When this happened, I would g

RE: VFP9-Reporting

2012-07-12 Thread Richard Kaye
I posted a little utility prg to the uploads section here a long time ago that strips the printer specific stuff out of a single FRX or an entire folder. There's a bug in the report designer that will flip the printer environment back on. Doug Hennig blogged about it some time ago and posted a

RE: [NF] Small fixed dialogue box in MS SQL Server Mgmt Studio (2008 R2)

2012-07-12 Thread Richard Kaye
Try scripting and a text editor, Mike. You can make the window as big as you want... -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Thursday, July 12, 2012 10:14 AM To: profoxt...@leafe.com

RE: SQL & Grouping Problem...

2012-07-18 Thread Richard Kaye
If you have enginebehavior 80 or 90, VFP will expect conformance to ANSI standard for grouping. You need to add aggregate functions to the non-grouped columns or add those columns to the group as Mr. Jarvis suggested. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:p

RE: What was that old trick for getting Intellisense to work in a PRG class with THIS. references?

2012-07-18 Thread Richard Kaye
LOCAL myvar AS [myclass.myobject] You have to have "set classlib to myclass" in scope. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Wednesday, July 18, 2012 3:39 PM To: profoxt...@leafe.co

RE: Max screen

2012-07-23 Thread Richard Kaye
Are you using the XFRX previewer? If not, I'd suggest looking into using that. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Sytze de Boer Sent: Saturday, July 21, 2012 3:19 AM To: profoxt...@leafe.com Subject: Re: Max scr

RE: SYS(3054)

2012-07-24 Thread Richard Kaye
Do you possibly have SET ECHO ON? I have used this without any screen echoes in a prg. SYS(3054,12,[cResults]) Query blah blah blah cresults=CR+CR+[Query ran in ]+TRANSFORM(nEnd-nStart)+[ seconds.]+CR+cresults STRTOFILE(cresults, [c:\rfc\sys3054.txt],1) MODIFY FILE [c:\rfc\sys3054.txt] NOWAIT --

RE: VFP9 SP2 weird issue on Win 7 x64 SP1

2012-07-25 Thread Richard Kaye
On my system, the dropdown orientation appears to be relative to the location of the method window. If it's lower down, the dropdown is a dropup... :) The tipping point location seems to be the top of the method window is roughly 3/4 from the top of the display. I'd be looking at display driver

RE: Logo

2012-07-26 Thread Richard Kaye
Until your table/memo gets corrupted. :) Or simply put the image file in the same folder as your reports. Make sure you size/format it to the exact print dimensions as opposed to allowing VFP to size the image. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxt

RE: Logo

2012-07-26 Thread Richard Kaye
Hey Jeff, No offense intended. In theory, you have potential performance differences between opening the table, locating the right row, grabbing the data from the memo and finally saving it back to disk. My suggestion is you can bypass all that by simply referring to the file that's already t

RE: Logo

2012-07-26 Thread Richard Kaye
Hi Bryant, Try this topic in the VFP help file How to: Add Pictures to Reports -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Bryant Minard Sent: Thursday, July 26, 2012 11:11 AM To: profoxt...@leafe.com Subject: Re: Logo

RE: Logo

2012-07-26 Thread Richard Kaye
Good to know. I wasn't sure and if I'm going to be offensive, I want it to be explicit... The performance comment was more theoretical in nature. I expect that in practical terms it's nil. But as Ted always says, you have to test these things in the proper environment to know for sure. I do

RE: Logo

2012-07-26 Thread Richard Kaye
Now you're just being cruel... ;-) -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ed Leafe Sent: Thursday, July 26, 2012 11:38 AM To: profoxt...@leafe.com Subject: Re: Logo Is there anyone still using VFP who is ne

RE: VFP data and VPN

2012-07-30 Thread Richard Kaye
If you are connected to the remote computer via RDP and your connection is configured to share your local resources in the RDP session, you can connect to a share on your computer and copy files that way. In a command window in the RDP session, it would look like this: net use x: \\tsclient\c\m

RE: Getting the My Documents folder

2012-07-31 Thread Richard Kaye
Here's something we've been using for a while that uses the Windows API. Don't know where we pinched it from or if it's better... FUNCTION GetSpecialFolderLocation(m.nFolderID AS Integer, m.lCreateNew AS Boolean) * Some common folder ids (refer to SHGetFolderPath in MSDN) #DEFINE CSIDL_PERSONAL

RE: PEM Code Editor version 7.11 bug

2012-07-31 Thread Richard Kaye
I'd post this over on the Google Group for Thor. That's where Jim Nelson tends to hang out. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Tuesday, July 31, 2012 1:25 PM To: profoxt...@leafe

RE: PEM Code Editor version 7.11 bug

2012-07-31 Thread Richard Kaye
foxt...@leafe.com Subject: Re: PEM Code Editor version 7.11 bug On 7/31/2012 1:39 PM, Richard Kaye wrote: > I'd post this over on the Google Group for Thor. That's where Jim Nelson > tends to hang out. CodePlex wouldn't be enough? I had put it ther

RE: PEM Code Editor version 7.11 bug

2012-07-31 Thread Richard Kaye
Software Solutions, LLC Sent: Tuesday, July 31, 2012 2:17 PM To: profoxt...@leafe.com Subject: Re: PEM Code Editor version 7.11 bug On 7/31/2012 1:43 PM, Richard Kaye wrote: > Maybe. There are GGs for Thor & GoFish that I tend to monitor more than the > VFPX forums. Does that mean yo

RE: Client manager?

2012-08-01 Thread Richard Kaye
IIRC Dave Crozier was working on a Lotus Organizer(?) clone in VFP? But that was a long time ago. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche Sent: Wednesday, August 01, 2012 10:47 AM To: profoxt...@leafe.com S

RE: corrupted table and database issues

2012-08-07 Thread Richard Kaye
Did you use the RECOVER option when executing VALIDATE DATABASE? Make sure you have a copy of the table, index and memo, if any. Once the DBC is repaired, you may be able to simply ADD TABLE. If the recover does remove the table reference from the DBC, you will need to re-establish any metadata

RE: Field Width

2012-08-07 Thread Richard Kaye
I believe the 6 would include the decimal point so for positive values it should be 999.99. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of John Weller Sent: Tuesday, August 07, 2012 4:22 PM To: profoxt...@leafe.com Subjec

RE: Field Width

2012-08-07 Thread Richard Kaye
) I would have expected an error on the larger numbers. Richard Kaye Vice President, Auction House Systems Artfact/RFC Systems Voice: 617.746.9838 Fax: 617.746.9801 For the fastest response time, please send your support queries to: Technical Support - techsupp...@rfcsystems.com Internet

RE: Query taking 4 minutes...ugh

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

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

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

RE: Query taking 4 minutes...ugh

2012-08-17 Thread Richard Kaye
Good spot, Bill! -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Bill Anderson Sent: Friday, August 17, 2012 12:29 AM To: profoxt...@leafe.com Subject: Re: Query taking 4 minutes...ugh Store the AddBS() function and the cCla

RE: just installed vfpro-9

2012-08-17 Thread Richard Kaye
Rick Schummer has a good whitepaper on maintaining multiple versions of VFP 9 installed. You may be able to apply some of his techniques. http://www.whitelightcomputing.com/resources/VFP9AllVersionsOnOneComputer.pdf -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:pr

RE: Help!! With grid event .AfterRowColChange

2012-08-22 Thread Richard Kaye
Containership rules... Create a method in either the grid itself or its parent (form? Class?) to handle grid clicks and use BINDEVENTS as needed. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Wednesd

RE: Help!! With grid event .AfterRowColChange

2012-08-22 Thread Richard Kaye
ASSERTS are a better way to invoke the debugger than SET STEP ON as they will not cause errors in a runtime environment. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Rafael Copquin Sent: Wednesday, August 22, 2012 2:01 PM

RE: Help!! With grid event .AfterRowColChange

2012-08-22 Thread Richard Kaye
Allen Sent: Wednesday, August 22, 2012 2:50 PM To: profoxt...@leafe.com Subject: RE: Help!! With grid event .AfterRowColChange Set step does not error, at least in VFP9 Al -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye

RE: Problem with Foxcharts

2012-08-24 Thread Richard Kaye
The source for SYSTEM.APP is from the GDIPlusX project at VFPX. http://vfpx.codeplex.com/releases/view/15083 -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul Newton Sent: Friday, August 24, 2012 9:10 AM To: profoxt...@l

RE: VFP9-Word/Excel licence

2009-08-26 Thread Richard Kaye
After the book, I found the best thing to do is work with the objects at the command prompt. The trick with that last one was finding out about the GetNameSpace method. After that, I let Intellisense do its thing. The code snippet I posted does not bring up any security warnings; at least on m

RE: VFP9-Word/Excel licence

2009-08-27 Thread Richard Kaye
And while it seems universal, not everyone uses Outlook so reading that data from the Outlook object could be inaccurate or missing entirely. rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Tracy Pearson Sent: Thursday, August

ctl32

2009-08-27 Thread Richard Kaye
Anyone using these classes in production and if so, which version are you using? TIA rk ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/

RE: ctl32

2009-08-27 Thread Richard Kaye
Thanks, Malcolm. I've been playing with the balloontip and progressbar. Carlos has indeed done a great job with this but I'm a little concerned that the project may be an orphan. I ran into an issue with the release from last September available from his site and traced it down to a function tha

RE: ctl32

2009-08-27 Thread Richard Kaye
Thanks for the update, Rick. I knew based on my Foxrockx sub that you were using these controls and hoped you might chime in. Have any other wisdom about deploying these classes, besides what you've already shared in your articles you care to add here? I hope Carlos gets back on his feet soon.

RE: [NF] A Mac Story

2009-08-31 Thread Richard Kaye
IIRC almost any Mac purchased after June 8 is eligible for the $9.95 Snow Leopard upgrade, as opposed to the $29. http://www.apple.com/macosx/uptodate/ Using this link, I was able to complete the process without resorting to 20th century technology like fax machines... rk -Original Mes

RE: ctl32

2009-08-31 Thread Richard Kaye
Thanks for the reply. Which version are you using? rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Andrew MacNeill Sent: Monday, August 31, 2009 5:31 AM To: profoxt...@leafe.com Cc: profoxt...@leafe.com Subject: Re: ctl32 I've

RE: ctl32

2009-09-02 Thread Richard Kaye
After trying to just cherry pick the progressbar class, I came to the conclusion I should just use the statusbar class as progressbar is embedded in that. I've had a few bumps along the way and the best piece of advice I can offer so far is to make sure you have recompiled the prgs and classes w

RE: ctl32

2009-09-02 Thread Richard Kaye
Thanks, Rick. I'll try that. And thanks again for the FoxRockx article. It has been very helpful. rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Rick Schummer Sent: Wednesday, September 02, 2009 11:33 AM To: profoxt...@leafe.c

RE: How to detect if digits in phone field?

2009-09-02 Thread Richard Kaye
In addition to Frank's suggestion, you can use ISDIGIT to walk the string or use regex. rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Wednesday, September 02, 2009 2:04 PM To: profoxt...@leaf

RE: How to detect if digits in phone field?

2009-09-02 Thread Richard Kaye
Still sounds like a job for regex to me... That's way more flexible (and complicated) than using chrtran. rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Wednesday, September 02, 2009 4:12 PM To

RE: VFP has a STRANGLEHOLD on My FXP...

2009-09-03 Thread Richard Kaye
Sounds puzzling indeed. Any possibility you don't have delete permission in the folder the fxp lives in? Is it possible there is another fxp with the same name in the execution path? Can you run something like filemon and see what processes have a handle to the fxp? rk -Original Message--

RE: VFP9SP1 included SCXs not being found when run

2009-09-17 Thread Richard Kaye
Silly question time. Are you sure it's in the project? Using macro expansion would mean you have to manually add the form to your project. rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions General Account S

RE: [NF] Outlook mass-emailing question

2009-09-18 Thread Richard Kaye
I'd advise her to ask you to write a program to extract the email addresses from the ~70 replies and build a distro list for her that she can you use in her reply. Or she could use VB inheritance, I mean copy and paste, to get the addresses. You did ask... And it's Friday... rk -Original

RE: VFP9 SP2 Runtime Installer

2009-09-22 Thread Richard Kaye
I have a copy of the last one they made, which does not include the SP2 hotfix, afaik. I can send it to you if you have an account that allows relatively large file attachments or an ftp site I can connect to. Anybody heard from Woody (who used to lurk here, iirc) or know what happened to them?

<    3   4   5   6   7   8   9   10   11   12   >