ProFox November 2019

profox@leafe.com

34 participants
44 discussions

joke
by Stephen Russell 13 Nov '19

13 Nov '19

What do you call a programmer's second autobiography? [image: ✍️] MySQL. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 1

[NF] DisableLeasing Side Effects?
by krdibble＠stny.rr.com 12 Nov '19

12 Nov '19

Folks, I'm being urged to apply a DisableLeasing registry hack to my Windows 2012 file server to address a problem with a split Access database application (not mine). There's some kind of ongoing issue with later Windows 10 releases and Access (I think beginning with Win 10 1803 and ongoing). MS has identified this as a problem but has been unable to fix it for a year and a half (*sigh*). My reading seems to indicate that this somehow turns off some aspect(s) of SMB globally on the server. I recall years ago that people had issues with SMB and VFP tables in LAN settings. It's not clear to me that this is another version of that. However, my VFP tables are on the same server as the back-end of this Access system, so I'd like to know if anyone has applied the DisableLeasing hack and subsequently had problems with VFP tables. Thanks. Ken Dibble www.stic-cil.org --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

[NF] Latest Outlook settings breaking default email interface
by M Jarvis 12 Nov '19

12 Nov '19

Our system has built into it a way to send us emails for error reports etc, pretty standard stuff. It just references the default client, fills in the usual suspects, Send. Apparently the latest Office 365 or whatever it is has a change or a setting that is preventing us from doing this. We don't use Outlook here so I can't test anything, but are there settings that can be changed on the user end or Admin level that might help resolve this? I'd like to pass along to the client some things to at least give a shot. TIA, -- Matt Jarvis Veneta, Oregon USA --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

We''re getting old ;)
by Jean Laeremans 08 Nov '19

08 Nov '19

https://photos.google.com/share/AF1QipMPKYanhXpYX9QgsBQdRmEipX1A9a48iuzZbDx… --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

6 8

VFP TSQL concordance
by Paul Newton 07 Nov '19

07 Nov '19

Hi all I asked about this quite some time ago and somebody suggested http://fox.wikis.com/wc.dll?Wiki~VFPSQL-TSQL-Mapping~WIN_COM_API. This is very useful but this only includes string functions. Any ideas where I might find something similar for date and numeric functions? Many thanks Paul Newton

2 2

Re: Exporting Tables
by Frank Cazabon 07 Nov '19

07 Nov '19

I use GridExtras which is available on the SPS site and has CopyToExcel in its GridExtrasProcs.prg Not sure if you have the exact same version or file but this code works for me: CREATE CURSOR ctest (cName c(10)) INSERT INTO ctest VALUES ("gene") INSERT INTO ctest VALUES ("frank") SET PROCEDURE TO gridextrasprocs m.lcFileName = "d:\temp\test.xlsx" IF FILE(m.lcFileName) ERASE (m.lcFileName) ENDIF IF copytoexcel(m.lcFileName, "Sheet1", "ctest", "Name", "cTest.cName") MESSAGEBOX("Excel file created") ELSE MESSAGEBOX("Failed") ENDIF Frank. Frank Cazabon On 06/11/2019 08:44 PM, Gene Wirchenko wrote: > At 13:41 2019-11-06, Frank Cazabon <frank.cazabon(a)gmail.com> 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 > > [excessive quoting removed by server]

1 0

RE: We''re getting old ;)
by juergen＠wondzinski.de 07 Nov '19

07 Nov '19

Thanks for those pictures! Seeing all of that faces really gets you to realize how times are flying by. And you realize, that yourself must be also getting older... Besides of Cathy of course, she always looks just stunning... wOOdy -----Ursprüngliche Nachricht----- Von: ProFox <profox-bounces(a)leafe.com> Im Auftrag von Jean Laeremans Gesendet: Donnerstag, 7. November 2019 11:54 An: ProFox Email List <profox(a)leafe.com> Betreff: We''re getting old ;) https://photos.google.com/share/AF1QipMPKYanhXpYX9QgsBQdRmEipX1A9a48iuzZbDxu ccdyZWCRNTug-PWhKFZGS0BD2A?key=NThNYmdXVkhOYWtNTnNNTXFrUklqeVlMUWVRMkJn [excessive quoting removed by server]

2 1

Re: Exporting Tables
by Koen Piller 07 Nov '19

07 Nov '19

Gene, Try with Vilhem Blogspot <http://praisachion.blogspot.com/2017/01/export-dbf-to-msexcel-xlsx.html> here you can find dbf2xlsx 4.0 zip which file contains a among others a copytoxlsx.prg and a testxlsx.prg Download the zip and play with the files You may also download exportxlsx 4.0.zip. This file contains a project with a class and a test.scx. To make use of the scx is childish simple: just click on the button run. That's it. Besides to write nearly everything in text gives me the impression you are not using VFP in the OOP way but as a procedural application which I don't recommend at all. After all it is* V*(isual) *F*(ox) *P*(ro). If you have troubles to understand the OOP I would than recommend you to read the book '1000 Things you wanted to know about Visual Foxpro' by Andy Kramek c.s. a standard work with thousands of samples. Regards, Koen Op do 7 nov. 2019 om 01:37 schreef Gene Wirchenko <gene(a)shaw.ca>: > At 12:08 2019-11-06, Koen Piller <koen.piller(a)gmail.com> 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 > > [excessive quoting removed by server]

1 0

Re: Exporting Tables
by Frank Cazabon 07 Nov '19

07 Nov '19

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) *********************************** * PARAMETER Information * tcXLSFile := a string specifying an excel file (*.xls, *.xlsx, *.xlsm, *.xlsb) on disk * tcSheet := a string specifying the name of the worksheet to create within the excel workbook * tvWorkarea [optional] := the Alias, Work Area, or File Name of the table you want to be copied to the worksheet (default is currently selected Alias) * tcExcelFieldList [optional] := a comma delimited list of columns you want to create in the worksheet (default is '*' - columns will match table field list) * tcTableFieldList [optional] := a comma delimited list of fields you want this function to copy from tvWorkArea * tcTableForExpr [optional] := a valid VFP Where/For clause to be used when querying tvWorkArea for data to be copied to the worksheet * * RETURN Information * returns numeric, the number of records inserted into the worksheet * * 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… Frank. Frank Cazabon On 06/11/2019 03:35 PM, Gene Wirchenko wrote: > At 06:08 2019-10-30, "Tracy Pearson" <tracy(a)powerchurch.com> 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 > > [excessive quoting removed by server]

2 1

Re: Exporting Tables
by Gene Wirchenko 07 Nov '19

07 Nov '19

At 12:08 2019-11-06, Koen Piller <koen.piller(a)gmail.com> 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

1 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox November 2019