RE: Extreme Case of PRG File Corruption?

2014-10-09 Thread Richard Kaye
: Extreme Case of PRG File Corruption? At 08:36 2014-10-08, Richard Kaye rk...@invaluable.com wrote: Another memory lapse on my part... ;-) I still think ASSERTS are way better than SET STEP as you can define logical conditions that give you the opportunity to invoke the debugger on demand

RE: Extreme Case of PRG File Corruption?

2014-10-09 Thread Richard Kaye
I believe the Resize event is a wee bit of a misnomer as I believe it fires even if you simply move the form. Also, closing the form container is resizing it from that POV. But if you use the event logging mechanism you can definitively prove or disprove my bold assertion. ;-) -- rk

RE: FTP_Send_File

2014-10-14 Thread Richard Kaye
Do you know the appropriate flag value for setting active vs. passive mode? Sometimes one works better than the other. You didn't say so I'll ask; how big is the file you are trying to FTP? Can you test with a nice small file and see what happens? Westwind Client Tools

RE: FTP_Send_File

2014-10-15 Thread Richard Kaye
Were you able to find a way to change passive/active mode? -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kevin Cully Sent: Wednesday, October 15, 2014 1:25 PM To: profoxt...@leafe.com Subject: Re: FTP_Send_File File does not exist on the

RE: Anyone see this?

2014-10-16 Thread Richard Kaye
I see you, Lew. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Lew Schwartz Sent: Thursday, October 16, 2014 4:54 PM To: profoxt...@leafe.com Subject: Anyone see this? or am I behind the too many bounces/gmail wall? -Lew Schwartz

RE: Office 365 and Office Automation?

2014-10-16 Thread Richard Kaye
Yes and yes. Sadly I don't recall the precise details. IIRC there's the equivalent of an installable desktop version. If I can locate anything more concrete I'll let you know. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche Sent:

RE: Strange pdf behaviour

2014-10-21 Thread Richard Kaye
In XFRX (and therefore I assume any PDF writer implementation) you can embed all fonts used, embed only the specific characters used in your text (to reduce the final file size) or don't embed fonts at all, which should give you the smallest PDF file. In the latter case the I believe PDF reader

RE: Excel Driver Not Working - Begging for Help!

2014-11-19 Thread Richard Kaye
It definitely has to be the 32 bit version of Office for the automation stuff to work. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff Johnson Sent: Wednesday, November 19, 2014 11:46 AM To: profoxt...@leafe.com Subject: Re: Excel Driver

RE: Excel Driver Not Working - Begging for Help!

2014-11-19 Thread Richard Kaye
Other general Office memories: In some versions of Office MS crippled/removed the automation interface. Good luck figuring that out... Click to run or 1st time use install option will cause problems. Do a full install. -- rk -Original Message- From: ProfoxTech

RE: VFP9 development environment

2014-11-19 Thread Richard Kaye
Check the DOCK WINDOW topic in the help file. I use an intellisense shortcut when I do want my command window docked. Dockable windows can be very nice when you have multiple monitors as you can move the docked windows outside of the main VFP window. For example, in my main dev environment I

RE: Remote desktop

2014-11-21 Thread Richard Kaye
Hi Dave, I have to say I had noticed your absence on the list here. Sorry to hear about your travails and very happy to hear that you are feeling better. Now that I've finished with my digression vbg, do you have an URL handy for Splashtop Business? -- rk -Original Message- From:

RE: VFP9 development environment

2014-11-26 Thread Richard Kaye
to see if there's any problem there. I would bet that deleting the Foxuser.dbf would resolve the problem, but then you loose the command history, etc. Mike Richard Kaye wrote: Check the DOCK WINDOW topic in the help file. I use an intellisense shortcut when I do want my command window docked

RE: [NF] Supporting remote clients

2014-12-01 Thread Richard Kaye
OK. I've been biting my tongue reading this thread but I can't take it anymore... :-) set soapbox on As a group of very smart people who make a living selling and supporting custom software solutions, I don't understand the reluctance to pay for a remote access/support product if the ROI is

