Re: So, about this VFPA thing...
At 08:07 2019-11-26, Koen Piller wrote: OK alright. My first impression on Alan's remark was a negative, meaning negative in the sense of the product, like this product is a hack, it is no good to use. Now meanwhile I have looked around and found on Wiki an explication of 'hack' :* Hacking is finding applications that are not intended by the creator of the resource, especially with regard to computers. Complexity does not play a role here, on the contrary, easy and fast alternative solutions are preferred. The use of a clothes peg to prevent a trouser leg from coming between a bicycle chain is basically a hack. "Normal" inventions and improvements are therefore not hacks, as long as they are used for what they are made for.* This makes me think Alan is not correct and I conclude VFPA is an improvement. Besides, the history of Alan's use: since 1991, I am proud to tell you I was there before 1990, started with dBaseII jumped from dBaseIV to FoxPro for DOS into now VFP9SP2. Newbie! I started with dBASE II version 2.02 which was apparently the very first version. If it is modification of a binary, it is a hack. It might be a very good hack because of improvements it makes, but it is still a hack. Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: VFP Advanced (was Fwd: RE: Fatal error issuing CALCULATE command)
At 15:07 2019-11-21, "MB Software Solutions, LLC" On 11/21/2019 4:34 PM, Eric Selje wrote: > The Microsoft of 20 years ago probably would have complained, but they're a > different company now. Their take is basically "If you want to modify the > copy of VFP that you paid for, go for it." Yeah, the ballmer days (thankfully) are long gone. That guy sucked. What did he suck? Donkey balls? https://donkeyballstore.com/ Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Fatal error issuing CALCULATE command
At 08:17 2019-11-21, Eric Selje wrote: [snip] Sorry for hijacking your post, Eric, but the original post did not make it to me. On Thu, Nov 21, 2019 at 9:50 AM Paul Newton wrote: > Hi all > > I think I have come across a possibly undocumented limitation to the > maximum number of expressions in a CALCULATE command. In my case a fatal > error occurred when trying to CALCULATE the SUMs of 32 different fields in > a cursor. It took a while to establish what was going on, but when I > reduced the number of expressions to 31 the error no longer occurred. Which fatal error? There are many, and error messages are helpful. > Has anybody else encountered this issue? Many thanks How long is the source line? The limit is 8192. Are you running into that? Experimenting with long lines, the error I get is either Line is too long. if there is no .fxp and is not an object file. if there is one. Either way, there is no .err file generated even if I explicitly compile with the compile command. My client billing app has a source line that is close to 6K long in actual command, but it has line continuations and && comments. I have not experimented, but one of the two prevents the line from being too long as otherwise the source line would be just over 20K long. Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Exporting Tables
At 13:41 2019-11-06, Frank Cazabon wrote:
What parameters did you pass in? The syntax is:
CopyToExcel("C:\Test.xlsx", "Sheet1", "MyTable") This is the header
of the Function in the GridExtrasProcs.prg that I have and use:
FUNCTION CopyToExcel(tcXLSFile, tcSheet, tvWorkArea,
tcExcelFieldList, tcTableFieldList, tcTableForExpr)
Yup. I specified the spreadsheet (tried no directory and with
directory), a sheet name (both "export" and "Sheet1"), and both a
filename and an alias.
All I get is an empty spreadsheet, and the return value is 0
every time. No error messages either.
[snip]
Sincerely,
Gene Wirchenko
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: https://leafe.com/archives/byMID/
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
Re: Exporting Tables
At 12:08 2019-11-06, Koen Piller wrote: Each one has a test.prg I believe which one do you want to use? None of them. I want VFP to Excel. I found one, but I do not know how to use it. Bear in mind that I do not know how to use .SCX, etc. as I write nearly everything in text. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Exporting Tables
At 11:59 2019-11-06, Koen Piller wrote:
Hmm I have that one as well, still can you upload?
Done.
[snip]
Sincerely,
Gene Wirchenko
*!* Simple Sample Usage
*!* DIMENSION aWrkSht(1), aCols(1)
*!* m.lcXlsFile = GETFILE("Excel:XLS,XLSX,XLSB,XLSM")
*!* IF FILE(m.lcXlsFile)
*!* CLEAR
*!* ?AWorkSheets(@aWrkSht,m.lcXlsFile,.T.)
*!* ?AWorkSheetColumns(@aCols,m.lcXlsFile,"Sheet1")
*!* AppendFromExcel(m.lcXlsFile, "Sheet1", "MyTable", "column1,column2,column3", "Recnum Is Not
Null", "field1,field2,field3", "field1 > 14000")
*!* SELECT MyTable
*!* GO TOP IN "MyTable"
*!* BROWSE LAST NOWAIT
*!* ENDIF
*!* CopyToExcel("C:\Test.xlsx", "Sheet1", "MyTable") && try xls, xlsb, and
xlsm as well
**
FUNCTION AppendFromExcel(tcXLSFile, tcSheet, tvWorkarea, tcExcelFieldList,
tcExcelWhereExpr, tcTableFieldList, tcTableForExpr, tlNoHeaderRow)
**
* PARAMETER Information
* tcXLSFile := a string specifying an excel file (*.xls, *.xlsx,
*.xlsm, *.xlsb) on disk
* tcSheet := a string specifying the name of a worksheet within the
excel workbook (can also be a range Sheet1$A1:C20 for instance)
* tvWorkarea [optional] := the Alias, Work Area, or File Name of the
table you want the worksheet result set appended to (default is currently
selected Alias)
* tcExcelFieldList [optional] := a comma delimited list of columns you
want from the worksheet (default is '*' - all columns)
* tcExcelWhereExpr [optional] := a valid SQL Where clause to be used
when querying the worksheet (default is '1=1')
* tcTableFieldList [optional] := a comma delimited list of fields you
want the worksheet result set inserted into (default is '*' - all fields)
* tcTableForExpr [optional] := a valid VFP Where clause to be used when
querying the worksheet result set (cursor) (default is '.T.')
* tlNoHeaderRow [optional] := pass .T. if the worksheet does not
contain a header row, .F. is the default which specifies that a header row does
exist
*
* RETURN Information
* returns numeric, the number of records inserted into tvWorkArea
*
* Provider Information
* the default provider being used in the SQLStringConnect function can
be downloaded and installed from:
*
http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en
**
LOCAL lnSelect, laErr[1], laTableFields[1], laExcelFields[1],
lnFieldCounter, ;
lcSQLAlias, lnResult, lcInsertValues, lcFieldList,
lcNvlFieldList, ;
lcFieldType, lcExcelFieldType, lcNvlFieldName, lcTempAlias,
loExc, lnReturn, ;
lcHeaderRow, llOpenedtvWorkArea
m.lnSelect = SELECT(0)
m.lnReturn = 0
IF NOT FILE(m.tcXLSFile)
ERROR 1, m.tcXLSFile
ENDIF
IF !USED(m.tvWorkarea) AND TYPE("m.tvWorkArea") = "C" AND
FILE(DEFAULTEXT(m.tvWorkarea,"DBF"))
SELECT 0
USE (DEFAULTEXT(m.tvWorkarea,"DBF")) SHARED AGAIN
m.tvWorkarea = ALIAS()
m.llOpenedtvWorkArea = .T.
ELSE
IF !USED(m.tvWorkarea)
m.tvWorkarea = ALIAS()
ENDIF
ENDIF
IF TYPE("m.tvWorkArea") = "N"
m.tvWorkArea = ALIAS(m.tvWorkArea)
ENDIF
m.tcSheet = ALLTRIM(EVL(m.tcSheet,"Sheet1$"))
IF AT("$",m.tcSheet) = 0
m.tcSheet = m.tcSheet + "$"
ENDIF
m.tcExcelFieldList = EVL(m.tcExcelFieldList,"*")
m.tcExcelWhereExpr = EVL(m.tcExcelWhereExpr,"1=1")
m.tcTableFieldList = EVL(m.tcTableFieldList,"*")
m.tcTableForExpr = EVL(m.tcTableForExpr,".T.")
m.lcSQLAlias = SYS(2015)
m.lcTempAlias = SYS(2015)
m.lnSQL = 0
m.lcHeaderRow = IIF(EMPTY(m.tlNoHeaderRow), "Yes", "No")
TRY
SELECT (m.tvWorkarea)
m.lnSQL = SQLSTRINGCONNECT([Provider=Microsoft.ACE.OLEDB.12.0;Data Source="] +
m.tcXLSFile + [";Extended Properties="Excel 12.0 Xml;HDR=] + m.lcHeaderRow + [;";])
*!* Alternate using DSN that comes with Office install (MSDASQL
= OLEDB wrapper for ODBC)
*!* m.lnSQL
Re: Exporting Tables
At 08:01 2019-11-05, Koen Piller wrote: Vilhelm? Check his blog: https://support.google.com/mail/answer/41078?co=GENIE.Platform%3DDesktop&hl=nl --- http://praisachion.blogspot.com/2018/03/appendfromxlsx-31.html http://praisachion.blogspot.com/2017/08/importfromxlsx-40.html http://praisachion.blogspot.com/2016/06/appendfrompptx-10.html http://praisachion.blogspot.com/2016/06/importfromdocx-31.html http://praisachion.blogspot.com/2016/06/importfrompptx-11.html http://praisachion.blogspot.com/2016/02/import-dbf-from-msoffice-2007-xlsx-docx.html So I am exporting to Excel. I think I found the right one, but how do I use it? There are no docs. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Exporting Tables
[reordered to chronological] At 11:43 2019-11-06, Koen Piller wrote: Op wo 6 nov. 2019 om 20:36 schreef Gene Wirchenko : > At 06:08 2019-10-30, "Tracy Pearson" wrote: > >Gene, > > > >I have not seen a difference in the output of the two commands. > > > >You might want to consider looking at Craig Boyd's post about exporting > and > >importing from Excel. It doesn't mention Memo fields that I could see. > > > https://www.sweetpotatosoftware.com/blog/index.php/2008/09/30/using-excel-20 > >07-file-formats-in-vfp-9-0/ > > Have you tried it? All I got for results with CopyToExcel() > was an empty spreadsheet. No column headers, no rows. Gene, The instruction "CopyToExcel() is that Vilhelm's procedure? If so , please upload the file so that we investigate. No, it is off Craig Boyd's site, the URL above. Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Exporting Tables
At 06:08 2019-10-30, "Tracy Pearson" wrote: Gene, I have not seen a difference in the output of the two commands. You might want to consider looking at Craig Boyd's post about exporting and importing from Excel. It doesn't mention Memo fields that I could see. https://www.sweetpotatosoftware.com/blog/index.php/2008/09/30/using-excel-20 07-file-formats-in-vfp-9-0/ Have you tried it? All I got for results with CopyToExcel() was an empty spreadsheet. No column headers, no rows. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Exporting Tables
At 07:23 2019-10-31, Koen Piller wrote: Gene, Vilhelm made fabulous classes to export DBF tables with memofields in MSExcel, MSWord, MSAcces have you tried any of them already? No, I had never heard of them. Where are they? [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Exporting Tables
At 07:38 2019-10-30, Stephen Russell wrote: Why not Import from SQL Server or Access? You can then make a backup file from SQL or just copy the access one to give to others who cannot use Fox tables. Because the tables are VFP tables. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Exporting Tables
Hello: I am having to do a bunch of data export so have had a closer look at the commands. 1) I am wondering if there is a difference between COPY TO ... TYPE ... and EXPORT TO ... TYPE ... where the type is XLS or XL5. 2) I know that memo columns are not exported so for tables with them, I am creating a cursor with the memo columns replaced with C(254) columns. In a few cases, this will result in data being clipped. Short of programming my exports to use Office Automation, is there a way around this? (I mean that is not a kludge. For example, I could create multiple columns each with a piece of the memo, but that would be horribly ugly.) Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Welcome, new guy!
At 14:07 2019-10-08, "MB Software Solutions, LLC" wrote: Well there's something that rarely happens around here...you notice a new guy! Welcome, cctbyst...@gmail.com aka Steve in Florida! Tell us about your travels with the Fox! Someone young! Possibly under fifty? Does he know what he is getting into? I wish Microsoft had been serious-good about VFP instead of The Slow Death. Welcome, Steve. If you do not already know how good the Fox can be, we hope you find out soon. What are you using it for? What do you already know? What do you need to know? Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: VFP App Startup Program
At 13:11 2019-10-07, "Tracy Pearson" wrote: Gene, How you launched the 2nd executable from the 1st executable may have been a cause. The VFP RUN command will block if you don't use the /N clause with it. I did use run /n. It works like a charm with my one-level loader. The ShellExec API should have returned control allowing you to exit the 1st executable. There are a couple of API's that will wait for the 2nd executable to return before continuing. The VFP RUN command the CMD window to run the 2nd executable. ShellExec will not. So how does this make a difference? It is bothersome trying to debug this, because I can not see what is happening. Because the loaders are .exe programs, I do not have the benefit of the debugger, etc. I have been wondering if having two VFP .exes running at once is an issue. (Is there a conflict between config files?) [snipped previous] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: AW: VFP App Startup Program
At 00:40 2019-10-07, wrote: Hi Gene, normally your Starter programm just runs the main program, after checking for updates, and then quits itself. The starter cannot update himself, thus another program / task has to do this. The easiest way would be to first install a new main program, which checks the starter for version, and optionally does the update for the starter program. Thus the two can update each other :) Look at my original post. That is exactly what I was trying to do with cbs2run.exe and cbs2run2.exe. But there was trouble. I do not know if I simply missed something or it is not possible in one execution chain. Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
VFP App Startup Program
Hello: I have seen discussions about this at various times, but I have not ever seen details. You have an app which might be updated and want to have that happen automatically. In my case, it is a VFP .exe, and I wrote a program to handle that years ago. What about if the startup program needs to be updated? Since there is a change (the first since) in that, I wanted to write a version that would update the update program, too. Somehow, it did not work. And since there is less debugging information available when debugging a .exe, I ended up giving up on it after some trouble. My thought was to have two programs: cbs2run.exe would check cbs2run2.exe if it needed updating (and maybe update), check cbs2.exe (the app) if it needed updating (and maybe update), then run cbs2run2.exe. cbs2run2.exe would check cbs2run.exe if it needed updating (and maybe update), then run cbs2.exe. The reason that I had two programs is so that cbs2run.exe would quit running and be overwritable. Even inserting a 5-second pause before trying to overwrite cbs2run.exe in cbs2run2.exe did not work. I got some very inconsistent and confusing results. Was I overlooking something? If so, what? Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] true or false?
At 19:17 2019-09-16, Stephen Russell wrote: Biologists Confirm Foxes Sneakiest Little Fuckers In Animal Kingdom <https://www.theonion.com/biologists-confirm-foxes-sneakiest-little-fuckers-in-an-1819579604> You needed to ask? Nice article. Look up "kitsune" in Japanese legend for more fun. Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Windows File Manager Reborn
At 15:38 2019-09-12, Mike wrote: Okay, that's cooler than my solution! WINDOWS+D could also be called the "of course I'm working hard" combo! Is there an "Of course, I am working smarter!" key? Maybe ? on key label "Ctrl-F" ? "Of course, I am working smarter!" Sincerely, Gene Wirchenko Kudos Tracy! Mike Tracy Pearson wrote: > Or if your in Windows 10 use the Windows key + D to switch to another desktop when you step away. It looks like nothing is open and running. > 4 Finger swipe to switch between them. > > On September 12, 2019 6:27:11 PM EDT, Mike wrote: >> Do your boss a favor...tell him about WINDOWS+M which will reduce (not >> close!) all open windows from the desktop. >> >> Mike >> >> >> Kurt at VR-FX wrote: >>> Here at work - and even on my personal PC - I may have anywhere >>> between 7 to 10 Explorer windows open. I keep them open to current >>> directories of projects I am working on. Of course - it drives me >>> INSANE when my boss comes into the shop - gets onto the co. work >>> laptop I mostly work on - and Shuts down ALL my Explorer Windows!!! >>> >>> RRrrr >>> >>> -K- >>> >>> On 9/6/2019 10:06 AM, Gene Wirchenko wrote: >>>> At 06:35 2019-09-06, Richard Kaye wrote: >>>>> Yeah. But I still like them in the same container. Like the old >>>>> Norton product. >>>>     The advantage of having multiple windows is that you can have >>>> even more directory displays if you want. I occasionally work with >>>> three directories. >>>> >>>> Sincerely, >>>> >>>> Gene Wirchenko >>>> >>>> [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/7674e634-1d78-dd9f-2a74-a428e2287...@ggisoft.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] Windows File Manager Reborn
At 06:35 2019-09-06, Richard Kaye wrote: Yeah. But I still like them in the same container. Like the old Norton product. The advantage of having multiple windows is that you can have even more directory displays if you want. I occasionally work with three directories. Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Happy Anniversary!
At 07:35 2019-08-17, Ed Leafe wrote: OK, it's a bit late, but it just occurred to me that we just passed the 20th anniversary of the ProFox list! I posted the first message on July 22, 1999. So break out the bubbly! https://leafe.com/archives/msg/1 Do not feel too bad. A few years ago, there was a big hoopla about the 10,000th day of Web. I wondered about that. With VFP's date handling, it was easy to work out the 10,000th day which was the day before that was being pushed. Hint: Start of Web plus 1 gives the 10001st day of the Web. Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Seeking well-equipped laptop recommendations
At 17:55 2019-08-16, Ken Dibble wrote: So modernity expects a person like me to be happy with 256 GB. But I've always been a fan of over-provisioning because the unpredictable and the unexpected is an everyday thing in my life. What is unexpected about needing more memory and disk space on a computer? Oh, Gene, Gene, Gene. Don't you see? We don't actually need *any* memory or disk space on our computers at all anymore. It's all done in the cloud! Sooo secure, and reliable, and everything is just taken care of for you, so you don't need to worry your little head about it! In fact, we should thank the IT powers that be for condescending to even allow our localized devices to continue to work for a few more years, so we can have time to adjust to the brave new world. IT is just great! It is totally blue sky! Not a cloud in ... uh ... Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Seeking well-equipped laptop recommendations
At 11:01 2019-08-15, Ken Dibble wrote: So modernity expects a person like me to be happy with 256 GB. But I've always been a fan of over-provisioning because the unpredictable and the unexpected is an everyday thing in my life. What is unexpected about needing more memory and disk space on a computer? Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
SET DEFAULT or ?
Hello: I have an app that has for years been executed out of the default directory with the data there, too. Now, I have to give at least the data an arbitrary location. Can I use SET DEFAULT for this and save having to rewrite hundreds of table referring statements? Or are there nasty things to worry about? I am thinking of having a config table in the startup default directory that specifies the data directory and then SET DEFAULT to that directory. When executing a .exe version of the app, I think this will not cause trouble, but for a debug version with separate .fxp, I think I also need to SET PATH for the code to be found. I join all my code together with SET PROCEDURE TO ... ADDITIVE in the startup .fxp if that makes a difference. Are the gotchas going to get me? Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF Airtable
Hello: My boss sold his company. The transition to the new owners is in progress. The new owners use a system called Airtable. Does anyone know much about it? I am particularly interested in what types of files it can import. (There do not seem to be many.) Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] How to Get Black Bars on Monitor
At 06:11 2019-07-20, Ricardo Molina wrote: >From Display Settings, go to Advanced display settings, then Display Adaptor properties. On that form, there's a List All Modes button. For my graphics card (Intel HD 530) I can choose 1024x768 and this gives me black vertical bars. The result might be a bit blurred because it's not native resolution. I have tried that, but on my system, it does not give me blacks bars. It distorts the screen image badly taking up the whole screen. I think that this is a place where Windows implementation varies widely, and what I want might not be possible on my system. (But I was hoping.) [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] How to Get Black Bars on Monitor
At 13:14 2019-07-19, Koen Piller wrote: Gene Try to play with the windiws screen settings., That is easy to do, and I have done it. Getting the desired result is the problem. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] How to Get Black Bars on Monitor
Hello: My desktop system's monitor just died. I now have a new one. Unfortunately, it is a wide one. I do not want a wide monitor. I want my 1024x768 resolution! Some people have this and the monitor displays black bars to the side and do not want this, but some of us do want it. Unfortunately, there does not seem to be a general solution. Does anyone know how to get 1024x768 on a wide monitor without getting distortion? Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Figured out how I was getting around that Page.Init "bug" not working as expected in my subclass
At 09:26 2019-07-11, "Paul H. Tarver" wrote: The older I get, the more disciplined I become at commenting. I cannot tell you how many times I have cursed my younger self for not doing more of that when he wrote the original code! My younger self was a pretty good programmer but alas he was lazy and stupid. :) At least when it was yourself, that is one young punk who will not be on your lawn. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Figured out how I was getting around that Page.Init "bug" not working as expected in my subclass
At 08:43 2019-07-10, "MB Software Solutions, LLC" wrote: 2 things: 1. thankfully I had source code backups 2. I'm very glad I documented (commented) it well with my datestamp too. I always code to help me later down the road when I lose my mind. I try to comment appropriately, but sometimes, I miss putting down what ends up being a critically missing detail years later. If my code were less reliable, then maybe, I would have looked at it sooner and would be more familiar with it for when I finally have to change it. The "Set it and forget it." mentality does have the problem of "forget it". [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Figured out how I was getting around that Page.Init "bug" not working as expected in my subclass
At 07:48 2019-07-09, "MB Software Solutions, LLC" wrote: Found some code from last year that told the tale: https://www.screencast.com/t/eHBKVzcvz I was simply removing the page after the fact in the Form.Init based on user preferences. And you probably felt somewhat foolish when you realised that your previously-written, previous-brilliant code was the cause. I just had that myself. Actually, I am just finishing up with that. I had to severely hack up one of my forms handling classes. How severely? I had to override a main method so that a bunch of other methods normally used would never be called. In one case, I had to override a method from about a page of code down to just a return statement. Then, I found that I had removed a bit too much functionality and had to debug that. One of my OOP peeves bit here. That is when I have to write a new subclass and have to override significant parent code. Flipping back and forth between the two classes gets old very fast. One of the great things about OOP is that you can write a class and then forget about it. That is also one of the nasty things. (I had not looked at the class much in the past several years.) Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Super bizarre page.init bug on form.pageframe -- it never runs! (VFP9SP2)
At 13:27 2019-07-03, Frank Cazabon wrote: Are you sure that what you are running is what you are editing? I second this. I am currently suffering from something like this. I have to hack my form handling for a special case. I have some methods of my form handling that are not usually overridden being overridden, some to doing nothing. It is great fun jumping between the two classes. There is a lot of event handling, too. SET STEP ON and ON and ON. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: LOCATE Backwards?
At 12:19 2019-07-03, Ted Roche wrote: On Wed, Jul 3, 2019 at 12:48 PM Gene Wirchenko wrote: > What if an index is not appropriate? Is there any way to do a > LOCATE backwards (or something equivalent)? (The table has 186,574 > rows currently so searching backwards would definitely be worth > it.) I do not think there is such a critter, but maybe, you know better? SET FILTER TO && optional GO BOTTOM SKIP -1 && as needed, this LOCATEs backwards Argh! I should not have missed that since I am not an anti-SET-FILTER-TO-ist. Thank you. Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
LOCATE Backwards?
Hello: I have a situation in my app where I am having to pick up what will presumably be the last row in a table. Mind you, the general situation is that it might not be if in a multiuser situation. With the current situation, I can use an index to find that row really fast. BUT ... What if an index is not appropriate? Is there any way to do a LOCATE backwards (or something equivalent)? (The table has 186,574 rows currently so searching backwards would definitely be worth it.) I do not think there is such a critter, but maybe, you know better? Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Odd Error Message
At 06:30 2019-06-25, "Tracy Pearson" wrote: Hello Gene, That just raises more questions about what COM object is being used to create the XLS file. Is it shipping with the latest Windows 10 computer? Is it built in to the VFP runtimes? Is this functionality suddenly going to stop working one day after the DLL is identified and removed by some anti-virus software? Since I use pretty much vanilla VFP with very little outside stuff, I do not know. Please note that this error is due to the directory not existing. The functionality is there if the directory does exist. I was bemused that the error was different for .dbf and spreadsheet. Before doing such copying I make sure to create the directory. I have a procedure that creates each needed subdirectory one at a time (which also deals with a bug where capitalisation is lost when creating multiple levels at a time with the VFP MD command). I have posted it before. If anyone wants a copy, just ask. All things I don't have time to investigate. Likewise. Due to a different control having the same "Unknown COM status" message when attempting to have it write a file to a non-existent path, or a locked file, I have put checks in before calling the functions. Sometimes I think I should change my behavior to write to a temporary file, then move the bytes from the temporary file in to the destination. It would mean a longer save time, but I would be able to deal with anti-virus and on-demand backup tools putting a lock on the files. It's not an exercise for this month. I create the directory explicitly first. It works for me. I am making a number of minor modifications to the system, and this nibbled. [snipped previous] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Odd Error Message
Hello: I got an interesting error message today. It was another example of an error message indicating that an error had occurred with the message not terribly useful for determining the actual error. Try the following use sometable copy to nothere\nothere\sometable copy to nothere\nothere\somecopy type xl5 where sometable is some table and nothere\nothere is a non-existent subdirectory chain. The error message for the first copy command is "Invalid path or filename." This is sensible. The error message for the second copy command is "OLE error code 0x80030003: Unknown COM status code." Huh? Copying to a directory that does not exist results in an error. You even get a choice of error messages. Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Funny bug
At 15:16 2019-06-06, "Paul H. Tarver" wrote: This made me think that we should hold a contest on this support network to create the most convoluted way to do something simple like assign a particular value to a variable. A Rube Goldberg Programming challenge. I believe with the sense of humor the members here have, it would be an absolute hoot to see how complicated we could make a simple variable assignment and extra points for obfuscating the code as well. I had an idea once of having a contest for the most convoluted way to exit a form normally. You could have validations having to be performed in a certain order (remarkably different from Z-order, of course) and other such nasties. However, the only reason I am ever on the Dark Side is for the odd cookie so I demurred. Then again, I've been so busy lately, I fell off the stats two months in a row. A blessing for sure, but still... I hope that means dollarful (as opposed to doleful). [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Funny bug
At 11:47 2019-06-06, António Tavares Lopes wrote: display .status would dismiss the need for any "correction". It's the same principle of using mdot *wherever* possible. I think I prefer the principle of not typing so much by remembering the language rules. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Funny bug
At 06:06 2019-06-06, Ted Roche wrote: On Wed, Jun 5, 2019 at 7:59 PM Bill Anderson wrote: > DECLARE Next(1, 1) > Next(1) = .F. && Boom! Naughty, naughty! Using a keyword as a name. VFP does let you get away with it much of the time. My observation is that if the keyword is not being used in its keyword sense in the context, you can get away with it. Does this sound like a guarantee? No, so I still do not use it. Except when I did by accident. See my other post about display status. Thank you for contacting ProFox technical support. Your email is important to us. Please read this entire message before replying, as our options have recently changed. ... for values of "recently" exceeding ten years. Some of us moved to this department, some of us moved to that department, etc. Lots of options. Your options? Well, no. [snip] FoxPro has improved greatly over the years (prior to the last ten or so), and you may benefit from upgrading to a later version. Going from 2.x to 3 or from 3 to 5 have been popular as they allow you to upgrade your hardware as well rewriting. Similarly, you may benefit from going from 5 to 6 or 6 to 7 or 7 to 8 or 8 to 9 or 9 to^W^W^W. Thank you for using ProFox technical support. We appreciate that you have many choices in FoxPro support, and greatly value your loyalty. Please ensure that your tray is stowed, your seat is in its upright position and note that the nearest exit may be behind you. FoxPro support is behind you (about ten years) so try a user group. Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Funny bug
At 06:50 2019-06-06, António Tavares Lopes wrote: That's a compelling argument for the use of mdot *whenever* possible! m.Next(1) = .F. && no-boom! Hardly. It *is* an argument for not using language keywords as names. There are other contexts when m. would not work for this. I once created a table with a column named status. One time, I wanted to see all of the values of this column. display status did not give me the expected output. I corrected the table. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: ProFox List Statistics for May 2019
At 22:55 2019-06-01, List Administrator Account wrote: == ProFox List Statistics May 2019 [snip] Top 20 Contributors by Number of Non-OT Posts |Posts Contributor | 1. 17MB Software Solutions, LLC 2. 15Gene Wirchenko Did anyone else notice the universe lurching? [snip] Sincerely, Gene Wirchenko --- This email has been checked for viruses by AVG. https://www.avg.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Converting an SCX to a PRG in batch mode
At 07:07 2019-05-30, "Tracy Pearson" wrote: [snip] DO (HOME() + 'scctextx') WITH cHome + cForm + "."+cExt,cLetter,cHome + cForm + ".txt",.t. What is this program scctextx, please, and where can I get it? [snip] Sincerely, Gene Wirchenko --- This email has been checked for viruses by AVG. https://www.avg.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Cursing Microsoft for dialog boxes that will not expand in any direction in Word 2016
At 12:09 2019-05-21, Eric Selje wrote: And as a programmer, can you fix my iPhone? Call a veterinarian instead. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Filtering Oddity
At 11:24 2019-05-19, Koen Piller wrote: Gene If you would have used a select..where.. into cursor curTemp from myTable into curosr myCursor than your next select statement could be select...where...from myCursor into cursor Temp2 you are done. easy quick and dirty. Nope. Have you missed where I stated that I need to diddle the original table? [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Filtering Oddity
At 03:17 2019-05-21, AndyHC wrote: +1 Not if you need to adjust the original table. I frequently do. This idiom of filter and diddle is very useful when I am checking the coverage of a report's error checking. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Filtering Oddity
At 07:29 2019-05-19, Man-wai Chang wrote: You can just watch the value of variable f. A valid filter expression stored in variable f will not produce error. What are you trying to do when you said "...would prefer just one statement in the heat of debugging"? Trying to restrict the filter further. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Filtering Oddity
At 11:41 2019-05-15, Richard Kaye wrote: Gene and Woody's point is that XBASE tools are quite useful for us when developing/testing, not that they are necessarily preferable for production code. Exactly. One advantage that is particularly nice is that they are often short, simple, and fast. When I am chasing a bug or working on an idea, I prefer being able to get done what I want done fast. The protections that one might well want for an app are often not relevant. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Filtering Oddity
At 11:01 2019-05-15, Koen Piller wrote: Gene I would like to see an actual situation where set filter is preferable over select() according to you. I put such a case in the message of mine that you replied to! Regards Koen Op wo 15 mei 2019 om 19:49 schreef Gene Wirchenko > At 02:00 2019-05-15, Koen Piller wrote: > >Hi, > >The use of 'Set Filter' in VFP is outdated. Nowadays we use > >Selectfrom...Where...into > > Who is "we"? Here is the case you are asking for: > Your select statement does not do the same thing. I use set > filter to check for data having certain properties especially when I > am likely to change said data. It is excellent for when I wish to > diddle some data to force an error condition during program testing. From there, I can browse the data and change it as needed. Or I could use replace. These commands and others were what I was referring to in this paragraph: > Many xBASE commands are very good for use in exploration, > debugging, testing, and the like. Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Filtering Oddity
At 16:43 2019-05-14, Ted Roche wrote:
On Tue, May 14, 2019 at 6:46 PM Gene Wirchenko wrote:
>
>use cwkf
>set filter to validto>={^2019.01.01}
>count
>browse
>
> I do know that I can do
>f=filter()+" and empty(wfd)"
>set filter to &f
> but in the heat of debugging, I would prefer just one statement.
>
> Is there a way to extend a filter in one statement without
> retyping the current filter expression?
>
No, SET FILTER is an ancient command that doesn't seem to accept anything
other than the literal expression inline. Your two-line macro expansion is
likely the fastest and simplest.
I posted about this problem to foxite.com as well. Yuri
Rubinov suggested
EXECSCRIPT("SET FILTER TO "+FILTER()+" and empty(wfd)")
which works.
[snip]
Sincerely,
Gene Wirchenko
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: https://leafe.com/archives/byMID/
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
Re: Filtering Oddity
At 02:00 2019-05-15, Koen Piller wrote: Hi, The use of 'Set Filter' in VFP is outdated. Nowadays we use Selectfrom...Where...into Who is "we"? Your select statement does not do the same thing. I use set filter to check for data having certain properties especially when I am likely to change said data. It is excellent for when I wish to diddle some data to force an error condition during program testing. Many xBASE commands are very good for use in exploration, debugging, testing, and the like. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Filtering Oddity
Hello:
I was looking over a program preparatory to an enhancement. I
inserted a debugging browse statement in a branch that I was going to
add some error reporting to. The branch, oddly, did not get
executed. Dig, dig ...
use cwkf
set filter to validto>={^2019.01.01}
count
browse
Lots of rows. Oh, the filter needs to be extended.
set filter to filter()+" and empty(wfd)"
VFP: Nice try. (Actually, "Command contains unrecognized phrase/keyword."
set filter to (filter()+" and empty(wfd)")
VFP: Don't be silly. (Same error.)
Putting an avaluate() around it does not work either. ("Syntax error.")
I do know that I can do
f=filter()+" and empty(wfd)"
set filter to &f
but in the heat of debugging, I would prefer just one statement.
Is there a way to extend a filter in one statement without
retyping the current filter expression?
Sincerely,
Gene Wirchenko
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: https://leafe.com/archives/byMID/
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
Re: Old Andy Kramek trick from WhilFest years ago...I can't recall exactly how he said it
At 19:25 2019-05-07, "MB Software Solutions, LLC"
wrote:
On 5/7/2019 8:13 PM, Gene Wirchenko wrote: > Â Â
  I set .lockscreen to .t. at the beginning
of instantiating a form > and back to .f. after
the setup. I have not looked at the speed-up >
recently, but in my testing years ago, it made
about a 20% difference. > > Â Â Â Â I do not
use it otherwise. > When you say "after the
Setup", Gene, what event is that...Show() ?
I misstated some. The following is after a code check.
First of all, at the beginning and end of form .init().
Secondly, I have some display routines
where a lot happens (basically, a lot of .enable
setting). To avoid flicker, I use .lockscreen there, too.
I use .lockscreen minimally. I am not
trying to do tricks to speed up display maximally
but rather enough that it works.
My display methods are not .show() -- it
has never occurred to me to add code to .show()
-- but custom methods. They often call
.refresh() indirectly. ("indirectly" because I
usually do not directly call methods where there
is an event of the same name. I tend to call a method that does that call.)
Sincerely,
Gene Wirchenko
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: https://leafe.com/archives/byMID/
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
RE: Old Andy Kramek trick from WhilFest years ago...I can't recall exactly how he said it
At 13:20 2019-05-07, "Tracy Pearson" wrote: Both ThisForm and _Screen have the LockScreen property. If you are updating a lot of things, you can flip it to .T. then flip it back to .F. when done. I set .lockscreen to .t. at the beginning of instantiating a form and back to .f. after the setup. I have not looked at the speed-up recently, but in my testing years ago, it made about a 20% difference. I do not use it otherwise. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: ProFox Messages are not showing up
At 13:20 2019-05-03, Charlie-gm wrote: Not sure what is going on. I got a weird message the other day saying my account has gotten a lot of bounces. I got one, too. This has been an occasional problem for years. This time does seem worse for number of list members affected. Could someone drop a note when they see this in the list (I should have prefixed this with [OT] or [NF] but I wanted to see if the most "visible" target is going through). I picked this up just after 10PM PDT Saturday. Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: FoxPro Job
At 11:08 2019-05-01, Kurt at VR-FX wrote: Gene - I totally agree with you. Its NOT funny - its VERY Problematic. But, that's besides a MUCH Deeper issues of Big Corp doing Age Discrimination Which affected me Greatly in my search for work for 1.5 years! Ugh... -K- Yes, that, too, but these are really all of one piece. Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: FoxPro Job
At 11:17 2019-04-29, Kurt at VR-FX wrote: That's a pretty funny one Gene. Especially as it relates to my scenario here in Cali. Turns out - when I got here - my sister insisted that NOBODY Goes to an interview in Cali w/a Suit on! As such, when out here - I have not used a suit at all... -K- I would not call it funny. I am looking for work right now. Apart from a bit of work from a long time client, I am idle. It is very frustrating dealing with HR when one has no idea what their standards are or how well one does. Arbitrary rules are evil. The prospective employee does not get hired. The people/department needing the help can not get their projects done as easily or on-time. Not a nice situation. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: FoxPro Job
At 15:48 2019-04-26, Kurt Wendt wrote: Actually, HR wasn't involved at all. I was interviewed by the department where the position was to occur, as well as multiple people in that department including I'm assuming maybe users of the system as well as programmers of the system. I was mentioning the likeliest (to me) scenario. There are other ways for things to go pear-shaped. I remember one post in alt.folklore.computers some years ago where the poster mentioned his company had trouble with hiring. It seems that there was one group of people who expected an applicant to be wearing a suit and another group that did not trust any applicant wearing a suit. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Request About Job Listings
At 10:57 2019-04-26, Kurt at VR-FX wrote: Gene - most times - folks post about a job - and they only pass on the request sent to them by a HeadHunter. So - they generally don't have more info about the jobs - like Visa req's. Just sayin'... -K- Country would be nice. I could not even find that company. Oh, I found something, but I do not know if that was the company. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: FoxPro Job
At 10:56 2019-04-26, Kurt at VR-FX wrote: Hey Ted - yeah, I hear ya. Turns out - I was NOT the Only one in this forum to have applied to the UCLA FoxPro job - and we BOTH did Two rounds of interviews - and we BOTH Did well in those interviews - yet Neither of us were considered for the job! Which I find rather shocking. Since I KNOW there are so VERY Few active VFP dev's these days! Oh well - that's how the cookie crumbles... I wonder who they ended up hiring. Maybe, you should check in a few months and see if they require additional help^W^Wwhom they should have hired in the first place. That result was not shocking to me. I do not think much of many HR departments. They might have a very good darts teams though. Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] Request About Job Listings
Hello: For those of you who post a job listing, please include where it is. There are issues about visas for some of us. For example, I am in Canada and would require a visa to work in the U.S.A. Many employers would not want the trouble. Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [ADMIN] Replies going right to the user instead of the group
At 07:28 2019-04-19, "MB Software Solutions, LLC" wrote: Has anyone else noticed that when you hit Reply, it goes to the person and not ProFox@leafe.com? Not me. The To field for this post was automatically set to: ProFox Email List The quoting starts with a line "At , you wrote:" and I replaced the "you" with the E-mail address from the From field of your E-mail that I am replying to. I have been doing this for years. Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: One VFP Developer (Visual Fox Pro) - Conshohocken, PA - CTH
At 19:32 2019-04-16, Ed Leafe wrote: On Apr 16, 2019, at 9:13 PM, Richard Quilhot wrote: > > - Knowledge of Microsoft Technology knowledge Sounds like my gig working in the Department of Redundancy Department. Or any "... gig working ...". Assuming you really are working and are not a slacker. Sincerely, [This is, of course, redundant or a lie.] Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Substandard Software
At 22:35 2019-04-14, "Kurt @ Gmail" wrote: Gene - I truly feel your pain. But, alas - your posting was a Delightful Chuckle!!! I truly enjoy your humor. -K- There is so much software out there that is missing important things. When it is software that is widely used, this should not happen. There was some software used at a credit union that I used to deal at that gave an interest figure that was wrong for a term deposit I was about to open. I knew that it could not be right. The staff member I was dealing with insisted that it was. Finally, I figured out that the interest amount was the amount of interest that would be earned in the then-current calendar year, but it was not labelled as such, just simply as being interest. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] StackOverflow Developer Survey Results
At 21:11 2019-04-11, "Paul H. Tarver" wrote: True. But in my defense, my tongue was fully in my cheek when I was referring to those young whipper snappers who need to get off my lawn! Lol Softie! They do need to get off lawns. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] StackOverflow Developer Survey Results
At 08:52 2019-04-11, "Paul H. Tarver" wrote: I think I found one of the big reasons Foxpro didn't do well on the survey: From the Survey: "About three-fourths of professional developers who took our survey are younger than 35." Sample bias. We see this in rec.arts.sf-written when someone posts about someone's list of the top 100 (or whatever) sf books. Often, the author of that list is a young person who does not know about older classics. From Wikipedia: "Visual Foxpro was derived from FoxPro (originally known as FoxBASE) which was developed by Fox Software beginning in 1984." S, apparently our favorite language is actually OLDER than most of the respondents to the survey. So we can honestly say we were all programming the Fox before most of these whippersnappers were even a gleam in their momma's eye. Or father's. "Luke (or whatever), I am not your father." PS: I also learned I'm in the rarified air of old professional programmers. Woohoo or Dammit (depends on the day)! Why? You can do both every day. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] Substandard Software
Dear [unless you write software like that I am about to discuss] List Members: Look! I have a shiny new E-mail address. The apartment complex where I live decided to change things -- new management -- and the local phone company shortly will no longer be able to deliver service here. I have everything transferred over, and so far, so good for the most part. Never mind that my new ISP's Webmail page will not let me sign in. Never mind that their Web page chops off some important parts of the page. (I usually just use POP anyway.) (I do not want to change my screen resolution as I like to be able to read what is on it without going all squinty.) If you send E-mail to my old E-mail address, it will get to me, but this is no thanks to Telus support. The Telus support rep did not know how to do redirection of neither new E-mail, nor existing E-mail and would probably rather have hung up on me. Telus's redirect feature operates on only one E-mail at a time. I had accumulated about 65 messages in the few days I have not been using E-mail. You can see what is coming, right? Telus's Webmail feature does allow selecting more than one message at a time, but this is not available for redirect and there is no message about this either. In addition, how one enters the target E-mail address seems to require use of both keyboard and mouse. Please do not write software like this. I would regret your death. I would also regret you not dying. Have a good weekend. Unless you write software like the above. (Yes, I know. We have all had to do shortcuts, but general use software like Webmail should have a better (complete?) user interface.) Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Looking for Visual FoxPro Developer - Philadelphia PA
At 07:33 2019-04-04, "Alan Bourke" wrote: > Seems like they need a specialist. This is a job for (flings cape open) Fox-Man! Faster than a speeding bullet! Tighter than a gnat's chuff! Able to look up and figure out obscure slang in a single search. It's ... Well, it sure is not me. What does that second line mean? Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/26908f640f0f2d156a9bf09f026b44c8@mtlp85 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Happy April Fools (and not OT!)
At 08:06 2019-04-01, Ted Roche wrote: Former Visual FoxPro marketing flunky, and now... "Microsoft marketing chief Chris Capossela sent out a note to employees last week announcing that the company had decided against doing any public-facing stunts, because âdata tells us these stunts have limited positive impact and can actually result in unwanted news cycles. So if you do bad marketing, it does not work. Maybe, doing good marketing would work. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/0e0bd5d493eda37a027abbace3154328@mtlp86 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Your laptop
At 03:29 2019-03-26, Ted Roche wrote: On Mon, Mar 25, 2019 at 6:16 PM Gene Wirchenko wrote: > At 05:01 2019-03-24, Koen Piller wrote: > >Dell , why do you change a winning team? > > Dell was not a winner for me. I had a Dell Optiplex. Dell and HP and all the rest make many lines of machines. There are inexpensive consumer-grade machines that won't put up with daily commutes and intense usage. There are servers designed for long-term support and predictable although mediocre performance, There are gaming laptops. Finally, there are professional machines that developers would need. If you buy a sports car, you can't complain it's lousy for hauling manure. But I can complain that a laser printer not even getting through two toner cartridges in light use is just not good enough. If you want a professional machine, a Dell Lattitude or Lenovo ThinkPad T or X are the product lines from those two vendors. I'm sure other vendors also have good machines, I'm just less familiar with them. Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/7004a1ea1ba1dc1e99b5ebee7f6136f0@mtlp84 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Your laptop
At 05:01 2019-03-24, Koen Piller wrote: Dell , why do you change a winning team? Dell was not a winner for me. I had a Dell Optiplex. The laser printer I did not use heavily. Possibly, the printer resented this as it died after using about 1.2 toner cartridges. Yes, that is one and a fifth. A few months later, the computer itself died. Loneliness? I still have the monitor though. Winning team or not, there may be other brands with some useful features that you find useful though computers are rather commodity. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5ffef12bef662f13569b9f521fec89c3@mtlp84 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: AW: Custom Scrollbar
At 10:21 2019-03-22, Frank Cazabon wrote: Gene, did you ever give this a good testing? Nope. Got onto other things. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/f91bbbd668c5f1b2eea9e9a4da87ecd9@mtlp85 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Why don't more folks use RDP?
At 07:13 2019-03-22, "MB Software Solutions, LLC" wrote: (I asked this in a different thread but didn't want to hijack that one so I'm starting a new thread now. Also, I searched for RDP in the ProFox archives for all time for both word and phrase and it found no matches. Years ago Ed had to adjust the site for 3-letter-word searches (JVP anyone?) so I'm wondering if during his last migration this tweak got lost?) Discussing RDP with a couple guys recently, I have to wonder why more don't go the RDP route? The problem with starting out with a TLA is that people might not know what you are talking about. To me, at first glance, "RDP" means "recursive descent parser", but you are apparently referring to something else. There are other overloaded TLAs: IDE Integrated Development Environment Integrated Drive [later Device] Electronics RPG Report Program Generator Rocket-Propelled Grenade (Some might say to use the latter if you have to use the former.) Please expand unusual TLAs when starting a conversation on them. This bit of [half-]witticism is not necessarily due to it being Friday. Good weekend, folks! Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/be7b2843107b3cd6cad6348d757f2d90@mtlp85 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Creating a copy of a database -- best practice?
At 14:49 2019-02-28, "Tracy Pearson" wrote: I feel like the young pup still being just 52. I used to define "old" as being five or more years older than I was. This was when I was a lot younger (kid and young adult), and it made sense then. I am 58 and hardly pay attention to it now. You are still a young pup though. Oops! [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/16085a74800ff8e7b4ba4665cce61182@mtlp86 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: false news....
At 09:00 2019-02-25, Ted Roche wrote: On Mon, Feb 25, 2019 at 11:38 AM Ed Leafe wrote: > They are presumably being used as PKs for tables representing humans, no? > Then the vast majority of potential records would have null values, since > most humans are not citizens of the USA. Ur either Muricans, or your not. ;) Maybe. I was a "US person" for the purposes of having a certificate of deposit. It meant US citizen or entitled to work in the USA. But seriously, there are some non-citizens with SSNs, and citizens, without. So, yeah, Matt's really sorry and promises not to do it again. Someone should make up a list "Lies Programmers Believe About Identifying Numbers". Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/8b69127bfa8cf87ff6d0525fa10eec87@mtlp83 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: false news....
At 08:38 2019-02-25, Ed Leafe wrote: On Feb 25, 2019, at 10:26 AM, Ted Roche wrote: > > There's a couple of issues with using SSNs. > > Technically, they are not unique. Several people have received duplicate > numbers, so they're not ideal primary keys. They are presumably being used as PKs for tables representing humans, no? Then the vast majority of potential records would have null values, since most humans are not citizens of the USA. You do not have to be a USA citizen to have an SSN. I had one when I worked down there on a visa; it might even still be assigned to me. Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/69b3d6aff5d4bb8f14cebe6e23eb1106@mtlp85 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Converting .scx to .prg
Hello: How do I convert a .scx to a .prg? I have found most of the pieces of code, but I do not see how the contained objects are created. (I was expecting to find a form .Init().) Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5ef83681a1a8f00c91ec781fc731b260@mtlp84 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: ERD with a table with strange keys
At 09:22 2019-01-26, Ted Roche wrote: [snip] To avoid this kind of refactoring later in the process, my rule has always been that every table has a unique, non-data-bearing PK which uniquely identifies the record from birth to death. You will never have to deal with all the RI code involved in changing primary keys because the data values (category or country codes) change, and avoid intricate and bothersome code. Why not? What if someone creates a second restriction row with the same category, country, and any other factors? Couldn't this create an integrity nightmare? In my client billing app, I have a few tables that have a date range for when each row is valid. This does mean that I have to handle the lookup into these tables. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/93ea9c5e198e85a53f2a9cfd7ba03e99@mtlp85 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: AW: Custom Scrollbar
At 06:06 2019-01-10, Frank Cazabon wrote: Gene, I've knocked up a quick demo which I hope meets your requirements and emailed you the link to the download on google drive. I was beat last week, and did not get to it. I have a couple days off (today and tomorrow) and am digging into it. Preliminary: I should have stated code only. Never mind. Converting it to code only will help me learn. I do not use database containers. I hope this does not break your solution. I was concerned because of the validation rules, but this, at least, does not appear to be an issue. Focus should be set on a control in the grid at the start. I assume that there is a simple statement to do that. Validation of each column is not done at the start of row-level validation. This is important. What if the data displayed is invalid? I may be able to get this myself. I have not done much yet, but this looks as if it works. So how did I miss it? I think bad documentation is to blame, but while converting it to code, I ought to find out. I think I probably got snookered by Before/AfterRowColChange(). [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/82033ed3938509bd19ec0df89bd6b3e3@mtlp86 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: AW: Custom Scrollbar
At 12:47 2019-01-10, Frank Cazabon wrote: All columns have different validation rules. There is no input mask to force the text column to only accept numbers. You can put alphabetic characters in there too. Then it uses the rule specified earlier by Gene. You can download it and look at it and read Gene's specification in his last message here. My spec was never intended to be bullet-proof, just adequate for a very basic but non-trivial grid. "non-trivial" means that it shows working and workable implementation some things of importance to me. I intend that numeric values be entered for numeric columns. Really, this is a simple example. Yes, I would have input masks in app code. Yes, I would have many other things as well. This is not app code. Anyone thinking that this code would be of use in a real app is overthinking the situation. Run and scream after looking at the code if you want. Print out a copy of the code, and burn it. Whatever you want. Thanks for you time, Frank and anyone else who has contributed. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/463275b5d647e6f1edf0e73149185b5d@mtlp85 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: AW: Custom Scrollbar
At 12:39 2019-01-10, Frank Cazabon wrote: What control? The text? This is a quick knock up for Gene to check out, all I've put in is what he specifically asked for so it's a bare minimum thing. ... and that is exactly what I want. I want something simple enough that I can fairly easily rip it to pieces figuring out how it works but not so simplistic that it does not scale to something useful. I will check it out. Maybe, I will have missed a couple things that will come up later and need a bit more help, but maybe, at that point, I will be able to handle them myself. I do not expect people to put in a lot of work on this. I just need help out of the pit. I would be pleased to find that I can get Grid working as I need. I do not believe it yet, but I have always been willing. Remember that ~15 years some have mentioned? This is the first time I have gotten some Grid code to chew on. Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/b1ed754e8aac86bb0df894138918765c@mtlp84 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: AW: Custom Scrollbar
At 12:23 2019-01-10, Richard Kaye wrote: Control not constrained to digits only? thetext is a character string. It is not constrained at all except by the validation that it can not be "". evennr and weirdnr are integers so digits (and signs) only. [snipped previous] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/bd0b46f6bdabe4ec67dbdb4e60afb514@mtlp83 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: AW: Custom Scrollbar
At 08:10 2019-01-10, Koen Piller wrote:
Frank,
Downloading and installing the file Gene.zip was easy done succesfull.
The form: I am not able to enter a value in column #Weird if I have entered
8 in the column text. Is that how it is supposed to work?
I came up with some simple rules to test validation. They are
arbitrary, but they are also simple. (No sense having them be
complicated for a proof of concept.)
Regarding weirdnr:
1) weirdnr is supposed to be divisible by 3.
2) It is also supposed to have the same even-oddness as the first
character of thetext.
Example 1: With thetext of "An example", "A" has a value of 65 which
is odd, so weirdnr must be odd. Since it must also be divisible by
3, it must be one of {3, 9, 15, ...} or the negative of one of them.
Example 2: With thetext of "Brilliant or bad example", "B" has a
value of 66 which is even, so weirdnr must be even. Since it must
also be divisible by 3, it must be one of {0, 6, 12, 18, ...} or the
negative of one of them.
The above assumes Frank implemented correctly what I asked for,
and for that matter, that I wrote what I intended. I have just
gotten home from work -- I am working full-time outside of IT -- and
have not looked at his code yet.
I might not get to look at it in detail for a few days. But I
will. This is the first potential grid example that works for my
value of "works". If I have been overlooking something, I want to
know about it.
Mind you, I am going to try to break it, too. I want something
solid and to know that I have something solid.
[snip]
Sincerely,
Gene Wirchenko
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/6672ca8cca1bbfc4a0a209cc6ae65401@mtlp86
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
Re: [ADMIN] Testing new mail relay
At 10:51 2019-01-09, Ed Leafe wrote: Many of you have had problems receiving mail from the list, as my domain is hosted on a server in the cloud, and many ISPs have blanket blocks on any IP addresses from cloud providers like mine (Digital Ocean). Iâm testing out a new relay service, Mailgun (https://www.mailgun.com/). So far it seems to be running well, but if any of you on the receiving end of things notices a problem, please let me know. One other issue is the cost: itâs free if the total # of emails sent is under 100K, but gets expensive above that. Last year the highest number of emails sent in a month was 280 in May, which is about 133,000 total emails, and that would have cost $120 for that month (ouch!). So Iâm not sure if I will keep it, but itâs worth a trial at least. The numbers do not make sense. Does that "100K" mean 100,000 messages or 100 kilobytes? How does 280 relate to 133,000? For testing, I suggest that you send some regular test messages. You might send three per day evenly spaced over a week, and number them. "This is test message 1.", "This is test message 2.", etc. Any of us noticing some missing can let you know. Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/d25cf5c51ab489070acc6c343b49bea6@mtlp83 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: AW: Custom Scrollbar
At 05:28 2019-01-08, Frank Cazabon wrote: Gene, back in April last year you were asking if anyone could write code to your specification regarding the grid problems you were having. I don't recall ever seeing your specification, maybe if you posted it someone might be able to do the code for you. At that time, I was also having difficulties posting to the list. I thought I had come up with something, but maybe, it did not make it and I mistakenly deleted it. Let me specify something simple: Consider a cursor or table of: thetext c(20) evennr n(3) weirdnr n(3) The validations are: thetext>"" evennr%2=0 weirdnr%3=0 and the row-level validation is: asc(thetext)%2=weirdnr%2 When a control-level validation error occurs, throw an appropriate message box and then set focus to the control with the erroneous value. For a row-level validation: 1) All control-level validations should be done first. Start with the current control, then do all the others from left to right. The first that fails gets the message box, and checking stops. Then, do the row-level validation. If it fails, throw an aoppropriate message box and then set focus to the control in the first column from the left of the values that are checked. (In the example above, thetext is left of weirdnr, so set focus to thetext.) Part 2: The columns can now be rearranged in any order. Despite this: The coontrol-level validations should still set focus to the correct control. The column-level validations done at the start of the row-level validation should be done in the order current then left-to-right. NOTE THAT THIS COULD NOW BE A DIFFERENT ORDER. The row-level validation should still set focus to the leftmost involved control. NOTE THAT THIS MIGHT BE A DIFFERENT CONTROL. (Example: If weirdnr gets moved to the left of thetext, row-level validation failing should set focus to weirdnr.) This is basic functionality that I want/need. I have been unable to get this to work with VFP's Grid despite my efforts. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/731e29e7879827379eafb5958e3b7f26@mtlp83 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: AW: Custom Scrollbar
At 07:54 2019-01-09, you wrote: Gene, correct me if I'm wrong, but as far back as this list goes, I remember you talking about your own VFP grid replacement, honestly as far back as 15+ years ago. Am I right? Yes and no. I have tried over that time, but most of the time, I have had to work on other stuff. My own grid is a low priority until I have something useful working. I have tried to work with VFP's Grid control and kept running into trouble. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/f7adc88592eecdc2621a1247365351dc@mtlp83 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: AW: Custom Scrollbar
At 14:47 2019-01-07, "Darren" wrote: Been watching this thread and decided to pipe in - I have to observe that I have done some pretty tricky stuff with the VFP grid. Granted some not so straight forward but subclass columns and headers etc. and you can go for broke. Not found anything that canât be done with the VFP grid. Not to say it can do everything but I'm yet to find what that is. Spend a bit of time (a few hours) and enlightened you will be. I have spent *manweeks* trying to get Grid to work for my needs. It has resisted quite effectively. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/7590d97538b2309d61ca7919f6e8cce0@mtlp86 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: AW: Custom Scrollbar
At 04:43 2019-01-07, Koen Piller wrote: Gene The native VFP grid can handle datahandling perfectly. Please explain why you differ on opinion Because despite multiple efforts by me to get it to work, it would not work. I do not believe that Grid works. At the very least, it is so quirky, it is very difficult to use. Given that I have been able to learn how to use other VFP classes fairly easily, I lean to the view that Grid is buggy. Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cee9014521ac7d80b138146d8c8cbf76@mtlp86 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: AW: Custom Scrollbar
At 03:18 2019-01-07, "Fernando D. Bozzo" wrote: Hi Gene, About this: >"One of the things that Grid is supposedly not for is data entry" I don't agree. Neither do I, but I have seen this opinion posted many times over the years. I do not understand it myself, but there it is. Not sure about the complexity of what you need to do, but if you used FoxPro before VFP, you could remember that before the grid component was the BROWSE command with many parameters that allowed many validations and options for row/column, and that many validations and options where made exactly for that purpose, for data entry. Most of them have no sense for other purpose than data entry. Yes, but I had a period of time where I was not using xBASE. That was about when the fancy browses had their day. I have looked at BROWSE, and it does not have quite what I want. One of my first programming challenges was to do a component exactly as you need it to (I'm talking about dBase III+ era), and could do it, but the problem was that performed horribly, too slow to navigate records and columns. I think that you could face the same problem. Do not forget that you have to control each and every aspect of the component, as: - Scrolling left/right controlling start and end columns I have this scrolling already working in a concept case. It was fairly easy. I grant that this may change when I add more feature. I do not think so though. - Scrolling top/bottom controlling start and end rows - Controlling the data you load/unload, because you can't load a millon records in memory, and this forces you to control dinamically the loading of a new bunch of records in the direction you are navigating, and unloading records from the other side - Yup! It is going to be fun, but I have some ideas. I am concerned with how the scrollbar works, but I may just come up with my own version that bypasses the issues. Controlling every key for navigation and other needed purposes - Controlling the visualization of each aspect of your info (think on Autosizing columns, pre-programmed sizes, combination of both, assuring that you show columns correctly and fluently ,etc) I do not plan to have every feature that Grid has, at least for the start. I tried to get Grid working when allowing column order to change, and it was horrible. - More things you may ancounter Quite possibly. What I have encountered is trouble with row-level validation. Without that, Grid is NOT what I want. Obviously I'm thinking in a component that can be used for any table, and not just for one special table, because the programming effort to do this type of component is too high to do it for just one table. Don't know if you already said this because I didn't follow the entire thread, but: What type of validation do you need, and what is the problem you are facing that can't be handled with the grid? I can not get proper row-level validation working consistently. I have tried and tried and tried. I keep finding cases where it breaks. I deal with a case, and something else breaks. It is very frustrating. I had quite a lot of trouble to get my test case to work. I had to experiment with events and methods, but once I got it, it worked and did so consistently. And more importantly: Is really a grid what you need? why can't you use an input form with navigation keys that scrolls data in background? Because some of the work that needs to be done needs multiple rows visible at once. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/15d042d9866641a883852a099cc7ceb5@mtlp83 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Custom Scrollbar
At 08:18 2019-01-06, Jean Laeremans wrote: If memory serves me right he must be at it for at least 15 years. No, it is just that I have never had the free time to go all the way with it. (It is lower priority than my other work.) During that time, I have tried to make VFP's Grid work and have failed despite solid efforts. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/f4d13cba68c15d53e75244bdc3b98ee7@mtlp85 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: AW: Custom Scrollbar
At 08:13 2019-01-06, wrote: >> I want to create my own grid WHY, just WHY? Because the VFP grid does not work. Haven't yet found a problem for which I would need a homegrown grid. What can't you do in VFP's native grid, in combination with the excellent container hierarchy which you could add into any / every column of a grid? Full validation of a row. I came close, but it required a lot of kludges and an innocent change in one place could blow it up. Build a set of controls, save them as class, add that class to the Column, change Column.CurrentControl to point to that class, set Column.Sparse to .F. and presto, you can do any complicated setup and stil have the benefits of VFP's native gridspeed. I wish. One of the things that Grid is supposedly not for is data entry. I need a grid that can handle that. Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/d3e7c8e925ef9658f59e62571a4e9cb3@mtlp84 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Custom Scrollbar
Hello: I want to create my own grid. I am slowly making progress. I have decided that I need my own scrollbar control. It appears that a combination of Image controls will do what I need -- but do you have some other ideas? -- but I have not worked with VFP graphics. Now, I need to define some icons/images. What software do you recommend for creating these at the pixel level? I would like to be able to duplicate the appearance (colourwise) so I would like to be able to pick the colours off existing VFP controls (especially scrollbars) as well. One issue that I am concerned with is being able to have a scrollbar stretched and still look good. How does one stretch an Image properly? Is there anything you think I am not considering but should? Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/fd8ca3149f93d983c8297e0f4acb4313@mtlp87 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: ProFox List Statistics for 2018
At 22:01 2019-01-02, List Administrator Account wrote: [snip] Total [OT] Posts: 1 (Down 97.67% from 2017) First entry of the year for "Hilarity in Statistics"? [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/eb0a81a4cc783616cc46b7933116a9de@mtlp85 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Initialising in a Class
Hello: I have been experimenting with the Shape control. One of the things that I wanted to do want to have one shape have the same colour as the form's BackColor. This led to define class ... * No procedure or function statement here! BackColor=ThisForm.BackColor but VFP does not like this. Apparently, there is some limitation to the expression being evaluable at compile-time. I had to create an Init to do the initialisation. Or am I missing something? What are the limitations to the initialisation expression? Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/687d53c8ce70335e401bdde0157cd771@mtlp86 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Fox Team member now MSFT CMO
At 10:18 2018-12-20, Ted Roche wrote: On Thu, Dec 20, 2018 at 12:36 PM Gene Wirchenko wrote: > >Amazingly, Chris is STILL with MSFT, his title now: CMO. > > What is a CMO? M is not for Microsoft, I assume. I think it means Collateralized Mortgage Obligation. You can read more about CMOs here: http://bfy.tw/LRoE And which meaning were you using? For example, https://www.abbreviations.com/CMO has many expansions. The following might fit: Chief Media Officer Chief Marketing Officer Contract Management Officer Chief Medical Official Chief Medical Officer Clinical Medical Officer Ed Roberts -- remember who he was? -- later became a medical doctor. Chief Meaning Officer Hilariously appropriate! Or it may have been something else. Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1e57959694e4a75d6cc93780bc2d27e8@mtlp83 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Fox Team member now MSFT CMO
At 06:34 2018-12-20, Ted Roche wrote: Some of you may remember Chris Capposella from the 1993 DevCon Orlando "Challenge Me!" skits.: https://flic.kr/s/aHsjDMvYaF (pictures by the late Geary Rachel, used with permission) Amazingly, Chris is STILL with MSFT, his title now: CMO. What is a CMO? M is not for Microsoft, I assume. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1e39cd69d5d9b8c4b50f6315177d6ade@mtlp84 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Happy Holidays To Everyone!
At 07:00 2018-12-20, "Paul H. Tarver" wrote: I may not get another chance to post this between now and Christmas as I will be traveling to be with family later today, but I wanted to wish everyone in the ProFox Group Happy Holidays! Likewise to you and yours, Paul. And everyone else here. Enjoy the holidays however you like to. Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/55d4647ffa963ee05237821ceaee7b49@mtlp85 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Skip Behaviour on Browses
Hello: I am back to working on my grid. Every time I start to dig in, my boss gives me some other work to do. Some day, I may actually have something useful. Right now, I am working on a model using an array. It is, of course, very easy to move within the array when there is no need to adjust the view array. (The array holds only those rows which could be viewed in a grid/browse.) When the view array has to change, I want to behaviour to be like a browse. I am a bit puzzled by the behaviour of a browse though. Here is what happens on my system: (Note that when I refer to a row, I am referring to the row of the browse counting from the top UNLESS I state "table row".) I open the browse. The current row is the first one. I execute a skip 10 and then click on the browse. It updates the current row to being the 11th. Good. I execute a skip 10 and then click on the browse. It updates the current row to being the 21st. Good. I execute a skip 10 and then click on the browse. At this point, I know that the view will change. What it does is unexpected. It does not simply advance 10 rows and scroll the display so the current row is the bottom row. Instead, it scrolls such that the current row is the 16th row. This is not halfway which would be the 15th row. If I instead execute skip 20 twice, I get the same row (16th) being the active row. The above are what I get if there are enough rows for the skip to be fully done. If there are not, the 16th row is still the active row, and it has the last table row. (This is assuming that there are at least 16 table rows.) If I adjust the browse height so that there are 14 rows, then the odd positioning is to the 8th row. Handy size chart: Browse Active HeightRow -- -- 30 16 29 16 148 54 43 33 The same sort of behaviour happens with negative skips. Obviously, the function is active row = int((browse height + 1) / 2) + 1. But why? Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/fc79acb4becf046c79cb33a79801319c@mtlp85 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Fwd: Urgent requirement for the position of : Programmer IV@ Torrance CA
At 15:14 2018-11-29, Richard Quilhot wrote: Anyone looking for VFP gig in CA? Sure, but my CA is Canada. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/f8df7e36da8be077153adc85b205476d@mtlp86 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Test One Two Three
At 09:02 2018-11-29, Ted Roche wrote: Four Five Six. Anybody home? Yes. That was close for you. Imagine missing out on Friday posts. Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/3d0eb0068ab15fb57c8ce1911b062c2b@mtlp85 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] The real Python
At 13:37 2018-11-27, Stephen Russell wrote: https://www.youtube.com/watch?v=t5rExOUynZM Ah, yes, another diatribe about the programming language. I think I will post about Monty Python being better. First, I will have a look ... Oh. Carry on then. A NSFW might have been a good idea, but "... you're past them now." -- Monty Python and the Holy Grail, record's opening introduction, the part about offensive language Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/14c56a20de40a09618f2ef3438350fce@mtlp86 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: IBM to buy RedHat
At 11:42 2018-11-07, Ted Roche wrote: On Wed, Nov 7, 2018 at 2:14 PM Gene Wirchenko wrote: > OTOH, there is that line about insanity. Oh, you mean: https://twitter.com/tedroche/status/701896005332168705 Yes. (Were you expecting any other answer? Be honest.) Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/f01619184f75943c35c2960a15996858@mtlp85 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
