Re: Application Protection
Is defox still a thing? 22 Apr 2024 19:48:27 Eric Selje : > I think ReFox is still out there. It has a application scrambler to prevent > decompilation, if that's what you're looking for. > > Eric > > > On Mon, Apr 22, 2024 at 5:35 PM Carl Lindner wrote: > >> Eons ago, I picked up Armadillo/Software passport 32 bit to protect my >> application. I still use on an old PC but there must be a better solution. >> >> >> >> Any thoughts. Thanks. >> >> >> >> Carl >> >> >> >> --- StripMime Report -- processed MIME parts --- >> multipart/alternative >> text/plain (text body -- kept) >> text/html >> --- >> [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/606aeb9b-315e-46c3-98b3-0fc77e37a...@gmail.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.
Re: Programatically placing text boxes on a form - continued
Try this: FOR i = 1 TO 4 FOR j = 1 TO 10 m.lcTextBoxName = "TextBox" + LTRIM(STR(i)) + LTRIM(STR(j)) THISFORM.ADDOBJECT( m.lcTextBoxName, "textbox") oTextbox = EVALUATE( "Thisform." + m.lcTextBoxName) WITH oTextbox .NAME = "TextBox" + LTRIM(STR(i)) + LTRIM(STR(j)) .LEFT = (j - 1) * 10 .TOP = (i - 1) * 20 .WIDTH = 100 .HEIGHT = 20 .VALUE = "Data for cell " + LTRIM(STR(i)) + ", " + LTRIM(STR(j)) .VISIBLE = .T. ENDWITH ENDFOR ENDFOR Frank. Frank Cazabon On 30/10/2023 2:23 pm, Joe Yoder wrote: Tracy, Thanks for the help - the first line makessence and executes just fine but the "oTextbox = evaluate" line errors with variable "TEXTBOX11" is not found. Do I need something in my code or on my form to have this work properly? BTW - sorry for not doing this as a reply. My email no longer gets posts from replies to my emails so I need to get them from .the archive. I reported the problem to Mailman at the leafe.com but have not received a response. Thanks again, Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [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/9a57b610-5634-588c-34f2-ca84e96e4...@gmail.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.
Re: Fun with label printers
Yes, you are correct, they should work like that, it's just the apps I've worked on have all been one at a time. Don't waste time trying my suggestion. Maybe, if you de-normalise your data to have one row with the data for the 2 labels? That is, instead of row 1: label1 row 2: label2 row 3: label3 row 4: label4 you have: row 1: label1, label2 row 2: label3, label4 just another WAG while I distract myself from some Flutter/Dart training I'm doing :) Frank. Frank Cazabon On 01/06/2023 2:23 pm, Richard Kaye wrote: Hi Frank, I appreciate the response. I'll check on that but the 3 other formats I have working all run from the same process/cursor and print one label per page as expected until all rows are output. -Original Message- From: ProfoxTech On Behalf Of Frank Cazabon Sent: Thursday, June 1, 2023 2:11 PM To: profoxt...@leafe.com Subject: Re: Fun with label printers Hey Richard, If I remember correctly, these label printers only print one label at a time. Can you loop through your result set and print each label one at a time? Frank. Frank Cazabon On 01/06/2023 1:21 pm, Richard Kaye wrote: Hi ProFoxers! Let's start June off with an actual VFP question. I've got the joy of generating labels using a DYMO 550 in my WWC web-based app. The precursor to getting this to work is standard MODIFY LABEL in dev, adjust the layout until everything preview/prints as desired, copy the label to my production environment. No special magic tricks or invoking the spirit of Cathy Poutney beyond saving the printer environment in the LBX. (Ah, the joys or proprietary hardware with proprietary paper sizes...) Currently I support 4 DYMO label formats. Well, actually it appears to be 3 because the 4th one is giving me agita. The first 3 are all single label per page with varying dimensions. The problem child here is a tiny little 1" x 1" page with 2 labels per page. Previewing or printing the output in dev only generates a single page with the first 2 records regardless of how many detail records are in the cursor that runs the report. While I continue to pound my head on this I toss it out to the collective wisdom... TIA -- rk [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/4731ed3b-bc5d-530c-0b5c-db488d909...@gmail.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.
Re: Fun with label printers
Hey Richard, If I remember correctly, these label printers only print one label at a time. Can you loop through your result set and print each label one at a time? Frank. Frank Cazabon On 01/06/2023 1:21 pm, Richard Kaye wrote: Hi ProFoxers! Let's start June off with an actual VFP question. I've got the joy of generating labels using a DYMO 550 in my WWC web-based app. The precursor to getting this to work is standard MODIFY LABEL in dev, adjust the layout until everything preview/prints as desired, copy the label to my production environment. No special magic tricks or invoking the spirit of Cathy Poutney beyond saving the printer environment in the LBX. (Ah, the joys or proprietary hardware with proprietary paper sizes...) Currently I support 4 DYMO label formats. Well, actually it appears to be 3 because the 4th one is giving me agita. The first 3 are all single label per page with varying dimensions. The problem child here is a tiny little 1" x 1" page with 2 labels per page. Previewing or printing the output in dev only generates a single page with the first 2 records regardless of how many detail records are in the cursor that runs the report. While I continue to pound my head on this I toss it out to the collective wisdom... TIA -- rk [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/59bcbb4a-ff6e-1e9f-3f99-7e2367ac2...@gmail.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.
Re: VFP Report Dynamics Tab Missing
Lol. The ones in GitHub are actually pretty recent. I think Doug Henning has
been fixing bugs in them
21 Apr 2023 10:21:06 MB Software Solutions, LLC
:
> Yeah, those 2005 files are so oldyou need to new and improved 2007
> version!!! LOL
>
> (That's what year my Report*.app files are, anyway)
>
>
> On 4/20/2023 5:27 PM, Frank Cazabon wrote:
>> Thanks
>>
>> 20 Apr 2023 17:20:29 Richard Kaye :
>>
>>> It's all on VFPX via Github.
>>>
>>> https://github.com/VFPX/ReportingApps
>>>
>>> From: ProfoxTech On Behalf Of Frank Cazabon
>>> Sent: Thursday, April 20, 2023 5:12 PM
>>> To: profoxt...@leafe.com
>>> Subject: Re: VFP Report Dynamics Tab Missing
>>>
>>> Thanks, those are correctly set. Hopefully it's just I have an old version
>>> of the report builder and I can find a newer one online
>>>
>>> 20 Apr 2023 17:06:35 Richard Kaye <mailto:rk...@invaluable.com>:
>>>
>>>> And that the various report-related system memvars are set properly, as
>>>> well as REPORTBEHAVIOR to 90
>>>>
>>>> --
>>>>
>>>> rk
>>>>
>>>>
>>>>
>>>> From: ProfoxTech <mailto:profoxtech-boun...@leafe.com> On Behalf Of Tracy
>>>> Pearson
>>>> Sent: Thursday, April 20, 2023 4:56 PM
>>>> To: mailto:profoxt...@leafe.com
>>>> Subject: RE: VFP Report Dynamics Tab Missing
>>>>
>>>> Hi Frank,
>>>>
>>>> My only thoughts is you need to be sure you have the updated Report*.app
>>>> files.
>>>>
>>>> HTH,
>>>> Tracy
>>>>
>>>> -Original Message-
>>>> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank
>>>> Cazabon
>>>> Sent: Thursday, April 20, 2023 3:27 PM
>>>> To: mailto:profoxt...@leafe.com
>>>> Subject: VFP Report Dynamics Tab Missing
>>>>
>>>> Hi,
>>>>
>>>> I've got version 09.00..7423 and SET("ReportBehavior") = 90 yet when
>>>> I double click a report control on a report I don't see the Dynamics Tab
>>>> or the Advanced Tab. Windows 11 Pro 22H2
>>>>
>>>> What am I doing wrong?
>>>>
>>>> --
>>>> Frank.
>>>>
>>>> Frank Cazabon
>>>>
>>>>
[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/5ea87975-c370-491e-b73a-203bdfa55...@gmail.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.
Re: VFP Report Dynamics Tab Missing
Tracy,
this was the problem, thanks!
I downloaded the latest files from https://github.com/VFPX/ReportingApps
and the extra tabs are available now.
Frank.
Frank Cazabon
On 20/04/2023 4:56 pm, Tracy Pearson wrote:
Hi Frank,
My only thoughts is you need to be sure you have the updated Report*.app
files.
HTH,
Tracy
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank
Cazabon
Sent: Thursday, April 20, 2023 3:27 PM
To: profoxt...@leafe.com
Subject: VFP Report Dynamics Tab Missing
Hi,
I've got version 09.00..7423 and SET("ReportBehavior") = 90 yet when
I double click a report control on a report I don't see the Dynamics Tab
or the Advanced Tab. Windows 11 Pro 22H2
What am I doing wrong?
___
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/15eafb9c-5c80-1b1a-319e-463f1d1dd...@gmail.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.
Re: VFP Report Dynamics Tab Missing
Thanks
20 Apr 2023 17:20:29 Richard Kaye :
> It's all on VFPX via Github.
>
> https://github.com/VFPX/ReportingApps
>
> From: ProfoxTech On Behalf Of Frank Cazabon
> Sent: Thursday, April 20, 2023 5:12 PM
> To: profoxt...@leafe.com
> Subject: Re: VFP Report Dynamics Tab Missing
>
> Thanks, those are correctly set. Hopefully it's just I have an old version of
> the report builder and I can find a newer one online
>
> 20 Apr 2023 17:06:35 Richard Kaye <mailto:rk...@invaluable.com>:
>
>> And that the various report-related system memvars are set properly, as well
>> as REPORTBEHAVIOR to 90
>>
>> --
>>
>> rk
>>
>>
>>
>> From: ProfoxTech <mailto:profoxtech-boun...@leafe.com> On Behalf Of Tracy
>> Pearson
>> Sent: Thursday, April 20, 2023 4:56 PM
>> To: mailto:profoxt...@leafe.com
>> Subject: RE: VFP Report Dynamics Tab Missing
>>
>> Hi Frank,
>>
>> My only thoughts is you need to be sure you have the updated Report*.app
>> files.
>>
>> HTH,
>> Tracy
>>
>> -Original Message-
>> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank
>> Cazabon
>> Sent: Thursday, April 20, 2023 3:27 PM
>> To: mailto:profoxt...@leafe.com
>> Subject: VFP Report Dynamics Tab Missing
>>
>> Hi,
>>
>> I've got version 09.00..7423 and SET("ReportBehavior") = 90 yet when
>> I double click a report control on a report I don't see the Dynamics Tab
>> or the Advanced Tab. Windows 11 Pro 22H2
>>
>> What am I doing wrong?
>>
>> --
>>
>> Frank.
>>
>> Frank Cazabon
>>
>>
[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/219c9e79-0dd5-4f69-a1b6-adec98210...@gmail.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.
Re: VFP Report Dynamics Tab Missing
Thanks, those are correctly set. Hopefully it's just I have an old version of
the report builder and I can find a newer one online
20 Apr 2023 17:06:35 Richard Kaye :
> And that the various report-related system memvars are set properly, as well
> as REPORTBEHAVIOR to 90
>
> --
>
> rk
>
>
>
> From: ProfoxTech On Behalf Of Tracy Pearson
> Sent: Thursday, April 20, 2023 4:56 PM
> To: profoxt...@leafe.com
> Subject: RE: VFP Report Dynamics Tab Missing
>
> Hi Frank,
>
> My only thoughts is you need to be sure you have the updated Report*.app
> files.
>
> HTH,
> Tracy
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank
> Cazabon
> Sent: Thursday, April 20, 2023 3:27 PM
> To: mailto:profoxt...@leafe.com
> Subject: VFP Report Dynamics Tab Missing
>
> Hi,
>
> I've got version 09.00..7423 and SET("ReportBehavior") = 90 yet when
> I double click a report control on a report I don't see the Dynamics Tab
> or the Advanced Tab. Windows 11 Pro 22H2
>
> What am I doing wrong?
>
> --
>
> Frank.
>
> Frank Cazabon
>
>
[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/474c00c0-8921-4c8a-9e40-3434a66f0...@gmail.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.
Re: VFP Report Dynamics Tab Missing
Thanks Tracy, that might be it. My version is dated 2005. I'll see if there's a
newer version available for download online.
20 Apr 2023 16:56:31 Tracy Pearson :
> Hi Frank,
>
> My only thoughts is you need to be sure you have the updated Report*.app
> files.
>
> HTH,
> Tracy
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank
> Cazabon
> Sent: Thursday, April 20, 2023 3:27 PM
> To: profoxt...@leafe.com
> Subject: VFP Report Dynamics Tab Missing
>
> Hi,
>
> I've got version 09.00..7423 and SET("ReportBehavior") = 90 yet when
> I double click a report control on a report I don't see the Dynamics Tab
> or the Advanced Tab. Windows 11 Pro 22H2
>
> What am I doing wrong?
>
> --
>
> Frank.
>
> Frank Cazabon
>
>
[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/c1a474f1-2e20-48bb-834a-f51615bfa...@gmail.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.
VFP Report Dynamics Tab Missing
Hi,
I've got version 09.00..7423 and SET("ReportBehavior") = 90 yet when
I double click a report control on a report I don't see the Dynamics Tab
or the Advanced Tab. Windows 11 Pro 22H2
What am I doing wrong?
--
Frank.
Frank Cazabon
___
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/1dd596f3-1617-fb84-8177-7a98a93bf...@gmail.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.
Re: [NF] Right-click Open with options
Could this be what you are looking for? https://www.wikihow.com/Add-New-Options-to-Right-Click-Menu-in-Windows 13 Nov 2022 09:19:04 Paul Newton : > As a result of various attempts I am now ending up with several duplicate > entries on the right-click menu - any ideas where these are stored so that I > can clean things up? > > Thanks > > Paul Newton > > On 13/11/2022 09:22, Alan Bourke wrote: >> I'd try copying the EXE to pspadadmin.exe and set a shortcut to that >> accordingly > [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/5b3f605f-ef19-4ce0-bf8a-edc44ef21...@gmail.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.
Re: GDIPlus - Resize
Does this site help? VfpImaging VFP tips and tricks blog: RESIZE IMAGES WITH VFP9 and GDI+ <http://vfpimaging.blogspot.com/2006/02/resize-images-with-vfp9-and-gdi_1706.html> Frank. Frank Cazabon On 27/06/2022 8:40 am, Paul Newton wrote: Unfortunately Alan's ResizeImage function won't work in this case. The source is 256x256 and the required target is 180x140. Using ResizeImage with the required target size produces an image which is 140x140. I am sure that there is a way to do this with GDIPlusX. By the way, my original BMP is created on-the-fly (using GDIPlusX) and never has a disk presence (although I could save it to disk). Paul On 27/06/2022 12:59, Alan Bourke wrote: Paul Take a look at the Windows Image Acquisition API, the link below is a method that I use to resize images from a signature pad. https://gist.github.com/AlanPBourke/b4ad122636978245a678a65155ba51e7 --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [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/257418d5-7961-0714-bfba-59bdb0a19...@gmail.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.
Re: [NF] Understanding Rackspace documentation
Thanks, unfortunately I don't have much of a say regarding my client's use of Rackspace. They have another developer who seems familiar with the PHP SDK so I'm trying to get this person to do this work. I think they also cannot achieve what they want to do anyhow because their data does not allow them to. I've left them investigating this for now. Frank. Frank Cazabon On 13/05/2022 4:01 pm, Ed Leafe wrote: On May 13, 2022, at 14:38, Frank Cazabon wrote: Ed, is there a C# SDK for doing this? Or maybe it's time to learn some python. A long time ago there was, but I have no knowledge of its current state. I used to head of the team that developed SDKs for Python, Java, NodeJS, Ruby, C#, and PHP. But that was 8 years ago, and Rackspace isn't the same company now that they were then. They were bought by a vulture ^H^H^H^H^H^H venture capital firm several years ago, and they are a pale shadow of what they once were. As an aside, I would consider moving resources to a different cloud provider. I haven't used Rackspace for any of my cloud needs for about 4 years now. -- Ed Leafe [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/b233bb72-56a1-0263-5381-7bfa3a249...@gmail.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.
Re: [NF] Understanding Rackspace documentation
Ed, is there a C# SDK for doing this? Or maybe it's time to learn some python. Frank. Frank Cazabon On 13/05/2022 9:12 am, Ed Leafe wrote: On May 13, 2022, at 07:36, Frank Cazabon wrote: What I get back is: Status 404, the resource could not be found. Can you see what I am doing wrong? Nothing jumps out at me. There is a 'v2' version of the API - have you tried that? -- Ed Leafe [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/3cdfa0b9-3f90-eda4-8860-d0314db32...@gmail.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.
Re: [NF] Understanding Rackspace documentation
I just tried it with no difference. I wonder if this has anything to do with user rights. While in the UI on rackspace I saw a message about not being able to upload files unless my admin was logged in. I'll get the client to logion and see. Frank. Frank Cazabon On 13/05/2022 9:12 am, Ed Leafe wrote: On May 13, 2022, at 07:36, Frank Cazabon wrote: What I get back is: Status 404, the resource could not be found. Can you see what I am doing wrong? Nothing jumps out at me. There is a 'v2' version of the API - have you tried that? -- Ed Leafe [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/4130e8f0-1c33-e98a-a173-aa748bdfd...@gmail.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.
Re: [NF] Understanding Rackspace documentation
I pull it out from an earlier response used for authentication
Frank.
Frank Cazabon
On 13/05/2022 8:40 am, Paul Newton wrote:
Where does m.lcToken come from?
On 13/05/2022 13:36, Frank Cazabon wrote:
Hi Ed,
unfortunately I'm not getting it to work (either from VFP or from
Postman).
Here is what I have tried in VFP:
m.lcAccountNumber = "99" && 6 digit customer number
m.lcSourceFile =
"/PensionDocuments/0003598C-466F-9A42-1C5E-F38944279108.pdf"
m.lcDestFile =
"/FRANK-Test/pensions/0003598C-466F-9A42-1C5E-F38944279108.pdf"
m.lcBaseUrl = "https://ord.blockstorage.api.rackspacecloud.com/v1/; +
m.lcAccountNumber
loXmlHttp.Open( "PUT" , m.lcBaseUrl + m.lcDestFile, .F. )
loXmlHttp.setRequestHeader("X-Auth-Token", m.lcToken)
loXmlHttp.setRequestHeader("X-Copy-From", m.lcBaseUrl + m.lcSourceFile)
loXmlHttp.setRequestHeader("Content-Length", 0)
loXmlHttp.Send()
? "==="
? loXmlHttp.Status
? loXmlHttp.responsetext
? "==="
What I get back is: Status 404, the resource could not be found.
Can you see what I am doing wrong?
Frank.
Frank Cazabon
On 12/05/2022 3:06 pm, Ed Leafe wrote:
On May 12, 2022, at 13:10, Frank Cazabon
wrote:
anybody here ever had to do anything with Rackspace's Storage API
to move objects around?
I think I've seen Rackspace mentioned here before so I'm hoping.
I've got to copy a file from one container to another (actually
it's a lot of files but I'm just trying to prove the concept).
I wrote the Python SDK for Rackspace (actually, all of OpenStack),
and here's the code for copying one object to another container:
@_handle_container_not_found
def copy_object(self, container, obj, new_container,
new_obj_name=None, content_type=None):
"""
Copies the object to the new container, optionally giving
it a new name.
If you copy to the same container, you must supply a
different name.
Returns the etag of the newly-copied object.
You can optionally change the content_type of the object by
supplying
that in the 'content_type' parameter.
"""
nm = new_obj_name or utils.get_name(obj)
uri = "/%s/%s" % (utils.get_name(new_container), nm)
copy_from = "/%s/%s" % (utils.get_name(container),
utils.get_name(obj))
headers = {"X-Copy-From": copy_from,
"Content-Length": "0"}
if content_type:
headers["Content-Type"] = content_type
resp, resp_body = self.api.method_put(uri, headers=headers)
return resp.headers.get("etag")
To translate to English, the URI is the base URI for the service,
with "/new_container/new_name" appended to it. "new_name" defaults
to the original object's name, but if you supply a different name
for the copied object, that one is used instead.
The headers contain an item "X-Copy-From", whose value is
"/original_container/original_name", which tells the API where to
copy from. The operation is a PUT. "COPY" is a non-standard method;
I don't know what idiot wrote the documentation you cited. These are
the HTTP methods:
https://en.wikipedia.org/wiki/Hypertext_Transfer_Protocol#Request_methods
Hope that makes some sense. If not, please let me know what needs
clarifying.
-- Ed Leafe
[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/be225df2-ca40-2dfd-9dc4-ee494834d...@gmail.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.
Re: [NF] Understanding Rackspace documentation
Hi Ed,
unfortunately I'm not getting it to work (either from VFP or from Postman).
Here is what I have tried in VFP:
m.lcAccountNumber = "99" && 6 digit customer number
m.lcSourceFile =
"/PensionDocuments/0003598C-466F-9A42-1C5E-F38944279108.pdf"
m.lcDestFile =
"/FRANK-Test/pensions/0003598C-466F-9A42-1C5E-F38944279108.pdf"
m.lcBaseUrl = "https://ord.blockstorage.api.rackspacecloud.com/v1/; +
m.lcAccountNumber
loXmlHttp.Open( "PUT" , m.lcBaseUrl + m.lcDestFile, .F. )
loXmlHttp.setRequestHeader("X-Auth-Token", m.lcToken)
loXmlHttp.setRequestHeader("X-Copy-From", m.lcBaseUrl + m.lcSourceFile)
loXmlHttp.setRequestHeader("Content-Length", 0)
loXmlHttp.Send()
? "==="
? loXmlHttp.Status
? loXmlHttp.responsetext
? "==="
What I get back is: Status 404, the resource could not be found.
Can you see what I am doing wrong?
Frank.
Frank Cazabon
On 12/05/2022 3:06 pm, Ed Leafe wrote:
On May 12, 2022, at 13:10, Frank Cazabon wrote:
anybody here ever had to do anything with Rackspace's Storage API to move
objects around?
I think I've seen Rackspace mentioned here before so I'm hoping.
I've got to copy a file from one container to another (actually it's a lot of
files but I'm just trying to prove the concept).
I wrote the Python SDK for Rackspace (actually, all of OpenStack), and here's
the code for copying one object to another container:
@_handle_container_not_found
def copy_object(self, container, obj, new_container, new_obj_name=None,
content_type=None):
"""
Copies the object to the new container, optionally giving it a new
name.
If you copy to the same container, you must supply a different name.
Returns the etag of the newly-copied object.
You can optionally change the content_type of the object by supplying
that in the 'content_type' parameter.
"""
nm = new_obj_name or utils.get_name(obj)
uri = "/%s/%s" % (utils.get_name(new_container), nm)
copy_from = "/%s/%s" % (utils.get_name(container), utils.get_name(obj))
headers = {"X-Copy-From": copy_from,
"Content-Length": "0"}
if content_type:
headers["Content-Type"] = content_type
resp, resp_body = self.api.method_put(uri, headers=headers)
return resp.headers.get("etag")
To translate to English, the URI is the base URI for the service, with
"/new_container/new_name" appended to it. "new_name" defaults to the original
object's name, but if you supply a different name for the copied object, that one is used instead.
The headers contain an item "X-Copy-From", whose value is
"/original_container/original_name", which tells the API where to copy from. The operation is a
PUT. "COPY" is a non-standard method; I don't know what idiot wrote the documentation you cited.
These are the HTTP methods: https://en.wikipedia.org/wiki/Hypertext_Transfer_Protocol#Request_methods
Hope that makes some sense. If not, please let me know what needs clarifying.
-- Ed Leafe
[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/0251468d-81e2-a976-f646-5c260f84e...@gmail.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.
Re: [NF] Understanding Rackspace documentation
:) Thanks Ed. I'll let you know how I get on. Frank. Frank Cazabon On 12/05/2022 3:33 pm, Ed Leafe wrote: On May 12, 2022, at 14:31, Ed Leafe wrote: Here's the code as it should be: https://github.com/pycontribs/pyrax/blob/master/pyrax/object_storage.py#L599-L606 Geez, that's just the handler code. Here's the actual call I copied in the first message: https://github.com/pycontribs/pyrax/blob/master/pyrax/object_storage.py#L1445-L1465 Gotta stop emailing while writing other code. :) -- Ed Leafe [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/fde14a17-771c-de7c-2690-dcbec23da...@gmail.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.
[NF] Understanding Rackspace documentation
Hi,
anybody here ever had to do anything with Rackspace's Storage API to
move objects around?
I think I've seen Rackspace mentioned here before so I'm hoping.
I've got to copy a file from one container to another (actually it's a
lot of files but I'm just trying to prove the concept).
I've managed to get the authentication sorted out which was defined like
this:
$ curl https://identity.api.rackspacecloud.com/v2.0/tokens \
-X POST \
-d
'{"auth":{"RAX-KSKEY:apiKeyCredentials":{"username":"yourUserName","apiKey":"$apiKey"}}}'
\
-H "Content-type: application/json"
I was able to translate that like this:
m.lcUrl = "https://identity.api.rackspacecloud.com/v2.0/tokens;
TEXT TO lcAuthBody NOSHOW TEXTMERGE
{
"auth": {
"RAX-KSKEY:apiKeyCredentials": {
"username": "<>",
"apiKey": "<>"
}
}
}
ENDTEXT
LOCAL loXmlHttp AS Microsoft.XMLHTTP
loXmlHttp = Newobject( "Microsoft.XMLHTTP" )
loXmlHttp.Open( "POST" , m.lcUrl, .F. )
loXmlHttp.setRequestHeader("Content-Type","application/json")
loXmlHttp.Send( m.lcAuthBody )
I can then pull the token out of the loXmlHttp.responsetext
Now I want to use this token to copy a file from one container to another.
The documentation here
(https://docs.rackspace.com/docs/cloud-files/v1/storage-api-reference/object-services-operations#copy-object
) gives this example:
COPY /v1/account/sourceContainer/sourceObject HTTP/1.1
Host: storageURL
X-Auth-Token: yourAuthToken
Destination: /destinationContainer/destinationObject
I don't know how to interpret this to make an xmlhttp call.
1. What is the url for the end point? I've got the account,
sourceContainer and sourceObject but not sure what comes before the /v1/
2. I'm unaware of a COPY type of Http request, so what should that be?
3. Even trying various things in PostMan aren't helping :(
--
Frank.
Frank Cazabon
___
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/f121bc31-2491-fc02-3207-c1a4e4d92...@gmail.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.
Re: Config.FPW command ignored when double-clicking on PJX in Explorer
OK, I think the file association of PJX with VFP9.exe has various parameters you can set, but I don't know if that will do what you want. You can find these settings somewhere in the registry if you want to dig into it. My setup is that I have a startup program configured (Tools | options | File Locations) and when I start VFP from either a shortcut or double clicking on a file like PJX, that program gets called where I display a folder selection dialogue and once I select a folder I then set default to that folder (all programmatically). btw, what is "CD in the command window"? Do you mean "?CURDIR()" ? Frank. Frank Cazabon On 09/05/2022 10:20 am, Paul Newton wrote: Hi Frank Thanks for your reply. I have tried as you suggest (Config.FPW and Startup.PRG in the VFP9.EXE folder) but that still does not work. Double-clicking on the PKX opens the project and CD in the command window shows the current folder as the project's folder) Paul On 09/05/2022 15:10, Frank Cazabon wrote: Paul, I think the issue you are seeing is that when you double click on the PJX, the VFP9.exe runs, but it runs with the default/start in folder being the folder where vfp9.exe sits. If you set up your config in that folder then you should get what you want, once you can make it generic enough. Frank. Frank Cazabon On 09/05/2022 10:07 am, Paul Newton wrote: Thanks Jan You say that double-clicking on a PJX works as usually but what are the commands in your Start.PRG and do they get executed (in addition to the project being opened). Paul On 09/05/2022 14:09, Jan Bucek wrote: My config.fpw and start.prg for "command=do start" are placed in VFP folder. Doubleclicking any PJX works for me as usualy. Dne 8.5.2022 v 19:19 Paul Newton napsal(a): Hi all I have a folder containing a PJX, Config.FPW, Startup.PRG, StartThor.PRGand StartHackCX.PRG Config.FPW contains "Command=Do Startup.PRG" Startup.PRG contains: Do StartThor.PRG Do StartHackCX.PRG The problem is that none of these commands executes when double-clicking on the PJX in Windows Explorer (or other file manager), even though Sys(2019) points to the Config.FPW in the folder in question. Any ideas or is this just the way it works? Paul Newton --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [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/e22741ef-d0e3-0f04-1ba2-7082e21c6...@gmail.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.
Re: Config.FPW command ignored when double-clicking on PJX in Explorer
Paul, I think the issue you are seeing is that when you double click on the PJX, the VFP9.exe runs, but it runs with the default/start in folder being the folder where vfp9.exe sits. If you set up your config in that folder then you should get what you want, once you can make it generic enough. Frank. Frank Cazabon On 09/05/2022 10:07 am, Paul Newton wrote: Thanks Jan You say that double-clicking on a PJX works as usually but what are the commands in your Start.PRG and do they get executed (in addition to the project being opened). Paul On 09/05/2022 14:09, Jan Bucek wrote: My config.fpw and start.prg for "command=do start" are placed in VFP folder. Doubleclicking any PJX works for me as usualy. Dne 8.5.2022 v 19:19 Paul Newton napsal(a): Hi all I have a folder containing a PJX, Config.FPW, Startup.PRG, StartThor.PRGand StartHackCX.PRG Config.FPW contains "Command=Do Startup.PRG" Startup.PRG contains: Do StartThor.PRG Do StartHackCX.PRG The problem is that none of these commands executes when double-clicking on the PJX in Windows Explorer (or other file manager), even though Sys(2019) points to the Config.FPW in the folder in question. Any ideas or is this just the way it works? Paul Newton --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [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/ce5a6843-c6ee-6cb3-f35d-3b591eb5a...@gmail.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.
Re: Accessing/processing archived emails
LOL Frank. Frank Cazabon On 13/04/2022 10:43 am, paul.newton.h...@gmail.com wrote: That's not surprising - I've just realised that his reply was to me and not to the list ... DOH! -Original Message- From: ProfoxTech On Behalf Of Frank Cazabon Sent: 13 April 2022 15:40 To: profoxt...@leafe.com Subject: Re: Accessing/processing archived emails Interesting, I never saw his message, it's not even in my spam (quite a few Profox emails end up in Google's spam) :( Frank. Frank Cazabon On 13/04/2022 10:33 am, paul.newton.h...@gmail.com wrote: Frank Vince suggested copying my old MBOX stuff into TB's default mail location ... seems to work but I am still verifying that all is OK. Paul -Original Message- From: ProfoxTech On Behalf Of Frank Cazabon Sent: 13 April 2022 15:28 To: profoxt...@leafe.com Subject: Re: Accessing/processing archived emails Glad you found something. I didn't see a response from Vince. What did he suggest? Frank. Frank Cazabon On 13/04/2022 10:24 am, paul.newton.h...@gmail.com wrote: Many thanks, Frank It looks as if Vince's suggestion might very well work and would be the ideal solution. Paul -Original Message- From: ProfoxTech On Behalf Of Frank Cazabon Sent: 11 April 2022 23:19 To: profoxt...@leafe.com Subject: Re: Accessing/processing archived emails Hi Paul, A quick search gave me these but I've never used them: https://www.bitrecover.com/blog/view-thunderbird-msf-files/ https://sysc.org/open-mbox-file-format/ 11 Apr 2022 18:03:11 paul.newton.h...@gmail.com: Hi all I have several (Windows Explorer) folders containing archived TB (Thunderbird) emails which I want to review and clean up (i.e. get rid of for good). These folders have an SBD extension and these correspond to TB's folders. They contain files with no extension (these contain the actual emails) and which I believe are "MBOX" files. They also contain files with an MSF extension which apparently contain summaries of the MBOX contents. One possible approach might be to set up TB or another email client which works with MBOX type files. I made a first attempt at this with TB but got stuck at the stage where it wants details of incoming and outgoing server accounts (I don't want to set up an account). Another approach might be to export all the MBOX messages as individual EML files. Here any recommendations for free/cheap solutions without limitations would be helpful - I have used Thunderstor in the past but now can only find a trial version with no means to upgrade. The idea then would be to use VFP to parse the EML files for subject, sender, recipient, date and content as well as to decode and save any attachments. Any ideas or suggestions regarding either approach (or a different approach) will be most welcome. In particular, I would not want to reinvent the wheel regarding the parsing of the EMLs - so if anybody knows of any tools or existing code that could be helpful . Many thanks, and apologies for the length of the message Paul Newton --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [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/9e880f45-e36a-4855-0145-d5519b855...@gmail.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.
Re: Accessing/processing archived emails
Interesting, I never saw his message, it's not even in my spam (quite a few Profox emails end up in Google's spam) :( Frank. Frank Cazabon On 13/04/2022 10:33 am, paul.newton.h...@gmail.com wrote: Frank Vince suggested copying my old MBOX stuff into TB's default mail location ... seems to work but I am still verifying that all is OK. Paul -Original Message- From: ProfoxTech On Behalf Of Frank Cazabon Sent: 13 April 2022 15:28 To: profoxt...@leafe.com Subject: Re: Accessing/processing archived emails Glad you found something. I didn't see a response from Vince. What did he suggest? Frank. Frank Cazabon On 13/04/2022 10:24 am, paul.newton.h...@gmail.com wrote: Many thanks, Frank It looks as if Vince's suggestion might very well work and would be the ideal solution. Paul -Original Message- From: ProfoxTech On Behalf Of Frank Cazabon Sent: 11 April 2022 23:19 To: profoxt...@leafe.com Subject: Re: Accessing/processing archived emails Hi Paul, A quick search gave me these but I've never used them: https://www.bitrecover.com/blog/view-thunderbird-msf-files/ https://sysc.org/open-mbox-file-format/ 11 Apr 2022 18:03:11 paul.newton.h...@gmail.com: Hi all I have several (Windows Explorer) folders containing archived TB (Thunderbird) emails which I want to review and clean up (i.e. get rid of for good). These folders have an SBD extension and these correspond to TB's folders. They contain files with no extension (these contain the actual emails) and which I believe are "MBOX" files. They also contain files with an MSF extension which apparently contain summaries of the MBOX contents. One possible approach might be to set up TB or another email client which works with MBOX type files. I made a first attempt at this with TB but got stuck at the stage where it wants details of incoming and outgoing server accounts (I don't want to set up an account). Another approach might be to export all the MBOX messages as individual EML files. Here any recommendations for free/cheap solutions without limitations would be helpful - I have used Thunderstor in the past but now can only find a trial version with no means to upgrade. The idea then would be to use VFP to parse the EML files for subject, sender, recipient, date and content as well as to decode and save any attachments. Any ideas or suggestions regarding either approach (or a different approach) will be most welcome. In particular, I would not want to reinvent the wheel regarding the parsing of the EMLs - so if anybody knows of any tools or existing code that could be helpful . Many thanks, and apologies for the length of the message Paul Newton --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [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/418ab462-0fff-1484-b710-ad6db55be...@gmail.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.
Re: Accessing/processing archived emails
Glad you found something. I didn't see a response from Vince. What did he suggest? Frank. Frank Cazabon On 13/04/2022 10:24 am, paul.newton.h...@gmail.com wrote: Many thanks, Frank It looks as if Vince's suggestion might very well work and would be the ideal solution. Paul -Original Message- From: ProfoxTech On Behalf Of Frank Cazabon Sent: 11 April 2022 23:19 To: profoxt...@leafe.com Subject: Re: Accessing/processing archived emails Hi Paul, A quick search gave me these but I've never used them: https://www.bitrecover.com/blog/view-thunderbird-msf-files/ https://sysc.org/open-mbox-file-format/ 11 Apr 2022 18:03:11 paul.newton.h...@gmail.com: Hi all I have several (Windows Explorer) folders containing archived TB (Thunderbird) emails which I want to review and clean up (i.e. get rid of for good). These folders have an SBD extension and these correspond to TB's folders. They contain files with no extension (these contain the actual emails) and which I believe are "MBOX" files. They also contain files with an MSF extension which apparently contain summaries of the MBOX contents. One possible approach might be to set up TB or another email client which works with MBOX type files. I made a first attempt at this with TB but got stuck at the stage where it wants details of incoming and outgoing server accounts (I don't want to set up an account). Another approach might be to export all the MBOX messages as individual EML files. Here any recommendations for free/cheap solutions without limitations would be helpful - I have used Thunderstor in the past but now can only find a trial version with no means to upgrade. The idea then would be to use VFP to parse the EML files for subject, sender, recipient, date and content as well as to decode and save any attachments. Any ideas or suggestions regarding either approach (or a different approach) will be most welcome. In particular, I would not want to reinvent the wheel regarding the parsing of the EMLs - so if anybody knows of any tools or existing code that could be helpful . Many thanks, and apologies for the length of the message Paul Newton --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [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/70a8ef4a-ad36-5e8f-a4a2-dbad9af4f...@gmail.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.
Re: Accessing/processing archived emails
Hi Paul, A quick search gave me these but I've never used them: https://www.bitrecover.com/blog/view-thunderbird-msf-files/ https://sysc.org/open-mbox-file-format/ 11 Apr 2022 18:03:11 paul.newton.h...@gmail.com: > Hi all > > > > I have several (Windows Explorer) folders containing archived TB > (Thunderbird) emails which I want to review and clean up (i.e. get rid of > for good). These folders have an SBD extension and these correspond to TB's > folders. They contain files with no extension (these contain the actual > emails) and which I believe are "MBOX" files. They also contain files with > an MSF extension which apparently contain summaries of the MBOX contents. > > > > One possible approach might be to set up TB or another email client which > works with MBOX type files. I made a first attempt at this with TB but got > stuck at the stage where it wants details of incoming and outgoing server > accounts (I don't want to set up an account). > > > > Another approach might be to export all the MBOX messages as individual EML > files. Here any recommendations for free/cheap solutions without > limitations would be helpful - I have used Thunderstor in the past but now > can only find a trial version with no means to upgrade. > > > > The idea then would be to use VFP to parse the EML files for subject, > sender, recipient, date and content as well as to decode and save any > attachments. > > > > Any ideas or suggestions regarding either approach (or a different approach) > will be most welcome. In particular, I would not want to reinvent the wheel > regarding the parsing of the EMLs - so if anybody knows of any tools or > existing code that could be helpful . > > > > Many thanks, and apologies for the length of the message > > > > Paul Newton > > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [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/573a9f87-a09a-480d-9b13-6aa268c3d...@gmail.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.
Re: Windows 11 ads and unexpected restarts on Win 10 Pro
I updated a couple weeks ago. Haven't noticed any problems. 27 Dec 2021 17:26:21 MB Software Solutions, LLC : > Anybody else upgrade to Win11 yet and can comment on how your Fox IDE (and > exes/rpts/etc) works with it? > > > On 12/16/2021 11:55 PM, data...@adam.com.au wrote: >> I have updated to windows 11 on 3 of my old laptops by editing the TPM >> settings in one of the DLLs of the setup. Windows 11 works and works well. >> IN fact it has made two of my laptops that were incredibly slow to become >> usable again. It looks like MS has finally broken the tradition of every >> second Windows release being garbage. >> >> -Original Message- >> From: ProFox On Behalf Of Michael Oke, II >> Sent: Friday, 17 December 2021 3:13 PM >> To: ProFox Email List >> Subject: Re: Windows 11 ads and unexpected restarts on Win 10 Pro >> >> Age perhaps. My desktop is a few years old as is my laptop so they both >> lack the TPM 2.0 support as well as at least the laptop sporting an >> unsupported processor. >> >> - >> Michael Oke, II >> oke...@gmail.com >> 661-349-6221 >> - >> >> >> On Thu, Dec 16, 2021 at 5:58 PM MB Software Solutions, LLC < >> mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: >> >>> I wonder how my Win10Pro machine would differ from yours? >>> >>> On 12/16/2021 6:13 PM, Michael Oke, II wrote: I haven't seen anything of the sort but I'm not sure that either of my physical Windows 10 machines qualifies for the update. - Michael Oke, II oke...@gmail.com 661-349-6221 - On Thu, Dec 16, 2021 at 2:21 PM MB Software Solutions, LLC < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > My Win10Pro dev machine decided to reboot overnight without any > warning to me TWICE in the past week, and it had me quite pissed off. > Thankfully my code was all saved (or at least 99% of it), but > admittedly, I often leave my VFP window open and pick up where I > left off the next day. > > As some of you may recall, I designed an app for managing my Beer > League Hockey group (called the "Babs Hockey Fraternity" on > Facebook--locations in two states now!), and initially, because it > was so quick to get it up and going, I used a VFP DBC backend. I > also use Mr. Chen's VFP 10 exclusively for that too. After a few > crashes from VFP 10 corrupting the DBFs, I swapped out to the > MariaDB backend instead. (I've been using MySQL/MariaDB since I > saw Bob Lee's n-tier presentation at GLGDW back in 2003.) > > Anyhooo.did anybody else get a similar behavior recently, with > your computer asking you if you wanted the free upgrade to Win 11? > > > -- > Michael J. Babcock, MCP > Fox/VFP dev since 1997 > Developer of FabNet estimating software - mbsoftwaresolutions.com > > [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/44c82575-64a1-47d5-9fb6-b16d36fb5...@gmail.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.
Re: VFP equivalent of SQL Server 'script table'
Hi Alan, maybe gendbc or gendbcx will do what you want? You could also check Thor to see if there are any tools available that will do that for you. The upsizing Wizard might be of some help as well. There is also this tool available for generating sample data: Sample Data as Text to post on forums | Foxite <https://www.foxite.com/faq/default.aspx?id=50> Visual MaxFrame Professional has a tool called XXDTGenAndPopCode to turn each record in a table into an INSERT statement. Frank. Frank Cazabon On 02/09/2021 7:05 am, Alan Bourke wrote: In MSSQL you can script a table out to a Transact SQL script, including all CREATE statements and multiple INSERT statements for the data. Is there a VFP equivalent that anyone knows of? This is for including test data in source control, it's better to have a PRG that can generate the database than adding binary DBF files etc. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ 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/87eac7c4-b16d-8fc6-0f10-8c3850001...@gmail.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.
Re: Disappearing pop-up windows (like the Find window dialog in Code References, and sometimes the entire Debug window)
Hi Michael, the resource file will store the position of the various windows, as I'm sure you know. If the left or top value gets set to something negative then it won't be visible. So maybe in your screen setup somehow things are getting changed around and you are ending up with a position off the screen somewhere? If you know the debug window is the active window, you can press Alt, then left arrow, then down arrow, then "M" and you will be able to move the window with the arrow keys. That might give you a better idea of where the window is. Frank. Frank Cazabon On 09/08/2021 9:57 pm, MB Software Solutions, LLC wrote: My workaround is to delete all the foxuser.id rows with 'debug' in them but that's a PITA. On 8/9/2021 7:56 PM, MB Software Solutions, LLC wrote: VFP9SP2 Win10Pro Dell Latitude 3400 and my favorite color today is red. Has anyone come across where your resource file just seems to get crazy and show windows in coordinates that are entirely off-monitor and you cannot see them? I do! Started not too long ago. I use a dual-monitor setup and on very rare occasion have my laptop lid open too while on the dock for a (unintended) 3rd monitor display. I can only guess that my re-arrange monitors perhaps has caused this. It's very frustrating. I've nuked the resource.dbf file a couple times but it repeats behavior. (Off the top of my head, I can't recall if the ZAP of resource.dbf fixes it or not, but if it does, eventually it happens again where I cannot see the Find window.) Only thing more I can contribute: leftmost monitor is #1 and right (and sometimes middle) is #2. Laptop sits at far right of my desk. Ideas? Tia. ___ 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/f84c9bd7-e99b-d5cd-e8cb-3aff5e5dc...@gmail.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.
Generate Restful API for a database
Hi, I'm converting a system that I've had running for the last 15 years or so against SQL Server/PostgreSQL to start using a restful API. I'm looking at doing this API in nodejs and probably using Express. It looks like tedious repetitive code that should be good for a generator. Has anyone come across one out there in the wild? -- Frank. Frank Cazabon ___ 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/6a73f4bd-9e75-0080-dc8c-5abacf974...@gmail.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.
Re: Data Manipulation, Pivot?
A possible solution:
SELECT StoreFK;
,EmployeeFK;
,MIN(Sheetdate) AS WeekStart;
,MAX(RosterStart1) AS RosterStart1 ;
,MAX(RosterEnd1) AS RosterEnd1 ;
,MAX(WorkStart1) AS WorkStart1 ;
,MAX(WorkEnd1) AS WorkEnd1 ;
,MAX(RosterStart2) AS RosterStart2 ;
,MAX(RosterEnd2) AS RosterEnd2 ;
,MAX(WorkStart2) AS WorkStart2 ;
,MAX(WorkEnd2) AS WorkEnd2 ;
,MAX(RosterStart3) AS RosterStart3 ;
,MAX(RosterEnd3) AS RosterEnd3 ;
,MAX(WorkStart3) AS WorkStart3 ;
,MAX(WorkEnd3) AS WorkEnd3 ;
,MAX(RosterStart4) AS RosterStart4 ;
,MAX(RosterEnd4) AS RosterEnd4 ;
,MAX(WorkStart4) AS WorkStart4 ;
,MAX(WorkEnd4) AS WorkEnd4 ;
,MAX(RosterStart5) AS RosterStart5 ;
,MAX(RosterEnd5) AS RosterEnd5 ;
,MAX(WorkStart5) AS WorkStart5 ;
,MAX(WorkEnd5) AS WorkEnd5 ;
,MAX(RosterStart6) AS RosterStart6 ;
,MAX(RosterEnd6) AS RosterEnd6 ;
,MAX(WorkStart6) AS WorkStart6 ;
,MAX(WorkEnd6) AS WorkEnd6 ;
,MAX(RosterStart7) AS RosterStart7 ;
,MAX(RosterEnd7) AS RosterEnd7 ;
,MAX(WorkStart7) AS WorkStart7 ;
,MAX(WorkEnd7) AS WorkEnd7 ;
FROM (;
SELECT A.StoreFK;
,A.EmployeeFK;
,A.SheetDate;
,IIF(DOW(A.SheetDate, 2) = 1, RosterStart, {::}) AS RosterStart1;
,IIF(DOW(A.SheetDate, 2) = 1, RosterEnd, {::}) AS RosterEnd1;
,IIF(DOW(A.SheetDate, 2) = 1, WorkStart, {::}) AS WorkStart1;
,IIF(DOW(A.SheetDate, 2) = 1, WorkEnd, {::}) AS WorkEnd1;
,IIF(DOW(A.SheetDate, 2) = 2, RosterStart, {::}) AS RosterStart2;
,IIF(DOW(A.SheetDate, 2) = 2, RosterEnd, {::}) AS RosterEnd2;
,IIF(DOW(A.SheetDate, 2) = 2, WorkStart, {::}) AS WorkStart2;
,IIF(DOW(A.SheetDate, 2) = 2, WorkEnd, {::}) AS WorkEnd2;
,IIF(DOW(A.SheetDate, 2) = 3, RosterStart, {::}) AS RosterStart3;
,IIF(DOW(A.SheetDate, 2) = 3, RosterEnd, {::}) AS RosterEnd3;
,IIF(DOW(A.SheetDate, 2) = 3, WorkStart, {::}) AS WorkStart3;
,IIF(DOW(A.SheetDate, 2) = 3, WorkEnd, {::}) AS WorkEnd3;
,IIF(DOW(A.SheetDate, 2) = 4, RosterStart, {::}) AS RosterStart4;
,IIF(DOW(A.SheetDate, 2) = 4, RosterEnd, {::}) AS RosterEnd4;
,IIF(DOW(A.SheetDate, 2) = 4, WorkStart, {::}) AS WorkStart4;
,IIF(DOW(A.SheetDate, 2) = 4, WorkEnd, {::}) AS WorkEnd4;
,IIF(DOW(A.SheetDate, 2) = 5, RosterStart, {::}) AS RosterStart5;
,IIF(DOW(A.SheetDate, 2) = 5, RosterEnd, {::}) AS RosterEnd5;
,IIF(DOW(A.SheetDate, 2) = 5, WorkStart, {::}) AS WorkStart5;
,IIF(DOW(A.SheetDate, 2) = 5, WorkEnd, {::}) AS WorkEnd5;
,IIF(DOW(A.SheetDate, 2) = 6, RosterStart, {::}) AS RosterStart6;
,IIF(DOW(A.SheetDate, 2) = 6, RosterEnd, {::}) AS RosterEnd6;
,IIF(DOW(A.SheetDate, 2) = 6, WorkStart, {::}) AS WorkStart6;
,IIF(DOW(A.SheetDate, 2) = 6, WorkEnd, {::}) AS WorkEnd6;
,IIF(DOW(A.SheetDate, 2) = 7, RosterStart, {::}) AS RosterStart7;
,IIF(DOW(A.SheetDate, 2) = 7, RosterEnd, {::}) AS RosterEnd7;
,IIF(DOW(A.SheetDate, 2) = 7, WorkStart, {::}) AS WorkStart7;
,IIF(DOW(A.SheetDate, 2) = 7, WorkEnd, {::}) AS WorkEnd7;
FROM (;
SELECT TD.EmployeeFK;
,T.SheetDate;
,T.StoreFK;
,TD.StartTime as WorkStart;
,TD.EndTime as WorkEnd;
from TimeSheetDetails TD ;
INNER JOIN TimeSheets T ON TD.TimeSheetFK = T.TimeSheetPK ;
WHERE NOT T.isRoster) A;
INNER JOIN (;
SELECT RD.EmployeeFK;
,R.SheetDate;
,R.StoreFK;
,RD.StartTime as RosterStart;
,RD.EndTime as RosterEnd;
from TimeSheetDetails RD ;
INNER JOIN TimeSheets R ON RD.TimeSheetFK = R.TimeSheetPK ;
WHERE R.isRoster;
) B ON A.EmployeeFK = B.EmployeeFK AND A.SheetDate =
B.SheetDate AND A.StoreFK = B.StoreFK;
) S ;
GROUP BY StoreFK, EmployeeFK;
INTO CURSOR c_TimeWorkedSummary
Frank.
Frank Cazabon
On 22/07/2021 9:11 am, Frank Cazabon wrote:
Hi,
I haven't done a lot of VFP recently so I've forgotten some basics. I
need to manipulate some data for reporting purposes. Here's some
sample code:CREATE CURSOR TimeSheets ;
(TimeSheetPK i,;
StoreFK i,;
Sheetdate d,;
isRoster l)
CREATE CURSOR TimeSheetDetails ;
(TimeSheetDetailsPK i,;
TimeSheetFK i,;
EmployeeFK i,;
StartTime T,;
EndTime T)
* roster time scheduled to work
INSERT INTO TimeSheets (TimeSheetPK, StoreFK, SheetDate, isRoster)
VALUES (1, 1, DATE(2021, 7, 12), .T.)
INSERT INTO TimeSheets (TimeSheetPK, StoreFK, SheetDate, isRoster)
VALUES (2, 1, DATE(2021, 7, 13), .T.)
INSERT INTO TimeSheets (TimeSheetPK, StoreFK, SheetDate, isRoster)
VALUES (3, 1, DATE(2021, 7, 14), .T.)
INSERT INTO TimeSheets (TimeSheetPK, StoreFK, SheetDate, isRoster)
VALUES (4, 1, DATE(2021, 7, 15), .T.)
INSERT INTO TimeSheets
Data Manipulation, Pivot?
but will shortly be moving to SQL Server * so you can use fastxtab if necessary as I should be able to change that to pivot table: CREATE CURSOR TimeRosteredAndWorked; (StoreFK i,; WeekStart D,; EmployeeFK i,; RosterStart1 T NULL,; RosterEnd1 T NULL,; WorkedStart1 T NULL,; WorkedEnd1 T NULL,; RosterStart2 T NULL,; RosterEnd2 T NULL,; WorkedStart2 T NULL,; WorkedEnd2 T NULL,; RosterStart3 T NULL,; RosterEnd3 T NULL,; WorkedStart3 T NULL,; WorkedEnd3 T NULL,; RosterStart4 T NULL,; RosterEnd4 T NULL,; WorkedStart4 T NULL,; WorkedEnd4 T NULL,; RosterStart5 T NULL,; RosterEnd5 T NULL,; WorkedStart5 T NULL,; WorkedEnd5 T NULL,; RosterStart6 T NULL,; RosterEnd6 T NULL,; WorkedStart6 T NULL,; WorkedEnd6 T NULL,; RosterStart7 T NULL,; RosterEnd7 T NULL,; WorkedStart7 T NULL,; WorkedEnd7 T NULL) * Employee 1 INSERT INTO TimeRosteredAndWorked ; (StoreFK,; WeekStart,; EmployeeFK,; RosterStart1,; RosterEnd1,; WorkedStart1,; WorkedEnd1,; RosterStart2,; RosterEnd2,; WorkedStart2,; WorkedEnd2,; RosterStart3,; RosterEnd3,; WorkedStart3,; WorkedEnd3,; RosterStart4,; RosterEnd4,; WorkedStart4,; WorkedEnd4,; RosterStart5,; RosterEnd5,; WorkedStart5,; WorkedEnd5,; RosterStart6,; RosterEnd6,; WorkedStart6,; WorkedEnd6,; RosterStart7,; RosterEnd7,; WorkedStart7 ,; WorkedEnd7); VALUES ; (1,; DATE(2021, 7, 12),; 1,; DATETIME(2021, 7, 12, 8, 0),; DATETIME(2021, 7, 12, 16, 0),; DATETIME(2021, 7, 12, 8, 30),; DATETIME(2021, 7, 12, 16, 30),; NULL,; NULL,; NULL,; NULL,; DATETIME(2021, 7, 14, 8, 0),; DATETIME(2021, 7, 14, 16, 0),; DATETIME(2021, 7, 14, 8, 10),; DATETIME(2021, 7, 14, 16, 10),; DATETIME(2021, 7, 15, 8, 0),; DATETIME(2021, 7, 15, 16, 0),; DATETIME(2021, 7, 15, 8, 20),; DATETIME(2021, 7, 15, 16, 20),; NULL,; NULL,; NULL,; NULL,; DATETIME(2021, 7, 17, 8, 0),; DATETIME(2021, 7, 17, 16, 0),; DATETIME(2021, 7, 17, 8, 40),; DATETIME(2021, 7, 17, 16, 40),; NULL,; NULL,; NULL,; NULL) * Employee 2 INSERT INTO TimeRosteredAndWorked ; (StoreFK,; WeekStart,; EmployeeFK,; RosterStart1,; RosterEnd1,; WorkedStart1,; WorkedEnd1,; RosterStart2,; RosterEnd2,; WorkedStart2,; WorkedEnd2,; RosterStart3,; RosterEnd3,; WorkedStart3,; WorkedEnd3,; RosterStart4,; RosterEnd4,; WorkedStart4,; WorkedEnd4,; RosterStart5,; RosterEnd5,; WorkedStart5,; WorkedEnd5,; RosterStart6,; RosterEnd6,; WorkedStart6,; WorkedEnd6,; RosterStart7,; RosterEnd7,; WorkedStart7 ,; WorkedEnd7); VALUES ; (1,; DATE(2021, 7, 12),; 2,; DATETIME(2021, 7, 12, 8, 0),; DATETIME(2021, 7, 12, 16, 0),; DATETIME(2021, 7, 12, 7, 0),; DATETIME(2021, 7, 12, 16, 0),; DATETIME(2021, 7, 13, 8, 0),; DATETIME(2021, 7, 13, 16, 0),; DATETIME(2021, 7, 13, 7, 45),; DATETIME(2021, 7, 13, 16, 0),; DATETIME(2021, 7, 14, 8, 0),; DATETIME(2021, 7, 14, 16, 0),; DATETIME(2021, 7, 14, 8, 5),; DATETIME(2021, 7, 14, 16, 0),; DATETIME(2021, 7, 15, 8, 0),; DATETIME(2021, 7, 15, 16, 0),; DATETIME(2021, 7, 15, 8, 15),; DATETIME(2021, 7, 15, 16, 0),; NULL,; NULL,; NULL,; NULL,; DATETIME(2021, 7, 17, 8, 0),; DATETIME(2021, 7, 17, 16, 0),; DATETIME(2021, 7, 17, 8, 25),; DATETIME(2021, 7, 17, 16, 0),; NULL,; NULL,; NULL,; NULL) I have used fastxtab which gets me close but the column names are based on the dates whereas I want to have fixed names for reference in the report, it also results in a separate row for each date for each employee whereas I want 1 row for each employee. Any suggestions as to the best way to approach this? -- Frank. Frank Cazabon ___ 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/3e98f042-81b7-c455-355e-b230145fe...@gmail.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.
RE: VFP Label Height changes
Good sleuthing Tracy! On 14 July 2021 16:14:32 GMT-04:00, Tracy Pearson wrote: >Crazy! > >I tracked down what was happening. >There is a caption_assign method on the base label class. >This is triggered before the init event. >The code in the caption_assign did not change the height of the label. >It >did adjust the width of a label. >When the width was adjusted the height would change, but there is not a >way >to capture that change and where it comes from. >I stepped through the code and never saw anything when I put an >height_assign method in there. > >So to correct this, I have to change the width of the label after the >form >has initialized. > >BINDEVENT(THISFORM, "INIT", THIS, "AFTER_FORM_INIT", 1) > >Awesome, it's working. > >Well, now I'm trying to launch a form that takes a parameter. > >Local nId >nId = 2547 >DO FORM TestForm with nId > >That errors with something that makes no sense. (Function argument >value, >type, or count is invalid.) > >DO FORM TestForm with 2547 > >That works without an error. > >Should I attempt to bind to the forms Show event? >Should I trigger something in the forms visible_assign code? > >I went with the visible_assign code today and the error isn't happening >anymore. > >So, if you need to resize something that needs to reference the parent >of an >object, don't do it in the child init method. Some properties don't >stay as >you suspect them to. > >Have Fun! >Tracy > > >-Original Message- >From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of >Tracy >Pearson >Sent: Friday, July 09, 2021 9:44 AM >To: profoxt...@leafe.com >Subject: RE: VFP Label Height changes > >Frank, > >I originally went down that path. Then I put some code in the INIT of >the >control on the form. >?PROGRAM(PROGRAM(-1)),"Height:",THIS.Height >DODEFAULT() > >That was when I decided I needed to figure out a hack to get around the >problem. If it is telling me the height of the control at the INIT was >17 >instead of 19 that was a problem. > >When I changed the Height to be overwritten to 19 in the cNavButton >class, >the above code correctly showed 19. >When I reset Height to default, it again showed 17. > >I spent a few hours attempting to reproduce it in a new project. I am >not >seeing the behavior currently. I'll may get some more time this weekend >to >continue my efforts. > > >Tracy > >-Original Message- >From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of >Frank >Cazabon >Sent: Thursday, July 08, 2021 10:48 AM >To: profoxt...@leafe.com >Subject: Re: VFP Label Height changes > >Tracy, > >you able to recreate this with base VFP controls and then maybe add in >your controls one by one to see where it's happening? > >Maybe there's some resizing code running or bindevents that does >something "special"? > >Frank. > >Frank Cazabon > >On 07/07/2021 4:46 pm, Tracy Pearson wrote: >> On cLabel and default everywhere used in this scenario. >> FontName: Segoe UI >> FontSize: 10 >> >> -Original Message- >> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of >Richard >> Kaye >> Sent: Wednesday, July 07, 2021 4:40 PM >> To: profoxt...@leafe.com >> Subject: RE: VFP Label Height changes >> >> What is the default height for the font name and size used? >> >> -- >> >> rk >> >> -Original Message- >> From: ProfoxTech On Behalf Of Tracy >Pearson >> Sent: Wednesday, July 7, 2021 3:37 PM >> To: profoxt...@leafe.com >> Subject: RE: VFP Label Height changes >> >> Autosize = .F. >> Alignment is centered >> The Label class doesn't have IntegralHeight. >> >> >> Tracy >> >> -Original Message- >> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of >Richard >> Kaye >> Sent: Wednesday, July 07, 2021 3:17 PM >> To: profoxt...@leafe.com >> Subject: RE: VFP Label Height changes >> >> Autosize? IntegralHeight? >> >> -- >> >> rk >> >> >> [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/a81ba8c7-8657-4e6f-98be-711185d78...@gmail.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.
Re: VFP Label Height changes
Tracy, you able to recreate this with base VFP controls and then maybe add in your controls one by one to see where it's happening? Maybe there's some resizing code running or bindevents that does something "special"? Frank. Frank Cazabon On 07/07/2021 4:46 pm, Tracy Pearson wrote: On cLabel and default everywhere used in this scenario. FontName: Segoe UI FontSize: 10 -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Wednesday, July 07, 2021 4:40 PM To: profoxt...@leafe.com Subject: RE: VFP Label Height changes What is the default height for the font name and size used? -- rk -Original Message- From: ProfoxTech On Behalf Of Tracy Pearson Sent: Wednesday, July 7, 2021 3:37 PM To: profoxt...@leafe.com Subject: RE: VFP Label Height changes Autosize = .F. Alignment is centered The Label class doesn't have IntegralHeight. Tracy -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Wednesday, July 07, 2021 3:17 PM To: profoxt...@leafe.com Subject: RE: VFP Label Height changes Autosize? IntegralHeight? -- rk [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/d11e0b83-ed7a-ba9e-839b-ab17516f2...@gmail.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.
Re: Strange display of DropDownList in Grid
Hi Tracy, sorry for the delay. I tried to stay away from the computer this weekend. My rowsourcetype = 1-value, style = 2-dropdown list Frank. Frank Cazabon On 25/06/2021 5:18 pm, Tracy Pearson wrote: Frank, I'm tinkering with a dropdown for something completely different than this post, and what do I see? That picture you posted of the odd caret on the left of the dropdown and no text included. By chance, is your dropdown being populated with a RowSourceType = 9 (popup) ??? Tracy -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Frank Cazabon Sent: Wednesday, June 02, 2021 8:32 AM To: profox@leafe.com Subject: Re: Strange display of DropDownList in Grid Thanks for checking this out Tracy. It's a subclass from the framework I use (Visual MaxFrame Professional). I'll experiment some more today and see if I can tie it down. Frank. Frank Cazabon On 01/06/2021 5:12 pm, Tracy Pearson wrote: I took another look at that. And I think that might be an odd scrollbar happening because the height of the dropdown got screwed up. That is very odd. Is that a standard combobox or one that has some customization? Tracy -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank Cazabon Sent: Tuesday, June 01, 2021 5:08 PM To: profoxt...@leafe.com Subject: RE: Strange display of DropDownList in Grid Thanks, I don't think that's the case here but I'll double check. I hardly ever use combo boxes, not sure why I did in this case. Maybe I'll just go back to my normal way and replace this combo. On 1 June 2021 16:57:23 GMT-04:00, Tracy Pearson wrote: I see that on a ComboBox on a form when the underlying controlsource is a value that is not in the RowSource. I think it might be the reason in the grid as well. HTH, Tracy -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank Cazabon Sent: Tuesday, June 01, 2021 3:22 PM To: profoxt...@leafe.com Subject: Re: Strange display of DropDownList in Grid Doh! forgot about the pictures not coming in the list. I've put it on imgur: https://imgur.com/a/eYWgr1b It's the only control in the column so sparse shouldn't be a problem. Not sure where/when to try calling thisform.cls() The problem seems to happen if I click anywhere in the combo, then move the mouse to try to select an item in the list (but don't actually click on anything). Frank. Frank Cazabon On 01/06/2021 3:05 pm, Tracy Pearson wrote: Pictures don't come through the list. I have learned if one drags the scrollbar of a listbox below or above the listbox, then select an item, the Item is not changed. I don't think that's what you are talking about. Does it have to do with the Column Sparse property? Does calling THISFORM.CLS() clear any odd drawing over the grid? The system I maintain has a ComboBox configured as a DropDown in a grid. I've not heard any complaints about it. HTH, Tracy -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank Cazabon Sent: Tuesday, June 01, 2021 2:56 PM To: profoxt...@leafe.com Subject: Strange display of DropDownList in Grid It's just come to my attention that in a certain instance, if I have a drop down list in a grid and I click on it then move the mouse as if I am going to select one of the options, the display changes to this: Anyone seen this before and got a way to fix it? Sometimes it fixes itself other times it's a real pain to get rid of and display the list properly. [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/c3939e1e-3448-cc31-2cf4-4edf0f9a0...@gmail.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.
Re: Strange display of DropDownList in Grid
Thanks for checking this out Tracy. It's a subclass from the framework I use (Visual MaxFrame Professional). I'll experiment some more today and see if I can tie it down. Frank. Frank Cazabon On 01/06/2021 5:12 pm, Tracy Pearson wrote: I took another look at that. And I think that might be an odd scrollbar happening because the height of the dropdown got screwed up. That is very odd. Is that a standard combobox or one that has some customization? Tracy -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank Cazabon Sent: Tuesday, June 01, 2021 5:08 PM To: profoxt...@leafe.com Subject: RE: Strange display of DropDownList in Grid Thanks, I don't think that's the case here but I'll double check. I hardly ever use combo boxes, not sure why I did in this case. Maybe I'll just go back to my normal way and replace this combo. On 1 June 2021 16:57:23 GMT-04:00, Tracy Pearson wrote: I see that on a ComboBox on a form when the underlying controlsource is a value that is not in the RowSource. I think it might be the reason in the grid as well. HTH, Tracy -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank Cazabon Sent: Tuesday, June 01, 2021 3:22 PM To: profoxt...@leafe.com Subject: Re: Strange display of DropDownList in Grid Doh! forgot about the pictures not coming in the list. I've put it on imgur: https://imgur.com/a/eYWgr1b It's the only control in the column so sparse shouldn't be a problem. Not sure where/when to try calling thisform.cls() The problem seems to happen if I click anywhere in the combo, then move the mouse to try to select an item in the list (but don't actually click on anything). Frank. Frank Cazabon On 01/06/2021 3:05 pm, Tracy Pearson wrote: Pictures don't come through the list. I have learned if one drags the scrollbar of a listbox below or above the listbox, then select an item, the Item is not changed. I don't think that's what you are talking about. Does it have to do with the Column Sparse property? Does calling THISFORM.CLS() clear any odd drawing over the grid? The system I maintain has a ComboBox configured as a DropDown in a grid. I've not heard any complaints about it. HTH, Tracy -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank Cazabon Sent: Tuesday, June 01, 2021 2:56 PM To: profoxt...@leafe.com Subject: Strange display of DropDownList in Grid It's just come to my attention that in a certain instance, if I have a drop down list in a grid and I click on it then move the mouse as if I am going to select one of the options, the display changes to this: Anyone seen this before and got a way to fix it? Sometimes it fixes itself other times it's a real pain to get rid of and display the list properly. [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/346c6655-80b4-ae2b-b371-3debdfd02...@gmail.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.
RE: Strange display of DropDownList in Grid
Thanks, I don't think that's the case here but I'll double check. I hardly ever use combo boxes, not sure why I did in this case. Maybe I'll just go back to my normal way and replace this combo. On 1 June 2021 16:57:23 GMT-04:00, Tracy Pearson wrote: >I see that on a ComboBox on a form when the underlying controlsource is >a >value that is not in the RowSource. >I think it might be the reason in the grid as well. > >HTH, >Tracy > >-Original Message- >From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of >Frank >Cazabon >Sent: Tuesday, June 01, 2021 3:22 PM >To: profoxt...@leafe.com >Subject: Re: Strange display of DropDownList in Grid > >Doh! forgot about the pictures not coming in the list. I've put it on >imgur: https://imgur.com/a/eYWgr1b > >It's the only control in the column so sparse shouldn't be a problem. > >Not sure where/when to try calling thisform.cls() > >The problem seems to happen if I click anywhere in the combo, then move > >the mouse to try to select an item in the list (but don't actually >click >on anything). > >Frank. > >Frank Cazabon > >On 01/06/2021 3:05 pm, Tracy Pearson wrote: >> Pictures don't come through the list. >> >> I have learned if one drags the scrollbar of a listbox below or above >the >> listbox, then select an item, the Item is not changed. >> >> I don't think that's what you are talking about. >> >> Does it have to do with the Column Sparse property? >> >> Does calling THISFORM.CLS() clear any odd drawing over the grid? >> >> The system I maintain has a ComboBox configured as a DropDown in a >grid. >> I've not heard any complaints about it. >> >> HTH, >> Tracy >> >> -Original Message- >> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of >Frank >> Cazabon >> Sent: Tuesday, June 01, 2021 2:56 PM >> To: profoxt...@leafe.com >> Subject: Strange display of DropDownList in Grid >> >> It's just come to my attention that in a certain instance, if I have >a >> drop down list in a grid and I click on it then move the mouse as if >I >> am going to select one of the options, the display changes to this: >> >> Anyone seen this before and got a way to fix it? >> >> Sometimes it fixes itself other times it's a real pain to get rid of >and >> display the list properly. >> > [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/1cc3b4a5-b456-45eb-bc95-b22ebd441...@gmail.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.
Re: Strange display of DropDownList in Grid
Doh! forgot about the pictures not coming in the list. I've put it on imgur: https://imgur.com/a/eYWgr1b It's the only control in the column so sparse shouldn't be a problem. Not sure where/when to try calling thisform.cls() The problem seems to happen if I click anywhere in the combo, then move the mouse to try to select an item in the list (but don't actually click on anything). Frank. Frank Cazabon On 01/06/2021 3:05 pm, Tracy Pearson wrote: Pictures don't come through the list. I have learned if one drags the scrollbar of a listbox below or above the listbox, then select an item, the Item is not changed. I don't think that's what you are talking about. Does it have to do with the Column Sparse property? Does calling THISFORM.CLS() clear any odd drawing over the grid? The system I maintain has a ComboBox configured as a DropDown in a grid. I've not heard any complaints about it. HTH, Tracy -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank Cazabon Sent: Tuesday, June 01, 2021 2:56 PM To: profoxt...@leafe.com Subject: Strange display of DropDownList in Grid It's just come to my attention that in a certain instance, if I have a drop down list in a grid and I click on it then move the mouse as if I am going to select one of the options, the display changes to this: Anyone seen this before and got a way to fix it? Sometimes it fixes itself other times it's a real pain to get rid of and display the list properly. ___ 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/e8446b7d-3006-46e8-d1c1-3b074b451...@gmail.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.
Strange display of DropDownList in Grid
It's just come to my attention that in a certain instance, if I have a drop down list in a grid and I click on it then move the mouse as if I am going to select one of the options, the display changes to this: Anyone seen this before and got a way to fix it? Sometimes it fixes itself other times it's a real pain to get rid of and display the list properly. -- Frank. Frank Cazabon --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) multipart/related text/html image/png --- ___ 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/2acebbca-9639-3be7-5481-116829a4b...@gmail.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.
Re: Formset goofy
Hi Joe, I haven't used formsets since FPW 2.6 (if my memory is correct). They really aren't necessary these days as you can do everything that they can do with single standalone forms, without getting involved in the complexities/strangeness of formsets. However I don't think your issue has anything to do with formsets in particular. If I understand your description properly you just set the left value of one of the screens to a large negative number and you want to set it to a different (not negative value). As far as I am aware there is no one click method to do this. you can manually change the value in the properties sheet, or you can use sys(1270) to get a reference to the form when you have it open in the designer and then set its properties in the command window: move the mouse over the title bar of the form or somewhere on the form that has no controls x = sys(1270) (in the command window) x.left = 0 Frank. Frank Cazabon On 26/05/2021 5:28 pm, Joe Yoder wrote: I have been working with two forms in a formset for the first time. All has worked out well as the two forms are simply two perspectives on the underlying data. I switch between them by turning visible on and off. One of the forms somehow got set to max width in the development environment. This is a nuisance to work with but I didn't bother to fix it until this morning. My fix was to scroll to the right bound of the screen and drag the right side of the screen to the left as far as I could and then repeat. This made it much easier to switch between the forms. In the same session I deleted a series of controls from form2 and replaced them with new ones. When I built the formset form 1 no longer has any controls showing up either in the form designer or when running the form. I Investigated and at least some of the form1 controls are still in the ,SCX. Actually I checked details in the Properties of the Formset for the missing form and discovered the Left setting was -1946 while the same setting for the present form was 8. Setting the negative value to 8 restored the missing controls. I'm quessing I inadvertently garbed the whole form rather than the right bound when I was making the screen narrower. Now my question is - is there a one click solution in the UI to correct this situation or is manual editing of the properties the best approach? Thanks in advance, Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [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/9bb75c86-0f15-fe47-e2b8-589106fd1...@gmail.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.
Re: _framewk,vct is missing or invalid, but it isn't and it's not.
Grant the user (or everyone) full control? Could it be anything to do with that old virtualisation thing that Windows used to do? Frank. Frank Cazabon On 04/05/2021 9:24 am, Ted Roche wrote: Rebuilding a project that includes c:\program files (x86)\microsoft visual foxpro 9\wizards\_framewk.vcx gives the error Memo file c:\program files (x86)\microsoft visual foxpro 9\wizards\_framewk.VCT is missing or invalid. But it isn't and it's not. I copied both _framewk files from another machine where it works, no change. I opened the file exclusively and tried to PACK and get the same error. I copy the two files to C:\temp and they pack fine, and compile classlib works there (after I also copied over _framewk.h) but moving the files back to the above directory and attempting a build project, rebuild all throws the same error. This is a permissions issue with the program files (x86) folder and I've tried turning off the "Read Only" settings and in the folder permissions granting Modify and Write to the Users group, but the errors continue. Any suggestions on how to get the Program files (x86) to be read-write for VFP? Moving the files to the project folder would be my preference, but it is not my project. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [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/461d9abf-f050-1658-727e-6fc8901c7...@gmail.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.
Re: Drag and Drop code
Might help you with the debugging: OLE Drag and Drop | Hacker’s Guide to Visual FoxPro (hackfox.github.io) <https://hackfox.github.io/section4/s4g830.html> Might help with specifics: Using Drag and Drop In Visual FoxPro (aksel.com) <http://www.aksel.com/whitepapers/DragDrop.htm> Frank. Frank Cazabon On 03/05/2021 3:43 pm, MB Software Solutions, LLC wrote: Many many moons ago I did some drag and drop code, but I have forgotten completely and it's no longer in my possession anyway. I want to drag names amongst a screen full of listboxes: https://www.screencast.com/t/6M8XxvSFV I know I need to code in the OLEDragDrop event and native VFP Help sucks, not really showing me anything. I was thinking the oDataObject was the listbox where the drag started but no. I tried to SET STEP ON but VFP says "CANCEL or SUSPEND is not allowed." LPARAMETERS oDataObject, nEffect, nButton, nShift, nXCoord, nYCoord LOCAL loLB as ListBox loLB = oDataObject wait window loLB.ListCount && this fails SET STEP ON && this doesn't work either I have the properties set correctly to allow me to drag from one list to another but now I'm stuck. Going to search the archives next but throwing this out there in the meantime. Was hoping to have drag/drop implemented by the time I had a ZOOM call with my fellow hockey captains to set the teams tonight! tia, --Michael --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ 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/7cb778e3-f349-b55b-c232-5fc245c1b...@gmail.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.
Re: Variations in CSV settings by region
I have never seen a standard when it comes to CSV. I have stopped using Excel and use Libre Office and when I try to save a file as CSV it prompts for Character set, field delimiter and String delimiter. Would the issue go away if you specified a tab as your field delimiter and no string delimiter? Or do your customers have no control over the production of the files? Frank. Frank Cazabon On 16/04/2021 10:33 am, Richard Kaye wrote: Hey Ted! It's snowing here in lovely MA right now... Happy April! I agree but it's not so much the users getting creative with the required formats (well, generally speaking...). The issue is what when the Belgian user exports the data from Excel, it's going to default to semis and no quotes and then our current import routine will choke. Ultimately I think I'm going to have to build a pre-import parsing method. -- rk -Original Message- From: ProfoxTech On Behalf Of Ted Roche Sent: Friday, April 16, 2021 10:26 AM To: profoxt...@leafe.com Subject: Re: Variations in CSV settings by region We did a lot of this in the 90s and aughts, with customers as far away as Louisiana and Indiana ;) and no one agrees on what CSV "standard" means. You could go the "AI" way of performing a FileToStr() and trying to parse out what the creator intended, but I think that might be overkill, and dates are ambiguous, even on a good day. "3/8/20" means... ? Our customers were in a similar situation: their customers were shipping them price lists and inventory lists in every format known. When they would explain they needed the format to be stable, the next month's sheets would show up with new columns added (and sometimes hidden!) and others re-arranged. We ended up leaving it to our customers to use Excel to import what they were sent, and reformat it as needed to a standard format, and exporting THAT as a strict CSV to import into the system. It was too much work to reinvent the wheel already built into Excel. "Be liberal in what you accept, but strict in what you emit" -- Postel's Law, roughly. (https://en.wikipedia.org/wiki/Robustness_principle) On Fri, Apr 16, 2021 at 9:42 AM Richard Kaye wrote: Throwing this one out to the collective wisdom. We're doing a lot with CSV import/experts these days with our web-based WWC application and are running into issues with regionalization. Here in the US, a "standard" CSV means commas between data elements and double quotes around text elements. But in Belgium, the delimiter is the semi-colon and text elements are not wrapped in double quotes. As best I can tell, Excel determines what format to use by the OS settings and not its own application settings. This makes importing from a CSV a bit of a dance for our Belgian clients as they have to change their regional settings, import the file that was received in US format, and then change their settings back. And, of course, changing region affects date and currency formats. For those of you working with clients from multiple locations where the standards may be different, what strategies do you use to deal with this? TIA -- rk --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [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/e4b38e1b-832b-f552-fa42-163643519...@gmail.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.
Re: File Server Sharing SMB1: W10 Update KB5001330 shuts off SMB1
My guess is he meant this: HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\MRXSmb\Parameters Frank. Frank Cazabon On 15/04/2021 6:53 am, Peter Cushing wrote: Hi Christof, Is there a word missing from the key below (before Parameters)? Peter On 14/04/2021 16:54, Christof Wollenhaupt wrote: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\\Parameters OplocksDisabled DWORD 1 This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email. www.whisperingsmith.com Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715 London Office: 101 St. Martin's Lane,London, WC2N 4AZ Tel:0207 299 7960 [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/f68e12bd-3783-16e7-c881-7b243b1ee...@gmail.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.
Re: Interesting Error 1426 on COPY TO (lcFile) FIELDS a, b, c FOR condition TYPE XL5
Hey Mike, what exactly worked?
On 8 April 2021 13:34:30 GMT-04:00, "MB Software Solutions, LLC"
wrote:
>Thanks, Frank and othersthat worked.
>
>
>On 4/7/2021 8:52 AM, Frank Cazabon wrote:
>> Hi Mike,
>>
>> have you worked this out yet?
>>
>> On my Windows 10 PC, this line:
>>
>> SYS(5) + ADDBS(GETENV("HOMEPATH")) + "Documents\"
>>
>> gives me the correct path, however, maybe the sys(5) is returning the
>
>> incorrect drive? Possibly the documents folder is not in the same
>> folder as your default drive?
>>
>> This is what I use to get the Documents folder:
>>
>> #DEFINE CSIDL_PERSONAL 0x0005
>> LOCAL lcFolderPath, lcDocumentsPath
>> m.lcFolderPath = space(255)
>>
>> DECLARE SHORT SHGetFolderPath IN SHFolder.dll ;
>> INTEGER hwndOwner, INTEGER nFolder, INTEGER hToken, ;
>> INTEGER dwFlags, STRING @pszPath
>>
>> SHGetFolderPath(0, CSIDL_PERSONAL, 0, 0, @m.lcFolderPath)
>>
>> m.lcDocumentsPath = Alltrim(m.lcFolderPath)
>>
>> m.lcDocumentsPath = SubStr(m.lcDocumentsPath,1,
>Len(m.lcDocumentsPath)
>> - 1)
>> RETURN ADDBS(m.lcDocumentsPath)
>>
>> Maybe another possibility is you are trying to copy more data than
>> Excel can handle (I can't remember the limit from that version) or
>> maybe there is bad data, like a date before 1/1/1900?
>>
>> But then again, those last 2 issues would probably only occur when
>> actually trying to open the file in Excel.
>>
>> FWIW I use this code for creating Excel files these days:
>>
>> loExcel = NEWOBJECT("VFPxWorkbookXLSX",
>"VFPxWorkbookXLSX.vcx")
>> loExcel.SaveTabletoWorkbook(m.lcTable, m.lcXLSFile, .T., .T.)
>>
>> I believe the URL for this utility is:
>>
>> https://github.com/ggreen86/XLSX-Workbook-Class
>>
>> Doug Hennig has a paper here that may be helpful if you want to
>> consider alternatives:
>>
>> https://doughennig.com/papers/Pub/201607dhen.pdf
>>
>> Frank.
>>
>> Frank Cazabon
>>
>> On 06/04/2021 1:56 pm, MB Software Solutions, LLC wrote:
>>> I get this error when executing a COPY TO TYPE XL5 line in a
>>> program designed over a decade ago: /OLE error code 0x80030003:
>>> Unknown COM status code. /
>>>
>>> Interesting. I remoted into the guy's computer. He said it's a
>>> fairly new laptop (3 months old?) and it's version is 2102 (Build
>>> 13801.20360). I fired up vRunFox.exe and did a simple xx =
>>> CREATEOBJECT("Excel.Application") and it worked fine. What's
>strange
>>> to me is that the line throwing that Error 1426 is not an Excel
>>> automation line, but the COPY TO line. I believe the problem is the
>
>>> lcFile variable. When this code was written, Vista was the latest
>>> operating system. You can see how I look at the OS() to select the
>>> proper area for My Documents.
>>>
>>> *** mjb 03/03/2010 - changed for Vista and beyond
>>> IF VAL(SUBSTR(OS(),9,1)) >= 6 THEN && Vista doesn't use My
>>> lcDir = SYS(5) + ADDBS(GETENV("HOMEPATH")) +
>"Documents\"
>>> ELSE && XP and below use My
>>> lcDir = SYS(5) + ADDBS(GETENV("HOMEPATH")) + "My
>Documents\"
>>> ENDIF
>>> lcFile = ADDBS(lcDir) + "Inventory_" + DTOC(DATE(),1)
>>> *** mjb 06/26/2017 - added nbrdft, ntotbf
>>> IF this.lShowZeroQty THEN
>>> COPY TO (lcFile) FIELDS ccompany, cpalletsize,
>>> cdescription, nqtyonhand, nprice, ntotvalue, nbrdft, ntotbf FOR
>>> this.CustomerSelected(icustid) TYPE XL5
>>> ELSE
>>> COPY TO (lcFile) FIELDS ccompany, cpalletsize,
>>> cdescription, nqtyonhand, nprice, ntotvalue, nbrdft, ntotbf FOR
>>> this.CustomerSelected(icustid) AND nQtyOnHand > 0 TYPE XL5
>>> ENDIF
>>>
>>> So in short, I think the fact that it's Error 1426 is misleading...I
>
>>> doubt it's an Excel problem at all but in fact a problem with that
>>> lcFile actual path derived.
>>>
>>> I think somebody recently mentioned a Doug Hennig bit of code to
>look
>>> at the user's ACTUAL path to his documents area, iirc? I'll dig for
>>> that later after an appt but wanted to throw this out there in the
>>> meanwhile in case others have the "I had that happen to me and thi
Re: Interesting Error 1426 on COPY TO (lcFile) FIELDS a, b, c FOR condition TYPE XL5
Hi Mike,
have you worked this out yet?
On my Windows 10 PC, this line:
SYS(5) + ADDBS(GETENV("HOMEPATH")) + "Documents\"
gives me the correct path, however, maybe the sys(5) is returning the
incorrect drive? Possibly the documents folder is not in the same folder
as your default drive?
This is what I use to get the Documents folder:
#DEFINE CSIDL_PERSONAL 0x0005
LOCAL lcFolderPath, lcDocumentsPath
m.lcFolderPath = space(255)
DECLARE SHORT SHGetFolderPath IN SHFolder.dll ;
INTEGER hwndOwner, INTEGER nFolder, INTEGER hToken, ;
INTEGER dwFlags, STRING @pszPath
SHGetFolderPath(0, CSIDL_PERSONAL, 0, 0, @m.lcFolderPath)
m.lcDocumentsPath = Alltrim(m.lcFolderPath)
m.lcDocumentsPath = SubStr(m.lcDocumentsPath,1, Len(m.lcDocumentsPath) - 1)
RETURN ADDBS(m.lcDocumentsPath)
Maybe another possibility is you are trying to copy more data than
Excel can handle (I can't remember the limit from that version) or maybe
there is bad data, like a date before 1/1/1900?
But then again, those last 2 issues would probably only occur when
actually trying to open the file in Excel.
FWIW I use this code for creating Excel files these days:
loExcel = NEWOBJECT("VFPxWorkbookXLSX", "VFPxWorkbookXLSX.vcx")
loExcel.SaveTabletoWorkbook(m.lcTable, m.lcXLSFile, .T., .T.)
I believe the URL for this utility is:
https://github.com/ggreen86/XLSX-Workbook-Class
Doug Hennig has a paper here that may be helpful if you want to consider
alternatives:
https://doughennig.com/papers/Pub/201607dhen.pdf
Frank.
Frank Cazabon
On 06/04/2021 1:56 pm, MB Software Solutions, LLC wrote:
I get this error when executing a COPY TO TYPE XL5 line in a
program designed over a decade ago: /OLE error code 0x80030003:
Unknown COM status code. /
Interesting. I remoted into the guy's computer. He said it's a fairly
new laptop (3 months old?) and it's version is 2102 (Build
13801.20360). I fired up vRunFox.exe and did a simple xx =
CREATEOBJECT("Excel.Application") and it worked fine. What's strange
to me is that the line throwing that Error 1426 is not an Excel
automation line, but the COPY TO line. I believe the problem is the
lcFile variable. When this code was written, Vista was the latest
operating system. You can see how I look at the OS() to select the
proper area for My Documents.
*** mjb 03/03/2010 - changed for Vista and beyond
IF VAL(SUBSTR(OS(),9,1)) >= 6 THEN && Vista doesn't use My
lcDir = SYS(5) + ADDBS(GETENV("HOMEPATH")) + "Documents\"
ELSE && XP and below use My
lcDir = SYS(5) + ADDBS(GETENV("HOMEPATH")) + "My Documents\"
ENDIF
lcFile = ADDBS(lcDir) + "Inventory_" + DTOC(DATE(),1)
*** mjb 06/26/2017 - added nbrdft, ntotbf
IF this.lShowZeroQty THEN
COPY TO (lcFile) FIELDS ccompany, cpalletsize,
cdescription, nqtyonhand, nprice, ntotvalue, nbrdft, ntotbf FOR
this.CustomerSelected(icustid) TYPE XL5
ELSE
COPY TO (lcFile) FIELDS ccompany, cpalletsize,
cdescription, nqtyonhand, nprice, ntotvalue, nbrdft, ntotbf FOR
this.CustomerSelected(icustid) AND nQtyOnHand > 0 TYPE XL5
ENDIF
So in short, I think the fact that it's Error 1426 is misleading...I
doubt it's an Excel problem at all but in fact a problem with that
lcFile actual path derived.
I think somebody recently mentioned a Doug Hennig bit of code to look
at the user's ACTUAL path to his documents area, iirc? I'll dig for
that later after an appt but wanted to throw this out there in the
meanwhile in case others have the "I had that happen to me and this is
how I fixed it!" kind of memory recall. ;-)
tia,
--Mike
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
___
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/466d4767-bccb-ade1-0d65-32e5f29fe...@gmail.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.
Re: Grid with an centered image
Hey Tracy, can you put together a simple example to share here and maybe one of us can have a look at it? Frank. Frank Cazabon On 17/03/2021 6:43 pm, Tracy Pearson wrote: I have spent a few days on this. I have a routine in our base form class that will resize the controls according to the DPI settings of the system. Since this happens in the form Init, the grid has already been initialized any centering of an object in a container in a grid column does not appear to display that way. I have used the DynamicCurrentControl property to call a method to be sure the image is centered. I have stepped through that code and see that it centers the image in the container. Once I release the break, visually the image is not centered in the container in the grid. (note: DynamicCurrentControl is fired multiple times for each visible row in the grid when the data is changed) -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Tracy Pearson Sent: Monday, March 08, 2021 5:41 PM To: profoxt...@leafe.com Subject: RE: Grid with an centered image Hi Frank, That's where I went first. We have a process that changes the font size used in the grid. I was attempting to base centering the image on the container based on the container size. The container size doesn't change with the rowheight of the grid. I didn't try an anchor. I may need to create a container base that holds the image control and the correct size and see what happens. I'll get back to you. Thank you, Tracy -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank Cazabon Sent: Monday, March 08, 2021 5:26 PM To: profoxt...@leafe.com Subject: Re: Grid with an centered image How about trying it in a container? On 8 March 2021 16:28:12 GMT-04:00, Tracy Pearson wrote: Hello everyone, I am wanting to add an image to a column in a grid and it be centered. Using the image control directly leaves the image in the upper left. (0 - Clip) Allowing the image to grow causes pixilation. (1 - Isometric, 2 - Stretch) I have placed the image in a button that this does the trick. It adds another problem that needs to be taken care of. The product uses the HighlightStyle 2 - Current row highlighting enabled with visual persistence. The CommandButton doesn't have a setting to be transparent. What options might I have to have the color come through around a centered image to have the highlight color set as the background color of the button for the current selected row Thank you, Tracy ___ 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/001101d71459$8fdbcab0$af936010$@powerchurc h.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. Report [OT] Abuse: http://leafe.com/reportAbuse/001101d71459$8fdbcab0$af936010$@powerchurch.co m ___ 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/aaad6340-945d-7662-5d1d-335289e63...@gmail.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.
Re: Debenu.com/FoxItSoftware for creating PDFs
I would consider creating a Windows service to do that, or maybe a scheduled job in Task Scheduler. I'd probably use C# :0) Frank. Frank Cazabon On 09/03/2021 10:13 am, MB Software Solutions, LLC wrote: If this were your task (/Task: Create PDFs via scheduled job calls of my Fox EXE for creating "reports at certain times of day" for historical review for various users to view for their own data/), how would you implement it? Remember this is a seamless process running on the Server, creating the various reports for various individual users, and to access them, they go to their "My Reports" link on either the website (this is a WWWC app) or the equivalent in their desktop application. On 3/9/2021 12:45 AM, MB Software Solutions, LLC wrote: Task: Create PDFs via scheduled job calls of my Fox EXE for creating "reports at certain times of day" for historical review for various users to view for their own data. I know XFRX creates PDFs easily (along with other outputs like Excel) but I already have the QuickPDF tool in my arsenal from FoxItSofware.com (formerly DebEnu.com) and FoxIt's software has a LOT of features for password-protecting PDFs among others. Has anyone implemented FoxIt's tools in their apps for creating PDFs? tia, --Mike ___ 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/aa630916-c580-3a41-ed2d-0aadd3b13...@gmail.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.
Re: Grid with an centered image
How about trying it in a container? On 8 March 2021 16:28:12 GMT-04:00, Tracy Pearson wrote: >Hello everyone, > >I am wanting to add an image to a column in a grid and it be centered. >Using the image control directly leaves the image in the upper left. (0 >- >Clip) >Allowing the image to grow causes pixilation. (1 - Isometric, 2 - >Stretch) > >I have placed the image in a button that this does the trick. >It adds another problem that needs to be taken care of. >The product uses the HighlightStyle 2 - Current row highlighting >enabled >with visual persistence. >The CommandButton doesn't have a setting to be transparent. > >What options might I have >to have the color come through around a centered image > to have the highlight color set as the background color of the button >for the current selected row > > >Thank you, >Tracy > > > >___ >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/001101d71459$8fdbcab0$af936010$@powerchurch.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. > >Report [OT] Abuse: >http://leafe.com/reportAbuse/001101d71459$8fdbcab0$af936010$@powerchurch.com -- Frank Cazabon Sent from my phone. Please excuse my brevity. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ 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/d4adea97-93e8-4501-9602-939743d3c...@gmail.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.
Re: XFRX support
You could try on level extreme (formerly universal thread). I see responses from her there regularly. On 20 February 2021 23:08:23 GMT-04:00, "MB Software Solutions, LLC" wrote: >Attn XFRX users, > >I've emailed XFRX and replied directly to Martina at eq...@eqeus.com >and >supp...@eqeus.com but gotten no response regarding this question: > >Hi Martina and team, > >I did not get a response from you on this. *Does the XFRX Private >Cloud solution exist? *I have a client who could use it. > >_*Please advise ASAP as I need to bid the job.*_ > > >Is there a better space to tap into Martina and the XFRX team? The >truth >is I'll probably buy this anyway but wondered. > >tia, >--Mike > > > > >-- >This email has been checked for viruses by Avast antivirus software. >https://www.avast.com/antivirus > > >--- StripMime Report -- processed MIME parts --- >multipart/alternative > text/plain (text body -- kept) > text/html >--- > >___ >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/4e07b5f6-5a4e-3e85-d0e5-3978356b6...@mbsoftwaresolutions.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. > >Report [OT] Abuse: >http://leafe.com/reportAbuse/4e07b5f6-5a4e-3e85-d0e5-3978356b6...@mbsoftwaresolutions.com -- Frank Cazabon Sent from my phone. Please excuse my brevity. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ 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/b7d1aaf7-1e76-4fdb-b455-478507059...@gmail.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.
Re: Report Switching cursor (by itself?)
Hi Vince, is curplants the recordsource if a grid on the screen? If so then move focus away from the grid prior to running the report. The grid is greedy and tries to get it's controlsource selected all the time. Frank. Frank Cazabon On 05/02/2021 8:59 am, Vince Teachout wrote: I've already implemented a work-around, but I'd like to know what's causing this. I have a report that builds a list of plant locations (curPlants), then builds a cursor full of data for a report. (cList) When I'm ready, I do this: Select cList Report Form MyReport blahblah It INSISTS on making curPlants the current cursor, massively messing up the report. I checked and there is nothing in the report data environment, or TAG1/TAG2. I set the DE initial cursor to cList, and get the same behavior. There is no mention of curPlants in the report form anywhere (It runs fine if I CLOSE curPlants) During debugging I stopped it, verified it was on the correct cursor with a browse, let it proceed - and it worked just as it should, using cList. Also during debugging I accidentally introduced a non-fatal error. It stopped, I ignored the error, and it proceeded to work correctly, using cList. Remove the error line, and don't pause... and it selects curPlants. WTH? I got around this by CLOSEing curPlants, which is less than Ideal, because then I have to close the screen, so they can't run multiple reports, but it's acceptable. Any Ideas? I wasted several hours on this. ___ 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/402d63f7-0f67-d3d8-0f5b-166fec9c0...@gmail.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.
Re: Setting Class Libraries
I guess that might work depending on if your class is the same name as in other classes included in the exe and with a set classlib to earlier in the code. Frank. Frank Cazabon On 15/01/2021 2:41 pm, Philip Borkholder wrote: Thanks Frank, Second question. What if I set CLASSLIBRARY TO mynewerclass.vcx ADDITIVE IN a hook provided by the author after the EXE starts? Thanks Philip -- Original Message -- From: Frank Cazabon To: profoxt...@leafe.com Subject: Re: Setting Class Libraries Date: Fri, 15 Jan 2021 13:21:13 -0400 What is in the exe will be used Frank. Frank Cazabon On 15/01/2021 1:03 pm, Philip Borkholder wrote: Hi all, Quick question that I can't remember the hierarchy. Situation: Running a VFP App compiled in an EXE. This EXE has a VCX class library file compiled into it that the author used. If I have a newer version of the VCX that performs some of the methods cleaner/faster than the one the author used, Can I simply place the newer VCX into the root of the application folder? Will the newer VCX take precedence when the SET CLASSLIBRARY TO command runs in the EXE? Thanks Philip B Vicksburg, MI [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/441e7244-3076-27cd-9cbd-181c5e837...@gmail.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.
Re: Setting Class Libraries
What is in the exe will be used Frank. Frank Cazabon On 15/01/2021 1:03 pm, Philip Borkholder wrote: Hi all, Quick question that I can't remember the hierarchy. Situation: Running a VFP App compiled in an EXE. This EXE has a VCX class library file compiled into it that the author used. If I have a newer version of the VCX that performs some of the methods cleaner/faster than the one the author used, Can I simply place the newer VCX into the root of the application folder? Will the newer VCX take precedence when the SET CLASSLIBRARY TO command runs in the EXE? Thanks Philip B Vicksburg, MI [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/edcf22b5-bfef-e0f9-be79-c519ff62c...@gmail.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.
Re: Automation & Office 365
Thanks, that's the link I put in the original post :) Frank. Frank Cazabon On 15/01/2021 11:38 am, Stephen Russell wrote: I saw this: https://support.microsoft.com/en-us/office/choose-between-the-64-bit-or-32-bit-version-of-office-2dee7807-8f95-4d0c-b5fe-6c6f49b8d261 It lists the reason why you would choose 64/32 bit versions. I had to use this when we got newer Office and older SharePoint stuff no longer worked the same way. Editing in a data sheet instead of the list in SP. On Fri, Jan 15, 2021 at 9:05 AM Richard Kaye wrote: Yes. But installing the full 32 bit desktop version is a requirement. Works fine for Word, Excel and Outlook. -- rk -Original Message- From: ProfoxTech On Behalf Of Frank Cazabon Sent: Friday, January 15, 2021 9:59 AM To: profoxt...@leafe.com Subject: Re: Automation & Office 365 Thanks, have you got it working? I've asked them to uninstall the 64bit and try with the 32bit. Will report back what happens. Frank. Frank Cazabon On 15/01/2021 10:53 am, Alan Bourke wrote: There's no reason why it wouldn't still work as long as you are using 32-bit Office. It's not the version, it's the bitness. 365 installs the 64-bit version of the applications by default now, which is annoying if you have Excel plugins, for example, or need to automate them from a 32-bit process. [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/479aaa66-6d32-680b-9b47-6fc2e26d9...@gmail.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.
Re: Automation & Office 365
OK, great to hear it works. Hopefully their testing will be successful. Thanks Frank. Frank Cazabon On 15/01/2021 11:04 am, Richard Kaye wrote: Yes. But installing the full 32 bit desktop version is a requirement. Works fine for Word, Excel and Outlook. -- rk -Original Message- From: ProfoxTech On Behalf Of Frank Cazabon Sent: Friday, January 15, 2021 9:59 AM To: profoxt...@leafe.com Subject: Re: Automation & Office 365 Thanks, have you got it working? I've asked them to uninstall the 64bit and try with the 32bit. Will report back what happens. Frank. Frank Cazabon On 15/01/2021 10:53 am, Alan Bourke wrote: There's no reason why it wouldn't still work as long as you are using 32-bit Office. It's not the version, it's the bitness. 365 installs the 64-bit version of the applications by default now, which is annoying if you have Excel plugins, for example, or need to automate them from a 32-bit process. [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/d7dc35b9-afb3-86a2-69f6-d60b2f901...@gmail.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.
Re: Automation & Office 365
thanks Frank. Frank Cazabon On 15/01/2021 11:02 am, Alan Bourke wrote: No I've never done it but have done plenty of Excel automation. ___ 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/fd79dd78-9f30-51c0-f511-1a3522693...@gmail.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.
Re: Automation & Office 365
Thanks, have you got it working? I've asked them to uninstall the 64bit and try with the 32bit. Will report back what happens. Frank. Frank Cazabon On 15/01/2021 10:53 am, Alan Bourke wrote: There's no reason why it wouldn't still work as long as you are using 32-bit Office. It's not the version, it's the bitness. 365 installs the 64-bit version of the applications by default now, which is annoying if you have Excel plugins, for example, or need to automate them from a 32-bit process. ___ 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/1614e507-b63c-7b42-3ab6-0bfd3149c...@gmail.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.
Automation & Office 365
Hi, I've got an old VFP app that uses Word 2007 to do a mail merge using automation. The client has now moved to Office 365 and of course this breaks the automation. I am seeing some evidence that if the 32 bit of Office 365 is installed locally then the automation should work. Office 365 and OLE Word Merge in Visual Foxpro Application (microsoft.com) <https://social.msdn.microsoft.com/Forums/en-US/496b97f2-239b-4981-b7c5-88192d5b18eb/office-365-and-ole-word-merge-in-visual-foxpro-application?forum=visualfoxprogeneral> Has anyone actually got this to work? If not, what alternatives are there for generating Word documents from VFP? -- Frank. Frank Cazabon --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ 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/82ec218a-f666-15ad-1c35-e01ace873...@gmail.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.
Re: SCX form included in EXE is not found on DO FORM line
OK. A couple things I would try: 1. After building the exe, try to run the exe in a separate instance of the IDE and see if that works. 2. Try running a form based on VFP's base form class with only VFP base class objects on it that is in the same folder as the trouble form. 3. Try moving your dev classes into another folder on the same drive (does not have to be under the same project folder, can be a totally unrelated one) and see if that works. (or you could move the project onto the same drive as your dev classes.) Frank. Frank Cazabon On 09/12/2020 10:14 am, MB Software Solutions, LLC wrote: Yes. EXE is created in the default location, same as the Project files. On 12/8/2020 4:38 PM, Frank Cazabon wrote: But when you compile the exe, does that get created in the same place as the pjx/t? On 8 December 2020 17:17:07 GMT-04:00, "MB Software Solutions, LLC" wrote: Oh sorry, Frank. Let me clarify: Project is in on my C: drive in the legacy folder (c:\wsapps\bwd). Form is in E: drive in my Dev\Client\Forms folder. Clear as mud now? ;-) --Mike On 12/8/2020 2:23 PM, Frank Cazabon wrote: I had looked at it 2 or 3 times but it doesn't answer some of the questions asked by others here and I'm still not 100% sure of one thing in particular. Woody asked you: Maybe, when compiling the EXE you are not saving tot he project folder? and you responded: it's definitely NOT the same folder tree...not even the same DRIVE! but below you have confirmed that point #5 is correct that it was built in the same folder as the PJX. Which is it? Frank. Frank Cazabon On 08/12/2020 3:07 pm, MB Software Solutions, LLC wrote: Hi Frank, Yeah...pretty much right. Take 43 seconds and see what I mean: 43 second demo showing the problem:https://www.screencast.com/t/ZjyWYqFI On 12/8/2020 12:22 PM, Frank Cazabon wrote: Mike, I'm coming in a bit late and am a bit unclear on some of your answers to previous questions. Let me know if this summary is accurate or not, please: 1. Your exe calls an SCX (DO MyForm.scx - without any path to the scx in the call) 2. The SCX is included in the exe 3. When the exe runs at your client site or on your PC outside of the VFP IDE the form is run properly 4. When you run the exe within the VFP IDE on your PC it fails, unless you have a SET PATH to the folder where the SCX is. 5. Your PJX and the EXE are both in the same folder on your development PC (the exe is actually built there, not built elsewhere and copied back) Frank. Frank Cazabon On 08/12/2020 1:03 pm, MB Software Solutions, LLC wrote: On 12/8/2020 9:22 AM, Richard Kaye wrote: A fine question. I didn't watch the movie. Are you putting a path in on your DO FORM call? Do you have a back door where you can see the runtime environment settings? I would think if you want VFP to walk its path to find the form in the EXE, then your DO FORM call should not include a fully qualified path or even a partial one. Exactlywhen I remove the pathing, it fails on my Dev machine (even when run inside the VFP IDE as I do the "run after build" option when creating the EXE). I have to put the pathing there for it to work. BUT, WHEN DEPLOYED TO THE CLIENT, WHERE THAT DEV FOLDER DOESN'T EXIST, it works. Cue Randy Quaid in the Vacation movies saying "I don't know!" :D [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/37addc50-cd6c-c4cc-765d-0304c8284...@gmail.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.
Re: SCX form included in EXE is not found on DO FORM line
But when you compile the exe, does that get created in the same place as the pjx/t? On 8 December 2020 17:17:07 GMT-04:00, "MB Software Solutions, LLC" wrote: >Oh sorry, Frank. Let me clarify: > >Project is in on my C: drive in the legacy folder (c:\wsapps\bwd). >Form >is in E: drive in my Dev\Client\Forms folder. > >Clear as mud now? ;-) >--Mike > > >On 12/8/2020 2:23 PM, Frank Cazabon wrote: >> I had looked at it 2 or 3 times but it doesn't answer some of the >> questions asked by others here and I'm still not 100% sure of one >> thing in particular. >> >> Woody asked you: >> >>> Maybe, when compiling the EXE you are not saving tot he project >folder? >> and you responded: >> >>> it's definitely NOT the same folder tree...not even the same DRIVE! >> >> but below you have confirmed that point #5 is correct that it was >> built in the same folder as the PJX. >> >> Which is it? >> >> >> Frank. >> >> Frank Cazabon >> >> On 08/12/2020 3:07 pm, MB Software Solutions, LLC wrote: >>> Hi Frank, >>> >>> Yeah...pretty much right. Take 43 seconds and see what I mean: >>> >>> 43 second demo showing the >problem:https://www.screencast.com/t/ZjyWYqFI >>> >>> On 12/8/2020 12:22 PM, Frank Cazabon wrote: >>>> Mike, >>>> >>>> I'm coming in a bit late and am a bit unclear on some of your >>>> answers to previous questions. Let me know if this summary is >>>> accurate or not, please: >>>> >>>> 1. Your exe calls an SCX (DO MyForm.scx - without any path to the >>>> scx in the call) >>>> >>>> 2. The SCX is included in the exe >>>> >>>> 3. When the exe runs at your client site or on your PC outside of >>>> the VFP IDE the form is run properly >>>> >>>> 4. When you run the exe within the VFP IDE on your PC it fails, >>>> unless you have a SET PATH to the folder where the SCX is. >>>> >>>> 5. Your PJX and the EXE are both in the same folder on your >>>> development PC (the exe is actually built there, not built >elsewhere >>>> and copied back) >>>> >>>> Frank. >>>> >>>> Frank Cazabon >>>> >>>> On 08/12/2020 1:03 pm, MB Software Solutions, LLC wrote: >>>>> On 12/8/2020 9:22 AM, Richard Kaye wrote: >>>>>> A fine question. >>>>>> >>>>>> I didn't watch the movie. Are you putting a path in on your DO >>>>>> FORM call? Do you have a back door where you can see the runtime >>>>>> environment settings? I would think if you want VFP to walk its >>>>>> path to find the form in the EXE, then your DO FORM call should >>>>>> not include a fully qualified path or even a partial one. >>>>> >>>>> Exactlywhen I remove the pathing, it fails on my Dev machine >>>>> (even when run inside the VFP IDE as I do the "run after build" >>>>> option when creating the EXE). I have to put the pathing there >for >>>>> it to work. BUT, WHEN DEPLOYED TO THE CLIENT, WHERE THAT DEV >>>>> FOLDER DOESN'T EXIST, it works. >>>>> >>>>> Cue Randy Quaid in the Vacation movies saying "I don't know!" :D >>>>> >>>>> >>>>> >>>> [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/f5732963-1dd1-4849-9747-d9383a5ff...@gmail.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.
Re: SCX form included in EXE is not found on DO FORM line
I had looked at it 2 or 3 times but it doesn't answer some of the questions asked by others here and I'm still not 100% sure of one thing in particular. Woody asked you: Maybe, when compiling the EXE you are not saving tot he project folder? and you responded: it's definitely NOT the same folder tree...not even the same DRIVE! but below you have confirmed that point #5 is correct that it was built in the same folder as the PJX. Which is it? Frank. Frank Cazabon On 08/12/2020 3:07 pm, MB Software Solutions, LLC wrote: Hi Frank, Yeah...pretty much right. Take 43 seconds and see what I mean: 43 second demo showing the problem:https://www.screencast.com/t/ZjyWYqFI On 12/8/2020 12:22 PM, Frank Cazabon wrote: Mike, I'm coming in a bit late and am a bit unclear on some of your answers to previous questions. Let me know if this summary is accurate or not, please: 1. Your exe calls an SCX (DO MyForm.scx - without any path to the scx in the call) 2. The SCX is included in the exe 3. When the exe runs at your client site or on your PC outside of the VFP IDE the form is run properly 4. When you run the exe within the VFP IDE on your PC it fails, unless you have a SET PATH to the folder where the SCX is. 5. Your PJX and the EXE are both in the same folder on your development PC (the exe is actually built there, not built elsewhere and copied back) Frank. Frank Cazabon On 08/12/2020 1:03 pm, MB Software Solutions, LLC wrote: On 12/8/2020 9:22 AM, Richard Kaye wrote: A fine question. I didn't watch the movie. Are you putting a path in on your DO FORM call? Do you have a back door where you can see the runtime environment settings? I would think if you want VFP to walk its path to find the form in the EXE, then your DO FORM call should not include a fully qualified path or even a partial one. Exactlywhen I remove the pathing, it fails on my Dev machine (even when run inside the VFP IDE as I do the "run after build" option when creating the EXE). I have to put the pathing there for it to work. BUT, WHEN DEPLOYED TO THE CLIENT, WHERE THAT DEV FOLDER DOESN'T EXIST, it works. Cue Randy Quaid in the Vacation movies saying "I don't know!" :D [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/c4dc4320-1f06-f04c-ac17-149c58daa...@gmail.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.
Re: SCX form included in EXE is not found on DO FORM line
Mike, I'm coming in a bit late and am a bit unclear on some of your answers to previous questions. Let me know if this summary is accurate or not, please: 1. Your exe calls an SCX (DO MyForm.scx - without any path to the scx in the call) 2. The SCX is included in the exe 3. When the exe runs at your client site or on your PC outside of the VFP IDE the form is run properly 4. When you run the exe within the VFP IDE on your PC it fails, unless you have a SET PATH to the folder where the SCX is. 5. Your PJX and the EXE are both in the same folder on your development PC (the exe is actually built there, not built elsewhere and copied back) Frank. Frank Cazabon On 08/12/2020 1:03 pm, MB Software Solutions, LLC wrote: On 12/8/2020 9:22 AM, Richard Kaye wrote: A fine question. I didn't watch the movie. Are you putting a path in on your DO FORM call? Do you have a back door where you can see the runtime environment settings? I would think if you want VFP to walk its path to find the form in the EXE, then your DO FORM call should not include a fully qualified path or even a partial one. Exactlywhen I remove the pathing, it fails on my Dev machine (even when run inside the VFP IDE as I do the "run after build" option when creating the EXE). I have to put the pathing there for it to work. BUT, WHEN DEPLOYED TO THE CLIENT, WHERE THAT DEV FOLDER DOESN'T EXIST, it works. Cue Randy Quaid in the Vacation movies saying "I don't know!" :D ___ 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/05f4c2b7-e3fd-efa4-f226-9875ae346...@gmail.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.
RE: Day one Virtual FoxFest has begun
Hey Dave,
I think Tamar said everything will be available on their you tube channel but
only after the last day. Maybe message geek gatherings directly to get the
unedited version :)
On 16 October 2020 06:43:00 GMT-04:00, Dave Crozier
wrote:
>Guys,
>I have registered for the conference but unfortunately missed yesterday
>as my mum took a bad fall. I hadn't registered for the day via Hopin
>and it now tells me that the sessions are obviously ended. Is there any
>way we can currently access the finished sessions so I can catch up
>before the next session?
>
>Dave Crozier
>Software Development Manager
>Flexipol Packaging Ltd.
>
>Mob: 07967 671080
>
>﴾⚆ᨎ⚆﴿
>
>
>
>Flexipol® Packaging Ltd
>T 01706 222 792
>E dcroz...@flexipol.co.uk
>W https://www.flexipol.co.uk/
>Follow us:
>Unit 14 Bentwood Road, Carrs Industrial Estate, Haslingden, Lancashire,
>BB4 5HH
>
>This communication and the information it contains is intended for the
>person or organisation to whom it is addressed. Its contents are
>confidential and may be protected in law. If you have received this
>e-mail in error you must not copy, distribute or take any action in
>reliance on it. Unauthorised use, copying or disclosure of any of it
>may be unlawful. If you have received this message in error, please
>notify us immediately by telephone or email.
>
>Flexipol Packaging Ltd. has taken every reasonable precaution to
>minimise the risk of virus transmission through email and therefore any
>files sent via e-mail will have been checked for known viruses.
>However, you are advised to run your own virus check before opening any
>attachments received as Flexipol Packaging Ltd will not in any event
>accept any liability whatsoever once an e-mail and/or any attachment is
>received.
>
>It is the responsibility of the recipient to ensure that they have
>adequate virus protection.
>
>-
>
>Terms & Conditions:
>Notwithstanding delivery and the passing of risk in the goods, the
>property in the goods shall not pass to the buyer until the seller
>Flexipol Packaging Ltd. ("The Company") has received in cash or cleared
>funds payment in full of the price of the goods and all other goods
>agreed to be sold by the seller to the buyer for which payment is then
>due. Until such time as the property in the goods passes to the buyer,
>the buyer shall hold the goods as the seller's fiduciary agent and
>bailee and keep the goods separate from those of the buyer and third
>parties and properly stored protected and insured and identified as the
>seller's property but shall be entitled to resell or use the goods in
>the ordinary course of its business. Until such time as the property in
>the goods passes to the buyer the seller shall be entitled at any time
>-Original Message-
>From: ProFox On Behalf Of Richard Kaye
>Sent: 15 October 2020 19:50
>To: profox@leafe.com
>Subject: Day one Virtual FoxFest has begun
>
>As far as I know it's not too late to register. 2 good sessions so far
>on SQL security and a graphics library that can be used in VFP.
>
>And cheers to Ted Roche for being a sponsor!
>
>--
>
>rk
>
>
>
>--- StripMime Report -- processed MIME parts --- multipart/alternative
> text/plain (text body -- kept)
> text/html
>---
>
[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/f2acb3c3-ddc1-464c-9b13-4f0e16951...@gmail.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.
Re: Virtual Fox Fest
Have you registered Andy logged in on hopin? On 15 October 2020 11:18:38 GMT-04:00, "MB Software Solutions, LLC" wrote: >Aw manWTF am I doing wrong? > > >On 10/15/2020 11:17 AM, Frank Cazabon wrote: >> Nope. The welcome just finished and waiting for the first session to >begin at half past the hour. >> >> On 15 October 2020 11:15:50 GMT-04:00, "MB Software Solutions, LLC" > wrote: >>> Anybody else having trouble viewing the webinar? >>> >>> >>> -- >>> This email has been checked for viruses by Avast antivirus software. >>> https://www.avast.com/antivirus >>> >>> >>> ___ >>> 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/93aac18e-a9e7-9529-49b9-fa282a4b2...@mbsoftwaresolutions.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. >>> >>> Report [OT] Abuse: >>> >http://leafe.com/reportAbuse/93aac18e-a9e7-9529-49b9-fa282a4b2...@mbsoftwaresolutions.com > >___ >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/849d3e96-d8ba-4fcd-0952-8f49f3108...@mbsoftwaresolutions.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. > >Report [OT] Abuse: >http://leafe.com/reportAbuse/849d3e96-d8ba-4fcd-0952-8f49f3108...@mbsoftwaresolutions.com -- Frank Cazabon Sent from my phone. Please excuse my brevity. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ 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/2b13c7e5-96d3-40ee-b016-d49220fa2...@gmail.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.
Re: Virtual Fox Fest
Nope. The welcome just finished and waiting for the first session to begin at half past the hour. On 15 October 2020 11:15:50 GMT-04:00, "MB Software Solutions, LLC" wrote: >Anybody else having trouble viewing the webinar? > > >-- >This email has been checked for viruses by Avast antivirus software. >https://www.avast.com/antivirus > > >___ >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/93aac18e-a9e7-9529-49b9-fa282a4b2...@mbsoftwaresolutions.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. > >Report [OT] Abuse: >http://leafe.com/reportAbuse/93aac18e-a9e7-9529-49b9-fa282a4b2...@mbsoftwaresolutions.com -- Frank Cazabon Sent from my phone. Please excuse my brevity. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ 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/9a29c54e-07be-46c4-9d9f-19123630a...@gmail.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.
Re: My memo field(s) Are Bloated......
I "think" the way to do this is to copy the data to a new table and then delete the old table and rename the new one to the old name, but it's been a really long time since I worked with DBFs so caveat emptor! Be careful if the table is part of a database and you have specific configuration set for the table in the dbc (long column names, autoinc, triggers). If that is going to be a problem maybe copy it to a new table, then zap the old table and append from the new table but you'd still have to look out for autoinc. Frank. Frank Cazabon On 05/10/2020 10:37 am, Desmond Lloyd wrote: Fascinating, original size of the DBF 710448 original size of fpt: 1276848 selecting * from the tabl3 DBF = 710448 FPT = 923354 A drop in the size of the fpt of 353492.. Could i rename the "selected" FPT and use it. I treid a pack memo and there no change in thesiz of the FPT? Regards, Desmond / On Mon, 5 Oct 2020 at 09:06, Tracy Pearson wrote: When you select * to a temp table. What is the size of the files? You'll know quickly if you have bloat. HTH, Tracy -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Desmond Lloyd Sent: Monday, October 05, 2020 9:49 AM To: profoxt...@leafe.com Subject: My memo field(s) Are Bloated.. Good Morning! Have a very wide dbf with about 8 memo fields . Started acteing strange like if I tried to re-index or pack memo it would seem to go so far and then freeze! Found a utility that seemed to repair the file. The only issue is that the DBF is 710mb and the associated memo file is 1.2gb! Yikes. Have ran a pack memo (with no issues) and there is no change in the size of the memo file, which I am assuming is boated. 1.) Is the memo file really bloated. 2.) Going to look at the individual memo fields and see if any one of the records has an unusually large memo field. 3.) Open to any other suggestion that you wise people could recommend TIA/Regards, Desmond --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [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/6e8d5d4d-2e00-9722-99f3-73d35491e...@gmail.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.
Re: [NF] Thunderbolt & VGA
Thanks Eric, I don't think that is the issue here but it may prove helpful elsewhere. I think it may be a problem with the adapter being DisplayPort Alt Mode and the port is actually DisplayPort. Or at least that's a theory. I'm still to understand this DisplayPort thing properly. Frank. Frank Cazabon On 22/09/2020 4:12 pm, Eric Selje wrote: I don't know if this is your issue, but here's a lesson I learned the hard way: https://www.urtech.ca/2017/12/solved-difference-active-passive-displayport-adaptors/ On Tue, Sep 22, 2020 at 1:19 PM Frank Cazabon wrote: I know there are some knowledgeable hardware people around here. Hope someone can clear something up for me. I've got a new laptop with a Thunderbolt 3 (USB type C 3.1 Gen 2) port (the manufacturer says: The Thunderbolt 3/USB type C port for the Element has support for DisplayPort(DP) connections), an old AOC LCD VGA monitor and bought an adapter so that I could connect this monitor. However the laptop does not detect the monitor. The adapter is Type C 2 in 1 HDMI+VGA adapter that says it's compatible with Laptops with USB-C output. The Amazon link for the adapter says: https://www.amazon.com/gp/product/B07PCKQWCX/ref=ppx_yo_dt_b_asin_title_o00_s01?ie=UTF8=1 Wide Compatibility】2018/17/16 New MacBook Pro, New MacBook Air, MacBook 12, 2018 New iPad Pro 11/12.9, 2018/17 iMac/Pro, Dell XPS 13, Surface Book 2, Samsung Galaxy S8/S9/Plus/Note 8/9, HUAWEI Mate 10 / Mate 10 Pro / P20 / P20 Pro Pixelbook, Chromebook, Intel NUC, HP, Acer, Lenovo and many others *with USB-C DP ALT Mode* (See Product Description) Shouldn't this work? Is there something I am missing? -- Frank. Frank Cazabon --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [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/3432fcee-3c8d-b751-bb88-89ae63eb5...@gmail.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.
[NF] Thunderbolt & VGA
I know there are some knowledgeable hardware people around here. Hope someone can clear something up for me. I've got a new laptop with a Thunderbolt 3 (USB type C 3.1 Gen 2) port (the manufacturer says: The Thunderbolt 3/USB type C port for the Element has support for DisplayPort(DP) connections), an old AOC LCD VGA monitor and bought an adapter so that I could connect this monitor. However the laptop does not detect the monitor. The adapter is Type C 2 in 1 HDMI+VGA adapter that says it's compatible with Laptops with USB-C output. The Amazon link for the adapter says: https://www.amazon.com/gp/product/B07PCKQWCX/ref=ppx_yo_dt_b_asin_title_o00_s01?ie=UTF8=1 Wide Compatibility】2018/17/16 New MacBook Pro, New MacBook Air, MacBook 12, 2018 New iPad Pro 11/12.9, 2018/17 iMac/Pro, Dell XPS 13, Surface Book 2, Samsung Galaxy S8/S9/Plus/Note 8/9, HUAWEI Mate 10 / Mate 10 Pro / P20 / P20 Pro Pixelbook, Chromebook, Intel NUC, HP, Acer, Lenovo and many others *with USB-C DP ALT Mode* (See Product Description) Shouldn't this work? Is there something I am missing? -- Frank. Frank Cazabon --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ 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/17435a4c-b5f3-b1df-b89b-dbe25aadb...@gmail.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.
Re: VFP9SP2 Error 108: File is in use by another user.
I haven't used dbfs in years and can't say I've ever got this error but this might help: https://www.tek-tips.com/viewthread.cfm?qid=686993 On 31 July 2020 16:00:32 GMT-04:00, "MB Software Solutions, LLC" wrote: >Got a stupid 108 error on a simple INSERT INTO SQL today, yet no other >application had that program/table open, and all usage is SHARED (set >exclusive is OFF). > >Anybody else ever get an Error 108 on a simple INSERT where there's no >exclusive use??? > > > > >-- >This email has been checked for viruses by Avast antivirus software. >https://www.avast.com/antivirus > > >___ >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/f933b99f-c4a3-c3ab-9184-a8d733c59...@mbsoftwaresolutions.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. > >Report [OT] Abuse: >http://leafe.com/reportAbuse/f933b99f-c4a3-c3ab-9184-a8d733c59...@mbsoftwaresolutions.com -- Frank Cazabon Sent from my phone. Please excuse my brevity. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ 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/545b91eb-98a5-4c67-98da-0b531edd4...@gmail.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.
Re: [NF] gmail tracker
Doesn't gmail do that for you already? Maybe if you explain what you want to do with the information? I don't think you can reliably track when someone has read your email. At least I know that I block any read receipts from going out so I assume others do it too. Frank. Frank Cazabon On 20/05/2020 08:19 am, Charles Hart Enzer, M.D. wrote: I want to track the email that i send from gmail. I want to know: - all the recipients -- especially when more than one - when read thank you. On Thu, May 14, 2020 at 8:50 PM Charles Hart Enzer, M.D. wrote: Recommendations for Gmail Tracking? - Who - Who with multiple recipients - When - Frequency Thank you. -- *Shai / שי **Charles Hart Enzer, MD(Retired, **Ohio**), FAACAP* *Aliyah <https://en.wikipedia.org/wiki/Aliyah>: Cincinnati to Jerusalem <http://www.gojerusalem.com/items/263/German-Colony/>'s German Colony <https://en.wikipedia.org/wiki/German_Colony,_Jerusalem> May 2017* *Volunteer Associate Professor of PsychiatryUniversity of Cincinnati Medical CenterWebSite: **EnzerMD.com <http://EnzerMD.com>* *Publications* <http://www.enzermd.com/CV.html#Publications> *Retirement is **not What You are Retiring from* *Retirement is about What You are Retiring to* ___ 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/1430b868-e2a2-dc53-8d7e-b35365c5b...@gmail.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.
Re: [NF] Gmail Tracking
Hi Charles, I think you might need to explain more what exactly you mean by "gmail tracking" as no one has responded to either of your messages. At least I don't understand what you are looking for. Frank. Frank Cazabon On 17/05/2020 01:00 pm, Charles Hart Enzer, M.D. wrote: Recommendations for Gmail Tracking? - Who - Who with multiple recipients - When - Frequency Thank you. ___ 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/0a163e1c-32bb-cc6e-ed3a-2b68729fb...@gmail.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.
Re: GoFish problem
Never used it but rendered this: https://www.foxite.com/archives/html-treeview-in-vfp-450232.htm On 28 April 2020 19:36:45 GMT-04:00, Matt Slay wrote: >Eric - what UI control would be used in a VFP in place of the current >OCX Treeview? > > > > >Matt Slay > > > >> On Apr 28, 2020, at 5:41 PM, Eric Selje wrote: >> >> We should (collectively) update GoFish because it doesn't work in >VFP10 64 >> bit yet either because of these controls. >> >> E >> >> >>> On Tue, Apr 28, 2020 at 4:18 PM Matt Slay > >>> wrote: >>> >>> Here is what GoFish uses: >>> >>> OLEObject = C:\Windows\SysWOW64\MSCOMCTL.OCX >>> >>> >>> - Matt Slay >>> >>> >>> On 4/28/2020 3:43 PM, Tracy Pearson wrote: We had enough problems with the Common controls we removed them >from our product. Try to open a screen in our software and Windows attempting to run >an installer. The file was there, and registered, but the installer >>> insisted it was the wrong one. You are looking for one these files. I don't know which version was >>> attached to the form: Microsoft Windows Common Controls 5.0 (SP2) File: c:\windows\syswow64\comctl32.ocx Microsoft Windows Common Controls 6.0 (SP6) File: c:\windows\syswow64\mscomctl.ocx If you are on a Windows 10 64-bit OS, that is where they live. I don't use GF personally. HTH, Tracy -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of >>> Paul H. Tarver Sent: Tuesday, April 28, 2020 4:09 PM To: profoxt...@leafe.com Subject: RE: GoFish problem It looks like the Microsoft Visual Basic 6.0 Common Controls >download >>> only updated my existing MSComCt files and didn't appear to install >anything >>> else and my OLE error remains. So I'm guessing it's something in a different distribution. Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of >>> Richard Kaye Sent: Tuesday, April 28, 2020 12:38 PM To: profoxt...@leafe.com Subject: RE: GoFish problem IIRC it uses MS common controls circa VB6 so you might need to hunt >down something like that. -- rk -Original Message- From: ProfoxTech On Behalf Of Paul >H. >>> Tarver Sent: Tuesday, April 28, 2020 11:05 AM To: profoxt...@leafe.com Subject: RE: GoFish problem After you brought up GoFish, I found a video on it and thought I'd >try to use it, but I can't get v5 to run. I keep getting an OLE error code >that >>> a class is not registered. If I click ok on the error the source >stops on a reference to 'otree'. I cannot find any instructions to setup it up >or >>> any pre-requisites as far as .ocx files that I need to have for it run. >I'd >>> like to try it, but so far no go. (Also, I couldn't find a download for >the >>> 4.3 version, so got stuck there too.) Any ideas? Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of >Paul Newton Sent: Tuesday, April 28, 2020 8:26 AM To: profoxt...@leafe.com Subject: GoFish problem Hi all I have been happily using GoFish (4.3) for years but today when I >tried >>> to run it (in VFP9 SP2) the cursor changes to that circular one which >>> appears when Fox is busy and GoFish refuses to load. Fox also displays >>> eventually as Not Responding. Any ideas/suggestions? Many thanks Paul Newton --- StripMime Report -- processed MIME parts --- >multipart/alternative text/plain (text body -- kept) text/html --- [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/3cea140d-42fc-443e-9fa3-5136e6269...@gmail.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.
Re: SQL Server 17 - ODBC or Native Client?
Great! Thanks again
Frank.
Frank Cazabon
On 08/04/2020 01:50 pm, António Tavares Lopes wrote:
Microsoft changed course about this.
The current (as of March 2020) state of affairs about ODBC is quite clear,
actually:
ODBC is the primary native data access API for applications written in C
and C++ for SQL Server. There is an ODBC driver for most data sources.
Other languages that can use ODBC include COBOL, Perl, PHP, and Python.
ODBC is widely used in data integration scenarios.
On Wed, Apr 8, 2020 at 6:45 PM Frank Cazabon
wrote:
Thanks Richard, I vaguely recall seeing that ODBC was no longer being
developed/used, hence my doubt about using it.
Frank.
Frank Cazabon
On 08/04/2020 01:20 pm, Richard Kaye wrote:
I got away from the NC drivers a long time ago. Currently using 17 for
pretty much everything.
--
rk
-Original Message-
From: ProfoxTech On Behalf Of António
Tavares Lopes
Sent: Wednesday, April 8, 2020 11:12 AM
To: profoxt...@leafe.com
Subject: Re: SQL Server 17 - ODBC or Native Client?
Frank,
With SPT, there is no big feature difference between NC and recent ODBC
drivers. If you're using NC, you can safely migrate to the more recent
drivers.
You may find bigger differences between the old "SQL Server" driver and
the following versions because of the way they handle SQL datatypes, and
how they are mapped into VFP. But if you're already using NC then you won't
face new issues.
On Wed, Apr 8, 2020 at 3:40 PM Frank Cazabon
wrote:
Hi,
I'm testing a VFP app against a SQL Server 2017 database. I use
"DRIVER=SQL Server Native Client 11.0" in my connection string for SQL
Server 2012 and 2014. I don't think there is a newer version of Native
Client than 11. Should I be using the "Driver={ODBC Driver 17 for SQL
Server}" instead?
--
Frank.
Frank Cazabon
[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/e7474d62-eedf-82d1-dc22-e0dadc747...@gmail.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.
Re: SQL Server 17 - ODBC or Native Client?
Thanks Richard, I vaguely recall seeing that ODBC was no longer being
developed/used, hence my doubt about using it.
Frank.
Frank Cazabon
On 08/04/2020 01:20 pm, Richard Kaye wrote:
I got away from the NC drivers a long time ago. Currently using 17 for pretty
much everything.
--
rk
-Original Message-
From: ProfoxTech On Behalf Of António Tavares
Lopes
Sent: Wednesday, April 8, 2020 11:12 AM
To: profoxt...@leafe.com
Subject: Re: SQL Server 17 - ODBC or Native Client?
Frank,
With SPT, there is no big feature difference between NC and recent ODBC
drivers. If you're using NC, you can safely migrate to the more recent drivers.
You may find bigger differences between the old "SQL Server" driver and the
following versions because of the way they handle SQL datatypes, and how they are mapped
into VFP. But if you're already using NC then you won't face new issues.
On Wed, Apr 8, 2020 at 3:40 PM Frank Cazabon
wrote:
Hi,
I'm testing a VFP app against a SQL Server 2017 database. I use
"DRIVER=SQL Server Native Client 11.0" in my connection string for SQL
Server 2012 and 2014. I don't think there is a newer version of Native
Client than 11. Should I be using the "Driver={ODBC Driver 17 for SQL
Server}" instead?
--
Frank.
Frank Cazabon
[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/25985d2c-0453-1713-315e-628c46e1a...@gmail.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.
Re: SQL Server 17 - ODBC or Native Client?
Thanks António
Frank.
Frank Cazabon
On 08/04/2020 11:12 am, António Tavares Lopes wrote:
Frank,
With SPT, there is no big feature difference between NC and recent ODBC
drivers. If you're using NC, you can safely migrate to the more recent
drivers.
You may find bigger differences between the old "SQL Server" driver and the
following versions because of the way they handle SQL datatypes, and how
they are mapped into VFP. But if you're already using NC then you won't
face new issues.
On Wed, Apr 8, 2020 at 3:40 PM Frank Cazabon
wrote:
Hi,
I'm testing a VFP app against a SQL Server 2017 database. I use
"DRIVER=SQL Server Native Client 11.0" in my connection string for SQL
Server 2012 and 2014. I don't think there is a newer version of Native
Client than 11. Should I be using the "Driver={ODBC Driver 17 for SQL
Server}" instead?
--
Frank.
Frank Cazabon
[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/a272a0ec-3569-d12e-72f4-d349fffe0...@gmail.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.
SQL Server 17 - ODBC or Native Client?
Hi,
I'm testing a VFP app against a SQL Server 2017 database. I use
"DRIVER=SQL Server Native Client 11.0" in my connection string for SQL
Server 2012 and 2014. I don't think there is a newer version of Native
Client than 11. Should I be using the "Driver={ODBC Driver 17 for SQL
Server}" instead?
--
Frank.
Frank Cazabon
___
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/f4a5171b-f215-853b-f8c8-58da3118d...@gmail.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.
Re: AW: May the Open Source Be With You: INTL and SDT!
If you can work out the structure of a PDF I'm sure you can do it. I prefer to print to a PDF printer or use something like PDFtk to fill in PDF forms. On 17 January 2020 17:43:52 GMT-04:00, roger tremblay wrote: > >Does anyone know if VFP can write pdf files? > >TIA > > >Roger > > >___ >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/b6730d27-69a8-6a77-0bc5-1d8ffaf24...@gmail.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. > >Report [OT] Abuse: >http://leafe.com/reportAbuse/b6730d27-69a8-6a77-0bc5-1d8ffaf24...@gmail.com -- Frank Cazabon Sent from my phone. Please excuse my brevity. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ 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/4c2c0d04-22f2-4f94-b491-167f3a0cb...@gmail.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.
Intl and Report Labels
Hi,
has anyone here used Steven Black's Intl code for translating their
applications?
I have written some code which will open all my FRX files and convert
each label to a text field with the expression of the label being called
in i(). So if i had a label with the text as "Client" I would end up
with a text box with the expression as: i("Client").
This works but ends up with me then having to modify each report to
slightly adjust the text box's positioning to get it to line up with
surrounding objects properly.
Is this the best way to do this or is there another recommended way?
Maybe some hook in the reportlistener to automatically call i() on the
label itself?
--
Frank.
Frank Cazabon
___
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/53778aed-3917-ce88-eb00-74120c5fc...@gmail.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.
Re: SQL Dump
You could dump it to excel or CSV and then do an import in SQL On 28 November 2019 12:55:01 GMT-04:00, Chris Davis wrote: >Hi All > >Is there any tricks I am missing which would speed up a dump of a VFP >table into a SQL table. > >I have predifined by SQL statement something like this > >"insert into mytable (myfield) values (?m.myfield)" > >I am then scanning through the VFP table performing a scatter memvar >and then executing the SQL. > >It works it just seems to take alot longer than I imagined it would. > >Thanks IA > >Chris. > > >--- StripMime Report -- processed MIME parts --- >multipart/alternative > text/plain (text body -- kept) > text/html >--- > >___ >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/loyp123mb31676f6ad36f7fae59e027738f...@loyp123mb3167.gbrp123.prod.outlook.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. > >Report [OT] Abuse: >http://leafe.com/reportAbuse/loyp123mb31676f6ad36f7fae59e027738f...@loyp123mb3167.gbrp123.prod.outlook.com -- Frank Cazabon Sent from my phone. Please excuse my brevity. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ 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/29bc5c32-fbed-4c62-8ff1-d269eb129...@gmail.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.
RE: Using XML String as part of query in SQL Server
I got it doing it like this:
SELECT iMemoNumber, DAGREEMENTDATE
FROM Agreements
WHERE iMemoNumber IN (
SELECT imemo = x.Rec.query('./imemonumber').value('.','integer') --
xmlArray.value('@imemonumber ','integer')
FROM @Array.nodes('/VFPData/c_agreements') AS x(Rec) --
TEMPTABLE(xmlArray)
)
Thanks for the help
On 26 November 2019 18:32:12 GMT-04:00, Frank Cazabon
wrote:
>Thanks Darren,
>
>I'm not getting anything returned and don't understand the syntax yet
>to be sure how to fix your example.
>
>I've tried this:
>
>declare @array xml = 'standalone="yes"?>
>http://www.w3.org/2001/XMLSchema-instance;
>xsi:noNamespaceSchemaLocation="mySchema.xsd">
>
> 17153
>
>
> 2
>
>
> 3
>
>
> 4
>
>
> 5
>
>'
>/*
>SELECT iMemoNumber
>FROM Agreements
> WHERE iMemoNumber IN (
> */
> SELECT xmlArray.value('@imemonumber ','integer')
> FROM @Array.nodes('/c_agreements/imemonumber') AS TEMPTABLE(xmlArray)
> --)
>
>And get nothing returned.
>
>If I change it to this (add in VFPData):
>
>SELECT xmlArray.value('@imemonumber ','integer')
>FROM @Array.nodes('/VFPData/c_agreements/imemonumber') AS
>TEMPTABLE(xmlArray)
>
>I get 5 rows back but they are all null.
>
>Any ideas what's wrong?
>
>On 26 November 2019 15:58:39 GMT-04:00, Darren
>wrote:
>>Not tested but something similar to ...
>>
>>CREATE PROCEDURE [dbo].[spFindByXML]
>> (
>> @Array xml
>> )
>>AS
>>
>>SET NOCOUNT ON;
>>--
>>SELECT iMemoNumber, AgreementDate, Amount
>>FROM Agreements WHERE iMemoNumber IN (SELECT
>>xmlArray.value('@imemonumber ','integer') FROM
>>@Array.nodes('/c_agreements/imemonumber') AS TEMPTABLE(xmlArray))
>>--
>>SET NOCOUNT OFF;
>>
>>-Original Message-
>>From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
>>Frank Cazabon
>>Sent: Wednesday, 27 November 2019 5:16 AM
>>To: profoxt...@leafe.com
>>Subject: Using XML String as part of query in SQL Server
>>
>>Hi,
>>
>>I need to write an SQL Server Stored Procedure or just a simple SELECT
>
>>Query that accepts an XML string which is basically a list of IDs that
>>I
>>want to use to filter data from a table.
>>
>>Example XML (created using CURSORTOXML):
>>
>>
>>http://www.w3.org/2001/XMLSchema-instance;
>>xsi:noNamespaceSchemaLocation="mySchema.xsd">
>>
>> 1
>>
>>
>> 2
>>
>>
>> 3
>>
>>
>> 4
>>
>>
>> 5
>>
>>
>>
>>I then need to:
>>
>>SELECT iMemoNumber, AgreementDate, Amount
>>
>>FROM Agreements
>>
>>WHERE iMemoNumber IN (<>)
>>
>>
>>Or maybe
>>
>>SELECT iMemoNumber, AGreementDate, Amount
>>
>>FROM Agreements
>>
>>INNER JOIN << my XML data on the iMemoNumber >>
>>
>>
>>My Google search terms have failed to produce what I am looking for.
>>
>>Anybody have the solution?
>>
>>--
>>
>>Frank.
>>
>>Frank Cazabon
>>
>>
[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/2e77d933-4456-4c5c-8095-148ddb165...@gmail.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.
RE: Using XML String as part of query in SQL Server
Thanks Darren,
I'm not getting anything returned and don't understand the syntax yet to be
sure how to fix your example.
I've tried this:
declare @array xml = '
http://www.w3.org/2001/XMLSchema-instance;
xsi:noNamespaceSchemaLocation="mySchema.xsd">
17153
2
3
4
5
'
/*
SELECT iMemoNumber
FROM Agreements
WHERE iMemoNumber IN (
*/
SELECT xmlArray.value('@imemonumber ','integer')
FROM @Array.nodes('/c_agreements/imemonumber') AS TEMPTABLE(xmlArray)
--)
And get nothing returned.
If I change it to this (add in VFPData):
SELECT xmlArray.value('@imemonumber ','integer')
FROM @Array.nodes('/VFPData/c_agreements/imemonumber') AS TEMPTABLE(xmlArray)
I get 5 rows back but they are all null.
Any ideas what's wrong?
On 26 November 2019 15:58:39 GMT-04:00, Darren wrote:
>Not tested but something similar to ...
>
>CREATE PROCEDURE [dbo].[spFindByXML]
> (
> @Array xml
> )
>AS
>
>SET NOCOUNT ON;
>--
>SELECT iMemoNumber, AgreementDate, Amount
>FROM Agreements WHERE iMemoNumber IN (SELECT
>xmlArray.value('@imemonumber ','integer') FROM
>@Array.nodes('/c_agreements/imemonumber') AS TEMPTABLE(xmlArray))
>--
>SET NOCOUNT OFF;
>
>-Original Message-
>From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
>Frank Cazabon
>Sent: Wednesday, 27 November 2019 5:16 AM
>To: profoxt...@leafe.com
>Subject: Using XML String as part of query in SQL Server
>
>Hi,
>
>I need to write an SQL Server Stored Procedure or just a simple SELECT
>Query that accepts an XML string which is basically a list of IDs that
>I
>want to use to filter data from a table.
>
>Example XML (created using CURSORTOXML):
>
>
>http://www.w3.org/2001/XMLSchema-instance;
>xsi:noNamespaceSchemaLocation="mySchema.xsd">
>
> 1
>
>
> 2
>
>
> 3
>
>
> 4
>
>
> 5
>
>
>
>I then need to:
>
>SELECT iMemoNumber, AgreementDate, Amount
>
>FROM Agreements
>
>WHERE iMemoNumber IN (<>)
>
>
>Or maybe
>
>SELECT iMemoNumber, AGreementDate, Amount
>
>FROM Agreements
>
>INNER JOIN << my XML data on the iMemoNumber >>
>
>
>My Google search terms have failed to produce what I am looking for.
>
>Anybody have the solution?
>
>--
>
>Frank.
>
>Frank Cazabon
>
>
[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/cf583317-7ffd-4da9-9f20-da9e4dfcc...@gmail.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.
Using XML String as part of query in SQL Server
Hi, I need to write an SQL Server Stored Procedure or just a simple SELECT Query that accepts an XML string which is basically a list of IDs that I want to use to filter data from a table. Example XML (created using CURSORTOXML): http://www.w3.org/2001/XMLSchema-instance; xsi:noNamespaceSchemaLocation="mySchema.xsd"> 1 2 3 4 5 I then need to: SELECT iMemoNumber, AgreementDate, Amount FROM Agreements WHERE iMemoNumber IN (<>) Or maybe SELECT iMemoNumber, AGreementDate, Amount FROM Agreements INNER JOIN << my XML data on the iMemoNumber >> My Google search terms have failed to produce what I am looking for. Anybody have the solution? -- Frank. Frank Cazabon ___ 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/d24f6592-0c0d-3ad5-dffd-6e5fa0f15...@gmail.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.
Re: How common is Table Buffering with DBFs??
The couple systems I have left using dbfs use table buffering On 25 November 2019 13:23:00 GMT-04:00, Matt Slay wrote: >For a while when my app was still on DBFs (instead of Sql Server) I >used >Table Buffering, with TableUpdate() and TableRevert() on all my CRUD >forms. I remember that it could get tricky keeping it all working >correctly in the UI, but in the end I had a pretty good pattern in >place. I took the path of making the user take the form into Edit Mode, > >then they could Save or Cancel, and I handled TableUpdate() or >TableRevert() accordingly. > >Anyway, I'm just trying to get a feel for how broadly used is Table >Buffering is in DBF-based apps?? It it a low number like 10%, or maybe > >30%? > >Did any of the other XBase language every have this table buffering >paradigm in them? > >I'm probing into this as (self-assigned) research so I can enlighten >the >X# Dev Team if this is something they may face as a common pattern in >VFP apps if anyone tried to move this sort of app over to X# one day. > > > > > > > >-- >*Matt Slay*, President >Jordan Machine Co. >355 Clow Lane >PO Box 170339 >Birmingham, AL 35217 >Ph: 205-849-5050 >Fx: 205-849-5075 >matts...@jordanmachine.com <mailto:matts...@jordanmachine.com> >http://www.JordanMachine.com > > > > > >--- StripMime Report -- processed MIME parts --- >multipart/alternative > text/plain (text body -- kept) > text/html >--- > >___ >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/da156899-bb36-e7ca-86b2-912b4f416...@jordanmachine.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. >Report [OT] Abuse: >http://leafe.com/reportAbuse/da156899-bb36-e7ca-86b2-912b4f416...@jordanmachine.com -- Frank Cazabon Sent from my phone. Please excuse my brevity. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ 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/10f3929e-990f-4786-b95c-ecf50b084...@gmail.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.
Re: Fatal error issuing CALCULATE command
That's interesting, I wonder if this is documented in the Hacker's Guide.
I have to admit that in my 28 years of using VFP I've never used CALCULATE.
Frank.
Frank Cazabon
On 22/11/2019 12:24 PM, Eric Selje wrote:
Yes, Paul, that now makes my system crash with Fatal Error too in VFP9 and
VFPA.
On Fri, Nov 22, 2019 at 6:59 AM Paul Newton
wrote:
No Alan - the following code (adapted from Eric) demonstrates exactly what
I am doing:
#DEFINE _fields 35
#DEFINE _rows 100
=RAND(-1)
CREATE CURSOR crsTest (id i)
cCalcCmd = [CALCULATE ]
cInsertFields = []
cInsertValues = []
cVariables = []
FOR x = 1 TO _fields
cField = "Field"+TRANSFORM(x)
ALTER table crsTest ADD COLUMN (cField) I
cCalcCmd = cCalcCmd + "SUM("+cField+"),"
cInsertFields = cInsertFields + ","+cField
cInsertValues = cInsertValues + ","+TRANS(INT(RAND()*100))
cVariables = cVariables + "lc"+cField+","
NEXT
cInsertCmd = [INSERT INTO crsTest (ID ] + cInsertFields +[) VALUES
(0]+cInsertValues+')'
FOR X = 1 TO _rows
NEXT
cCalcCmd = Left(cCalcCmd,Len(cCalcCmd)-1) + " To " +
Left(cVariables,Len(cVariables)-1) &&+ "AVG(Field1)"
? cCalcCmd
Return
Paul
-Original Message-
From: ProfoxTech On Behalf Of Alan Bourke
Sent: 22 November 2019 12:55
To: profoxt...@leafe.com
Subject: Re: Fatal error issuing CALCULATE command
Sent by an external sender
--
Paul
Do you mean you are doing this?
calculate sum(field1 + field2 + ... + field32) to lnTotal
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm
[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/e3860082-6f47-86c8-0cbc-c268f1637...@gmail.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.
Re: Gartner Analyst Relations
Yep, in 1995 or 96 they said "FoxPro is dead". I think that was VFP 5 time. Frank. Frank Cazabon On 22/11/2019 11:11 AM, MB Software Solutions, LLC wrote: Thankfully my memory on bullshit fades but I recall something about them hosing FoxPro wy before it's true demise. You others longer in the game than I may recall better (unless you've got that CRS syndome too. CRS = Can't Remember Shit) On 11/22/2019 9:35 AM, Charlie Coleman wrote: Gartner probably one of the most 'listened to' but 'highly inaccurate' companies that exist. So yes, I too would be irritated if they suggested (wasting my) time with them. :) -Charlie On Fri, Nov 22, 2019 at 9:27 AM MB Software Solutions, LLC < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: I still get slightly agitated when I see the name "Gartner" -- you all remember that?!?!? Forwarded Message Subject: Gartner Analyst Relations Date: Thu, 21 Nov 2019 21:18:58 + From: Noonan,Devin To: mbabc...@mbsoftwaresolutions.com Hi Michael, I’m reaching out to better understand if MB Software Solutions, LLCwould be a fit to work with our analyst community for thought leadership and strategic insight. I am spearheading a new Gartner channel that focuses on high growth startups and emerging tech/service providers, and would love to discuss how Gartner can contribute to MB Software Solutions, LLC's continued growth. Do you have 30 minutes for a phone call this week or next to discuss this further? Kind regards, Devin Devin Noonan Business Development Director *Gartner* Direct: +1 (239) 900-8405 | Mobile: +1 (732) 977-4929 gartner.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [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/eef6e3e1-50cd-0e26-0860-f1b8f0617...@gmail.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.
Re: File Sync
Alan posted this earlier: https://docs.microsoft.com/en-us/windows-server/administration/windows-commands/robocopy On 20 November 2019 18:57:01 GMT-04:00, Koen Piller wrote: >Hi, > >Where can I find the Helpfile for RoboCopy? > >Rgds, > >Koen > >Op wo 20 nov. 2019 om 22:26 schreef Man-wai Chang : > >> Do not forget about ROBOCOPY that comes with Window$. >> >> robocopy source target /l /mt:1 /a-:sh /mir /xjd >> >> On Wed, Nov 20, 2019 at 11:39 PM Chris Davis >> wrote: >> > >> > Can anyone recommend a free and simple file syncing program to >mirror a >> folder on a server to a local folder (files and subfolders). >> > >> > I had been using freefilesync / robocopy but struggling with both >of >> these on one particular computer and want to try another such utility >to >> see if it gives me a better idea of what the issue is. >> >> -- >> .~. Might, Courage, Vision. SINCERITY! >> / v \ 64-bit Fedora 25 Server Spin >> /( _ )\ http://sites.google.com/site/changmw >> ^ ^ May the Force and farces be with you! >> [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/af3fa8f7-8d21-4821-b279-b7df56fee...@gmail.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.
Re: File Sync
I use syncback https://www.2brightsparks.com/freeware/freeware-hub.html On 20 November 2019 11:39:10 GMT-04:00, Chris Davis wrote: >Can anyone recommend a free and simple file syncing program to mirror a >folder on a server to a local folder (files and subfolders). > >I had been using freefilesync / robocopy but struggling with both of >these on one particular computer and want to try another such utility >to see if it gives me a better idea of what the issue is. > >Thanks > >Chris. > > >--- StripMime Report -- processed MIME parts --- >multipart/alternative > text/plain (text body -- kept) > text/html >--- > >___ >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/loyp123mb31672e4deab27cf67d2af7928f...@loyp123mb3167.gbrp123.prod.outlook.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. > >Report [OT] Abuse: >http://leafe.com/reportAbuse/loyp123mb31672e4deab27cf67d2af7928f...@loyp123mb3167.gbrp123.prod.outlook.com -- Frank Cazabon Sent from my phone. Please excuse my brevity. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ 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/6a5efc28-8196-4da0-87d0-70846cdd1...@gmail.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.
Re: Exporting Tables
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 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]
___
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/8090d215-3a89-d7e0-cd93-9fc825ebe...@gmail.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.
Re: Exporting Tables
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-9B72-EF94E038C891=en
Frank.
Frank Cazabon
On 06/11/2019 03:35 PM, Gene Wirchenko wrote:
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
[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/13881fdf-6ae5-1535-61c0-45b09d161...@gmail.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.
Re: [NF] This is incredible....command prompt refusing my command to change directory!
Yes, you are having a senior moment. You need to enter e: first and then cd when you are on the e: drive Frank. Frank Cazabon On 08/10/2019 11:07 AM, MB Software Solutions, LLC wrote: Am I having a senior moment?!?? See screenshot: https://www.screencast.com/t/ur5534H9KT I am trying to navigate to a different folder on my dev drive and Windows says "No!" ??? ___ 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/f038e533-a51d-97a1-f41b-928c2f4b3...@gmail.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.
Re: Bad style, but any chance it would ever fail to update properly?
Yes, it fails if you are at EOF in the currently selected table, if I recall correctly. Frank. Frank Cazabon On 02/10/2019 02:14 PM, MB Software Solutions, LLC wrote: We've seen this before (and I did it 2 decades ago): REPLACE MyTable.MyField with SomeOtherTable.SomeField The implication is that "replace the MyField value in the MyTable table." But if one doesn't use the IN clause, will there ever be any chance that the update to MyTable.MyField would fail? tia, --Mike --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus [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/f32c2e96-1dfc-3aeb-da47-55c5ab9e8...@gmail.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.
Re: Outlook Redemption tool
Kurt,
you could be correct that send(.t.) may just send it. I do have some
code that uses it to display the message prior to it being sent, but
looking back at the code now, it is referring to a messages object, not
a mailitem as in Mike's code, so maybe there is a difference but it's
easy enough to try it out.
Frank.
Frank Cazabon
On 03/09/2019 07:14 PM, Kurt at VR-FX wrote:
Frank - I think what you suggested would Send it. He simply wants it
on the screen to view. I think its possible that the window is Hidden
some how. Must be a way to place it on top.
I've done this kinda stuff in the past - using the same book at
examples in it. But, I'm confounded at the "Explorer" references in
your code Mike!
FYI - I believe there is a ".Visible" option that you must use
somewhere in your code - and THAT may make the email visible to use
for viewing before sending! Just a WAG here...
Again - its been YEARS since I did the Office Auto. stuff!
-K-
On 9/3/2019 2:41 PM, Frank Cazabon wrote:
Off the top of my head (and is been a long time since I did this) but
try passing true to the send (.t.) I think that might display the
email ready to be sent.
On 3 September 2019 16:53:17 GMT-04:00, "MB Software Solutions, LLC"
wrote:
I have a need to use MAPI (yes, I know Ted et al: MAPI bad, SMTP
good...but this customer wants to see a system generated email in
Outlook, review it including file attachment, and then press Send
manually). I thought I was going to have to use the Redemption tool to
get around the security issues with Outlook but I'm stunned that this
simple code worked on my laptop which has Outlook 2016 on it:
LOCAL oOutlook as Outlook.Application, oNamespace as Outlook.NameSpace,
oMailItem as Outlook.MailItem
oOutlook = CREATEOBJECT("Outlook.Application")
#DEFINE olFolderDisplayNormal 0
#DEFINE olMailItem 0
oNameSpace = oOutlook.GetNameSpace("MAPI")
oExplorer =
oOutlook.Explorers.Add(oNameSpace.Folders[1],olFolderDisplayNormal)
oMailItem = oOutlook.CreateItem(olMailItem)
WITH oMailItem
.Subject = 'Testing email send'
.Body = "Thank you for your participation in the test at " +
TTOC(DATETIME())
.Recipients.Add("mbabc...@mbsoftwaresolutions.com")
.Attachments.Add("C:\crap\MyFile.pdf")
.Save()
*.Send() && commented out for now as I don't want to
auto-send...user wants to review and manually Send
ENDWITH
oExplorer.Activate()
This is basically using the code from the Microsoft Office Automation
with Visual FoxPro book from HWP. (Thanks for the cue, Ted!). Now the
comment and question:
1. I'm amazed that Outlook 2016 let me do this without any
warning/blocking. I was thinking I'd have to use the Outlook
Redemption add-in tool (http://www.dimastr.com/redemption/)
2. The sample code above saves it to the Drafts folder but when I open
OL via the last line (oExplorer.Activate()), I was hoping to have
the email front and center so the user could just press the Send
button after reviewing it manually on screen. Any ideas how to
achieve that?
tia,
--Mike
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
___
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/f7d9c573-16a6-b737-9aaa-f288fa112...@mbsoftwaresolutions.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.
Report [OT] Abuse:
http://leafe.com/reportAbuse/f7d9c573-16a6-b737-9aaa-f288fa112...@mbsoftwaresolutions.com
[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/130e4afb-cf8d-0924-63d2-ed5378aef...@gmail.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.
Re: Outlook Redemption tool
Off the top of my head (and is been a long time since I did this) but try
passing true to the send (.t.) I think that might display the email ready to be
sent.
On 3 September 2019 16:53:17 GMT-04:00, "MB Software Solutions, LLC"
wrote:
>I have a need to use MAPI (yes, I know Ted et al: MAPI bad, SMTP
>good...but this customer wants to see a system generated email in
>Outlook, review it including file attachment, and then press Send
>manually). I thought I was going to have to use the Redemption tool to
>
>get around the security issues with Outlook but I'm stunned that this
>simple code worked on my laptop which has Outlook 2016 on it:
>
>LOCAL oOutlook as Outlook.Application, oNamespace as Outlook.NameSpace,
>
>oMailItem as Outlook.MailItem
>oOutlook = CREATEOBJECT("Outlook.Application")
>#DEFINE olFolderDisplayNormal 0
>#DEFINE olMailItem 0
>oNameSpace = oOutlook.GetNameSpace("MAPI")
>oExplorer =
>oOutlook.Explorers.Add(oNameSpace.Folders[1],olFolderDisplayNormal)
>oMailItem = oOutlook.CreateItem(olMailItem)
>WITH oMailItem
> .Subject = 'Testing email send'
> .Body = "Thank you for your participation in the test at " +
>TTOC(DATETIME())
> .Recipients.Add("mbabc...@mbsoftwaresolutions.com")
> .Attachments.Add("C:\crap\MyFile.pdf")
> .Save()
> *.Send() && commented out for now as I don't want to
>auto-send...user wants to review and manually Send
>ENDWITH
>
>oExplorer.Activate()
>
>
>This is basically using the code from the Microsoft Office Automation
>with Visual FoxPro book from HWP. (Thanks for the cue, Ted!). Now the
>
>comment and question:
>
> 1. I'm amazed that Outlook 2016 let me do this without any
>warning/blocking. I was thinking I'd have to use the Outlook
>Redemption add-in tool (http://www.dimastr.com/redemption/)
> 2. The sample code above saves it to the Drafts folder but when I open
>OL via the last line (oExplorer.Activate()), I was hoping to have
>the email front and center so the user could just press the Send
>button after reviewing it manually on screen. Any ideas how to
>achieve that?
>
>tia,
>--Mike
>
>
>
>
>---
>This email has been checked for viruses by Avast antivirus software.
>https://www.avast.com/antivirus
>
>
>--- StripMime Report -- processed MIME parts ---
>multipart/alternative
> text/plain (text body -- kept)
> text/html
>---
>
>___
>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/f7d9c573-16a6-b737-9aaa-f288fa112...@mbsoftwaresolutions.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.
>Report [OT] Abuse:
>http://leafe.com/reportAbuse/f7d9c573-16a6-b737-9aaa-f288fa112...@mbsoftwaresolutions.com
--
Frank Cazabon
Sent from my phone. Please excuse my brevity.
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
___
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/9fa51d6b-86c0-4d1e-8a37-4c3aac990...@gmail.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.
Re: FoxPro 2.6a for Chromebooks
There's probably a way to mount a shared folder in DosBox. this might help: https://ares.gobien.be/2017/03/mount-network-drive-shared-folder-in-dosbox/ Frank. Frank Cazabon On 03/09/2019 12:33 PM, Charles Hart Enzer, M.D. wrote: Thank you, Srikanth I can't figure out how to copy files from my Chromebook into DosBox *Shai / שי **Charles Hart Enzer, MD(Ohio, USA), FAACAP* *Aliyah <https://en.wikipedia.org/wiki/Aliyah>: Cincinnati to Jerusalem <http://www.gojerusalem.com/items/263/German-Colony/>'s German Colony <https://en.wikipedia.org/wiki/German_Colony,_Jerusalem> May, 2017* *Volunteer Associate Professor of PsychiatryUniversity of Cincinnati Medical CenterWebSite: **EnzerMD.com <http://EnzerMD.com>* *Publications* <http://www.enzermd.com/CV.html#Publications> *Tiny Country, Huge Dreams* *ארץ זעירה, **חלומות ענקיים* *עם ישראל חי* On Mon, Sep 2, 2019 at 10:14 PM Srikanth Bhandari < srikanth.bhanda...@gmail.com> wrote: Download a DosBox for your OS Version & FoxPro for Dos should run in that DosBox. DosBox is a Freeware. https://chrome.google.com/webstore/detail/dosbox-for-google-chrome/jhceknlmaggijlkkcemdaghpniimajhd -- Cheers!!! *Srikanth Bhandari* Mobile: +91 99625 42134 / +91 99001 39393 Email: consult...@srikanthbhandari.ind.in / srikanth.bhanda...@gmail.com Web: srikanthbhandari.ind.in On Fri, Aug 30, 2019 at 8:43 PM Charles Hart Enzer, M.D. I can't find a site from which can download the Foxpro 2.6a app for my Chromeboook -- Android OS *Shai / שי **Charles Hart Enzer, MD(Ohio, USA), FAACAP* *Aliyah <https://en.wikipedia.org/wiki/Aliyah>: Cincinnati to Jerusalem <http://www.gojerusalem.com/items/263/German-Colony/>'s German Colony <https://en.wikipedia.org/wiki/German_Colony,_Jerusalem> May, 2017* *Volunteer Associate Professor of PsychiatryUniversity of Cincinnati Medical CenterWebSite: **EnzerMD.com <http://EnzerMD.com>* *Publications* <http://www.enzermd.com/CV.html#Publications> *Tiny Country, Huge Dreams* *ארץ זעירה, **חלומות ענקיים* *עם ישראל חי* --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [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/af3376a5-8119-21a3-4cc4-2a5edee13...@gmail.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.
Re: SMB
Hi Chris, I moved away from DBF and DBC a long time ago but I don't think it was very difficult to check the registry settings manually. There is a tool available here: http://www.symantec.com/connect/downloads/smb2-toggle-too-mikes-tool-set Here are my notes from back then: *To Disable SMB2* When using the terms "client" and "server" in case of file and print sharing, it does not necessarily mean that a client-type OS such as Vista "always" connects to a server-type Os such as Windows Server 2008. Sometimes, a Vista computer will connect to another Vista computer, and in that case, the computer that is "serving" the shares is considered to be the "server". Here's how SMB is used when related to SMB versions: When a Windows Server 2008/Vista "client" connects to a Windows Server 2008/Vista "server", SMB 2.0 is used. When a Windows Server 2008/Vista "client" connects to a Windows 2000/XP/2003 "server", SMB 1.0 is used. When a Windows 2000/XP/2003 "client" connects to a Windows Server 2008/Vista "server", SMB 1.0 is used. When a Windows 2000/XP/2003 "client" connects to a Windows 2000/XP/2003 "server", SMB 1.0 is used. So, for troubleshooting purposes, mostly in an environment that has mixed operating systems, you might want to consider disabling SMB 2.0. You need to do so on both the "client" and the "server" operating systems. To disable SMB 2.0 for Windows Vista or Windows Server 2008 systems that are the “client” systems run the following commands: sc config lanmanworkstation depend= bowser/mrxsmb10/nsi sc config mrxsmb20 start= disabled Note there's an extra " " (space) after the "=" sign. To enable back SMB 2.0 for Windows Vista or Windows Server 2008 systems that are the “client” systems run the following commands: sc config lanmanworkstation depend= bowser/mrxsmb10/mrxsmb20/nsisc config mrxsmb20 start= auto Again, note there's an extra " " (space) after the "=" sign. In order to disable SMB 2.0 on the server-side computer, follow these steps: Warning! This document contains instructions for editing the registry. If you make any error while editing the registry, you can potentially cause Windows to fail or be unable to boot, requiring you to reinstall Windows. Edit the registry at your own risk. Always back up the registry before making any changes. If you do not feel comfortable editing the registry, do not attempt these instructions. Instead, seek the help of a trained computer specialist. 1. Run "regedit" on Windows Server 2008 based computer. 2. Expand and locate the sub tree as follows. HKLM\System\CurrentControlSet\Services\LanmanServer\Parameters 3. Add a new REG_DWORD key with the name of "Smb2" (without quotation mark) Value name: Smb2Value type: REG_DWORD0 = disabled1 = enabled 4. Set the value to 0 to disable SMB 2.0, or set it to 1 to re-enable SMB 2.0. 5. Reboot the server. This paper may also be of some assistance: https://www.dataaccess.com/KBasePublic/Files/2476.Tuning%20Microsoft%20Networks%20for%20the%20Legacy%20Embedded%20Database_PDF_FMT.PDF Frank. Frank Cazabon On 27/08/2019 06:57 AM, Chris Davis wrote: Hi All With any networked VFP application sharing a DBC the SMB performance of the server hosting the DBC is very important? Assuming your answer to the above question is Yes or Of Course, then when you have one server that seems to perform well and one that doesn't it would be useful to easily compare the setup of the two. Is anyone aware of any utilities that make the configuration and tweaking of SMB easy or at least allow you to compare to setups? Of course, if your answer to the first question isn't yes I would also be interested in your thoughts. I know there is a lot more that comes into the performance of an application other than the setup of the server, i.e the spec of the client, the os of the client, other software such as anti virus, network infrastructure etc etc. Where I am going with this... We have lots of sites where an application works well and one site where it doesn't, and without having to spend hours and hours investigating all the various settings and registry entries, I just want to start with the servers and make a comparison to see if there are any obvious differences. Thanks Chris. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [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: h
Re: Easiest/best way to create an email using local MS Outlook with file attachments?
Mike,
along with Alan's code you can use loMsg.Display() to display the email
on screen before sending.
Frank.
Frank Cazabon
On 21/08/2019 04:17 AM, Alan Bourke wrote:
If you want to use Outlook:
loOutlook=CreateObject("Outlook.Application")
loMsg = loOutlook.CreateItem(0)
loMsg.BodyFormat= 2
&& olFormatHTML
loMsg.HtmlBody="HTML body text"
loMsg.Body = "Plain body text for clients without HTML mail support."
loMsg.Subject="Subject"
loMsg.Recipients.Add("some...@somewhere.com")
loMsg.Recipients.Add("some...@anotherplace.com")
loMsg.Attachments.Add("attach1.txt", 1)
loMsg.Attachments.Add("attach2.txt", 1)
loMsg.Attachments.Add("attach3.txt", 1)
Try
llSent = loMsg.Send()
Catch to loException
&& handle it
Finally
release loMsg
release loOutlook
Endtry
HOWEVER
There are some drawbacks to this.
- Despite it sending via Outlook, you will find that any Outlook signatures or
stationery that would normally apply won't get used on the programmatically
created message.
- You may find that the dread Outlook security message ('A program is trying to
send mail on your behalf...') will crop up, depending on Outlook and Exchange
Server version.
___
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/846fca74-7d65-c745-5c26-51197748a...@gmail.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.
Re: SQL server connection
I use SQL native client (which is an option to install when installing SQL
server):
https://www.microsoft.com/en-us/download/details.aspx?id=50402
And then I use a connection string like:
ConnectionString=DRIVER=SQL Server Native Client
11.0;Trusted_Connection=Yes;DATABASE=GoldBuy;SERVER=MyServer;App=MyApp;
Or:
ConnectionString=DRIVER=SQL Server Native Client
11.0;Trusted_Connection=No;uid=myuserid;PWD=mypassword;DATABASE=GoldBuy;SERVER=MyServer;App=MyApp;
But you could use a user or system dsn.
On 20 August 2019 12:26:35 GMT-04:00, Peter Cushing
wrote:
>Hi,
>
>Thanks to everyone that replied. I don't have to worry about getting
>fired, so all good there.
>SPT seems the easiest to begin with, but not got it working yet.
>I have created an ODBC link called X2live. I set it up as a system DSN
>as I tried a user DSN first and that didn't work.
>Just wondering what version of the ODBC driver are you using. Mine is:
>Microsoft SQL Server ODBC Driver Version 06.01.7601
>Did a few quick searches and can't seem to establish if this is a 32 or
>64 bit driver.
>
>When I click test data source it comes back with Tests completed
>successfully but if I try
>?sqlconnect('x2live') && returns -1
>
>I have tried putting in the username/password and didn't make any
>difference.
>
>What actual commands do you use to connect?
>
>TIA
>
>Peter Cushing
>IT Department
>WHISPERING SMITH
>
>
>On 20/08/2019 15:11, Paul H. Tarver wrote:
>> Peter,
>>
>> Personally, I like SPT because I can build valid and safe
>pass-through commands in my code based on user selections, generate the
>string, hand it off to the server with an ASYNCH connection and easily
>provide users with progress feedback while data is returned.
>>
>> For some reason, I've never been able to wrap my head around cursor
>adapters completely. Maybe it’s a control issue! :) I think SPT just
>made more sense to me upfront. Thankfully, Foxpro gives you plenty of
>different ways to accomplish the same things and you can pick the one
>that works the way you do! I use it to query data for reporting
>purposes and it gives me a lot of control over how I construct the
>query string since I can use all of the string functions within Foxpro
>to build exactly the query I want based upon users' selections.
>>
>> Another advantage is I able to dump the query string to my audit
>files just before the SQLEXEC() command fires, so if something goes
>wrong, I can just copy the query to my SQL management tool and see if I
>can manually figure out what is going on.
>>
>> So far, I've used SPT successfully to backend Foxpro with SQL, MySQL,
>Oracle, Access, PostgreSQL, SQLite, etc. I just tweak queries to
>customize for the database and the rest of my code remains the same.
>>
>> It works for me, but I'm sure, someone else here will provide you
>with the benefits of cursor adapters.
>>
>> Paul H. Tarver
>>
>>
>> -Original Message-
>> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
>Peter Cushing
>> Sent: Tuesday, August 20, 2019 4:40 AM
>> To: profoxt...@leafe.com
>> Subject: SQL server connection
>>
>> Hi,
>>
>> After running my app (VFP 9) on our local network (with a DBC) for
>many
>> years, we are upgrading it (in stages) to a visual studio app with
>SQL
>> server back end.
>> I have read many people here talking about using SQL as a back end.
>At
>> the beginning I will just be accessing the SQL data for reporting
>> purposes but may need to write to it at some point. Looking through
>the
>> archives some people mentioned SPT and others cursor adapters. Just
>> wondering what people recommend to connect, so I can avoid the usual
>> gotchas.
>>
>> Thanks,
>
>
>This communication is intended for the person or organisation to whom
>it is addressed. The contents are confidential and may be protected in
>law. Unauthorised use, copying or disclosure of any of it may be
>unlawful. If you have received this message in error, please notify us
>immediately by telephone or email.
>
>www.whisperingsmith.com
>
>Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3
>1RR.
>Tel:0161 831 3700
>Fax:0161 831 3715
>
>London Office: 101 St. Martin's Lane,London, WC2N 4AZ Tel:0207 299
>7960
>
>
[excessive quoting removed by server]
___
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/bbfa9daf-e816-4dd3-9190-50f759d79...@gmail.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.
Re: SQL server connection
Yes, agreed using stored procedures is a good way, however I believe you still need SPT or CursorAdapters to access those stored procedures, so they are not necessarily mutually exclusive. Frank. Frank Cazabon On 20/08/2019 09:42 AM, Stephen Russell wrote: Considering they are flipping over SQL Server I would learn to USE SQL SERVER correctly on the front end from VFP. You create the sprocs that do all of your CRUD operations. Populate them from the fox world and as VFP is replaced, the newer interfaces will use the same sprocs you laid down today whenever they are activated. On Tue, Aug 20, 2019 at 7:24 AM Frank Cazabon wrote: I use Visual MaxFrame Professional so the details are hidden from me and I don't really care what technology is used behind the scenes. < smile > I actually think that Drew coded it so that it works through remote views in the background. If I were to start doing my own code/framework now in VFP I would probably use CursorAdapters but I have never actually used them for more than playing with to learn about them. I believe they give you enough flexibility while hiding some of the technical details. If you want absolute control, then go with SPT. Frank. Frank Cazabon On 20/08/2019 05:39 AM, Peter Cushing wrote: Hi, After running my app (VFP 9) on our local network (with a DBC) for many years, we are upgrading it (in stages) to a visual studio app with SQL server back end. I have read many people here talking about using SQL as a back end. At the beginning I will just be accessing the SQL data for reporting purposes but may need to write to it at some point. Looking through the archives some people mentioned SPT and others cursor adapters. Just wondering what people recommend to connect, so I can avoid the usual gotchas. Thanks, [excessive quoting removed by server] ___ 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/cf6bd2c1-06c7-35e6-354e-472f0d257...@gmail.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.
Re: SQL server connection
I use Visual MaxFrame Professional so the details are hidden from me and I don't really care what technology is used behind the scenes. < smile > I actually think that Drew coded it so that it works through remote views in the background. If I were to start doing my own code/framework now in VFP I would probably use CursorAdapters but I have never actually used them for more than playing with to learn about them. I believe they give you enough flexibility while hiding some of the technical details. If you want absolute control, then go with SPT. Frank. Frank Cazabon On 20/08/2019 05:39 AM, Peter Cushing wrote: Hi, After running my app (VFP 9) on our local network (with a DBC) for many years, we are upgrading it (in stages) to a visual studio app with SQL server back end. I have read many people here talking about using SQL as a back end. At the beginning I will just be accessing the SQL data for reporting purposes but may need to write to it at some point. Looking through the archives some people mentioned SPT and others cursor adapters. Just wondering what people recommend to connect, so I can avoid the usual gotchas. Thanks, ___ 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/ad40605d-54b7-7f3a-6cdf-53dfc484f...@gmail.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.
Re: Working with multi-page PDF files and automatically labeling and later extracting select pages
I've never merged or split PDFs with it but I've used it to fill in a
PDF form. Basically I create a script to run the pdftk command, store it
in a batch file and execute the batch file
STRTOFILE(m.lcFDFFile, m.lcFolder + "source.fdf")
m.lcCommand = [pdftk "] + m.lcBlankForm + [" fill_form "] +
m.lcFolder + [source.fdf" output "] + m.lcFilledForm +[" flatten drop_xfa]
* store the command in a batch file due to the 240 character limit
for run commands
m.lcBatchFile = m.lcFolder + "fillpdf.bat"
STRTOFILE(m.lcCommand, m.lcBatchFile)
*!* maybe use shellexecute
RUN ""
IF FILE(m.lcFilledForm)
m.lcFileName = JUSTFNAME(m.lcFilledForm)
IF MESSAGEBOX('The file ' + m.lcFileName + CHR(13) + 'was
successfully created.' + CHR(13) +;
'Would you like to open it now?',36,'PDF Merge
Successful') = 6
X8ShellExecute(m.lcFilledForm)
ENDIF
ELSE
MESSAGEBOX("The system encountered a problem creating the
PDF.",64,"Problem Encountered")
ENDIF
Frank.
Frank Cazabon
On 02/08/2019 11:40 AM, MB Software Solutions, LLC wrote:
That looks great, Frank. Got any source code to share with me?!???
On 8/2/2019 8:32 AM, Frank Cazabon wrote:
This is the PDF Toolkit I have used:
https://www.pdflabs.com/tools/pdftk-the-pdf-toolkit/
which allows you to merge and split (and more) PDFs
Frank.
Frank Cazabon
On 02/08/2019 08:02 AM, MB Software Solutions, LLC wrote:
Ideally, these would be the tables:
MyComponents.dbf
* iid int autoinc PK
* cLabel v(50) (e.g., INVOICE, FUEL RECEIPT, BILL OF LADING, etc.)
* tAdded t
MyPDFs.dbf
* iid int autoinc PK
* cFilename v(50)
* tAdded t
MyPages.dbf
* iid int autoinc PK
* iFileID int (backlink to MyPDFs.dbf)
* nStartPage int
* nEndPage int
* iLabelID (backlink to MyComponents.dbf)
And then on demand, I could generate a new deliverable PDF
containing multiple components, selectable by the user ahead of time
to put it together. From the original post: "B, C, and E" -- all in
one PDF file.
On 8/1/2019 4:29 PM, Frank Cazabon wrote:
PDF toolkit might let you split a PDF into separate PDFs. But it
really sounds like you should keep the original PDFs as separate
entities and deal with each component as you wish.
On 1 August 2019 16:19:10 GMT-04:00, "MB Software Solutions, LLC"
wrote:
Customer has a single PDF ("document") with several pages in it
(let's
say 12 pages). The document is made up of several scanned files,
each
a
different file type or "component."
Customer wants to extract certain pages from this single PDF into
later
email to other parties. They cannot mail the entire document because
some content isn't intended for recipients (like invoices) but they
want
to be able to send other selected "component" parts and that file
attached to the email deliverable would be a SINGLE file.
Example:
MyPDF.PDF
Page 1: Invoice ("A")
Page 2-3: Bill of lading ("B")
Page 4-6: Fuel slips ("C"
Page 7-10: Something else ("D")
Page 11-12: Yada yada yada ("E")
Eventually, components B, C, and E will be emailed to somebody.
Given this scenario, what do you recommend?
tia,
--Mike
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
[excessive quoting removed by server]
___
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/08dc0f9a-03cc-adbc-f27d-26558ef01...@gmail.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.
Re: Working with multi-page PDF files and automatically labeling and later extracting select pages
This is the PDF Toolkit I have used:
https://www.pdflabs.com/tools/pdftk-the-pdf-toolkit/
which allows you to merge and split (and more) PDFs
Frank.
Frank Cazabon
On 02/08/2019 08:02 AM, MB Software Solutions, LLC wrote:
Ideally, these would be the tables:
MyComponents.dbf
* iid int autoinc PK
* cLabel v(50) (e.g., INVOICE, FUEL RECEIPT, BILL OF LADING, etc.)
* tAdded t
MyPDFs.dbf
* iid int autoinc PK
* cFilename v(50)
* tAdded t
MyPages.dbf
* iid int autoinc PK
* iFileID int (backlink to MyPDFs.dbf)
* nStartPage int
* nEndPage int
* iLabelID (backlink to MyComponents.dbf)
And then on demand, I could generate a new deliverable PDF containing
multiple components, selectable by the user ahead of time to put it
together. From the original post: "B, C, and E" -- all in one PDF file.
On 8/1/2019 4:29 PM, Frank Cazabon wrote:
PDF toolkit might let you split a PDF into separate PDFs. But it
really sounds like you should keep the original PDFs as separate
entities and deal with each component as you wish.
On 1 August 2019 16:19:10 GMT-04:00, "MB Software Solutions, LLC"
wrote:
Customer has a single PDF ("document") with several pages in it (let's
say 12 pages). The document is made up of several scanned files, each
a
different file type or "component."
Customer wants to extract certain pages from this single PDF into later
email to other parties. They cannot mail the entire document because
some content isn't intended for recipients (like invoices) but they
want
to be able to send other selected "component" parts and that file
attached to the email deliverable would be a SINGLE file.
Example:
MyPDF.PDF
Page 1: Invoice ("A")
Page 2-3: Bill of lading ("B")
Page 4-6: Fuel slips ("C"
Page 7-10: Something else ("D")
Page 11-12: Yada yada yada ("E")
Eventually, components B, C, and E will be emailed to somebody.
Given this scenario, what do you recommend?
tia,
--Mike
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
[excessive quoting removed by server]
___
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/e1abf2ad-06f3-9615-97a6-684327dc3...@gmail.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.