RE: Powerbuilder

2014-12-03 Thread Richard Kaye
One of the first 3rd party reporting engines for VFP (Mind's Eye) was built in Power Builder. Dude's name was Rich something or other. A bit of a rocket scientist as I recall. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche Sent:

RE: Powerbuilder

2014-12-03 Thread Richard Kaye
at Whilfests. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Tracy Pearson Sent: Wednesday, December 03, 2014 12:29 PM To: profoxt...@leafe.com Subject: RE: Powerbuilder Richard Kaye wrote on 2014-12-03: One of the first 3rd party reporting

RE: (NF) Note storage, access, what do you use?

2014-12-11 Thread Richard Kaye
Maybe something like Trello? https://trello.com -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Mike Copeland Sent: Thursday, December 11, 2014 3:15 PM To: profoxt...@leafe.com Subject: (NF) Note storage, access, what do you use? All, I

RE: (NF) Note storage, access, what do you use?

2014-12-11 Thread Richard Kaye
I have a long time client who also used to use his spreadsheet program as a word processor - Lotus 123... I made sure to send him the official Lotus 123 funeral notice that IBM sent out earlier this year. rofl -- rk -Original Message- From: ProfoxTech

RE: Moving VFP9 sp2

2014-12-17 Thread Richard Kaye
Many of the VFP tools you might have customized keep their settings in DBFs. For example, the primary tools I use are Intellisense, the Environment Manager in the Task Pane and the Toolbox. All these DBFs that can be backed up and restored in a migration. Also, all the stuff you see in

RE: SDT Index Problem

2015-01-26 Thread Richard Kaye
Possible DBC or CDX corruption? What happens when you run VALIDATE DATABASE? -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff Johnson Sent: Monday, January 26, 2015 1:42 PM To: profoxt...@leafe.com Subject: SDT Index Problem I have a set

RE: VFP 9 Install problem

2015-02-04 Thread Richard Kaye
Mine is in the xsource folder. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave Crozier Sent: Wednesday, February 04, 2015 7:29 AM To: profoxt...@leafe.com Subject: RE: VFP 9 Install problem Could someone tell me where wizctrl.vcx is

RE: using select in a case

2015-01-20 Thread Richard Kaye
INDEXSEEK() will also return .t. or .f. if a matching row is found without moving the record pointer, allows you to pick the index to use, and is Rushmore aware. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave Crozier Sent: Tuesday,

RE: using select in a case

2015-01-20 Thread Richard Kaye
It can if you use a VFP UDF. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Man-wai Chang Sent: Tuesday, January 20, 2015 12:20 PM To: profoxt...@leafe.com Subject: Re: using select in a case A SQL SELECT also doesn't move the record

RE: using select in a case

2015-01-20 Thread Richard Kaye
for this case was what I was after. I'm not anti UDF. I do use them elsewhere Why do you say use a UDF? I don't need the pointer to remain in my case. Al -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: 20 January 2015 18:34 To: profoxt

RE: using select in a case

2015-01-20 Thread Richard Kaye
, Richard Kaye wrote: It can if you use a VFP UDF. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Man-wai Chang Sent: Tuesday, January 20, 2015 12:20 PM To: profoxt...@leafe.com Subject: Re: using select in a case A SQL SELECT also doesn't

RE: boy, I'm rusty

2015-01-21 Thread Richard Kaye
Sticking that comma in your search string may have unintended consequences. I know it was a one time and you're done but I just can't help myself... :-) I would dump all that trimming; city and state columns usually aren't so wide that you need to worry about storage in the DB or the overall

RE: boy, I'm rusty

2015-01-21 Thread Richard Kaye
Why are you trimming your index values? IIRC you need to have your search expression match your index tag. So dump the RTRIMs on the tag or add the RTRIMs to your SEEK. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Virgil Bierschwale

RE: [NF] Windows 10

2015-01-21 Thread Richard Kaye
Painless? Sure. Quick? Not exactly... But maybe the Google has wired your town... ;-) -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Malcolm Greene Sent: Wednesday, January 21, 2015 6:32 PM To: profoxt...@leafe.com Subject: Re: [NF] Windows

RE: Return Numbers from String

2015-01-16 Thread Richard Kaye
The truly sad part is I remembered that you had offered a solution to that problem years ago when the question came in this time. I think I even have it saved in my local Profox archives. I thought about searching the archives but noticed that Tracy has come up with the same answer. Nice sig

RE: How do I configure VFP to find UDFs in a library folder?

2015-01-27 Thread Richard Kaye
You may not have a config.fpw setting your path but you can also do that via Tools-Options. You can also check your current path with ?SET({Path]) at the command prompt. I personally have found great utility in the Environment Manager which is found via the Task Pane Manager. It's pretty easy

RE: function to convert currency formated data in a text field

2015-01-27 Thread Richard Kaye
I admit I just did ?VAL(-123). I did not try with a negative currency value. But Stephen's question didn't format his test string with a minus sign either. As Gene points out, reading the fine manual should eliminate any ambiguity. :-) -- rk -Original Message- From: ProfoxTech

RE: How do I configure VFP to find UDFs in a library folder?

2015-01-28 Thread Richard Kaye
the trick - works great! Thanks again - Joe On Tue, Jan 27, 2015 at 8:35 PM, Richard Kaye rk...@invaluable.com wrote: You may not have a config.fpw setting your path but you can also do that via Tools-Options. You can also check your current path with ?SET({Path]) at the command prompt. I

RE: function to convert currency formated data in a text field

2015-01-27 Thread Richard Kaye
in a text field On Tue, Jan 27, 2015 at 10:34 AM, Richard Kaye rk...@invaluable.com wrote: VAL returns a numeric from a text representation of numbers and IIRC is also smart enough to handle currency character. Is there a built in FoxPro function to convert a text field containing ($123.45

RE: function to convert currency formated data in a text field

2015-01-27 Thread Richard Kaye
VAL returns a numeric from a text representation of numbers and IIRC is also smart enough to handle currency character. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe Yoder Sent: Tuesday, January 27, 2015 11:32 AM To:

RE: function to convert currency formated data in a text field

2015-01-27 Thread Richard Kaye
And the answer is yes. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Tuesday, January 27, 2015 12:06 PM To: profoxt...@leafe.com Subject: RE: function to convert currency formated data in a text field I don't know. That's

RE: VFP to SQL Server Migration

2015-02-09 Thread Richard Kaye
I thought I ran this against a 2008 R2 engine with the VFPx version but it's possible I just used the workaround mentioned by Matt. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Matt Wiedeman Sent: Monday, February 09, 2015 9:56 AM To:

RE: VFP Love/Hate Relationship

2015-02-09 Thread Richard Kaye
Since your select is on a single table, try removing the table.field ref? -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff Johnson Sent: Monday, February 09, 2015 1:18 PM To: profoxt...@leafe.com Subject: VFP Love/Hate Relationship Okay,

RE: VFP Love/Hate Relationship

2015-02-09 Thread Richard Kaye
] On Behalf Of Jeff Johnson Sent: Monday, February 09, 2015 1:42 PM To: profoxt...@leafe.com Subject: Re: VFP Love/Hate Relationship Same result Richard. I exclusively use arrays as my rowsources so I will try an array and report back. Thanks, On 2/9/2015 11:39 AM, Richard Kaye wrote: Since your

RE: VFP Love/Hate Relationship

2015-02-09 Thread Richard Kaye
, Richard Kaye wrote: Just curious, you got rid of it in both the column list and the WHERE clause? When does the cursor get created? Could this be similar to changing the data source of a grid after its initial creation? -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun

RE: [NF] Unreliable MySQL select

2015-02-09 Thread Richard Kaye
Is it possible you have NULLs in pw_1? The most logical thing that comes to mind is the exceptions are not returning the expected data type. Does MySQL have the equivalent of the VFP NVL() function? -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On

RE: VFP to SQL Server Migration

2015-02-09 Thread Richard Kaye
I recently used the VFPX upsizing wizard and don't recall that particular gotcha. There were others such as null support on Boolean columns but it ultimately did work. Because we have the source I was able to make a few tweaks, not to mention run through the debugger so I could figure out what

RE: Inspect Returned Object

2015-02-13 Thread Richard Kaye
If you want to leverage the joy of VFP you've got XMLTOCURSOR. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff Johnson Sent: Friday, February 13, 2015 1:53 PM To: profoxt...@leafe.com Subject: Inspect Returned Object I am calling a web

RE: Internal Consistency Error

2015-03-20 Thread Richard Kaye
The CDX was somehow corrupted and in the process of getting hosed the duplicate primary key value was inserted. Once that happened you were toast until it was repaired. This reeks of unpatched SMB2/3 or out of date SMB2/3 patches. -- rk -Original Message- From: ProfoxTech

RE: [NF] How cheap is it to get SQL Server Developer? VERY

2015-03-11 Thread Richard Kaye
SQL Express is free to download and gives you the data engine. But it does not give you the management tools (i.e. SSMS or what us old guys refer to as Enterprise Manager) or the other bells whistles mentioned by Stephen. -- rk -Original Message- From: ProfoxTech

RE: [NF] How cheap is it to get SQL Server Developer? VERY

2015-03-11 Thread Richard Kaye
: [NF] How cheap is it to get SQL Server Developer? VERY On 3/11/2015 1:52 PM, Richard Kaye wrote: SQL Express is free to download and gives you the data engine. But it does not give you the management tools (i.e. SSMS or what us old guys refer to as Enterprise Manager) or the other bells

RE: Index Corruption / SMB

2015-03-11 Thread Richard Kaye
That's an interesting endorsement. I've been burned so many times by index or table corruption due to SMB issues that it's been really hard to trust MS when they say No, really. We've fixed it this time. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On

RE: [NF] SQL Server 2008 R2 Developer Version

2015-03-31 Thread Richard Kaye
SSMS = SQL Server Management Studio. This is actually the 2008 R2 version I just found. http://www.microsoft.com/en-us/download/details.aspx?id=22985 And then there's the 2014 download but it's not 100% clear to me if this is time limited in any way since the page refers to eval.

RE: [NF] SQL Server 2008 R2 Developer Version

2015-03-31 Thread Richard Kaye
Large is a relative term, Jeff. Does it exceed the capacities of the current Express version? If not, you should be able to just get that. And one change over time is they also make SSMS available to Express users. It used to be SSMS was not available so you got the engine but not the dev

RE: [NF] SQL Server 2008 R2 Developer Version

2015-04-01 Thread Richard Kaye
From the Words Have Meaning Department, there is no more Enterprise Manager, Jeff. :-) There is only SSMS. The learning curve shouldn't be too bad especially considering what you want to do. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of

RE: VFP 9 Install on Windows 10

2015-03-02 Thread Richard Kaye
Try installing the SOAP toolkit from the installation CD? -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Francis Coppage Sent: Monday, March 02, 2015 3:12 PM To: profoxt...@leafe.com Subject: VFP 9 Install on Windows 10 Hi Folks, Long

RE: Resizing

2015-02-25 Thread Richard Kaye
You might want to look into Markus Winhard's mwresize class. http://leafe.com/download/mwresize51.zip -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Chris Davis Sent: Wednesday, February 25, 2015 7:10 AM To: profoxt...@leafe.com Subject:

RE: Resizing

2015-02-25 Thread Richard Kaye
[mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: 25 February 2015 13:08 To: profoxt...@leafe.com Subject: RE: Resizing You might want to look into Markus Winhard's mwresize class. http://leafe.com/download/mwresize51.zip -- rk -Original Message- From: ProfoxTech

RE: Truncated Decimal Digits

2015-02-26 Thread Richard Kaye
Another potential gotcha is when you ROUND calculations using values that have more precision that your current SET DECIMALs setting. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche Sent: Thursday, February 26, 2015 8:02 AM To:

RE: [NF] Pros/cons of using a standup desk, recommendations on standup/adjustable height desks

2015-02-26 Thread Richard Kaye
Nice! I've got to walk that one around the office here... -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Gene Wirchenko Sent: Thursday, February 26, 2015 1:33 PM To: profoxt...@leafe.com Subject: Re: [NF] Pros/cons of using a standup desk,

RE: Truncated Decimal Digits

2015-02-26 Thread Richard Kaye
I'm you have DECIMALS set to 2 but I can't recall what you wrote in the original post. :-) My rough guess would be that the last digit is showing up because the TRANSFORM picture clause includes 3 places and it gets applied after DECIMALS does its magic. If you change your TRANSFORM to 4

RE: FoxproDOS - No APP after BUILD APP

2015-03-26 Thread Richard Kaye
What's in the err file? -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kevin Cully Sent: Thursday, March 26, 2015 3:11 PM To: profoxt...@leafe.com Subject: FoxproDOS - No APP after BUILD APP Hello Foxpro for DOS gods. Me again. I believe

RE: SQL Group By Question

2015-01-30 Thread Richard Kaye
IIRC DISTINCT is not Rushmore aware and will force a table scan. Group by is Rushmore aware so depending on the number of rows in your table and the presence of a matching index your performance mileage will vary. And let's not forget that if the data supports NULLs you may get some different

RE: Print Notification

2015-04-24 Thread Richard Kaye
Do you have a copy of the What's New in Nine book? There's a section using a reportlistener to monitor progress. IIRC I think there's also a SYS() function that indicates the preview vs. printed status. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On

RE: Print Notification

2015-04-24 Thread Richard Kaye
Check out SYS(2024) and SYS(2040). -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Friday, April 24, 2015 7:36 AM To: profoxt...@leafe.com Subject: RE: Print Notification Do you have a copy of the What's New in Nine book

RE: VFP 9: Peculiar Query Behaviour

2015-04-20 Thread Richard Kaye
Gene, If I'm reading this right, you are running a query without specifying an INTO clause? When you do this, VFP will call its result cursor QUERY which describes the behavior you are seeing. (SQL passthrough will call its result cursor SQLRESULT if you don't specify an alias.) Closing the

RE: Microsoft competing with Dabo now

2015-05-01 Thread Richard Kaye
IIRC Dabo was a Star Trek:DS9 reference... -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt Wendt Sent: Friday, May 01, 2015 12:24 PM To: profoxt...@leafe.com Subject: RE: Microsoft competing with Dabo now To be honest - I didn't really

RE: Error 1884 - Uniqueness of index ZTAX1 is violated

2015-04-29 Thread Richard Kaye
I believe Ted is referring to GETFLDSTATE(). -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche Sent: Wednesday, April 29, 2015 10:17 AM To: profoxt...@leafe.com Subject: Re: Error 1884 - Uniqueness of index ZTAX1 is violated Whenever

RE: Error 1884 - Uniqueness of index ZTAX1 is violated

2015-04-29 Thread Richard Kaye
- Uniqueness of index ZTAX1 is violated On Wed, Apr 29, 2015 at 10:42 AM, Richard Kaye rk...@invaluable.com wrote: I believe Ted is referring to GETFLDSTATE(). Yeah, it stinks to get old. That's it. -- Ted Roche ___ Post Messages to: ProFox@leafe.com

RE: Delay in USEing table on network causes errors, using VMs, Win7

2015-05-06 Thread Richard Kaye
Of course, Ted beat me to it. I'm wondering if the VFP2C library, which has LLIO functions in it, might be more reliable than the VFP FILE function? -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Wednesday, May 06, 2015

RE: New project on VFPx: Bin 2 Text extension

2015-05-06 Thread Richard Kaye
VFPx has been around for years, Kurt. Sadly, it has nothing to do with the core VFP engine being released open source. Happily, there are quite a few excellent tools, including Fernando's Foxbin2PRG, and I would highly recommend poking around there to look for items to add to your toolkit if

RE: Delay in USEing table on network causes errors, using VMs, Win7

2015-05-06 Thread Richard Kaye
There are registry settings that allow you to set the idle time for network resources on both servers and workstations, iirc. https://support.microsoft.com/en-us/kb/297684#LetMeFixItMyselfAlways -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf

RE: ProFox List Statistics for April 2015

2015-05-05 Thread Richard Kaye
Glenn, We had a wee bit of an explosion of crud due to everyone's amazement at the OT messages stat for the month. Then, as my Yiddisheh grandmother might have said, we called down the evil eye by saying whatever happened to I'm sure things will settle down again once the OT trolls have

RE: VFP, SccText CodeWright - Oh My...

2015-05-08 Thread Richard Kaye
Subject: RE: VFP, SccText CodeWright - Oh My... Is compfiles a utility built into VFP? Or is it part of this Merge utility you speak of?? -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Friday, May 08, 2015 3:37 PM To: profoxt

RE: VFP, SccText CodeWright - Oh My...

2015-05-08 Thread Richard Kaye
I have used a product called Araxis Merge for years and it supports COM automation. I wrote a VFP wrapper that instantiates the object, sets the necessary props and calls the appropriate method to compare. If there are diffs, it makes the object visible. If not, it just pops up a message box to

RE: VFP, SccText CodeWright - Oh My...

2015-05-08 Thread Richard Kaye
I've done enough automation stuff over the years that I like being able to type: DO compfiles WITH file1,file1 In the VFP command window. :-) I also think Merge is an excellent comparison tool and like recommending the product. -- rk -Original Message- From: ProfoxTech

RE: VFP9: Form Data Environment

2015-05-14 Thread Richard Kaye
...@leafe.com] On Behalf Of Richard Kaye Sent: 14 May 2015 20:03 To: profoxt...@leafe.com Subject: RE: VFP9: Form Data Environment You're always using at least one datasession; the default. Maybe it does an implicit select 0? To be honest I haven't really noticed. But I will pay more attention to see if I

RE: VFP9: Form Data Environment

2015-05-14 Thread Richard Kaye
should not more anything. Al -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: 14 May 2015 17:11 To: profoxt...@leafe.com Subject: RE: VFP9: Form Data Environment I'm not sure it changes the current workarea all on its own but I have

RE: VFP9: Form Data Environment

2015-05-14 Thread Richard Kaye
I'm not sure it changes the current workarea all on its own but I have found that it doesn't necessarily connect to the datasession of the form you may be debugging. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Allen Sent: Thursday, May

RE: SMB3, Op-Lock, and Free Tables

2015-05-13 Thread Richard Kaye
The only way you can change the OpLocks setting as far as I know is to use SMB1 and that means disabling SMB 2/3. Despite what I've seen here from some folks I greatly respect, indicating that MS has finally gotten this right, I still recommend to my clients that SMB v1 be enabled with OpLocks

RE: CopyToExcel (Craig Boyd)

2015-05-15 Thread Richard Kaye
Excel version number mismatch? -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul Newton Sent: Friday, May 15, 2015 10:16 AM To: profoxt...@leafe.com Subject: CopyToExcel (Craig Boyd) Hi all I have been using Craig's CopyToExcel function

RE: [NF] Recomendations for a developer laptop

2015-05-19 Thread Richard Kaye
Lots of USB ports. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Peter Cushing Sent: Tuesday, May 19, 2015 7:13 AM To: profoxt...@leafe.com Subject: Re: [NF] Recomendations for a developer laptop On 18/05/2015 12:32, Ted Roche wrote:

RE: [NF] Recomendations for a developer laptop

2015-05-19 Thread Richard Kaye
[mailto:profox-boun...@leafe.com] On Behalf Of Richard Kaye Sent: 19 May 2015 12:32 To: profox@leafe.com Subject: RE: [NF] Recomendations for a developer laptop Lots of USB ports. -- rk ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http

RE: Data Dictionary questions

2015-04-15 Thread Richard Kaye
I highly recommend the Super Browse tool from the VFPX Thor toolkit. It's been called browse on steroids. Point it at a table or cursor. It not only lets you browse the data; it's also got a UI that lets you pick the columns you want, etc and then generate various SQL fragments in VFP or SQL

RE: Data Dictionary questions

2015-04-15 Thread Richard Kaye
I'm sure it's not all that hard but the SB tool takes most of the effort out of it. Another way to approach it would be to use a DBC to create a local or remote view on the table in question. That also has a way to view the SQL generated. As always, there are at least 6 different ways in the

RE: Nulls

2015-04-15 Thread Richard Kaye
Just to be clear, are these DBFs created from SQL tables? If so, check the ALTER TABLE...ALTER COLUMN syntax for existing tables where you want to remove NULL support. Unlike SQL, I believe VFP will assign default values when you remove NULL support. Otherwise you may need to do what Stephen

RE: Data Dictionary questions

2015-04-15 Thread Richard Kaye
I don't think VFP allows spaces in long column names. But Access and other DBMSes do... If you create a remote view against an Access table VFP will substitute an underscore for any columns with spaces. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On

RE: Nulls

2015-04-15 Thread Richard Kaye
measurement for one test yet you should never average that same data with a 0. That column may be AttemptsMade. On Wed, Apr 15, 2015 at 2:12 PM, Richard Kaye rk...@invaluable.com wrote: Nope, MSSQL guy. ;-) VFP does that for you when you turn off nulls. It looks at the data type and puts

RE: Nulls

2015-04-15 Thread Richard Kaye
Nope, MSSQL guy. ;-) VFP does that for you when you turn off nulls. It looks at the data type and puts in a default value. Jeff, you will be able to script those structure updates using ALTER TABLE. Definitely faster than using the UI to MODI STRU. -- rk -Original Message- From:

RE: Nulls

2015-04-16 Thread Richard Kaye
Sure you're smart enough, Jeff . You're on the Profox list... ;-) NVL() is your friend and can make null checking/handling fairly trivial. And you need to handle nulls when you run queries using left or right joins; not just table structures. -- rk -Original Message- From: ProfoxTech

RE: Nulls

2015-04-16 Thread Richard Kaye
Hi Gene, You've already got your workarounds in place but for future reference this is where you can use NVL() in your SQL to avoid nulls that might arise from a left/right/outer join. SELECT t1.column1, NVL(t2.column2,0) column2, t1.column3... -- rk -Original Message- From:

RE: Data Dictionary questions

2015-04-15 Thread Richard Kaye
ADBOBJECTS() can also be useful. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jean MAURICE Sent: Wednesday, April 15, 2015 6:03 AM To: profoxt...@leafe.com Subject: Re: Data Dictionary questions Joe, have a look at AFIELDS() and COPY

RE: Nulls

2015-04-17 Thread Richard Kaye
Well this seems like the right time to share this one again. :-) https://xkcd.com/327/ -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul Hill Sent: Friday, April 17, 2015 12:05 PM To: profoxt...@leafe.com Subject: Re: Nulls I read this

RE: [NF] Win10 what you will lose in the OS update

2015-06-04 Thread Richard Kaye
I believe the answer is priceless. Maybe we can ask Bob... Or Clippie... -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche Sent: Thursday, June 04, 2015 1:28 PM To: profoxt...@leafe.com Subject: Re: [NF] Win10 what you will lose in the

RE: [NF] Win10 what you will lose in the OS update

2015-06-04 Thread Richard Kaye
Roche Sent: Thursday, June 04, 2015 1:40 PM To: profoxt...@leafe.com Subject: Re: [NF] Win10 what you will lose in the OS update On Thu, Jun 4, 2015 at 1:30 PM, Richard Kaye rk...@invaluable.com wrote: I believe the answer is priceless. Maybe we can ask Bob... Or Clippie... Thought of them, too

RE: Can I Beautify on the fly?

2015-06-05 Thread Richard Kaye
... Today's Topics:   1. zip/unzip (Rafael Copquin)   2. RE: zip/unzip (Kurt Wendt)   3. Re: zip/unzip (Mike Copeland)   4. Re: zip/unzip (Kevin Cully)   5. RE: [NF] Win10 what you will lose in the OS update (Richard Kaye)   6. Re: zip/unzip (Rafael Copquin)   7. Re: zip/unzip (Laurie Alvey)   8. Re: zip

RE: FW: Programatic moving of items in listbox

2015-06-04 Thread Richard Kaye
Pay attention to that FORCE option on DOEVENTS if you want Windows to not assume your application has gone unresponsive during some batch process. OTOH there can be some significant overhead if you just call it a lot. The strategy I've settled on when using DOEVENTS inside some kind of

RE: [NF] Win10 what you will lose in the OS update

2015-06-04 Thread Richard Kaye
Yes. g -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of John Weller Sent: Thursday, June 04, 2015 2:07 PM To: profoxt...@leafe.com Subject: RE: [NF] Win10 what you will lose in the OS update Is that Apple or M$ you are referring to? :-) John

RE: Grid Autofit

2015-06-18 Thread Richard Kaye
Have you tried refreshing the specific containers (i.e. the grid itself or the page or the pageframe)? -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kevin Cully Sent: Thursday, June 18, 2015 11:16 AM To: profoxt...@leafe.com Subject: Grid

RE: VFPX site down?

2015-06-25 Thread Richard Kaye
/maintenance cycle. Rick White Light Computing, Inc. www.whitelightcomputing.com www.swfox.net www.rickschummer.com -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Friday, June 19, 2015 11:18 To: profoxt...@leafe.com Subject: VFPX

VFPX site down?

2015-06-19 Thread Richard Kaye
Hey Rick, If you're lurking out there, do you know what's going on with the VFPX Codeplex site? -- rk --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to:

RE: VFPX site down?

2015-06-19 Thread Richard Kaye
2015). Support emails are down, so let us know issues via twitter! Regards.- 2015-06-19 17:17 GMT+02:00 Richard Kaye rk...@invaluable.com: Hey Rick, If you're lurking out there, do you know what's going on with the VFPX Codeplex site? -- rk

RE: Rushmore and JOINs

2015-06-26 Thread Richard Kaye
Check out SYS(3054). It can give you more insight into query optimization. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Philip Borkholder Sent: Friday, June 26, 2015 12:50 PM To: profoxt...@leafe.com Subject: Re: Rushmore and JOINs Thank

RE: ReportBuilder.app and VFPx

2015-06-19 Thread Richard Kaye
IIRC Doug Hennig has posted some report*.app fixes in his blog over the years. I believe these were discovered post SP2 which is another reason why it's good to have the source so you can update if the bugs he found affect your applications. -- rk -Original Message- From: ProfoxTech

RE: ReportBuilder.app and VFPx

2015-06-19 Thread Richard Kaye
PM To: profoxt...@leafe.com Subject: RE: ReportBuilder.app and VFPx Richard Kaye wrote on 2015-06-19: IIRC Doug Hennig has posted some report*.app fixes in his blog over the years. I believe these were discovered post SP2 which is another reason why it's good to have the source so you can

RE: Hacker's Guide still lives

2015-06-10 Thread Richard Kaye
I have to admit I haven't heard from Whil in a while but then again his target market is probably about the size of the active Profox list. And we should all already own our own copies of the HG, right? :-) Both versions... -- rk -Original Message- From: ProfoxTech

RE: Hacker's Guide still lives

2015-06-10 Thread Richard Kaye
The current version of the VFP 9 Help is a VFPX project and is now maintained by the community. Here's a link so Kurt doesn't yell at me again... ;-) http://vfpx.codeplex.com/wikipage?title=VFP%209%20SP2%20Help%20File -- rk -Original Message- From: ProfoxTech

<    8   9   10   11   12   13   14   15   16   17   >