Re: FoxBin2Prg Form.Property = "" becomes .F.

[Fernando D. Bozzo]

Hi Tracy,

Finally, today I fixed all pending reported bugs. I'm not programming in
VFP since late 2018, but today I was feel nostalgic and did it :)

Best regards!

Fernando.-


El jue., 14 mar. 2019 a las 15:51, Tracy Pearson ()
escribió:

> Further examination looks like this behavior might only be happening when
> the property name is "note".
> I see other properties on the same form that are not showing this behavior.
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Tracy
> Pearson
> Sent: Thursday, March 14, 2019 10:48 AM
> To: profoxt...@leafe.com
> Subject: FoxBin2Prg Form.Property = "" becomes .F.
>
> I have just recently started to use FoxBin2Prg to store my VCX and SCX
> files
> as text versions in Git.
> Some of my forms have properties set to a have nothing in it. VFP displays
> this as "(none)".
>
> When I use FoxBin2Prg to put this particular form in to the SC2 form, the
> back to the SCX form this property becomes a .F.
>
> Just putting this out there for those that might use this tool.
>
> Tracy
>
>
[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/CAGQ_Juk5rf4ZqPBea3L=xz3dqt0jzgd+xtcrxrtha17xnfj...@mail.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: FoxBin2Prg and DBF files

[Fernando D. Bozzo]

Hi Tracy,

DBF import/export data It's configurable, but disabled by default.

Here is the doc:

https://github.com/fdbozzo/foxbin2prg/wiki/FoxBin2Prg-internals#DBF_Data_ExportImport_for_DiffMerge

Best Regards!



El jue., 7 feb. 2019 a las 22:44, Tracy Pearson ()
escribió:

> Does anyone that uses the FoxBin2Prg app convert DB2 files back to DBFs?
>
> >From the documentation it looks like it should convert back and forth. I'm
> getting the following error:
>
> 2019-02-07T16:32:52
>
> 
> 
> Error 1098, File [C:\Work\pconebody\PCOnebody_MetaData.db2] is not
> supported
> convert, 4087
> FoxBin2Prg: [C:\WORK\TOOLS\FOXBIN2PRG\FOXBIN2PRG.EXE] (EXE Version:
> v1.19.51)
> tc_InputFile = [C:\WORK\PCONEBODY\PCONEBODY_METADATA.DB2]
>
> Source file: C:\Work\pconebody\PCOnebody_MetaData.db2
>
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_Ju=caf9trsbu6oxzxaazxjh9pnaygqtfawrjt0+uejp...@mail.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: Converting .scx to .prg

[Fernando D. Bozzo]

Hi Gene,

When I made FoxBin2Prg, the main reason to do it was to generate prg-like
code with the maximum possible prg compatibility, but allowing the reverse
convertion with a valid binary again, so this imposed some constraints in
the way that value assignments are made to preserve the original assignment.

Rigth now, if you generate a prg from a scx file, the only adjustment you
need to make, AFAIR, is in the property assignments, because they are in a
format like:

Property = string

And not in the proper prg format, that is:

Property = "string"

I did it this way because there are like 4 different ways of assigning
properties, and in any case the value must preserve a format that is needed
to differentiate between these possibilities:

- default blank property value
- default property value when you press enter on it's value
- normal user assigned value
- user assigned function (like when using "=value" in the property value,
with the equal sign)

So, if checking/correcting those values and adding the missing quotes is
not a problem for you, the other 99% of the generated code is pure prg that
follows the prg rules and syntax.

Hope it helps,

Fernando D. Bozzo

El mar., 29 ene. 2019 6:59, Gene Wirchenko  escribió:

> Hello:
>
>   How do I convert a .scx to a .prg?
>
>   I have found most of the pieces of code, but I do not see how
> the contained objects are created.  (I was expecting to find a form
> .Init().)
>
> Sincerely,
>
> Gene Wirchenko
>
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_jukkpxao5q8vbk7gwbq_p7y9xysmbc-qnptqxgmwgxl...@mail.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: [ADMIN] Testing new mail relay

[Fernando D. Bozzo]

Hi Dave, I'd read you :-D


El jue., 10 ene. 2019 11:24, Dave Crozier 
escribió:

> Ed,
> I have all the emails and seem to be able to receive everything apart from
> my own emails and responses, any chance you can give it a look please as it
> seems to be since we moved over to Office 365. I used to send all my emails
> as davec at Flexipol.co.uk when we had exchange but now send them under
> my domain name dcrozier at flesipol.co.uk but can receive under the old
> alias..
>
> If someone can confirm that they can see this email it will help me in
> confirming I am not going mad and that I am sending correctly.
>
> Thanks
>
> Dave Crozier
> Software Development Manager
> Flexipol Packaging Ltd.
>
> ﴾⚆ᨎ⚆﴿
>
>
>
> 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: ProfoxTech  On Behalf Of Fernando D.
> Bozzo
> Sent: 09 January 2019 18:58
> To: profoxt...@leafe.com
> Subject: Re: [ADMIN] Testing new mail relay
>
> Test PASSED! - Green light
>
> :D
>
>
> El mié., 9 ene. 2019 a las 19:52, Ed Leafe () escribió:
>
> > Many of you have had problems receiving mail from the list, as my
> > domain is hosted on a server in the cloud, and many ISPs have blanket
> > blocks on any IP addresses from cloud providers like mine (Digital
> Ocean).
> >
> > I’m testing out a new relay service, Mailgun (https://www.mailgun.com/).
> > So far it seems to be running well, but if any of you on the receiving
> > end of things notices a problem, please let me know.
> >
> > One other issue is the cost: it’s free if the total # of emails sent
> > is under 100K, but gets expensive above that. Last year the highest
> > number of emails sent in a month was 280 in May, which is about
> > 133,000 total emails, and that would have cost $120 for that month
> > (ouch!). So I’m not sure if I will keep it, but it’s worth a trial at
> least.
> >
> >
> > -- Ed Leafe
> >
> >
> >
> >
> >
> >
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_jumwpk7qfrh3y5bbyrxfqtyfdwq0mxr_jjb9chpw4p8...@mail.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: [ADMIN] Testing new mail relay

[Fernando D. Bozzo]

Test PASSED! - Green light

:D


El mié., 9 ene. 2019 a las 19:52, Ed Leafe () escribió:

> Many of you have had problems receiving mail from the list, as my domain
> is hosted on a server in the cloud, and many ISPs have blanket blocks on
> any IP addresses from cloud providers like mine (Digital Ocean).
>
> I’m testing out a new relay service, Mailgun (https://www.mailgun.com/).
> So far it seems to be running well, but if any of you on the receiving end
> of things notices a problem, please let me know.
>
> One other issue is the cost: it’s free if the total # of emails sent is
> under 100K, but gets expensive above that. Last year the highest number of
> emails sent in a month was 280 in May, which is about 133,000 total emails,
> and that would have cost $120 for that month (ouch!). So I’m not sure if I
> will keep it, but it’s worth a trial at least.
>
>
> -- Ed Leafe
>
>
>
>
>
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_JunF5SzSQR9ZF+GiQUjXrn_FVj=8adfemtgr2tshqds...@mail.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: VSS to git conversion

[Fernando D. Bozzo]

When people leave VSS for a new SCM tool, one of the first mistakes that
many of them make is to try to use the new SCM tool in the same way that
they used VSS, and they do not realize that the new SCM tools are designed
With a different mindset and considering a different work flow, it is an
evolution of the old way of doing things.

If one tries to change this type of tool for a new one with the same
mentality and is not evolving in the way of doing things, then he could not
obtain the benefits of the new way of doing things and he will simply
repeat what he knows.

Applying this to VFP, many people try to use something like Git or similar
with the same workflow they used with VSS, for example, blocking modified
files so that no one else can modify them, and doing this is in the 21st
century on a computer local or distributed, it's a huge mistake.

Some of those benefits are speed, concurrency and independence.

Speed because allowing several people to work on the same component is
better and faster than one at a time

Concurrence due to the same, 2 or more people can work in different
arrangements or functions in the same component at the same time without
blocking each other

Independence because if one of the people who works on a component (form,
class library) leaves the edition open and leaves (vacation, illness,
etc.), nobody is blocked and others can continue working on it.

VSS treated the files independently, one by one, and this is one of the
great changes with the new tools, since they are no longer individual
files, now there is a set of changes composed of many modified files
related to the task, for what when you need to know what files were
modified for a solution / feature, you can know.

VSS was useful at the time with the mentality of its time, but now there
are better ways of doing things and thinking about the code and if you want
to make that transition and improve the way you work with the code, then it
is convenient to learn how to do it as it is done now, although really the
new way of working has already been in existence for more than 15 years.

The best way to take advantage of all this in VFP is not to tie yourself to
the VSS way of doing things, not to think about files but about features or
arrangements, and focus on that. Forget SccText and what was already
generated with it and regenerate all text files with FoxBin2Prg to start
benefiting from being able to make code mixes like the rest of the
languages do.

The branches by task help to work in this way. VSS could not work with
branches in a useful or efficient way, now it can and is very useful, since
you can be working on several features and arrangements at the same time
without interfering with each other.

Many of the changes in the way of work have to do also with the new way of
making the code mixes, the composition of the components through the
different contributions of the developers, something unimaginable with VSS.

Finally, leave open the possibility of not wanting to continue controlling
everything from the project manager, which is very comfortable for the old
way of working, but it is not efficient when you can be working on one
feature at a time and the next moment you have to leave all by halves and
continue working in another branch for an important arrangement.

In order to do this, it is better and more efficient to separate the
management of the VFP project manager code and manage it with the SCM tool
chosen, outside of VFP. At first it is difficult to get used to the idea,
especially when they have been using the same thing for many years, but
then one gets used to another form of work and discovers the advantages
that I mention.

Best Regards!

Fernando D. Bozzo



El 9 ene. 2019 2:24 a. m., "Fletcher Johnson" 
escribió:

Tracy,

Now I remember.  I actually had a program that I could run that would
re-sort the scx (or the generated code) and then re-format the code so that
the code was always in more or less the same sequence and format. I am
guessing that whoever wrote FoxBin2PRG had some of the same frustrations and
was nice enough to build something more robust and then publish it.

When VSS support was first added, the theory was that any source control
could be used.  I often wondered if the hooks were still there so that Git
could be used as (more or less) seamlessly as VSS.

I hope things work out,


Fletcher


Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
beknown.com/FletcherJohnson
twitter.com/fletcherJ
twitter.com/svcsug
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Tracy Pearson
Sent: Friday, January 4, 2019 1:25 PM
To: profox@leafe.com
Subject: RE: VSS to git conversion

Fletcher,

We used the default SCCTEXT.PRG is what creates the VCA and SCA files stored
in VSS next to the binary files. However, attempting to DIFF that did 

Re: AW: Custom Scrollbar

[Fernando D. Bozzo]

Hi Gene:

I think that I've found what you need.
You need to use the Valid event of the grid in combination with the valid
of the controls.

Please, read this chapter about grids of the book 1001 things you wanted to
know about VFP.

"Grids, the misunderstood controls:"

https://books.google.es/books?id=wKNfTHRNkLAC=PA159=PA159=chapter+6+grids+the+misunderstood+controls=bl=_08ZpTRmYN=96XyTJ44EPz0-LM5magwVtuTzmg=es=X=2ahUKEwj15-zS0N3fAhWMJ1AKHX0kAzgQ6AEwBHoECAgQAQ#v=onepage=chapter%206%20grids%20the%20misunderstood%20controls=false




El mar., 8 ene. 2019 4:27, Gene Wirchenko  escribió:

> At 03:18 2019-01-07, "Fernando D. Bozzo"  wrote:
> >Hi Gene, About this: >"One of the things that Grid is supposedly not
> >for is data entry"
>
> >  I don't agree.
>
>   Neither do I, but I have seen this opinion posted many times
> over the years.  I do not understand it myself, but there it is.
>
> >  Not sure about the complexity of what you need to do, but if you
> > used FoxPro before VFP, you could remember that before the grid
> > component was the BROWSE command with many parameters that allowed
> > many validations and options for row/column, and that many
> > validations and options where made exactly for that purpose, for
> > data entry. Most of them have no sense for other purpose than data entry.
>
>   Yes, but I had a period of time where I was not using
> xBASE.  That was about when the fancy browses had their day.  I have
> looked at BROWSE, and it does not have quite what I want.
>
> >  One of my first programming challenges was to do a component
> > exactly as you need it to (I'm talking about dBase III+ era), and
> > could do it, but the problem was that performed horribly, too slow
> > to navigate records and columns. I think that you could face the
> > same problem. Do not forget that you have to control each and every
> > aspect of the component, as: - Scrolling left/right controlling
> > start and end columns
>
>I have this scrolling already working in a concept case.  It
> was fairly easy.  I grant that this may change when I add more
> feature.  I do not think so though.
>
> >  - Scrolling top/bottom controlling start and end rows -
> > Controlling the data you load/unload, because you can't load a
> > millon records in memory, and this forces you to control
> > dinamically the loading of a new bunch of records in the direction
> > you are navigating, and unloading records from the other side -
>
>   Yup!  It is going to be fun, but I have some ideas.
>
>   I am concerned with how the scrollbar works, but I may just
> come up with my own version that bypasses the issues.
>
> >Controlling every key for navigation and other needed purposes -
> >Controlling the visualization of each aspect of your info (think on
> >Autosizing columns, pre-programmed sizes, combination of both,
> >assuring that you show columns correctly and fluently ,etc)
>
>   I do not plan to have every feature that Grid has, at least for
> the start.
>
>   I tried to get Grid working when allowing column order to
> change, and it was horrible.
>
> >  - More things you may ancounter
>
>   Quite possibly.
>
>   What I have encountered is trouble with row-level
> validation.  Without that, Grid is NOT what I want.
>
> >  Obviously I'm thinking in a component that can be used for any
> > table, and not just for one special table, because the programming
> > effort to do this type of component is too high to do it for just
> > one table. Don't know if you already said this because I didn't
> > follow the entire thread, but: What type of validation do you need,
> > and what is the problem you are facing that can't be handled with the
> grid?
>
>   I can not get proper row-level validation working
> consistently.  I have tried and tried and tried.  I keep finding
> cases where it breaks.  I deal with a case, and something else
> breaks.  It is very frustrating.
>
>   I had quite a lot of trouble to get my test case to work.  I
> had to experiment with events and methods, but once I got it, it
> worked and did so consistently.
>
> >  And more importantly: Is really a grid what you need? why can't
> > you use an input form with navigation keys that scrolls data in
> background?
>
>   Because some of the work that needs to be done needs multiple
> rows visible at once.
>
> [snip]
>
> Sincerely,
>
> Gene Wirchenko
>
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.co

Re: AW: Custom Scrollbar

[Fernando D. Bozzo]

Hi Gene,

About this:

>"One of the things that Grid is supposedly not for is data
entry"

I don't agree. Not sure about the complexity of what you need to do, but if
you used FoxPro before VFP, you could remember that before the grid
component was the BROWSE command with many parameters that allowed many
validations and options for row/column, and that many validations and
options where made exactly for that purpose, for data entry. Most of them
have no sense for other purpose than data entry.

One of my first programming challenges was to do a component exactly as you
need it to (I'm talking about dBase III+ era), and could do it, but the
problem was that performed horribly, too slow to navigate records and
columns.
I think that you could face the same problem. Do not forget that you have
to control each and every aspect of the component, as:

- Scrolling left/right controlling start and end columns
- Scrolling top/bottom controlling start and end rows
- Controlling the data you load/unload, because you can't load a millon
records in memory, and this forces you to control dinamically the loading
of a new bunch of records in the direction you are navigating, and
unloading records from the other side
- Controlling every key for navigation and other needed purposes
- Controlling the visualization of each aspect of your info (think on
Autosizing columns, pre-programmed sizes, combination of both, assuring
that you show columns correctly and fluently ,etc)
- More things you may ancounter

Obviously I'm thinking in a component that can be used for any table, and
not just for one special table, because the programming effort to do this
type of component is too high to do it for just one table.

Don't know if you already said this because I didn't follow the entire
thread, but:
What type of validation do you need, and what is the problem you are facing
that can't be handled with the grid?

And more importantly: Is really a grid what you need? why can't you use an
input form with navigation keys that scrolls data in background?

Best Regards!


El lun., 7 ene. 2019 a las 6:20, Gene Wirchenko ()
escribió:

> At 08:13 2019-01-06,  wrote:
> > >> I want to create my own grid
> >
> >WHY, just WHY?
>
>   Because the VFP grid does not work.
>
> >Haven't yet found a problem for which I would need a homegrown grid.
> >What can't you do in VFP's native grid, in combination with the excellent
> >container hierarchy which you could add into any / every column of a grid?
>
>   Full validation of a row.
>
>   I came close, but it required a lot of kludges and an innocent
> change in one place could blow it up.
>
> >Build a set of controls, save them as class, add that class to the Column,
> >change Column.CurrentControl to point to that class, set Column.Sparse to
> >.F. and presto, you can do any complicated setup and stil have the
> benefits
> >of VFP's native gridspeed.
>
>   I wish.
>
>   One of the things that Grid is supposedly not for is data
> entry.  I need a grid that can handle that.
>
> Sincerely,
>
> Gene Wirchenko
>
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_Ju=v1uvypm_nohs-b0v31ppr2nbbazawmknzqw2crhe...@mail.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: VSS to git conversion

[Fernando D. Bozzo]

Hi Tracy:

I've done that in 2014 to migrate the last 10 labeled versions from our VSS
projects to PlasticSCM repositories.

The simplest way I'd find to do it is to checkout each version, copy to the
new repository and checkin into PlasticSCM.

In our case we migrated tx2 files and binaries, but you can do it with just
tx2 files.
Special care must by take with moved or renamed files.
I did the migration of those 10 latest versions (2700 files between tx2 and
binaries) in an hour or so.

Because the tx2 are the same, there is no need for regeneration.

Hope this helps,

Best Regards!


El jue., 3 ene. 2019 17:29, Tracy Pearson  escribió:

> We are looking at changing things over from VSS to git. There are about 20
> projects that we want to transfer the history of the files in to git.
> However, we do not want to transfer the binary files over. We haven't been
> using the FoxBin2PRG since we have been just working directly in the
> standard project manager in VFP.
>
> For example, a form in VSS is a binary file. It has had 16 changes to in
> over the past few years. We would like to have these historical changes
> stored in git allowing us to reference this history without the need to go
> back to VSS. The catch is, we only want to store the text equivalent of the
> form in git.
>
> Is there someone out there that has done this in the past?
>
> Thank you,
> Tracy
>
>
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_JumvGAWyPdr-8TH4bVgrPLDwD5s1_Ry+JWVmSYfA=vj...@mail.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: Reallocating drive space

[Fernando D. Bozzo]

... I still prefer the simplicity of the interface of SpaceSniffer.

So much 3D effects are very distracting for me, and makes difficult to se
some details.

I think that the 3D interface of WizTree have usability problems because of
this effects.



El mar., 20 nov. 2018 8:36, Alan Bourke  escribió:

> Not as cool as WizTree, which uses the file allocation table to scan the
> drive and will produce a map for a 512GB drive in a few seconds.
>
>
> https://antibody-software.com/web/software/software/wiztree-finds-the-files-and-folders-using-the-most-disk-space-on-your-hard-drive/
>
> --
>   Alan Bourke
>   alanpbourke (at) fastmail (dot) fm
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_Ju=c+f1=sBYv-zqua8UjPwvHLy1Rue2dpkCUfv=ttsk...@mail.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 methods in forms

[Fernando D. Bozzo]

It's true, right now VFP works better when installed out of Program Files
dir.


El mar., 20 nov. 2018 10:27,  escribió:

> >> Installation in the  default folder - C:\Program Files (x86)
>
> That's maybe the culprit. Everything installed in "Program files" is
> readonly for normal users, thus for VFP this isn't the ideal homebase,
> since it cannot write anything in it's folder hierarchy (like temp files or
> support tables), or recompile some of the classes, etc.
>
> You may want to set the attributes of the VFP folder and it's subfolders
> to ReadWrite, or always  run it explicitely with Administrative Rights.
> And next time install it to something like c:\develop\   :)
>
>
> wOOdy
>
>
>
>
> -Ursprüngliche Nachricht-
> Von: ProFox  Im Auftrag von Ajit Abraham
> Gesendet: Dienstag, 20. November 2018 08:34
> An: profox@leafe.com
> Betreff: Re: AW: disappearing methods in forms
>
>
>   Installation in the  default folder - C:\Program Files (x86) My work is
> on another drive
>
> Ajit
>
> On 19/11/2018 19:33, juer...@wondzinski.de wrote:
> > In which folder did you install your VFP ?
> >
>
>
>
> --- 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: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_juksbijqfnokf3hdbedvbc_4yebdu+fspbfc5zdfrgx...@mail.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: Reallocating drive space

[Fernando D. Bozzo]

Without any doubt, you shoul try SpaceSniffer, the best freeware program
I'd use to know what is eating the disks:

http://www.uderzo.it/main_products/space_sniffer/




El lun., 19 nov. 2018 a las 19:47, Stephen Russell ()
escribió:

> This utility may allow you to find the log file that is eating you your
> space?
>
> https://jam-software.com/treesize_free/
>
> Been using this for 5 years now I believe.
>
> On Mon, Nov 19, 2018 at 12:40 PM Paul Hill 
> wrote:
>
> > On Mon, 19 Nov 2018 at 18:17,
> >  wrote:
> > >
> > > See screenshot showing my C: drive near full and plenty of space on my
> > > D: drive allocation:  https://www.screencast.com/t/eaW92AgbXXF.  It's
> > > the same 512 GB SSD drive.  What's the easiest way to reallocate space,
> > > to take XX GB from D: and apply to C: drive?
> >
> > You will need to delete D and expand C.  The Disk Management tool in
> > Windows can do this.
> > Looks like there is just enough room on C to hold the contents of D.
> >
> > Do a backup first!
> >
> > --
> > Paul
> >
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_jumneed09xnyczc03yun6hzej45owmwo2melnszutml...@mail.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 methods in forms

[Fernando D. Bozzo]

You should use a SCM tool (git, etc) and convert your binaries to text


El lun., 19 nov. 2018 17:07, Ajit Abraham  escribió:

> Hello All,
>
> This is the second time I am facing this issue on Windows 10.
>
> After I compile the project to an exe, I find that entire methods of my
> forms have gone empty!.
> First time, when it happened, I "solved" this mysterious problem by
> having an exclusion entry of my vfp program folders in Windows 10's
> default Defender program.
>
> After a long time, this happened again yesterday - To my surprise -
> Defender had removed all my exclusions ! - and my methods started
> disappearing again.
> By the way - this happened after the last update couple of days back.
>
> Woes of Windows 10 !
>
>
> Ajit
>
>
>
>
>
>
>
>
> --- 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: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_Jumrn4eC-YCOHPkkQYqBVbXnZ-=ydiurgxgwyib4pjn...@mail.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: GetFile() issue

[Fernando D. Bozzo]

Hi Dave:

I think that have a simple solution for the GetFile() problem.
Try this:

oo  = CreateObject("visualfoxpro.application")
oo.DoCmd("cd 'c:\desa'")
? oo.Eval("getfile()")
oo.Release()

Works ok and do not change main VFP default dir.




El jue., 8 nov. 2018 a las 15:38, Dave Crozier ()
escribió:

> Gene,
> The problem if you are using GetFile() is that if you use the set default
> then open the dialogue and then keep the dialogue open for a few seconds,
> any background process/thread will pick up the new default location before
> you set it back after you close the dialogue.
>
> Dave Crozier
> Software Development Manager
> Flexipol Packaging Ltd.
>
> ﴾⚆ᨎ⚆﴿
>
>
>
> 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: ProfoxTech  On Behalf Of Gene
> Wirchenko
> Sent: 07 November 2018 19:13
> To: profoxt...@leafe.com
> Subject: Re: GetFile() issue
>
> At 07:08 2018-11-07, Ted Roche  wrote:
> >On Wed, Nov 7, 2018 at 5:57 AM Dave Crozier 
> wrote:
> >
> > > Unknown to me after all these years, the set default to command has
> > > an effect on the whole of the VFP thread not just the DataSession you
> are in.
> >
> >To quote my co-author, "Computer language purists object to SET
> >commands for a pretty straightforward reason: the formation of the
> >infinite-state machine. Although that sounds cool,..." (
> >https://www.tedroche.com/hackfox7/s4g126.html)
>
>   That URL was wrong in your post as it included the closing paren.
> Oddly, Eudora excluded it in this reply.
>
> >SETs often have global effects which make their local use frustrating.
>
>   I have not found it so, but one must be careful.
>
>   If I change a global setting SET (as opposed, say, to a SET ORDER),
> I either set the setting back as soon as I can or I have a procedure for
> doing the modified function requiring the different SET value.  One must be
> careful about this stuff.
>
> >Three things:
> >
> >1. If you were rewriting the app, you'd store a "Data Directory" in
> >your global settings table and precede all your file open commands with
> that.
> >That makes it INCREDIBLY easy to have a test mode that just switches
> >that setting. But you're not re-writing your app, so...
>
>   I did that for a few programs where I needed to get to a different
> set of data.  I am glad that it was only a few.
>
> [snip]
>
> Sincerely,
>
> Gene Wirchenko
>
>
[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: 

Re: GetFile() issue

[Fernando D. Bozzo]

Changing default folder temporarily is an old trick to make getfile() start
at it by default because there is no other way to do it with getfile()

Normally it's encapsulated in a method (like select_dir or similar) with
code that save actual dir, select dest dir, prompts user with getfile,
restores actual_dir and returns selected file.

All this is normally to minimize user errors selecting through directories


El jue., 8 nov. 2018 14:21, Peter Cushing 
escribió:

> Hi Dave,
>
> I never change my default folder when the app is running and for things
> like output folders or getting data I usually just get the user to
> select the folder with :
>
> cImport = GETDIR('','Select upload folder')
>
> You can then ask for every report or save this for their session and
> keep outputting to this folder.
>
> Not quite sure why you need to change the default folder?
>
> Peter
>
> On 07/11/2018 10:56, Dave Crozier wrote:
> > Hi folks,
> > Just had an issue that has been bugging me for a while and I now why but
> I haven’t got a solution to hand… so maybe you can help.
> >
> > In lots of places we allow users to export their reports and spreadsheet
> results onto their own personal “C” drives. And to do this I implement
> >
> > … default folder set in prior coding
> >
> > cOld_Folder = SYS(5) + SYS(2003)
> > set default to 
> > cFile = Getfile(……..)
> > set default to (cOld_Folder)
> >
> > This code allows the user to be programmatically placed in the suggested
> folder to save/open files.
> >
> > Unknown to me after all these years, the set default to command has an
> effect on the whole of the VFP thread not just the DataSession you are in.
> Unfortunately for me I have a number of regular timers running that check
> whether any particular file or process is locked, or the system is
> available for use i.e. it can sometimes auto log out the user  to allow
> system maintenance for example. The timers open tables and expect to be in
> the base folder of the application but issuing the above coding changes the
> base folder for ALL the application, hence throwing errors as the tables
> (all held relative to the application folder) cannot be found in the new
> location.
> >
> > So, if you action the Getfile() command and stay in the dialogue for a
> period of time during which the timers fire, then the timer coding cannot
> open it’s tables as you are no longer where it expects you to be.
> >
> > Looking at the help file ( OK, I should have looked at it years ago!!)
> it states:
> > “The SET DEFAULT command is not supported in either single or
> multithreaded DLL servers. This command changes the default directory of
> the entire process, so all threads which are part of the process are
> affected. Use the 
> mk:@MSITStore:c:\program%20files%20(x86)\microsoft%20visual%20foxpro%209\dv_foxhelp.chm::/html/047f2e74-3552-43b7-a18d-ee2c7dd2db6e.htm
> in DLL servers, in place of CD and CHDIR.”
> > The pertinent fact being: This command changes the default directory of
> the entire process, so all threads which are part of the process are
> affected. The same thing goes for CD and Chdir so using those as
> replacements is not an option unfortunately.
> >
> > Has anyone any ideas as to how to produce a dialogue for saving/opening
> a file which doesn’t require the “set default to ” instruction?
> >
> > I can modify all the timers to open tables based upon absolute paths but
> this would be a mega change which I am trying to avoid. Of course I could
> roll my own Getfile() unless anyone has one available!!!
> >
> > All suggestions accepted, thanks in anticipation.
> >
> > Dave Crozier
> > Software Development Manager
> > Flexipol Packaging Ltd.
> >
> > ﴾⚆ᨎ⚆﴿
> >
> >
> >
> > 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.
> >
> >
> 

Re: Test

[Fernando D. Bozzo]

Verified, Spam arrives correctly :-P


El jue., 8 nov. 2018 12:05, Dave Crozier  escribió:

> Test message to test our email spamfilter…. Mailsphere…. Yak!
>
> Dave Crozier
> Software Development Manager
> Flexipol Packaging Ltd.
>
> ﴾⚆ᨎ⚆﴿
>
>
>
> 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
>
>
> --- StripMime Report -- processed MIME parts ---
> multipart/related
>   multipart/alternative
> text/plain (text body -- kept)
> text/html
>   image/jpeg
>   image/jpeg
>   image/png
>   image/png
>   image/png
>   image/png
> ---
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_Ju=U+JR7M3w7iU4YoX=gxMARZ4=bmw8nwwnhc--kse4...@mail.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] Tool for editing multiple files for huge search/replace operation

[Fernando D. Bozzo]

By the way, Notepad++ have a search & replace function that works on all
files of a given mask in subdirectories, so no manual replacement in each
file is needed.


El mar., 30 oct. 2018 0:30, Fernando D. Bozzo  escribió:

> You can use Notepad++ on TX2 files, then generate de binaries with
> FoxBin2Prg.
> I used it many times :D
>
>
>
>
> El lun., 29 oct. 2018 a las 22:17, <
> mbsoftwaresoluti...@mbsoftwaresolutions.com> escribió:
>
>> Literally about 10 years ago, I'm pretty sure this list suggested a tool
>> that I used to update several text files in a common folder; it was a
>> big "replace text 123 with 456" kind of thing.  But alas, my memory is
>> failing me and I can't recall what the tool was called.
>>
>> Anybody know of such a tool to handle large search/replace across
>> several text files in a same folder or even perhaps cascading tree of
>> folders?
>>
>> tia,
>> --Mike
>>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_Ju=qJVc1V_aCREG8-GrTX+6Q2=NSDzWn=osngh0ej2g...@mail.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] Tool for editing multiple files for huge search/replace operation

[Fernando D. Bozzo]

You can use Notepad++ on TX2 files, then generate de binaries with
FoxBin2Prg.
I used it many times :D




El lun., 29 oct. 2018 a las 22:17, <
mbsoftwaresoluti...@mbsoftwaresolutions.com> escribió:

> Literally about 10 years ago, I'm pretty sure this list suggested a tool
> that I used to update several text files in a common folder; it was a
> big "replace text 123 with 456" kind of thing.  But alas, my memory is
> failing me and I can't recall what the tool was called.
>
> Anybody know of such a tool to handle large search/replace across
> several text files in a same folder or even perhaps cascading tree of
> folders?
>
> tia,
> --Mike
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_jukv-jwtooi5rwvazf6ijcaf96gn6n1+vy+dmxxjrsf...@mail.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] Broken Windows

[Fernando D. Bozzo]

Yes, it has, it's called 7za and is open source too.


El jue., 25 oct. 2018 15:27, Man-wai Chang  escribió:

> On Wed, Oct 24, 2018 at 9:46 AM Gene Wirchenko  wrote:
> >
> >
> >   I am using PKZIP version 2.04g.  At 25 years old, it may be
> > older than some of those Microsoft programmers.  It might work better,
> too.
> >
>
> 7-zip is fine! I think it has a command-line version.
>
> --
>  .~. 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: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_JukixK2W2p40FzK-h65YDvRm9gzs1ckDk-3aCw2=h9c...@mail.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: .h files included or excluded in your project?

[Fernando D. Bozzo]

No, not useful at all, except if you want to make the EXE bigger and allow
decompiling them too.

Regards,

Fernando D Bozzo


El mié., 24 oct. 2018 19:32, 
escribió:

> VFP9SP2
>
> Since .h #INCLUDE files are only utilized at build time, is there any
> reason you'd want to include the .h files in the EXE?  I'm thinking
> "no."
>
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_Jum1bV95anZ5gu+Qe-CiMAPJFF4JQ=k_a-dxrf_qf-g...@mail.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 file types in explorer

[Fernando D. Bozzo]

I second Richard's method, which did work for me in the past and is
documented in VFP help :

\vfp9.exe /regserver



El lun., 24 sept. 2018 18:12, Richard Kaye  escribió:

> Right click on a PRG or VCT, etc and use the Open with option to set the
> default program. There is also a command  line option to add the default
> registry values. (vfp9.exe /regserver)  I'm not sure if this also
> reestablishes the VFP file associations. Finally, you could try rerunning
> setup and tell it to repair.
>
> --
>
> rk
>
> -Original Message-
> From: ProfoxTech  On Behalf Of Paul Newton
> Sent: Monday, September 24, 2018 10:44 AM
> To: profoxt...@leafe.com
> Subject: VFP file types in explorer
>
> Hi all
>
> In Windows explorer, files with a VCX extension are displayed as type
> Microsoft Visual FoxPro  Class Library but VCT and PRG just display as VCT
> File and PRG File respectfully.  How can I get them to be recognised as
> types Microsoft Visual FoxPro  Class Library and Microsoft Visual FoxPro
> Program respectfully?
>
> Many thanks in advance
>
> Paul Newton
>
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_jumssb31u2gljud+zotjd159woclhqm_gzk8udwebdc...@mail.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: ON KEY usage in your apps

[Fernando D. Bozzo]

I use ON KEY LABEL just for debugging purposes, like suspending, opening
dev tools menu or admin maintenance, dumping memory variables to disk and
the like.


El mié., 19 sept. 2018 10:51, Alan Bourke 
escribió:

> We use ON KEY LABEL F1 for throwing up the application help file. Aside
> from that we almost exclusively use form KeyPreview() methods I think.
>
> --
>   Alan Bourke
>   alanpbourke (at) fastmail (dot) fm
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_jukrbwwfysyvyrj4wl2v7mdnzbkf2q6n96bua4ms2hb...@mail.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: 2 Excel questions using automation from VFP9SP2

[Fernando D. Bozzo]

Hi:

About (1), y thinq you could use the same value that makes Word quit
without saving, which is *Quit(0)* (can't find any doc about Quit)

Another option is closing de document without saving using *Close(0)*
method then quitting.
https://docs.microsoft.com/en-gb/visualstudio/vsto/how-to-programmatically-close-documents?view=vs-2017

Hope it helps.

Fernando D. Bozzo



2018-09-05 22:47 GMT+02:00 :

> See screenshot for case matter:  https://www.screencast.com/t/VNdRiSd1D
>
> 1) (rose highlight) I've forgotten how to get Excel to close without
> asking me this every time.  Currently, I'm just calling the .Quit() method
> of my Excel object.  I tried passing a .T. parm but that failed.
>
> 2) (yellow highlight) Anybody know how to get this slick NETWORKDAYS
> formula to work in VFP?  Would be neat to have this and I thought perhaps
> someone already built it.
>
> tia,
> --Mike
>
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_jumopzvcsbs_j09kc2aqpu5tarxanhicjng5ge7mpza...@mail.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: Test One-Two, *tink* *tink* is this thing on?

[Fernando D. Bozzo]

Test Received.-


2018-08-31 15:40 GMT+02:00 Ted Roche :

> Just checking to see if the Internet has unsubscribed us all, again.
>
> Happy Labor Day to my US friends and first-day of school to northern
> hemisphere types.
>
>
>
> --
> Ted Roche
> Ted Roche & Associates, LLC
> http://www.tedroche.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: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_jundgmvooyhjkyarvlpkvjgp7urd9daw_c6c96dafdv...@mail.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] Recommendations for online PHP course?

[Fernando D. Bozzo]

Hi:

You can find many in this course search engine:

https://coorsy.com/

Regards

El mié., 8 ago. 2018 4:35, Vince Teachout  escribió:

> Would anyone have recommendations for online PHP courses.
>
> A client is willing to pay for it for me to start to do some PHP for for
> them, and I tend to learn more quickly with a structured lesson plan.
> Thanks.
>
>
> ---
> 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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_Ju=xelfw7nhbasym3wq6kjjw7arfqt4-pjhc5j1g_eo...@mail.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: ReFox Experience

[Fernando D. Bozzo]

I'm with TED on this one.

One extra problem trying to decompile the EXE --iin the best case-- is that
you always loose the .H files, the formatting and the comments, that
sometimes are the ONLY documentation for the system.
...if they didn't use Control Source Software, then probably do not have
any docs either, so the code comments can be important too.

Regards.-



2018-08-03 19:29 GMT+02:00 Philip Borkholder :

> Hi folks,
>
> I'm in a difficult situation. I have a new customer who has a VFP app that
> she designed and owns. She then has customers where this was installed.
> Her previous programmer had provided her with "source code" so she thought
> it would be no problem hiring me to take over since the previous developer
> no longer has time to commit to the ongoing development of this software.
>
> I reviewed the "source code" she had to start quote her how much newer
> changes might cost.
> In my review of the software, I noticed it is missing:
> 1) VFP Project Files
> 2) Menu files (Mnx,Mnt). mpx is there.
> 3) Some graphic files used.
> 4) Who knows how many other files are missing? Without the original
> Project Files, I can't tell what else was used in the project.
>
> When she asked her previous programmer for these missing files, she was
> told they are probably on an old server that he would have to restart and
> try to retrieve files from it. He said it would probably be easier just
> having the new developer (me) decompile the EXE to get the source code.
>
> Question for you: Does ReFox uncompile an EXE into the actual MNX/MNT and
> Project Files? I'm thinking no. Probably just the MPR, VCX/T, PRG, etc.
> Also, I remember from long ago that ReFox would not de-compile any
> programming notes from the previous PRGs etc.
>
> My thought is the previous developer should've provided this to my client
> since she designed and owns the software.
> And now, since it is not all there, he should provide it to her. Instead,
> he wants to charge a hefty bill to start up his old server to retrieve what
> might be on there and no guarantee that it will all be there.
>
> Thanks for any thoughts,
>
> Philip B
> Vicksburg, MI
> 
> Melissa McCarthy Confirms Unfortunate News
> track.volutrk.com
> http://thirdpartyoffers.netzero.net/TGL3241/5b6490fa2747f10ef4a37st02duc
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_juna+g-wrrbuayef5ddbh8nth7g7qumtgmizxv_50i7...@mail.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: Determining Text File Encoding

[Fernando D. Bozzo]

AFAIK there is no way to determine the exact encoding of the files. You can
do a "best effort" algorithm to try identifying it, but even Notepad++
sometimes fails to show the correct encoding.

That's why XML, HTML and some other metalanguages use the
[encoding="utf-8"] or [charset="utf-8"] or similar, because this must be
explicitly indicated for not misunderstanding the contents.

In similar way, when delivering text files to someone, an encoding must be
explicitly defined and agreed between the parts to not misinterpret the
contents.

UTF-16 is a little strange for me and never did deal with it, isn't used
for double byte characters, like chinese or similar?

One idea that comes to me is that you can ask for a header indicating the
encoding (like XML does), or even ask for a predefined string (always the
same, like "Test header - áàä") [with some special chars] which you can
compare to your own. If the comparison of the source string in UTF-16 does
not match your string in UTF-16, then you can assume it's UTF-8, or
re-check comparing with the same string in UTF-8


Regards.-


2018-08-01 20:00 GMT+02:00 Paul H. Tarver :

> Ok, this may be a dumb question, but is there a reliable and easy way to
> detect and determine the file encoding on simple text files?
>
>
>
> I have a client sending me files with UTF-16 Little Endian encoding. I have
> some code in place to try to determine if a file is UNICODE based on the
> first two or four characters once the file is loaded to memory and then
> convert it using STRCONV, but I'm concerned that although it works, it is a
> bit of a hack and maybe there is a better way.
>
>
>
> Any thoughts?
>
>
>
> Paul
>
>
>
>
>
> --- 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: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_jumyhtcqqpjmb-jpmcxrfwlg-txdkds5jcdx050lfc0...@mail.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: Every day a school day.

[Fernando D. Bozzo]

Yes, FOR..EACH is normally used with collections, that's whay the addition
of the "FOXOBJECT" keyword, to treat them different than COM objects (which
are the default expected objects for FOR..EACH)




2018-07-31 6:57 GMT+02:00 :

> On 2018-07-27 04:43, Alan Bourke wrote:
>
>> No matter how long you've been hacking VFP and how good you think you
>> are, there's always something you didn't realise.
>> Such as the fact that FOR ... EACH works with arrays.
>>
>
>
> I pretty much only use it with arrays.  What else would you use it for???
> Collections I guess?
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_jumne6qlpezi_uit+mryrgq75+ckj-fkdt2-ia5qtok...@mail.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: Bounces

[Fernando D. Bozzo]

Me too, today, but didn't say anything because I though was only me...

It is not the first time I need to confirm I want to keep in the list.


El lun., 9 jul. 2018 16:24, Garrett Fitzgerald 
escribió:

> Anybody else getting too-many-bounces warnings from the list today, or is
> it just me?
>
>
> --- 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: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_junarb--scanvg2fuwaqf6d2hcr4usxq+0m-2ardhvn...@mail.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: Coverage profiler (DISREGARD...I FOUND IT -- MAXCOV.APP) (ED -- PROBLEM WITH FILE UPLOAD TO PROFOX DOWNLOADS PAGE)

[Fernando D. Bozzo]

Hi,

Here is the link for CVP.EXE, it's an excellent tool I'd use many times:

http://gorila.netlab.cz/cvp.html

Regards.-



2018-07-05 17:08 GMT+02:00 :

> I found Markus' add-in in an old dev folder.  It's called MaxCov.app.  I
> tried uploading it to the ProFox downloads site but got the following error:
>
> 400 Bad Request
> The server could not comply with the request since it is either malformed
> or otherwise incorrect.
>
> No file specified
>
>
> I selected the file via the button so I know it's there.
>
> Ed -- problem behind the scenes with the file uploader???
>
> --Mike
>
>
> On 2018-07-05 10:49, Frank Cazabon wrote:
>
>> The only thing I can think of is CVP. I have version 1.19.18 and it
>> was written by Martina Jindrová. Can't remember where I downloaded it
>> from but maybe Level extreme (formerly Universal Thread) or Foxite.
>>
>> Frank.
>>
>> Frank Cazabon
>>
>> On 05/07/2018 10:24 AM, mbsoftwaresoluti...@mbsoftwaresolutions.com
>> wrote:
>>
>>> VFP9SP2 on Win7Pro PC
>>>
>>> I want to see how long it's taking some code to run.  Beyond
>>> self-created start/stop variables, I thought "why not use the coverage
>>> profiler?"  MANY years ago, I recall there was some sort of alternative
>>> cool tool to the native Coverage Profiler but I can't recall the
>>> specifics.  Markus Egger comes to mind.  I did a search of the ProFox
>>> archives for "coverage profile" but found nothing across the entire archive
>>> (https://www.screencast.com/t/FF8gEjeK5DeP).  I found this in the
>>> ProFox downloads area but I haven't used that before (yet):
>>> http://leafe.com/download/cvp_1.18._9_20090211.zip.  I found this
>>> link when searching for Markus Egger Coverage Profiler (
>>> http://www.scrigroup.com/calculatoare/tutorials/434/The-
>>> Coverage-Profiler33512.php) but the reference at the end to
>>> http://www.eps-software.com/ is a fruitless end as I can't seem to
>>> search that site; it just asks you which CoDE site you want to visit.
>>>
>>> Do any of you have Markus' old CP Analyzer tool or what's your
>>> recommendation for analyzing code performance in your VFP code?
>>>
>>> tia,
>>> --Mike
>>>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_Ju=B=Fhku3a5C0Q=uoemajmtqxblv8inuneg4udrzhi...@mail.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: VFP9 and Blat

[Fernando D. Bozzo]

Hi,

I see 2 things:


1) Macrosubstitution is not needed: (not an error, but error prone
sometimes)

DECLARE INTEGER Send in _name STRING blatstring
could be:
DECLARE INTEGER Send in (dll_name) STRING blatstring


2) Bad capitalization of the function:

lnresult = send(lcstring)
should be:
lnresult = Send(lcstring)

The capitalization of "Send" (and any DLL function) should be keept in all
the code.
At least this is a problem with many Win32 API functions, and I apply it
for any DLL function.


Other than this:
- Could be a permissions problem in the server
- ¿Some dependant C++ runtime?


Regards,

Fernando D. Bozzo.-




2018-06-28 19:31 GMT+02:00 Desmond Lloyd :

> Good Morning all,
>
> Have been using Blat here at work for years.   Essentially modifying the
> code as the need arose.  now have a client that I would like to use it on,
> but for some reason it always returns a code 1 in the new environment but
> works fine here at work...
>
> Would someone please look at the sample below to see what I might be
> missing?
>
> LPARAMETERS lcsubject, lcbody, lcrecipient, lcfrom, lccopyto
>
> lcFrom = 'dll...@wow.com'
>
> *lcfrom = 'dll...@test.com'
>
> lcSubject = 'Email Test'
>
> set Safety off
>
> lcBody = 'This is a Test of an automated email system. Third Test. Would
> you Please reply if received'+ CHR(13) + CHR(10) + CHR(13) + CHR(10)
>
> lcRecipient = 'desmond.ll...@gmail.com'
>
> STRTOFILE(lcbody, "Body.txt")
>
> lcstring = 'C:\Body.txt -s "' + lcsubject + '" -to ' + lcrecipient + ' -f '
> + lcfrom + ' -u '+'dlloyd'+' -pw '+'password'+ ' -server
> '+'192.168.999..62'
>
> dll_name = "blat.dll"
>
> DECLARE INTEGER Send in _name STRING blatstring
>
> lnresult = send(lcstring)
>
> IF lnresult > 0
>
> wait window 'Result: '+alltrim(str(lnREsult))
>
> ENDIF
>
>
> --- 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: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_junme4aptlw5-0n_j0yz8cnzjd6h-_g6xhecrlu3h_n...@mail.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: Nothing like a cryptic error to start the work week!

[Fernando D. Bozzo]

You may convert frmEditJob.scx to text with FoxBin2Prg and search there.

Because the error says "ALIAS IS NO FOUND" you should look closely at all
data statements, like "SELECT " or "." and macros/vars
too, in the case you don't use real Alias names and use substituted alias
names.

By the picture one can infere that you don't have an error procedure. In
this case, even a basic error handling like this may help:

ON ERROR MESSAGEBOX(TEXTMERGE("Error <>,
<>"+CHR(13)+"Proc.<>, line <>"))

It's better than the VFP default error handler.




2018-06-25 17:05 GMT+02:00 :

> On 2018-06-25 10:58, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
>
>> VFP9SP2, Win7Pro, MySQL backend
>> Screenshot:  https://www.screencast.com/t/QKA2etzLnW
>>
>> I've searched frmEditJob.scx in the Code References for any text of
>> IMG and it found nothing.  Ugh.  Now how to track down this new
>> mystery?
>>
>
>
>
> Ooops...wrong screenshot!  Here's the right one:
> https://www.screencast.com/t/qdzgy9RnGF
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_Ju=wskg_sbd7nlpy0n7ps3hsxigaqdbhvg6ceo8z069...@mail.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: VFP9, SqlServer and NULL values

[Fernando D. Bozzo]

Very nice! Adapter Pattern to the rescue :D



2018-06-14 18:50 GMT+02:00 Stephen Russell :

> I don't ever remember writing code like this in FP/VFP:
> myDate = createObject("Date")
>
> That is great that you can, and I bet it would have been easier to pass a
> date to another language in a function.
>
>
> On Thu, Jun 14, 2018 at 10:05 AM Eric Selje  wrote:
>
> > /Too bad/ Hey, that's *exactly* what the DateTime static variable type in
> > FoxTypes  is all about.
> >
> > myDate = createObject("Date")
> > myDate.value = date()
> > ? myDate.ToString()  && 06/14/2018
> > ? myDate.ToString('F')  && June 14, 2018 00:00:00 AM
> > ? myDate.ToString('D')  && Thursday, June 14, 2018
> > (etc etc etc)
> >
> > Eric
> >
>


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_Juk=3kthfkcg+keo6waztuofbcyfmg043ozacp7aroy...@mail.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] Best Practices for collaborative sharing of information

[Fernando D. Bozzo]

I think that a CMS could be an option



El mar., 29 may. 2018 18:22, 
escribió:

> The Corporate gig has tasked me with looking into a way for several
> similar organizations to communicate and share with each other things
> are the related to the success of all of them; a collaborative sharing
> of ideas, best practices, information, etc. to help the (healthcare)
> product as a whole.
>
> I have advised against a listserve as I don't feel that's friendly
> enough for sharing materials/files/stories.  I'm believing a forum would
> be best.
>
> Would appreciate your thoughts.
>
> Thanks,
> --Mike
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_jumyrqegg_v-wjszlc_bha+tkmktpw73ycz8e1vencd...@mail.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 10 April 2018 Update & Running EXE from Shared drive (Samba)

[Fernando D. Bozzo]

I don't know if you can find something here :

https://technet.microsoft.com/en-us/security/bulletins.aspx



El jue., 10 may. 2018 7:22, Mike <m...@ggisoft.com> escribió:

> Fernando,
>
> Would love to.
>
> Where to start?
>
> Mike
>
>
> Fernando D. Bozzo wrote:
> > Hi Mike:
> >
> > If you suspect that the problem could be because of a new restriction
> > policy, you may try to find the full description of what did include this
> > update.
> >
> >
> > El jue., 10 may. 2018 5:33, Mike <m...@ggisoft.com> escribió:
> >
> >> Thanks, Gianni. That's a dead-on exact match for what I've run into.
> >>
> >> But, the TechNet article you referenced seems to point the finger at
> >> SMBv1, or higher not being available.
> >>
> >> While this might be the case, it's obvious that Windows 10 1803 is now
> >> applying additional restrictions when the EXE is launched from a shared
> >> drive instead of local. My EXE connects to MariaDB perfectly if the same
> >> EXE connects to the same server, when started from the local drive.
> >>
> >> While this might be something in the network stack, low-level, it makes
> >> more sense (to me) that it would be a difference in the firewall (tried
> >> disabling it) or security policy settings. I've looked through the local
> >> security policy options (I'm NOT on a domain!) and nothing seems to
> apply.
> >>
> >> The 'answer' in the Technet Forum discussion you sent seems to be to
> >> move the EXE file to a different server (Win Serv 2012 instead of 2008)
> >> but I don't have Windows Server anything...I'm 100% Linux (Samba)
> servers.
> >>
> >> Microsoft, love to hate them.
> >>
> >> Mike
> >>
> >> Gianni Turri wrote:
> >>> Someone on the Italian TechNet Forum had a similar problem but with SQL
> >> server.
> >>> May be you can find something useful in the discussion.
> >>>
> >>> Problemi connessione SQL dopo l'aggiornamento di Aprile 2018
> >>>
> >>
> https://social.technet.microsoft.com/Forums/it-IT/38a6727a-7dce-48ef-8c3e-a69e7847c9b8/
> >>> Gianni
> >>>
> >>> On Wed, 9 May 2018 17:35:52 -0500, Mike <m...@ggisoft.com> wrote:
> >>>
> >>> Have already tried that. No change.
> >>>
> >>> To be more precise...it's not that the EXE won't run, it's that the EXE
> >>> can't connect to my Maria DB server.
> >>>
> >>> BUT!
> >>> Since the same application CAN connect to Maria DB if the EXE is run
> >>> locally, this appears to be a security policy issue.
> >>> I am NOT on a Domain!
> >>>
> >>> Still troubleshooting...
> >>>
> >>> Thanks Gianni!
> >>>
> >>> Mike C
> >>>
> >>>
> >>> Gianni Turri wrote:
> >>>> Try enabling "SMB 1.0/CIFS File Sharing Support" in "Windows
> features".
> >>>>
> >>>> Gianni
> >>>>
> >>>> On Wed, 9 May 2018 16:23:49 -0500, Mike <m...@ggisoft.com> wrote:
> >>>>
> >>>> Heads up...
> >>>>
> >>>> After updating to Win 10 Pro 17134 (last night) apps that are stored
> on
> >> a network share (Samba server) will no longer run. Move the EXE file to
> a
> >> local drive and it works fine.
> >>>> Have already disabled firewall, no effect.
> >>>> Have moved all resource (DLL and FLL, OCX, APP) files to a local
> >> folder, no help.
> >>>> Move EXE file to a local folder, runs fine.
> >>>>
> >>>> Same application has run for years as a share, even over a VPN link.
> >>>>
> >>>> Mike Copeland
> >>>>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_JukEJvFgrPHRubiZ89Tfy0=s7gjzmqytcitbnqmei-h...@mail.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 10 April 2018 Update & Running EXE from Shared drive (Samba)

[Fernando D. Bozzo]

Hi Mike:

If you suspect that the problem could be because of a new restriction
policy, you may try to find the full description of what did include this
update.


El jue., 10 may. 2018 5:33, Mike  escribió:

> Thanks, Gianni. That's a dead-on exact match for what I've run into.
>
> But, the TechNet article you referenced seems to point the finger at
> SMBv1, or higher not being available.
>
> While this might be the case, it's obvious that Windows 10 1803 is now
> applying additional restrictions when the EXE is launched from a shared
> drive instead of local. My EXE connects to MariaDB perfectly if the same
> EXE connects to the same server, when started from the local drive.
>
> While this might be something in the network stack, low-level, it makes
> more sense (to me) that it would be a difference in the firewall (tried
> disabling it) or security policy settings. I've looked through the local
> security policy options (I'm NOT on a domain!) and nothing seems to apply.
>
> The 'answer' in the Technet Forum discussion you sent seems to be to
> move the EXE file to a different server (Win Serv 2012 instead of 2008)
> but I don't have Windows Server anything...I'm 100% Linux (Samba) servers.
>
> Microsoft, love to hate them.
>
> Mike
>
> Gianni Turri wrote:
> > Someone on the Italian TechNet Forum had a similar problem but with SQL
> server.
> >
> > May be you can find something useful in the discussion.
> >
> > Problemi connessione SQL dopo l'aggiornamento di Aprile 2018
> >
> https://social.technet.microsoft.com/Forums/it-IT/38a6727a-7dce-48ef-8c3e-a69e7847c9b8/
> >
> > Gianni
> >
> > On Wed, 9 May 2018 17:35:52 -0500, Mike  wrote:
> >
> > Have already tried that. No change.
> >
> > To be more precise...it's not that the EXE won't run, it's that the EXE
> > can't connect to my Maria DB server.
> >
> > BUT!
> > Since the same application CAN connect to Maria DB if the EXE is run
> > locally, this appears to be a security policy issue.
> > I am NOT on a Domain!
> >
> > Still troubleshooting...
> >
> > Thanks Gianni!
> >
> > Mike C
> >
> >
> > Gianni Turri wrote:
> >> Try enabling "SMB 1.0/CIFS File Sharing Support" in "Windows features".
> >>
> >> Gianni
> >>
> >> On Wed, 9 May 2018 16:23:49 -0500, Mike  wrote:
> >>
> >> Heads up...
> >>
> >> After updating to Win 10 Pro 17134 (last night) apps that are stored on
> a network share (Samba server) will no longer run. Move the EXE file to a
> local drive and it works fine.
> >>
> >> Have already disabled firewall, no effect.
> >> Have moved all resource (DLL and FLL, OCX, APP) files to a local
> folder, no help.
> >> Move EXE file to a local folder, runs fine.
> >>
> >> Same application has run for years as a share, even over a VPN link.
> >>
> >> Mike Copeland
> >>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_Ju=dawluvcswtxv8+qczsdaw6sdckbcjm94jwwzz40k...@mail.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: Resetting VFP

[Fernando D. Bozzo]

Depending on the kind of hang, killing VFP with task manager should
suffice, but if in the process of hanging you add a bad programming
practices, bad or no garbage collection, bad use of PC resources and
intermitent hangings that can corrupt RAM, then power off/on is the final
solution.

We have a legacy application on Production, with +20 years of bad
modifications that slowly consumes Server resources and do not restore
them, even if restarting the app, so every week we need to reset de Server
:-(



2018-04-27 19:21 GMT+02:00 Gene Wirchenko :

> Hello:
>
>  Sometimes, the coding is a breeze, and sometimes, it is not.
>
>  Suppose, because of bugs, incomplete functionality, etc., you have
> just hung up VFP.
>
>  Is there a way to reset VFP?  Something that always works?
>
>  I know I can abort it and then restart it, but I have had to do so
> dozens of times.  The thrill palls.
>
> Sincerely,
>
> Gene Wirchenko
>
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_Jum6n1fpgq7OKoBD2QWV35J79a3m=pdvolawmvhf_qi...@mail.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: Grids, Again

[Fernando D. Bozzo]

Hi Gene:

Those events do not occur after RowColChange because you can use
RowColChange as a general validation event that works for existent objects
and for dynamically added one.

Think of it as the KeyPress of the form, that prevail to the objects


El vie., 20 abr. 2018 4:40, Gene Wirchenko  escribió:

> Hello:
>
>   I now have the time to dig into grids again.  I hope this lasts
> long enough for some real results.  I took a look yesterday at "1001
> Things ...", chapter 6 (Grids: The Misunderstood Controls).  The
> number of gotchas is quite high.
>
>   I find one particular thing especially weird.  Why, oh why,
> does BeforeRowColChange fire before the active cell's Valid and LostFocus
> fire?
>
>   To me, it seems obvious that the most likely reason why one
> would deny a row-col change is because the active cell's validation
> failed.  I will go further: why else would one deny a row-col change?
>
>
>   My previous approach has gotten horribly baroque and still was
> not enough.
>
>   There are nasty things happening such as 1) the current
> control's value not being assigned until after the
> BeforeRowColChange, 2) the validation using the previous value when I
> try to correct after some errors (but not always) but only for the
> first time, and it goes on.
>
>   Correct one problem, and something else breaks.
>
>
>   I am wondering if anyone would be willing to write a simple
> example of a grid IN CODE to a spec I provide.  This is the example
> that I am trying to implement.  Maybe, I am overlooking something
> crucial.  I sure have not seen any examples of grids other than trivial.
>
> Sincerely,
>
> Gene Wirchenko
>
>
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_JumKsh2ZcMT=KKzd=hweqvog+ylwz8hoqmjy6evjzyj...@mail.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: INSERT INTO...SELECT Issue

[Fernando D. Bozzo]

2018-04-19 21:15 GMT+02:00 Paul H. Tarver :

> Ted:
>
> > No, I think you've found one of those genuine "BUGS" in Visual FoxPro,
> > rare as hen's teeth.
>
> It's one of the only ones I've ever encountered!
>
>
I've found other bugs, in example: the collection object support ordering,
but doesn't work if you use the FOXOBJECT keyword :-(


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_junpfqseqafytyszeovxs3dkdt3c9n6swzhyxhb-pif...@mail.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: INSERT INTO...SELECT Issue

[Fernando D. Bozzo]

Hi Paul:

The problem is that Visual FoxPro explicitly says in documentation that
field names must start with a letter or underscore, so if in some rare
situation VFP respects a field name starting with a number it's really a
bug, and that's why this do not work allways.

Here is the spec on VFP name creation:
https://docs.microsoft.com/en-us/previous-versions/visualstudio/foxpro/d7aa568a(v%3dvs.71)



El jue., 19 abr. 2018 17:45, Paul H. Tarver  escribió:

> I posted a full detailed description of the process and all the testing
> I've done so far in this thread:
>
> https://leafe.com/archives/msg/510840
>
> Paul
>
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Peter
> Cushing
> Sent: Thursday, April 19, 2018 8:53 AM
> To: profoxt...@leafe.com
> Subject: Re: INSERT INTO...SELECT Issue
>
> On 19/04/2018 14:38, Paul H. Tarver wrote:
> > 
> >
> >
> > My question is this: Has anyone here run into this issue and if so, Is
> there
> > any another way or procedure around this situation that would allow me to
> > manually fix the fieldnames which start with a number assuming I have no
> way
> > to change the source data.
> >
> Not run into that issue but just want to check what actually happens, as
> not quite sure from your description.
> The client gives you a spreadsheet file.  Are you then appending that
> into a cursor and trying to select from the cursor into some other table?
>
> Peter
>
> ,"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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_juky6x4p2ohnq6++yyj6xqsxka-gn6mqpktg4me5kf3...@mail.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: "Cannot load 32-bit DDL wwipstuff.dll"

[Fernando D. Bozzo]

C++ runtime (msvcrtxx) or other dll dependency

May be this can help:
https://support.west-wind.com/Thread4T60C0F5O.wwt


El mié., 18 abr. 2018 18:51, Ted Roche  escribió:

> Someone in the office hit this today.
>
> Win10, 674-bit fully updated.
>
> This project has been running fine.
>
> The project crashed this morning and had to be rebuilt and only now
> does the above error show up.
>
> What's the most likely thing you'd check?
>
> The DLL's in the path.
>
> --
> Ted Roche
> Ted Roche & Associates, LLC
> http://www.tedroche.com
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_Jukj_xnXOUSJnqRknU9D+=aRvFoZ9FTSEE=hox+yg4g...@mail.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] Microsoft’s Next OS is Based on Linux, Not Windows

[Fernando D. Bozzo]

I agree, they have enough software for getting lots of money with licenses
(visual studio, office, etc) to be worried about the OS.

But if happens, will no be after 5 or 10 years


El mié., 18 abr. 2018 12:53, Alan Bourke  escribió:

> I could see them doing a Chromebook-style affair with Office 365
> subscription , using the browser based versions of Word et al.
>
> Perhaps with the capability of running the Microsoft Store and UWP apps.
>
> --
>   Alan Bourke
>   alanpbourke (at) fastmail (dot) fm
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_juncdktzf5qni-kopnltxnxdt6pg7v+wu9t2j2jmixt...@mail.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: VFP9 - Save as XLSX

[Fernando D. Bozzo]

In Business Assurance, with 1000's of licences and CIOs looking for cutting
costs down, I can assure you that I know some people that do not have
Excel, and of course Excel is not installed on all +300 servers.



2018-04-16 20:33 GMT+02:00 Stephen Russell <srussell...@gmail.com>:

> In busienss consulting, I cannot remember ANYONE that didn't have excel
> installed.  It is a no brainer expecting it in that this is a desktop
> environment and not a server based web farm.
>
> On Mon, Apr 16, 2018 at 11:50 AM, Fernando D. Bozzo <fdbo...@gmail.com>
> wrote:
>
> > The adventage of Vilhelm's method is that he manipulates the XLSX file
> > without Excel (at least for reading, didn't test with writing)
> >
> > Not needing Excel is really a Plus, because you need an Excel license in
> > each machine that you need to use it, even if you only need an unattended
> > server for automated conversion tasks.
> >
> >
> >
> > 2018-04-16 18:46 GMT+02:00 Stephen Russell <srussell...@gmail.com>:
> >
> > > Or learn how to manipulate Excel as a com object and have Excel bring
> in
> > > the data for you into the modern sheet format.
> > >
> > > A for loop within a for loop to get rows and columns.
> > >
> > > On Mon, Apr 16, 2018 at 11:32 AM, Peter Cushing <
> > > pcush...@whisperingsmith.com> wrote:
> > >
> > > > On 16/04/2018 17:17, Desmond Lloyd wrote:
> > > >
> > > >> Good Morning,
> > > >>
> > > >> Need to be able to copy the contents of a cursor to an Excel file,
> > but
> > > it
> > > >> needs to be in the xlsx.
> > > >>
> > > >> Am a newbie to Excel Automation and have read that you can saveas,
> > and
> > > it
> > > >> will save in the latest format.  Well mine doesn't.
> oworkbook.version
> > > >> shows 16. (we are running Office 365)
> > > >>
> > > >> Tried the SweetPotato method but it errors out.   Not sure why.
> > > >>
> > > >> Would someone be kind enough to point me in the right direction,
> with
> > > >> some
> > > >> possible examples...
> > > >>
> > > >> You can copy the contents of the cursor out to .xls only using the
> > > > standard COPY TO ... TYPE XL5
> > > > Then you can use automation to create an .XLSX file.   I'm using
> office
> > > > 365 but I am on version 15 so slightly older so you should be able to
> > > > create an .XLSX file with your version.
> > > >
> > > > #include include\excel.h
> > > > TRUE=.T.
> > > > FALSE=.F.
> > > > oExcel = CREATEOBJECT('excel.application')
> > > > oExcel.Workbooks.Open(myfile)
> > > > cOutfile2 = 'myfilev2.xlsx'
> > > > objexcel.ActiveWorkbook.SaveAs(cOutfile2, xlOpenXMLWorkbook)
> > > >
> > > >
> > > > In excel.h xlOpenXMLWorkbook is 51
> > > >
> > > > HTH,
> > > >
> > > > Peter
> > > >
> > > >
> > > > ,"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,
> > > > <https://maps.google.com/?q=h+Ltd+Head+Office:61+Great+
> > > Ducie+Street,=gmail=g>
> > > > 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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_jumkcnijvyzpwg01vymb6fn0zamfjdhcm0nalxzoywe...@mail.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: VFP9 - Save as XLSX

[Fernando D. Bozzo]

The adventage of Vilhelm's method is that he manipulates the XLSX file
without Excel (at least for reading, didn't test with writing)

Not needing Excel is really a Plus, because you need an Excel license in
each machine that you need to use it, even if you only need an unattended
server for automated conversion tasks.



2018-04-16 18:46 GMT+02:00 Stephen Russell :

> Or learn how to manipulate Excel as a com object and have Excel bring in
> the data for you into the modern sheet format.
>
> A for loop within a for loop to get rows and columns.
>
> On Mon, Apr 16, 2018 at 11:32 AM, Peter Cushing <
> pcush...@whisperingsmith.com> wrote:
>
> > On 16/04/2018 17:17, Desmond Lloyd wrote:
> >
> >> Good Morning,
> >>
> >> Need to be able to copy the contents of a cursor to an Excel file,  but
> it
> >> needs to be in the xlsx.
> >>
> >> Am a newbie to Excel Automation and have read that you can saveas,  and
> it
> >> will save in the latest format.  Well mine doesn't.  oworkbook.version
> >> shows 16. (we are running Office 365)
> >>
> >> Tried the SweetPotato method but it errors out.   Not sure why.
> >>
> >> Would someone be kind enough to point me in the right direction,  with
> >> some
> >> possible examples...
> >>
> >> You can copy the contents of the cursor out to .xls only using the
> > standard COPY TO ... TYPE XL5
> > Then you can use automation to create an .XLSX file.   I'm using office
> > 365 but I am on version 15 so slightly older so you should be able to
> > create an .XLSX file with your version.
> >
> > #include include\excel.h
> > TRUE=.T.
> > FALSE=.F.
> > oExcel = CREATEOBJECT('excel.application')
> > oExcel.Workbooks.Open(myfile)
> > cOutfile2 = 'myfilev2.xlsx'
> > objexcel.ActiveWorkbook.SaveAs(cOutfile2, xlOpenXMLWorkbook)
> >
> >
> > In excel.h xlOpenXMLWorkbook is 51
> >
> > HTH,
> >
> > Peter
> >
> >
> > ,"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,
> >  Ducie+Street,=gmail=g>
> > 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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_jumd4tc4xgzqgumuj+xfwh3ke8chu4tzjg6pvkte1xi...@mail.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: VFP9 - Save as XLSX

[Fernando D. Bozzo]

Hi Desmond:

In Vilhelm's Blog there are some Excel import/export functions:

http://praisachion.blogspot.com.es/

Regards.-



2018-04-16 18:17 GMT+02:00 Desmond Lloyd :

> Good Morning,
>
> Need to be able to copy the contents of a cursor to an Excel file,  but it
> needs to be in the xlsx.
>
> Am a newbie to Excel Automation and have read that you can saveas,  and it
> will save in the latest format.  Well mine doesn't.  oworkbook.version
> shows 16. (we are running Office 365)
>
> Tried the SweetPotato method but it errors out.   Not sure why.
>
> Would someone be kind enough to point me in the right direction,  with some
> possible examples...
>
> TIA,
> 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: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_Jums5wHcKXz5q+_Whc6dkeJbTiVO5WJuwtO=gfnykoe...@mail.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: Appending from a Cursor

[Fernando D. Bozzo]

... and one more thing to add to what Richard said about APPEND FROM:

When APPEND FROM was created, in dBase/CPM times (1979), SQL syntax did not
exist, so did not get implemented in any language, at least until 1986, far
later than dBase.



El jue., 12 abr. 2018 4:16, Richard Kaye  escribió:

> APPEND FROM is xBase. As others mentioned, it wants the physical file and
> a cursor is a temp file buried in your temp directory using sys(2015) to
> create the file name. The SQL SELECT doesn't care about the location of the
> physical file since you already have it open.
>
> --
>
> rk
>
> -Original Message-
> From: ProfoxTech  On Behalf Of Gene
> Wirchenko
> Sent: Wednesday, April 11, 2018 8:32 PM
> To: profoxt...@leafe.com
> Subject: RE: Appending from a Cursor
>
> At 11:10 2018-04-11, "John Weller"  wrote:
> >You could try
> >
> >APPEND FROM DBF(alimport)
>
>[whack object="hand" target="forehead"]  I have used it in the
> past, just not very often.  When I checked my code, I searched for
> "append from (" instead of just "append from".  Sometimes, 90% of the
> battle is knowing what to look for.
>
>   I ended up using
> 
> insert into (this.thiscode+"_cwkt") select * from (alimport)
> 
>
>   I am puzzled why (alimport) works for the SQL but not the
> append from, but whatever.
>
> [snip]
>
> Sincerely,
>
> Gene Wirchenko
>
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_jukg5lx4n6bp_t8gqlywfrvu7j3xgip_jvdq7g-sepf...@mail.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: .tmp Is Read-Only

[Fernando D. Bozzo]

Just to complete a little more what I wrote:

For Development I use a directory structure like this

\root-app-dir => Directory from where I run the code and the EXE,
and when MAIN.PRG is
 \config  => contains the config.fpw included on the EXE/APP
 \classes
 \progs   => All PRGs EXCEPT main one, that is on root app dir
 \DATA=> DBFs, CDXs, etc (AV excluded DIR)

On Production, the directory structure is a subset:

\root-app-dir => EXE
 \DATA=> DBFs, CDXs, etc (AV excluded DIR)




2018-04-09 19:19 GMT+02:00 Fernando D. Bozzo <fdbo...@gmail.com>:

> Hi Paul,
>
> 1. Occurred to me, and I think that *could* have something to do with
> Windows Folder Virtualization
>
> 2. When Windows can't write to your CFG dirs, then automatically select
> the TEMP
>
> In my experience with this "strange" errors, I've fixed them creating a
> subdirectory by user behind a public one --well ahead of Windows own dirs--
> with all the permissions necessary (ie: "C:\APPNAME\DATA\USERX")
>
> I have 2 solutions for this up to now, and in both of them Windows can't
> interfere in any way, and you just want to configure de AV software to
> ignore it:
>
>
> 1) When the PC is not shared between users:
>
> This is the most simple case, and all you need is to create a DATA
> directory (ie: "C:\APPNAME\DATA") and a CONFIG.FPW with this directory for
> all config items
>
>
> 2) When the PC (Server) is shared among users:
>
> This is a little tricky, but with you can asure that user TMP files are
> well separated, and requires a "launcher" file (can be a VFP or a VBS
> script one) that before starts the VFP APP/EXE, creates a "personal" CFG
> file for each user (ie: "C:\APPNAME\DATA\USERX\config.fpw") with all the
> paths ponting to this dir, the launches the VFP APP/EXE with the *-C*
> C:\APPNAME\DATA\USERX\config.fpw option
>
> You even can use an internal CONFIG.FPW with starting exactly with this
> lines to allow using the external CFG:
>
> * internal config.fpw
> ALLOWEXTERNAL=ON
> RESOURCE=OFF
>
>
> Hope it helps.
>
>
> 2018-04-09 18:46 GMT+02:00 Paul H. Tarver <p...@tpcqpc.com>:
>
>> I think this is a two part question for VFP9:
>>
>>
>>
>> 1)  Has anyone had any experience with getting a program error at
>> runtime like this: File c:\users\paul\appdata\local\te
>> mp\xxx.tmp
>> is read-only? I do not get a similar error when running in development
>> mode
>> and I have explicitly set SORTWORK, PROGWORK, EDITWORK and TMPFILES in the
>> CONFIG.FPW file.
>>
>> 2)  Why does VFP continue to create cursor temp files in the
>> aforementioned path at all when I've manual set the path for temporary
>> files
>> in the CONFIG.FPW file?
>>
>>
>>
>> I'm sure it is something I'm doing wrong, so feel free to provide
>> constructive OR destructive criticism. J
>>
>>
>>
>> Thanks!
>>
>>
>>
>> Paul
>>
>>
>>
>>
>>
>> --- 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: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_Ju=1N5xeCfAnu0i1zkhMnMHJota2k3i=o5m9np6htk9...@mail.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: .tmp Is Read-Only

[Fernando D. Bozzo]

Hi Paul,

1. Occurred to me, and I think that *could* have something to do with
Windows Folder Virtualization

2. When Windows can't write to your CFG dirs, then automatically select the
TEMP

In my experience with this "strange" errors, I've fixed them creating a
subdirectory by user behind a public one --well ahead of Windows own dirs--
with all the permissions necessary (ie: "C:\APPNAME\DATA\USERX")

I have 2 solutions for this up to now, and in both of them Windows can't
interfere in any way, and you just want to configure de AV software to
ignore it:


1) When the PC is not shared between users:

This is the most simple case, and all you need is to create a DATA
directory (ie: "C:\APPNAME\DATA") and a CONFIG.FPW with this directory for
all config items


2) When the PC (Server) is shared among users:

This is a little tricky, but with you can asure that user TMP files are
well separated, and requires a "launcher" file (can be a VFP or a VBS
script one) that before starts the VFP APP/EXE, creates a "personal" CFG
file for each user (ie: "C:\APPNAME\DATA\USERX\config.fpw") with all the
paths ponting to this dir, the launches the VFP APP/EXE with the
*-C*C:\APPNAME\DATA\USERX\config.fpw
option

You even can use an internal CONFIG.FPW with starting exactly with this
lines to allow using the external CFG:

* internal config.fpw
ALLOWEXTERNAL=ON
RESOURCE=OFF


Hope it helps.


2018-04-09 18:46 GMT+02:00 Paul H. Tarver :

> I think this is a two part question for VFP9:
>
>
>
> 1)  Has anyone had any experience with getting a program error at
> runtime like this: File c:\users\paul\appdata\local\
> temp\xxx.tmp
> is read-only? I do not get a similar error when running in development mode
> and I have explicitly set SORTWORK, PROGWORK, EDITWORK and TMPFILES in the
> CONFIG.FPW file.
>
> 2)  Why does VFP continue to create cursor temp files in the
> aforementioned path at all when I've manual set the path for temporary
> files
> in the CONFIG.FPW file?
>
>
>
> I'm sure it is something I'm doing wrong, so feel free to provide
> constructive OR destructive criticism. J
>
>
>
> Thanks!
>
>
>
> Paul
>
>
>
>
>
> --- 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: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_jumcgk3231bbsoy7s5zmnyh-oi_rla55e_r+k9a0aq0...@mail.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: Numeric(x,0) vs Integer field type in VFP tables

[Fernando D. Bozzo]

Yes, in this case INT is much better because it only need 4 bytes on disk
and have direct hex interpretation, while the number occupies 10 bytes and
need digit by digit calculation.

Being both data types related, I thing that it's a secure assumption that
the number field can be replaced by the INT data type.


El jue., 5 de abril de 2018 5:05, <
mbsoftwaresoluti...@mbsoftwaresolutions.com> escribió:

> On 2018-04-04 16:53, Fernando D. Bozzo wrote:
> > Not counting legacy reasons for already available systems, I think that
> > this is because many did not learn about the available data types and
> > just
> > stay with what they know, others because did think that are the same,
> > and
> > others because they don't care.
> >
> > I know some of those guys, btw.
>
>
> ALBEIT PROBABLY MINISCULE, won't the Integer type be a better, more
> efficient, faster processing choice?  I noticed in this app I inherited,
> the main table where it's the PK, it's an INTEGER type, but in a another
> table where it's the foreign key, it's a N(10,0) type.  I'll have to
> break out SYS(3054) I guess to see if it optimizes, given the
> difference!
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_JukqbCLryDREi_8HvtF=vOjSdX_EU3gRUm6C1hDa4c=x...@mail.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: Numeric(x,0) vs Integer field type in VFP tables

[Fernando D. Bozzo]

Not counting legacy reasons for already available systems, I think that
this is because many did not learn about the available data types and just
stay with what they know, others because did think that are the same, and
others because they don't care.

I know some of those guys, btw.



2018-04-04 21:43 GMT+02:00 :

> VFP9
>
> I don't see why folks would use Numeric(X,0) where X > 4 instead of an
> Integer field.  Can you tell me why?  I'm guessing it's leftover legacy
> design?
>
> tia,
> --Mike
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_Ju=z_kq0vgh1uwvd7xgjexu_eu0kbqn3o3ggdshwadz...@mail.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] M$ teaches about AI (free)

[Fernando D. Bozzo]

I did take a look at it because they say it's free, but and at the end if
the content index they say that you need an Azure account which is free
only for the first month... so you have the exact time fir using Azure for
this course only before they start taking money from your credit card.


El mié., 4 abr. 2018 17:38, Stephen Russell 
escribió:

> Have not looked into this much have other irons in the fire right now.
>
>
>
> https://techcrunch.com/2018/04/02/microsoft-launches-entry-level-software-development-and-ai-courses/
>
> Saw a lecture on AI in an end user pharmacy app last night.
>
>
> --
> Stephen Russell
> Sr. Analyst
> Ring Container Technology
> Oakland TN
>
> 901.246-0159 cell
>
>
> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
>   text/plain (text body -- kept)
>   text/html
> ---
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_jun5_uucukat3refq1xgkja_mg5s91sdsjwqxy4m1gb...@mail.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: VFP9 Screwed - HELP!

[Fernando D. Bozzo]

Hi Dave:

I have some ideas to check, based on similar situation in the past:

Preferences:
There are two things related to this; foxuser.dbf and the
"HKCU\Software\Microsoft\VisualFoxPro" registry key.
- Try deleting (or renaming) all foxuser.dbf you have, or convert to text
with FoxBin2Prg if you have some foxuser that is really important for you.
Later you can regenerate that file in case of some corruption
- Try renaming the registry key, adding something at the end so VFP can't
recognize it an regenerate a new key, soy you keep a copy of the settings
in case you want to check differences

Security:
There are two main things on this topic:
- Check on viruses: all we know the strange behaviours they can cause
- Check if the Security Department or admins have changed some security or
access policies: This one specially have beed very dangerous to us, at the
extent that nobody did can save VFP own settings and IDE/applications start
to have strange behaviours, even causing non functioning or many errors.

Hope it helps.

Fernando D. Bozzo


2018-03-29 12:35 GMT+02:00 Dave Crozier <da...@flexipol.co.uk>:

> Fellow Gurus.
> Any input welcome as to why my VFP9 all serviced packed to date and
> working no problem on Win 10, 64 bit has suddenly died and won't come back
> to life. Not worried about why it went wrong, I just want a working VFP
> system.
>
> For some reason VFP remembers the old projects I had loaded at the time it
> died (C5 error...) and no won't forget the projects that were loaded.
>
> First I tried a repair option and still C5's on opening and then tried a n
> uninstall, reboot then install and it still c5's on opening my old projects
> which I assumed it would have forgotten but obviously not. Removed all
> traces of FoxUser.* to no avail.
>
> Running VFP 9.exe  /regserver  or vfp9 /a has no effect on loading the old
> projects despite saying it should ignore any registry settings an primarily
> unregistering VFP.
>
> Any ideas how I get a simple no projects loaded VFP application loaded?
>
> Of course it would happen on Year End stocktake day wouldn't it!!
> Grr!
>
> Dave Crozier
> Software Development Manager
> Flexipol Packaging Ltd.
>
>
>
> ---
> 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.
>
> Flexipol Packaging Ltd.
> Unit 14 Bentwood Road
> Carrs
> Industrial Estate
> Haslingden
> Rossendale
> Lancashire
> BB4 5HH
>
> Tel:01706-222792
> Fax: 01706-224683
> www.Flexipol.co.uk
> ---
>
> 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
>
[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: http://lea

Re: [ADMIN] Testing

[Fernando D. Bozzo]

Because Gmail by default treat ProFox email as spam, I am using what Ted
once wrote, about adding ProFox to the contacts list, and from then I have
no more ProFox emails in Spam.

Another option in Gmail is creating a filter and checking "Never mark this
as spam". I have many lists like this.




2018-03-28 11:28 GMT+02:00 AndyHC :

> Well gMail always blocks them - I just set Thunderbird to copy them to my
> inbox
>
> On 28-Mar-2018 1:00 AM, Ken Dibble wrote:
>
>> Not receiving my own posts?
>>
>>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_Ju=4fh4ynekcu6nqlxgn_bzm-zfzaze208ca44dsluw...@mail.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: Get Method Issue with Hidden Property

[Fernando D. Bozzo]

Hi Ken:

Sometimes, for unknown reasons, VFP have trouble with hidden properties,
and when this happens one of the fixes is unhidding the property, making it
public.

May be not the best solution, but it's better a bad solution than no
solution at all.



2018-03-27 20:21 GMT+02:00 Ken Dibble :

> VFP 9 SP 1, running on Win 7 Ultimate SP 1.
>
> I know that there can be issues with hidden object properties; that's why
> I give the base class "Set" and "Get" methods to deal with them. That's
> always supposed to work, right?
>
> So today somebody's software blew up on the "Get" method for a Shape
> object:
>
> This is in my resize code (I created this long before VFP had Anchors, and
> I haven't bothered to change it; the cause of the problem is not that I'm
> not using Anchors, and the correct solution for the actual problem cannot
> be to ditch my code and use Anchors instead, even though some people may
> suggest that.)
>
> This seems to have happened because of some bizarre anomaly where a user
> was previewing a report using the standard VFP report preview window. That
> report was called from a window that was opened by another window, both of
> which are In-Desktop windows inside my custom-made main window (I don't use
> _SCREEN). She closed the preview window, whereupon a shape that is ON THE
> MAIN WINDOW, not on the window that should have gotten focus, somehow
> executed its Resize() method--so she probably nudged the border of the main
> window somehow while playing with the report preview.
>
> My shape subclass did this:
>
> thepercent = THIS.ObtainAValue("PercentWidth")
>
> * PercentWidth is a hidden property of the baseclass. The baseclass code
> is this:
> PROCEDURE ObtainAValue
>  LPARAMETERS cTheProperty
>
> IF PEMSTATUS(THIS,cTheProperty,5) = .T.
>   * Property exists; the IF statement just said so...
>   RETURN THIS.  && Error 1734 "Property PERCENTWIDTH
> is not found"
> ELSE
>   RETURN 0
>ENDIF
> ENDPROC
>
> That's all of the code involved; I'm not leaving anything out.
>
> I can't reproduce this myself.
>
> Needless to say, various users have resized their various forms bazillions
> of times, thereby running this code bazillions of times *times* the number
> of times Resize() gets called when you're messing with the borders of a
> form, without having this happen. This is the kind of stuff that just irks
> me. I've seen it before; built-in VFP functions just flat-out lie, leaving
> my code with nothing to trust--but it only happens once in a blue moon.
>
> Any thoughts (other than "Use anchors instead"?)
>
> Thanks.
>
> Ken Dibble
> www.stic-cil.org
>
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_JunVsEmsHD8YjjGFgT5ZNJoTobe5uZ0toRXh=qrtvj1...@mail.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: Thread Start Test

[Fernando D. Bozzo]

Kurt, you wrote the exactly same that I was thinking ;-)



El mar., 27 mar. 2018 16:38, Kurt Wendt  escribió:

> PGRpdiBkaXI9J2F1dG8nPkdvb2Qgb25lIERhdmUhPC9kaXY+
>
>
> --- StripMime Report -- processed MIME parts ---
> text/html (html body -- converted)
> ---
>
>

>


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_Ju=b7kevnruh3w1o3opmguzssc72ejssyusnqjgjgto...@mail.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: Thread Start Test

[Fernando D. Bozzo]

Hi Gene,

You are wrong :-P

Best Regards!


El mar., 27 mar. 2018 0:36, Gene Wirchenko  escribió:

> Hello:
>
>   I do not appear to be able to originate threads on ProFox.
>
>   If you are reading this, I am wrong.
>
> Sincerely,
>
> Gene Wirchenko
>
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_JumgMSKjdDoQt0MFbvS=17t1wykxeg0ryhdd3fbr-+g...@mail.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: FoxBin2Prg v1.19.51 released (total binary support!:)

[Fernando D. Bozzo]

Wow! you keep using them!

Then please, tell me what you think of the export to text of these files.

Best Regards!


El lun., 26 mar. 2018 14:26, Richard Kaye <rk...@invaluable.com> escribió:

> Sadly, I use both MEM files and an FKY file. 
>
> Thanks, Fernando! I also have found FB2P to be an excellent tool.
>
> --
>
> rk
>
> -Original Message-
> From: ProfoxTech <profoxtech-boun...@leafe.com> On Behalf Of Fernando D.
> Bozzo
> Sent: Sunday, March 25, 2018 7:04 PM
> To: profoxt...@leafe.com
> Subject: FoxBin2Prg v1.19.51 released (total binary support!:)
>
> Hi guys!
>
> Just want to share this with you, for those that know or use this two-way
> converter for Visual FoxPro 9 binaries.
>
> With this version I finally have the total support for VFP9 binaries, being
> the macros file (fky) and memory variables file (mem) the latest two
> supported.
>
> I know that almost nobody use these two files, but I did it just because
> the technical chalenge and to feel that now is complete, nothing left out.
>
> For those that want to know the complete list of features added, this is
> the GitHub Wiki log of the project, so you can find easily the rest of the
> docs and the download section too:
>
> https://github.com/fdbozzo/foxbin2prg/wiki/FoxBin2Prg-Full-Change-History
>
> Thanks to all that did contribute to this project reporting issues,
> debating ideas for new features or fixing bugs. It is a great experience to
> work on an Open Source project like this with the great feedback that did
> occur over the years.
>
> Now the project is mainly in support mode, to fix some bugs that could
> appear.
>
> Thank you :-)
>
> Fernando D. Bozzo
>
>
> --- 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: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_jum1bw5stvawp7zrfqmy2ghd629trru1-xbvkj4gufq...@mail.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.

FoxBin2Prg v1.19.51 released (total binary support!:)

[Fernando D. Bozzo]

Hi guys!

Just want to share this with you, for those that know or use this two-way
converter for Visual FoxPro 9 binaries.

With this version I finally have the total support for VFP9 binaries, being
the macros file (fky) and memory variables file (mem) the latest two
supported.

I know that almost nobody use these two files, but I did it just because
the technical chalenge and to feel that now is complete, nothing left out.

For those that want to know the complete list of features added, this is
the GitHub Wiki log of the project, so you can find easily the rest of the
docs and the download section too:

https://github.com/fdbozzo/foxbin2prg/wiki/FoxBin2Prg-Full-Change-History

Thanks to all that did contribute to this project reporting issues,
debating ideas for new features or fixing bugs. It is a great experience to
work on an Open Source project like this with the great feedback that did
occur over the years.

Now the project is mainly in support mode, to fix some bugs that could
appear.

Thank you :-)

Fernando D. Bozzo


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_JunhtpNMgCrfnn08Po-x_YZVJ66B=bXxU=e5fx-kdqh...@mail.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: Testing tells the tale (SYS 3054) -- "BETWEEN(a, b, c)" equivalent to "a BETWEEN b and c"

[Fernando D. Bozzo]

Using ALLTRIM() on idexes is a bad idea, the full field is always better
and faster, because VFP does not have to preprocess the value for
searching, for adding a new value and for reindexing.


El lun., 19 de marzo de 2018 23:29, Bill Anderson 
escribió:

> Mike,
>
> I believe ALLTRIM()s in SQL doesn't "defeat" optimization, it's just that
> you can't have ragged (meaning, varying length) indexes in VFP.
>
> A tag on ALLTRIM(field) is padded out to the full length of the field.
>
> Bill Anderson
>
>
> On Mon, Mar 19, 2018 at 12:55 PM, <
> mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
>
> > -Original Message-
> >> From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of
> >> mbsoftwaresoluti...@mbsoftwaresolutions.com
> >> Sent: Sunday, March 18, 2018 2:34 PM
> >> To: ProFox 
> >> Subject: Testing tells the tale (SYS 3054) -- "BETWEEN(a,b,c)"
> >> equivalent to "a BETWEEN b and c"
> >>
> >> VFP9SP2 WestWind WebConnection App on WinServer 2012
> >>
> >> I was looking at a notoriously slow query to see about optimizing it.
> >> Using SYS(3054,11,"cmemvar"), I was able to do so, but during my
> >> testing, I found that using MyDate BETWEEN Arg1 and Arg1 was the same
> >> optimization-wise as BETWEEN(MyDate,Arg1,Arg2).  Somewhere in history,
> >> I thought that using VFP's native BETWEEN(field,d1,d2) was NOT
> >> Rushmore friendly.  However, testing with SYS(3054) showed otherwise!
> >>
> >> Just an interesting find this weekend for me whilst debugging.
> >>
> >> Carry on!
> >> --Mike
> >>
> >
> >
> > Also found that the ALLTRIMs in some SQLs were defeating optimization as
> > well.  Just a tip for others here!  I don't code that way but somebody in
> > the history of this app did.
> >
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_Juk36oB8Xes_pF5Ka3exCwLCHrsFF=ybqvi_oi+ym0i...@mail.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: Error 108 on an INSERT INTO MyVFPTable

[Fernando D. Bozzo]

... I always forget the antivirus thing. Yes! nothing more intrusive like
that!



El vie., 16 mar. 2018 14:53, Tracy Pearson  escribió:

> I don't know why this happens, but I can say our customers will sometimes
> get it.
> We open our tables Shared with Table Buffering in the Dataesssion of the
> form.
> We have had standalone installs have this error. (local machine, data is
> not
> shared)
> I suspect it has something to do with an anti-virus or on demand backup
> software that causes the behavior.
> After we exclude the DBF, CDX and FPT files, and remove the backup software
> that doesn't really stop temporarily locking the files, we don't hear from
> them with that particular issue again.
>
> Good luck finding the culprit.
>
> Tracy
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> mbsoftwaresoluti...@mbsoftwaresolutions.com
> Sent: Thursday, March 15, 2018 8:32 PM
> To: profoxt...@leafe.com
> Subject: Error 108 on an INSERT INTO MyVFPTable
>
> VFP9SP2 app/Win10 Pro workstation/Win2012 Server
>
> Got a bug report from a client today that threw a 108 "File is in use by
> another user" on an INSERT INTO statement (all VFP9 dbc tables).  Found
> it interesting that the VFP Help file says that's on a USE, DELETE, or
> RENAME command (but not INSERT INTO).
>
>
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_jungcoev1-jvycwibenjj7noq--6so92cganwkufvfd...@mail.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: Error 108 on an INSERT INTO MyVFPTable

[Fernando D. Bozzo]

I didn't test it and didn't use it in many years, but could be possible
that the table had a file lock (not record lock) by this another user?

Don't know if the message is the same or something more like "table header
is locked by another user"



El vie., 16 mar. 2018 4:30, 
escribió:

> On 2018-03-15 21:15, Richard Kaye wrote:
> > INSERT INTO has to be doing an implicit USE, don't you think?
>
>
> I can't tell if the table was open, and if not, your logic is
> reasonable, but if it WAS already open, 
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_jumnkq84-pgaw7cf5azrmaj6jptrnbpcetbn3z38b8e...@mail.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: Displaying Content on a TV

[Fernando D. Bozzo]

That depends on the variability of yor html.
If it is a lot of text, the using cVar=cVar+"html text" is the fastest way.
If not, then you can use TEXT.. ENDTEXT or a mix of both.
Or you can also use the htmlDocument object from Windows.


El 22 feb. 2018 0:39, "Desmond Lloyd"  escribió:

> Thanks all for your responses!
>
> What is the best way to generate HTML out of VFP?   Report to HTML?
>
> Regards,
> Desmond
>
>
> On 21 February 2018 at 12:26, Kevin J Cully 
> wrote:
>
> > I'd purchase a Raspberry PI.  The power for this $30 computer can come
> > from the USB port on the TV.  Output from the Raspberri PI is from the
> HDMI
> > port into the HDMI port on the TV.
> >
> > I'd have the Raspberry PI boot and load a browser full screen with no
> > menu.  That browser would be configured to display a HTML page from
> itself
> > and have that HTML page refresh every "X" minutes.
> >
> > I'd then from your production system, I'd generate that HTML and whatever
> > graphs / charts that you'd like.  I would then have those files sent to
> the
> > Raspberry PI via FTP, torrent, Dropbox or similar.
> >
> > $0.02.
> >
> >
> > -Original Message-
> > From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Desmond
> Lloyd
> > Sent: Wednesday, February 21, 2018 12:32 PM
> > To: ProFox Email List 
> > Subject: Displaying Content on a TV
> >
> > We want to display a list of orders on a TV. coming from a VFP based
> > system.   Thus far I have generated a report to PDF,  then converting
> that
> > to a JPEG and displaying that on the TV/  Very clumsy and we have not
> been
> > able to automate...
> >
> > Would someone please recommend possible ways of accomplishing this?
> >
> > 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: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_Jum2sAzzSSMA06YzkP1+n+o2f5cAp=9bbopffq+tugi...@mail.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: String Reference to Object

[Fernando D. Bozzo]

(part 2)

Gene, about the alias thing:

If you have your table already open with something like this:

  use ccli

Then you can re-open the same table under another alias this way:

  use ccli alias *mytable again shared*
  ? *mytable*.clcode
  ...
  use in (select("mytable"))


Interesting things about this:
- VFP does not create a second handle to the table, just reuse the existing
one with another name
- Because of that, the reopening with different aliases is the fastest way
to reuse an already opened table
- Each alias have it's own record pointer and can have it own index too,
without interfering with the other aliases
- Aliases allows you to encapsulate functionality for a group of tables
that share one or more fields when you need to treat them the same way



2018-02-15 20:50 GMT+01:00 Fernando D. Bozzo <fdbo...@gmail.com>:

> Gene, you did talk about objects, not tables and fields. They are not
> treated the same way.
>
> In this case, then Ted is right, the alias must be used.
>
> You can use generically with something like this:
>
>   use ccli alias *mytable*
>   ? *mytable*.clcode
>
> Nice thing about aliases is that you can use the same alias for any table
> in the case that those tables have the same fields you want to access.
>
>
>
>
> 2018-02-15 20:16 GMT+01:00 Gene Wirchenko <ge...@telus.net>:
>
>> At 11:07 2018-02-15, Gene Wirchenko <ge...@telus.net> wrote:
>>
>>> At 10:57 2018-02-15, "Fernando D. Bozzo" <fdbo...@gmail.com> wrote:
>>>
>>
>> To talk with an example, if you have this:
>>>>
>>>> oObj = createobject("custom")
>>>> reference = "oObj"
>>>>
>>>> The you have at least 3 options:
>>>>
>>>> 1) The way you know =>  
>>>>
>>>> 2) Using evaluate =>  =Evaluate(reference + ".referredto")
>>>>
>>>> 3) My preferred: Caching the object and then using it:
>>>>
>>>> oRef = Evaluate(reference)
>>>> ? oRef.refered1
>>>> ? oRef.refered2
>>>> ...
>>>>
>>>
>>>  I was hoping to avoid evaluate(), but your third way makes sense.
>>> I will check if it works in all the contexts I am thinking of.  (I was
>>> using "object" and "reference" rather loosely.)
>>>
>>
>>  Unfortunately, it does not work in my usual use case: as an alias.
>> Example:
>>   use ccli
>>   where=evaluate("ccli") && Nope
>>   ? where.clcode
>>
>> Sincerely,
>>
>> Gene Wirchenko
>>
>>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_JumE_wB5unwo3=qi1jweabucu3gex46htewbex+jwie...@mail.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: String Reference to Object

[Fernando D. Bozzo]

Gene, you did talk about objects, not tables and fields. They are not
treated the same way.

In this case, then Ted is right, the alias must be used.

You can use generically with something like this:

  use ccli alias *mytable*
  ? *mytable*.clcode

Nice thing about aliases is that you can use the same alias for any table
in the case that those tables have the same fields you want to access.




2018-02-15 20:16 GMT+01:00 Gene Wirchenko <ge...@telus.net>:

> At 11:07 2018-02-15, Gene Wirchenko <ge...@telus.net> wrote:
>
>> At 10:57 2018-02-15, "Fernando D. Bozzo" <fdbo...@gmail.com> wrote:
>>
>
> To talk with an example, if you have this:
>>>
>>> oObj = createobject("custom")
>>> reference = "oObj"
>>>
>>> The you have at least 3 options:
>>>
>>> 1) The way you know =>  
>>>
>>> 2) Using evaluate =>  =Evaluate(reference + ".referredto")
>>>
>>> 3) My preferred: Caching the object and then using it:
>>>
>>> oRef = Evaluate(reference)
>>> ? oRef.refered1
>>> ? oRef.refered2
>>> ...
>>>
>>
>>  I was hoping to avoid evaluate(), but your third way makes sense.  I
>> will check if it works in all the contexts I am thinking of.  (I was using
>> "object" and "reference" rather loosely.)
>>
>
>  Unfortunately, it does not work in my usual use case: as an alias.
> Example:
>   use ccli
>   where=evaluate("ccli") && Nope
>   ? where.clcode
>
> Sincerely,
>
> Gene Wirchenko
>
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_junykisubvyaz7ogvpfxmxqwt8mlwb_2x_1thxkr5e-...@mail.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: String Reference to Object

[Fernando D. Bozzo]

Hi Gene:

To talk with an example, if you have this:

oObj = createobject("custom")
reference = "oObj"

The you have at least 3 options:

1) The way you know =>  

2) Using evaluate =>  =Evaluate(reference + ".referredto")

3) My preferred: Caching the object and then using it:

oRef = Evaluate(reference)
? oRef.refered1
? oRef.refered2
...




2018-02-15 19:51 GMT+01:00 Gene Wirchenko :

> Dear Foxers:
>
>  I sometimes have a "reference" to an object that is in the form of a
> string variable.  I have used
>   
>
>  Is there a better way of doing this?
>
>   (reference).referredto
> would be nice, but it does not compile.
>
> Sincerely,
>
> Gene Wirchenko
>
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_JukotJHyYsJ5OtmJ8jSiO3jGOMZ=w+9u8ewny64vx5c...@mail.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: New Term: Zombie Language

[Fernando D. Bozzo]

I don't feel bad about it, really, but this makes clear that the Author of
the article probably never did work with this languages and didn't work
maintaining any systems developed in those now zombie languages.

I think that those stats have much sense if you think that there is too
much code working in production and that all this situations can justify
this reborn on TIOBE:

- You have to maintain a legacy system (VB in this case) and you need to
search some info about language functionality or parameters, what do you
do? If you have not installed the MSDN on your disk, then you search it on
Google

- The same applies to old ASP pages with VBscript. You probably search for
VBscript or VB6

- You need to search some examples about COM functionality (COM components,
Soap, XML, WMI, etc) used from an old Windows language, what do you do? you
search it on Google, and probably you search for a VB6 example even if you
are interested in VFP or other language. Why? because VB6 have always been
the Microsoft preference in last century, and most examples are done using
VB6. I did search the other day for a VB6 example if something that I want
to call from VFP!

And the same applies to any COM compatible  language. It's easier to find
something for VB6 than for anything else.

Fernando D. Bozzo


El 15 feb. 2018 16:21, "Paul H. Tarver" <p...@tpcqpc.com> escribió:

> Did anyone catch this article about "Zombie Languages"?
>
>
>
> https://www.techrepublic.com/article/zombie-programming-
> languages-could-visu
> al-basic-be-the-next-cobol/?ftag=TRE684d531
> <https://www.techrepublic.com/article/zombie-programming-
> languages-could-vis
> ual-basic-be-the-next-cobol/?ftag=TRE684d531=
> 1999552568774123473679
> 288983> =1999552568774123473679288983
>
>
>
> While the article focuses on Visual Basic, I think VFP qualifies under
> their
> definition:
>
>
>
> Zombie Languages: "Those old developer favorites that refuse to die"
>
>
>
> To be honest, it makes all of us FoxPro coders cool again: We are all
> "Zombie Wranglers!"
>
>
>
> ~~~ Pull Quote ~~~
>
> James Milligan also drew parallels with the perennial demand for
> programmers
> skilled in venerable mainframe programming language COBOL, a language older
> than The Beatles.
>
>
>
> "Other languages which continue to be widely used despite running legacy
> systems include COBOL. It's known that COBOL tends to be preferred in
> business, finance and administrative systems due to its efficiency in
> handling large volumes of data - so it's predicted to remain popular across
> these sectors."
>
> ~~~
>
>
>
> Paul
>
>
>
>
>
> --- 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: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_JukqSzbgrR=1-kypf5me4itbeb2q+fcxrrwhsf9gmb-...@mail.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: Trashed class library

[Fernando D. Bozzo]

Hi Bill:

In his GitHub repository Mike wrote an introductory help page (almost all
GitHub repos have this, or even a wiki section with more help, like
FoxBin2Prg)

Here is his repo url:

https://github.com/mikepotjer/vfp-git-utils


El 2 feb. 2018 0:18, "Bill Anderson"  escribió:

> >>  And you can setup Git integration which leverages the FB2P stuff.<<
>
> Is there a primer for how to do this? I know there's "read the help", but
> I've been spoiled by Thor's "Check for Updates", does Git provide a similar
> mechanism?
>
> (Admitted Git newbie...)
>
> Bill Anderson
>
> On Mon, Jan 29, 2018 at 3:51 PM, Richard Kaye 
> wrote:
>
> > It's pretty new. And you can setup Git integration which leverages the
> > FB2P stuff.
> >
> > --
> >
> > rk
> >
> > -Original Message-
> > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> > mbsoftwaresoluti...@mbsoftwaresolutions.com
> > Sent: Monday, January 29, 2018 6:09 PM
> > To: profoxt...@leafe.com
> > Subject: Re: Trashed class library
> >
> > On 2018-01-29 15:57, Richard Kaye wrote:
> > > Yes. I have not integrated into the PM as of yet. Someday... Maybe at
> > > the same time I get Doug Hennig's VFPX PM replacement going.
> >
> >
> > I'll have to look into Doug's VFPX PM replacement tool.  I can't recall
> > reviewing it.
> >
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_JunsDufKr2Ge808pqKrkvM5RjFKQQ6fVtxO2ixr3049r=q...@mail.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: Declaring variable as "Empty" ???

[Fernando D. Bozzo]

A small error writing by heart, but EMPTY class has no AddProperty()
method, so really is:

AddProperty( loReg, "name", value)
...




2018-01-30 23:56 GMT+01:00 Fernando D. Bozzo <fdbo...@gmail.com>:

> Declaring a variable as "EMPTY" is the same as declaring as "object": As
> Ted said, has no programmatic effects, but in this case has no effect even
> for Intellisense.
>
> When I want Intellisense for an EMPTY object I define a CUSTOM class with
> the properties of the EMPTY object, so I (or the team) can benefit of
> Intellisense for the EMPTY object, like this example:
>
> * TEST.PRG
> LOCAL loReg as C_REG OF TEST.PRG
> loReg = CREATEOBJECT("EMPTY")
> loReg.AddProperty("name", value)
> loReg.AddProperty("address", value)
> ...
> RETURN
>
> DEFINE CLASS C_REG AS CUSTOM
>name = ""
>address = ""
> ENDDEFINE
>
>
> In some situations this is very useful.
>
> Fernando.-
>
>
>
> 2018-01-30 23:44 GMT+01:00 Paul H. Tarver <p...@tpcqpc.com>:
>
>> I think I accidently did something similar recently and I think using
>> createobject('Empty') may have been a cleaner method of doing what I did.
>>
>> I was trying to create an object I could use to store say a dozen or more
>> attributes and then pass the reference to the object as one parameter
>> rather
>> than a dozen or more separate parameters. This need comes up from time to
>> time when I want to build a complex method that uses only parameters to do
>> the same job repeatedly as I fall through a large table. In this specific
>> situation, I was looping through 50 or 60 columns on about 1,000 records.
>> Not sure if there is any performance benefit one way or another in using
>> lots of parameters as compared to using an object references, but it sure
>> made the development of the two-part processing a lot easier.
>>
>> The way I did it was to add a custom object to my Class Library and then
>> use
>> NewObject to create the object within my main code like this:
>>
>> loTaxObject = NEWOBJECT("Std_VarObj","toolkit")
>> loTaxObject.AddProperty('ocClientId', '')
>> loTaxObject.AddProperty('ocEmplId', '')
>> loTaxObject.AddProperty('ocEmplName', '')
>> 
>> etc.
>>
>> I then fall through a scan...endscan routine where we populate the various
>> properties on the object and then pass the loTaxObject as a parameter to a
>> different method which then uses all of the properties to the final
>> processing. Not sure whether this is good programming style or not, but it
>> worked like I wanted and I think I'll be using something like this again
>> in
>> the near future. Then I saw the CreateObject('Empty') command mentioned on
>> this thread.
>>
>> Wouldn't that accomplish the same thing I did via NewObject with a
>> pre-established class?
>>
>> Thanks!
>>
>> Paul
>>
>> -Original Message-
>> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank
>> Cazabon
>> Sent: Tuesday, January 30, 2018 2:13 PM
>> To: profoxt...@leafe.com
>> Subject: Re: Declaring variable as "Empty" ???
>>
>> I've seen it used as a lightweight class.
>>
>> http://fox.wikis.com/wc.dll?Wiki~EmptyClass
>>
>> On 30 January 2018 14:50:57 GMT-04:00,
>> mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
>> >Saw this today while looking for other stuff:
>> >https://www.screencast.com/t/PyvZvy53oZFu
>> >
>> >Never saw anyone declare a variable AS "Empty" before?  I guess that's
>> >basically this:  loMenuItem = CREATEOBJECT("Empty")  (although you'd
>> >still have to write that code, of course, since no instantiation in
>> >declaration in VFP).
>> >
>> >???
>> >
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_Junj8KFoa7DFNmiH5hNBMCMN468tEKOHbX46m8o=umg...@mail.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: Declaring variable as "Empty" ???

[Fernando D. Bozzo]

Declaring a variable as "EMPTY" is the same as declaring as "object": As
Ted said, has no programmatic effects, but in this case has no effect even
for Intellisense.

When I want Intellisense for an EMPTY object I define a CUSTOM class with
the properties of the EMPTY object, so I (or the team) can benefit of
Intellisense for the EMPTY object, like this example:

* TEST.PRG
LOCAL loReg as C_REG OF TEST.PRG
loReg = CREATEOBJECT("EMPTY")
loReg.AddProperty("name", value)
loReg.AddProperty("address", value)
...
RETURN

DEFINE CLASS C_REG AS CUSTOM
   name = ""
   address = ""
ENDDEFINE


In some situations this is very useful.

Fernando.-



2018-01-30 23:44 GMT+01:00 Paul H. Tarver :

> I think I accidently did something similar recently and I think using
> createobject('Empty') may have been a cleaner method of doing what I did.
>
> I was trying to create an object I could use to store say a dozen or more
> attributes and then pass the reference to the object as one parameter
> rather
> than a dozen or more separate parameters. This need comes up from time to
> time when I want to build a complex method that uses only parameters to do
> the same job repeatedly as I fall through a large table. In this specific
> situation, I was looping through 50 or 60 columns on about 1,000 records.
> Not sure if there is any performance benefit one way or another in using
> lots of parameters as compared to using an object references, but it sure
> made the development of the two-part processing a lot easier.
>
> The way I did it was to add a custom object to my Class Library and then
> use
> NewObject to create the object within my main code like this:
>
> loTaxObject = NEWOBJECT("Std_VarObj","toolkit")
> loTaxObject.AddProperty('ocClientId', '')
> loTaxObject.AddProperty('ocEmplId', '')
> loTaxObject.AddProperty('ocEmplName', '')
> 
> etc.
>
> I then fall through a scan...endscan routine where we populate the various
> properties on the object and then pass the loTaxObject as a parameter to a
> different method which then uses all of the properties to the final
> processing. Not sure whether this is good programming style or not, but it
> worked like I wanted and I think I'll be using something like this again in
> the near future. Then I saw the CreateObject('Empty') command mentioned on
> this thread.
>
> Wouldn't that accomplish the same thing I did via NewObject with a
> pre-established class?
>
> Thanks!
>
> Paul
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank
> Cazabon
> Sent: Tuesday, January 30, 2018 2:13 PM
> To: profoxt...@leafe.com
> Subject: Re: Declaring variable as "Empty" ???
>
> I've seen it used as a lightweight class.
>
> http://fox.wikis.com/wc.dll?Wiki~EmptyClass
>
> On 30 January 2018 14:50:57 GMT-04:00,
> mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
> >Saw this today while looking for other stuff:
> >https://www.screencast.com/t/PyvZvy53oZFu
> >
> >Never saw anyone declare a variable AS "Empty" before?  I guess that's
> >basically this:  loMenuItem = CREATEOBJECT("Empty")  (although you'd
> >still have to write that code, of course, since no instantiation in
> >declaration in VFP).
> >
> >???
> >
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_jukmt3cl8y0bmxdaufsgqz1r0-tx4nmekuyaoeq3z21...@mail.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: Trashed class library

[Fernando D. Bozzo]

Hi Paul:

You should start using a Source Control tool to minimize those problems.

Or at least make a textual conversion with FoxBin2Prg so you can rebuild
your library.

Look at the temp folder if there is a tmp file that can be the vct renamed
(you can see their contents using a hex editor)


El 29 ene. 2018 15:00, "Alan Bourke"  escribió:

> It hasn't just changed the extension on the VCX?
>
> Try the free version of Recuva: https://www.ccleaner.com/recuva
>
>
> --
>   Alan Bourke
>   alanpbourke (at) fastmail (dot) fm
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_Juk8PzTAm06ymm6VO=cxwae+cg8wrm-cifvwjhesbq1...@mail.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: Indexes on VFP tables--when do they get updated

[Fernando D. Bozzo]

Yeah, and that's why DBF files can be easily corrupted: You have many
clients trying to update the same files remotely over a network. Any
network microcut, any client virus or any client that collapse or reset is
a potential contributor to write bad info, resulting in the well known file
corruption, being some of the worst those that passes unseen (corrupted
data that does not corrupt the file structure) but that soon or later you
will find.

This problem is more noticed starting from Windows greater than 2003/XP,
for wich the SMB protocol have changed, privileging fast througputs and
optimizations for HTTP protocols at the expense of the now deprecated ISAM
files access.




2018-01-25 20:04 GMT+01:00 Stephen Russell <srussell...@gmail.com>:

> I see a potential problem when multiple users are doing updates on the same
> table.
> What constitutes the server file to be updated?
> How do the localized cdx files know to update when the server version is
> updated?
>
>
>
>
>
> On Thu, Jan 25, 2018 at 12:51 PM, Gene Wirchenko <ge...@telus.net> wrote:
>
> > At 08:15 2018-01-25, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
> >
> >> On 2018-01-24 18:39, Fernando D. Bozzo wrote:
> >>
> >>> When the index is evaluated initially, VFP knows exactly what fields
> >>> affect
> >>> what index, so really just affected indexes are updated.
> >>> It's easy to test it. just make an old index (IDX) on two different
> >>> fields:
> >>> CREATE TABLE test (field1 C(10), field2 I)
> >>> INDEX on field1 TO test_f1 additive
> >>> INDEX on field2 TO test_f2 additive
> >>> Add some data, wait a minute, replace one of the fields and do a FLUSH
> >>> FORCE, and you will see that only the affected index changes his
> >>> timestamp.
> >>>
> >>
> > I don't think that's a fair test to use IDX files since this example uses
> >> a CDX file, and it's all in the same file.
> >>
> >
> >  I think it *is* a fair test for exactly that reason.  If you see
> only
> > one of the IDX index files change, that suggests that VFP only updates an
> > index where it would make a difference.
> >
> >  I grant that it could be that that optimisation does not exist in
> the
> > CDX handling, but how likely do you think that is?
> >
> > Sincerely,
> >
> > Gene Wirchenko
> >
> >
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_Ju=_FxRdwzcJc6tp3yH3V0NOLXsq=H=FW=Qvx1_PGeG=8...@mail.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: Indexes on VFP tables--when do they get updated

[Fernando D. Bozzo]

When the index is evaluated initially, VFP knows exactly what fields affect
what index, so really just affected indexes are updated.

It's easy to test it. just make an old index (IDX) on two different fields:

CREATE TABLE test (field1 C(10), field2 I)
INDEX on field1 TO test_f1 additive
INDEX on field2 TO test_f2 additive

Add some data, wait a minute, replace one of the fields and do a FLUSH
FORCE, and you will see that only the affected index changes his timestamp.




2018-01-24 23:57 GMT+01:00 :

> On 2018-01-24 15:21, Ted Roche wrote:
>
>> First off, don't do that. REPLACE (or better, UPDATE) once. Especially
>> in high network traffic situations, the amount of time it takes to
>> assemble a field and value list to issue one:
>>
>> UPDATE TableName SET  WHERE FilterCriteria
>>
>> saves an enormous amount of I/O and CPU cycles: one lock, one
>> transaction, one row re-write, one set of reindexes.
>>
>
>
> Yes, I retooled some code to replace (pun not intended) a whole bunch of
> REPLACE commands in the same area with a SCATTER to object, do the voodoo,
> then just ONE REPLACE afterwards for that very purpose.  I specifically
> listed that "multiple conditions" example thinking if I didn't, someone
> would say as you did to avoid the multiple REPLACEs.  :-)
>
>
>
>> Second, in VFP, all indexes have to be evaluated, as there's no
>> backlink to which fields are used in which expressions. Indexes are
>> defined at the table level, not the row, so can have multiple field
>> names, functions (UPPER() or DELETED(), for example), concatentations
>> or just random stuff.
>>
>
>
> So you're contending that ALL of the indexes--not just those affected by
> the field that was changed--would have to be reevaluated?
>
>
>
>> 
>> I once worked on an app where the original developer thought it would
>> be a "clever" idea to define index expressions as UDFs. Yes, it's
>> possible. In his UDFs, he would switch work areas, open tables if not
>> already opened, look up values, and then return the value, cleaning up
>> work areas and tables as he went. For every index definition for every
>> record. A reindex with more than a couple hundred records brought the
>> entire system to its knees.
>> 
>>
>
>
> YIKES  Thanks for sharing that one!
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_Ju=4VNPRZZ5QXsK2iY9eY55thp4vpiO=vyrhthxwdeu...@mail.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: Searching for FoxPro Work & a Change in Work Status...

[Fernando D. Bozzo]

Hi Kurt:

You can be sure that there is nobody with less than 40 here (including me:)

Good luck and report back! :-)

Fernando D. Bozzo


El 23 ene. 2018 1:22, "Kurt at VR-FX" <v...@optonline.net> escribió:

FYI -  had a 1st interview via phone today - and, I think I'm a Shoe-In for
this Gig!

(Is this "shoe-in" still used as a common phrase - or only by OLD people
such as Me?)

Why? Cause exactly how many VFP programmers are still out there working in
the world? Well - lucky for me - Seems there is STILL a NEED! Hell - we ALL
of us here know of some Old Apps still in the field - still in VFP - and
STILL Working! So - now its my time to quickly get acquainted with this app
at this new potential Gig!

Tomorrow is an Inperson interview. I should have no problem with that.

But, will report back as to the Outcome.

-K-



On 12/4/2017 10:40 AM, Ted Roche wrote:

> On Sun, Dec 3, 2017 at 1:09 PM, Kurt at VR-FX <v...@optonline.net> wrote:
>
>> Thus why I am looking around for VFP
>> work. So - if anyone knows of anything in the NYC area - or even work
>> that I
>> can do remotely - I would really appreciate it!
>>
>> Sorry to hear that, Kurt. I'll keep an eye out for opportunities to
> send your way.
>
>

[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_Juk7A0wzRKA90xQk7z4S7++35=jOi=fuluvmb7wvj6i...@mail.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: Include (.H) files

[Fernando D. Bozzo]

No, you should mark them as excluded.



2018-01-08 21:10 GMT+01:00 :

> Wanted to get your 2 centsif .H include files are simply used at
> compile time, there would be no need to include them in the EXE, right?
>
> tia,
> --Mike
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_JumBnNZNNL5ivGbrb3xzt=zxz9na-6jiqjqty4yaqka...@mail.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: What would you do?

[Fernando D. Bozzo]

You may have a look at XBase++ from Alaska Software:

https://www.alaska-software.com/products/clipper-compatibility.cxp




2017-12-16 13:26 GMT+01:00 Michael Madigan :

> A client may be forced to convert his legacy foxpro software to something
> commercial and currently commercially supported by the manufacturer.
> My client would prefer to keep it as is, but the decision may be out of his
> hands.  Open source is probably out too.
> There is no software currently on the market that will do what he does the
> way he does it.
> What would you do?  The system is relatively simple, has to support 100
> simultaneous users, has to be at least as secure as Foxpro, and run from a
> internal server.  Id love something that works like Foxpro, I.E.   a DBMS
> package with a powerful programming language, and is easy to learn.
> What would you migrate it to?
>
>
> --- 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: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_juk5mrd9z11aegt1dsdda1rnh3ug-rasjlq_pck4sad...@mail.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] SSD drives vs. 7200 rpm drives

[Fernando D. Bozzo]

You mean who make the MSI Laptop? MicroStar International

Here is the link:
https://www.msi.com/Laptop/support/GP62-7RE-Leopard-Pro.html

Mine is a gaming one, with lightning keaybord, very useful at night.




2017-11-20 16:58 GMT+01:00 <mbsoftwaresoluti...@mbsoftwaresolutions.com>:

> Who makes that model?  Sorry if I missed that.
>
>
> On 2017-11-20 10:56, Fernando D. Bozzo wrote:
>
>> Forgot to mention that I'm using it with a Dock station, because y prefer
>> to use a 24" wide monitor with external keyboard and mouse.
>>
>> By the way, my primary OS is Ubuntu Linux, with Windows 10 dual boot
>>
>> Love to have the OS loaded in less than 12 secs :-P
>>
>> El 20 nov. 2017 16:32, "Fernando D. Bozzo" <fdbo...@gmail.com> escribió:
>>
>> This one:
>>>
>>> *MSI GP62 7RE-431XES Leopard Pro Intel Core
>>> i7-7700HQ/8GB/1TB/GTX1050Ti/15.6"*
>>>
>>> and added a 256GB SSD
>>>
>>>
>>> El 20 nov. 2017 16:11, <mbsoftwaresoluti...@mbsoftwaresolutions.com>
>>> escribió:
>>>
>>> On 2017-11-20 10:03, Fernando D. Bozzo wrote:
>>>>
>>>> I personally use a 256 GB SSD just for fast - loading the OS, but the
>>>>> data
>>>>> on the HDD.
>>>>>
>>>>> This way you can have the best of the two worlds.
>>>>>
>>>>>
>>>>
>>>> Is this on a laptop?  What make/model do you have?
>>>>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_Juk-E9r+6nM=HZWM4xm=6idcebgh9fyrywjxr3xqhfd...@mail.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: 16GB RAM vs 8GB in laptop

[Fernando D. Bozzo]

... then use Firefox, uses less ram :-P


El 20 nov. 2017 4:54 p. m., "Stephen Russell" 
escribió:

> Chrome Browser laughs in your face.  All the apps need ram and the more you
> have the more they can fit into it.
>
> On Mon, Nov 20, 2017 at 9:40 AM, <
> mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
>
> > Is it ridiculous to double to 16 when 8 is probably great already on a
> new
> > laptop with SSD hard drive?
> >
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_junggfhi26iupwcq+yzhbpf6p3-sx8+9sn4dy3c0s1t...@mail.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: 16GB RAM vs 8GB in laptop

[Fernando D. Bozzo]

Yes, 8GB is fine for normal development use, but if you use some concurrent
virtual machines with 2GB RAM each, then you could need them.


El 20 nov. 2017 16:40, 
escribió:

> Is it ridiculous to double to 16 when 8 is probably great already on a new
> laptop with SSD hard drive?
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_JunjABwPvS75k+pwAkF+FP7M8Da3bBBPOJhjLC=7h7v...@mail.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] SSD drives vs. 7200 rpm drives

[Fernando D. Bozzo]

Forgot to mention that I'm using it with a Dock station, because y prefer
to use a 24" wide monitor with external keyboard and mouse.

By the way, my primary OS is Ubuntu Linux, with Windows 10 dual boot

Love to have the OS loaded in less than 12 secs :-P

El 20 nov. 2017 16:32, "Fernando D. Bozzo" <fdbo...@gmail.com> escribió:

> This one:
>
> *MSI GP62 7RE-431XES Leopard Pro Intel Core
> i7-7700HQ/8GB/1TB/GTX1050Ti/15.6"*
>
> and added a 256GB SSD
>
>
> El 20 nov. 2017 16:11, <mbsoftwaresoluti...@mbsoftwaresolutions.com>
> escribió:
>
>> On 2017-11-20 10:03, Fernando D. Bozzo wrote:
>>
>>> I personally use a 256 GB SSD just for fast - loading the OS, but the
>>> data
>>> on the HDD.
>>>
>>> This way you can have the best of the two worlds.
>>>
>>
>>
>> Is this on a laptop?  What make/model do you have?
>>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_junynb6bmdhfoda49_xtnq_nnrne8bbzeh4zebr_-0k...@mail.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] SSD drives vs. 7200 rpm drives

[Fernando D. Bozzo]

This one:

*MSI GP62 7RE-431XES Leopard Pro Intel Core
i7-7700HQ/8GB/1TB/GTX1050Ti/15.6"*

and added a 256GB SSD


El 20 nov. 2017 16:11, <mbsoftwaresoluti...@mbsoftwaresolutions.com>
escribió:

> On 2017-11-20 10:03, Fernando D. Bozzo wrote:
>
>> I personally use a 256 GB SSD just for fast - loading the OS, but the data
>> on the HDD.
>>
>> This way you can have the best of the two worlds.
>>
>
>
> Is this on a laptop?  What make/model do you have?
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_JunXr=ZrP0_Ye=80wktb_drotlrt-kezruqpp8cqy4m...@mail.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] SSD drives vs. 7200 rpm drives

[Fernando D. Bozzo]

I personally use a 256 GB SSD just for fast - loading the OS, but the data
on the HDD.

This way you can have the best of the two worlds.


El 20 nov. 2017 15:58, 
escribió:

> Well, I've been talking about it for a couple years now.  I think I'm
> going to buy a laptop this week for some Black Friday deal (hopefully) to
> get the best savings.
>
> I bought a Surface Pro 3 from a friend last year but I'm used to a Dell
> Latitude laptop that fits in my docking stations so I'm not taking to the
> Surface Pro 3 I guess for that reason.  Plus I need to wipe his image (it
> was a buyout from his company) and hence "if I have to spend for that, why
> not just spend a little more and get a new Dell Latitude."
>
> My question here:  I LOVE LOVE LOVE the SSD drives, but of course the 7200
> rpm drives are cheaper.  Would YOU spend the extra $$$ for the SSD drive
> (despite it also being smaller in size than the RPM drive)?
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_Ju=j0t36a3g3x0hn+b8svbjk4gzb2_x6iqkoc3t-ljb...@mail.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: "Source not available" -- seems to happen in the history of the list! (workaround found)

[Fernando D. Bozzo]

If the problem was on the PJX, then you could regenerate it from the pj2
text file, so you have a new PJX without any "noise".

The same applies to classlibs and forms, which sometimes have little
corruptions that do not throw errors, but sometimes produce strange
behaviours.

Well, all this just if you use FoxBin2Prg to generate the text files, which
are useful not only for Version Control, but for backup purposes.



2017-07-27 21:06 GMT+02:00 :

> I found a workaround.  I had a copy of the PJX/PJT from a year ago from a
> source code backup.  Works now.  Bottom line -- I think something wonky
> with the Project file.  Wonder if that weird quirk could lead to this wonky
> "ghosting" behavior they're seeing?  It's not consistent either.  Oh well.
> Onward.
>
> Ugh.
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_jumforhxwfdxgo5pde5xylvzqmio6shozfhffondwbr...@mail.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: Alternative to PROGRAM() and SYS(16,n)

[Fernando D. Bozzo]

Hi Paul:

>From inside the COM component (exe in this case), you can obtain the exe
name using sys(16,0
Another way can be using the class's ServerName property.



El 14 jul. 2017 10:16, "Paul Newton"  escribió:

Hi all

I want to find the path of the "master" EXE at some arbitrary point in code
- and I need it to work within a method of a class defined as OLEPUBLIC.
PROGRAM() and SYS(16,n) do not give me just the fully qualified path/name
of the master EXE.  I have come up with the following but I wondered
whether anybody can think of a better/simpler solution.  Thanks

=lASTACKINFO(laStackInfo)
Return laStackInfo(1,2)

Paul Newton

[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_JumNYQT9mr25ihaA3ATJ-LjD3wnT4EQSMBy2F2Q5=x+...@mail.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: frx to html conversion

[Fernando D. Bozzo]

@Mike:

The FOXOBJECT only applies wheh iterating over an object matrix, like
objects or controls or any object collection, not for iterating properties
or character arrays

In any case I did learn that it's always better to iterate using for i = 1
to x syntax, because normally you need to know the position of the item on
the array to do something else, even just logging what you have done on
which element or the like


El 20/6/2017 9:07, <mbsoftwaresoluti...@mbsoftwaresolutions.com> escribió:

> On 2017-06-19 12:15, Fernando D. Bozzo wrote:
>
>> Hi Paul:
>>
>> Just in case you didn't already think on possible setting's that can
>> affect
>> the performance heavily, and you keep looking what is different in VFP 9
>> that can make things so slow, I give you one that could be the
>> responsible:
>>
>> Using for..each for looping into a VFP object without using the new
>> keyword
>> FOXOBJECT
>> I think that it is the most important change that need a code change to
>> maintain compatibility.
>> If the for..each is for looping a com object, then no problem, but if the
>> object is a VFP object, then not having the FOXOBJECT keyword make VFP
>> treat the object as a com one, making it's access really slow
>>
>
>
>
> Just when I thought I couldn't learn anything more about VFP9you
> educated me on the FOXOBJECT keyword.  I often use FOR EACH loops, and
> they're ALWAYS fox objects.  I'll have to remember this tip.
>
> Thanks, Fernando!
> --Mike
>
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_JumEH37dvFzGsqpgAH=xbylkgkko2z0r4wzfmdtatvg...@mail.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: frx to html conversion

[Fernando D. Bozzo]

Hi Paul:

Just in case you didn't already think on possible setting's that can affect
the performance heavily, and you keep looking what is different in VFP 9
that can make things so slow, I give you one that could be the responsible:

Using for..each for looping into a VFP object without using the new keyword
FOXOBJECT
I think that it is the most important change that need a code change to
maintain compatibility.
If the for..each is for looping a com object, then no problem, but if the
object is a VFP object, then not having the FOXOBJECT keyword make VFP
treat the object as a com one, making it's access really slow



El 19/6/2017 2:55 p. m., "Paul Hemans"  escribió:

> Koen, honestly why I am using vfp8 is a long (frustrating) story. The short
> story is that I wrote a huge development environment with its own compiler,
> I won't bore you with the details :) suffice to say that I am not kidding
> when I say it is huge.
> It runs fine under vfp8, but under vfp9 something changed internally with
> the string handling. One of the features of the environment is that the
> compiler turns html with embedded vfp into classes. Under vfp9 this process
> runs incredibly slow. Under vfp8 an installation (which is when the
> compiling happens) takes about 20 minutes, under vfp9 it took 6 hours.
> I have spent a lot of time trying to sort it out. I have played with the
> memory settings and with the coverage trying to track it down and in the
> end, I hate to say it but it beat me.
>
>
>
> On Mon, Jun 19, 2017 at 10:36 PM, Koen Piller 
> wrote:
>
> > Paul,
> > upgrade to VFP9SP2 and make use of FoxyPreviewer.
> > FoxyPreviewer has different export/saving options, amongst HTML
> > Easy to use.
> > Why do you stick to VFP8 anyway?
> > Regards,
> > Koen
> >
> > 2017-06-19 1:03 GMT+02:00 Paul Hemans :
> >
> > > Is anyone aware of a utility that will take a vfp8 report .frx / .frt
> and
> > > convert it into some form of html template? To clarify, I am not
> looking
> > to
> > > run a vfp report and have it output in html.
> > >
> > > We need to take a number of fairly simple reports and permanently move
> > them
> > > to html. I expect to have to do some editing to clean them up.
> > >
> > > The application currently outputs pdfs from frx and they are presented
> on
> > > the web. However, to better support i18n the database is moving to
> > > Postgres, and the code to JS, that leaves a problem with the reports.
> > >
> > > Thanks.
> > >
> > >
> > > --- 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: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_Ju=u2ZxrR0A1Qs2xWTgOgyXYem8Cp9PnbeFb=nxzc6w...@mail.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: Running Multiple Instances of VFP 9

[Fernando D. Bozzo]

Well, in that case you can create a shortcut in every root dir project that
starts a vfp9.exe in this directory, so depending on which directory you
double-click the shortcut, the corresponding config.fpw is loaded.

I use something similar to this to open vfp9 sessions on different default
directories


El 13/5/2017 0:22, "Paul H. Tarver"  escribió:

> I guess the deal is that if I open VFP by clicking on a .PJX file, it seems
> to always open in the same dev environment, but if I open VFP by clicking
> on
> the VFP icon, I can get a new development environment. The challenge is
> that
> because I work on so many different projects I use unique config.fpw files
> to set the paths and other custom settings for each project. That means if
> I
> start the project from the folder where the config.fpw is located, all the
> settings are controlled by the config.fpw stored in that folder. However,
> if
> I start the program from the icon, it loads the standard default settings
> which are not necessarily what I need for each specific project.
>
> I think what I was really asking was whether there was a setting that would
> force VFP to open new projects in a new development environment. Kind of
> like right clicking on a link and choosing to open the page in a new tab or
> a new window.
>
> Paul H. Tarver
> Tarver Program Consultants, Inc.
> Email: p...@tpcqpc.com
>
>
>
> -Original Message-
> From: Richard Kaye [mailto:rk...@invaluable.com]
> Sent: Friday, May 12, 2017 2:21 PM
> To: profoxt...@leafe.com
> Subject: RE: Running Multiple Instances of VFP 9
>
> Sure. I do it all the time. It should just work unless you have your
> environment setup with some dependencies on exclusive access.
>
> --
>
> rk
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul
> H.
> Tarver
> Sent: Friday, May 12, 2017 3:19 PM
> To: profoxt...@leafe.com
> Subject: Running Multiple Instances of VFP 9
>
> Does anyone know if there is a way to run multiple instances of the VFP
> development environment on the same computer. I run into this need from
> time
> to time, but I've not taken a lot of time to research it.
>
> I know I can run multiple instances of a compiled VFP program, but every
> time I try to open multiple VFP projects, it simply brings the existing dev
> window forward and opens each project within the same development
> environment.
>
> Short of running virtual machines, is this even possible?
>
> Paul H. Tarver
> Tarver Program Consultants, Inc.
>   p...@tpcqpc.com
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_Jum9zQGizrQOZo3PEyueXaJ6PgR1Py5fr=v+a_ygzdp...@mail.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: Running Multiple Instances of VFP 9

[Fernando D. Bozzo]

I use multiple sessions all the time.
Normally in one session I do the programming/compuling and have some
projects open, and in the other I only run/debug those programs, so If a
hang occurs, the project and classes are not affected and just open and
run/debug again.

I use even 2 vfp sessions for each project that resides in a different
directory. Same schema, 1 for dev/compile and 1 for run/debug



El 12/5/2017 9:20 p. m., "Paul H. Tarver"  escribió:

> Does anyone know if there is a way to run multiple instances of the VFP
> development environment on the same computer. I run into this need from
> time
> to time, but I've not taken a lot of time to research it.
>
>
>
> I know I can run multiple instances of a compiled VFP program, but every
> time I try to open multiple VFP projects, it simply brings the existing dev
> window forward and opens each project within the same development
> environment.
>
>
>
> Short of running virtual machines, is this even possible?
>
>
>
> Paul H. Tarver
> Tarver Program Consultants, Inc.
>   p...@tpcqpc.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: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_JunBfdezpwjD0Lzk05xSJpmXcmxvYseeanb6C=zlr9y...@mail.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: Getting count of rows in a text file -- best approach?

[Fernando D. Bozzo]

Forget my comment, I've tested it and works beautifully :)





2017-04-28 15:24 GMT+02:00 Fernando D. Bozzo <fdbo...@gmail.com>:

> Gianni, you skipped something very important, the part that skip the lines
> so the Line property is updated:
>
> 'Skip lines one by one Do While txsInput.AtEndOfStream <> True
> txsInput.SkipLine ' or strTemp = txsInput.ReadLineLoop
>
>
>
> 2017-04-28 15:08 GMT+02:00 Gianni Turri <gianni...@gmail.com>:
>
>> On Thu, 27 Apr 2017 17:12:49 +0200, "Fernando D. Bozzo" <
>> fdbo...@gmail.com> wrote:
>>
>> >Hi Mike:
>> >
>> >A very fast method is using the FileSystemObject:
>> >
>> >loFSO = CREATEOBJECT("Scripting.FileSystemObject")
>> >loFile1 = loFSO.OpenTextFile(lcArchivo1, 1)
>> >
>> >Look at the syntax on Microsoft web site for the read method.
>> >It does not have the limitation of VFP's fread/fgets
>>
>> loFSO = createobject("Scripting.FileSystemObject")
>>
>> loFile = loFSO.OpenTextFile(m.filename, 8, .f.)
>> ? loFile.Line -1
>>
>> This method overcome VFP memory / file size limits.
>>
>> Source:
>> http://stackoverflow.com/questions/7416553/function-to-count
>> -number-of-lines-in-a-text-file
>>
>> --
>> Gianni
>>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_Jumn7d5vAYK69Firt3Mkgw86my08E2dYYW-yteCw_XH=u...@mail.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: Getting count of rows in a text file -- best approach?

[Fernando D. Bozzo]

Gianni, you skipped something very important, the part that skip the lines
so the Line property is updated:

'Skip lines one by one Do While txsInput.AtEndOfStream <> True
txsInput.SkipLine ' or strTemp = txsInput.ReadLineLoop



2017-04-28 15:08 GMT+02:00 Gianni Turri <gianni...@gmail.com>:

> On Thu, 27 Apr 2017 17:12:49 +0200, "Fernando D. Bozzo" <fdbo...@gmail.com>
> wrote:
>
> >Hi Mike:
> >
> >A very fast method is using the FileSystemObject:
> >
> >loFSO = CREATEOBJECT("Scripting.FileSystemObject")
> >loFile1 = loFSO.OpenTextFile(lcArchivo1, 1)
> >
> >Look at the syntax on Microsoft web site for the read method.
> >It does not have the limitation of VFP's fread/fgets
>
> loFSO = createobject("Scripting.FileSystemObject")
>
> loFile = loFSO.OpenTextFile(m.filename, 8, .f.)
> ? loFile.Line -1
>
> This method overcome VFP memory / file size limits.
>
> Source:
> http://stackoverflow.com/questions/7416553/function-to-
> count-number-of-lines-in-a-text-file
>
> --
> Gianni
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_jum2sv-y3owtuh8otvctzuzheqef-2oce0mtxil4ywd...@mail.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: Getting count of rows in a text file -- best approach?

[Fernando D. Bozzo]

Yeah, and did you try reading a +1GiB txt file? ;-)



El 28/4/2017 12:22, "Laurie Alvey" <trukke...@gmail.com> escribió:

> Have you thought about the ALINES() function?
>
> Laurie
>
> On 27 April 2017 at 16:12, Fernando D. Bozzo <fdbo...@gmail.com> wrote:
>
> > Hi Mike:
> >
> > A very fast method is using the FileSystemObject:
> >
> > loFSO = CREATEOBJECT("Scripting.FileSystemObject")
> > loFile1 = loFSO.OpenTextFile(lcArchivo1, 1)
> >
> > Look at the syntax on Microsoft web site for the read method.
> > It does not have the limitation of VFP's fread/fgets
> >
> > Regards
> >
> > El 21/4/2017 4:45 p. m., <mbsoftwaresoluti...@mbsoftwaresolutions.com>
> > escribió:
> >
> > > VF9SP2
> > >
> > > Currently, I'm simply doing this for now:
> > >
> > > RowCount = OCCURS(CHR(13),FILETOSTR(m.Filename))
> > >
> > > Is there a better (read: FASTER) way?  These are tab delimited text
> files
> > > so I can't really use FSEEK or FSIZE(m.Filename) (which requires SET
> > > COMPATIBLE ON) because I can't be sure of each record's length.
> > >
> > > tia,
> > > --Mike
> > >
> > >
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_jukezybcdz3etb1qvnsp5yjs0uz0s7pqgnpwtymogvh...@mail.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: Getting count of rows in a text file -- best approach?

[Fernando D. Bozzo]

Hi Mike:

A very fast method is using the FileSystemObject:

loFSO = CREATEOBJECT("Scripting.FileSystemObject")
loFile1 = loFSO.OpenTextFile(lcArchivo1, 1)

Look at the syntax on Microsoft web site for the read method.
It does not have the limitation of VFP's fread/fgets

Regards

El 21/4/2017 4:45 p. m., 
escribió:

> VF9SP2
>
> Currently, I'm simply doing this for now:
>
> RowCount = OCCURS(CHR(13),FILETOSTR(m.Filename))
>
> Is there a better (read: FASTER) way?  These are tab delimited text files
> so I can't really use FSEEK or FSIZE(m.Filename) (which requires SET
> COMPATIBLE ON) because I can't be sure of each record's length.
>
> tia,
> --Mike
>
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_jumz+u+fpxu5dh64c0sbyffts+t4y8gyk+0ax74qtmp...@mail.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: Codeplex is shutting down, VFPX.org is spinning up

[Fernando D. Bozzo]

Yes, I mean the auto-update feature of the projects.




2017-04-26 20:39 GMT+02:00 <mbsoftwaresoluti...@mbsoftwaresolutions.com>:

> You mean so that it's still self-updating?
>
>
> On 2017-04-26 12:01, Fernando D. Bozzo wrote:
>
>> I suppose that it will need some rework to work with Github
>>
>>
>> El 26/4/2017 5:59 p. m., <mbsoftwaresoluti...@mbsoftwaresolutions.com>
>> escribió:
>>
>> On 2017-03-31 20:51, Fernando D. Bozzo wrote:
>>
>> No shit... moving all the projects will be a hard. Binaries, version
>>> history, documentation, bye bye Thor :_(
>>>
>>>
>>
>> Why would you say "bye bye Thor" ??
>>
>>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_JunpBdD-OWM8fRSgyR0JHFxD4-QBLyOv=CN1=PgSYFJu=q...@mail.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: Codeplex is shutting down, VFPX.org is spinning up

[Fernando D. Bozzo]

I suppose that it will need some rework to work with Github


El 26/4/2017 5:59 p. m., <mbsoftwaresoluti...@mbsoftwaresolutions.com>
escribió:

On 2017-03-31 20:51, Fernando D. Bozzo wrote:

> No shit... moving all the projects will be a hard. Binaries, version
> history, documentation, bye bye Thor :_(
>


Why would you say "bye bye Thor" ??


[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_junzn1ugxdo+pj3ccwh-liuxj4bh413mdexm0blkf8b...@mail.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: Retrospective properties - the magic of inheritance

[Fernando D. Bozzo]

In my experience, that's bad design.

If you need geniuses to modify that, then that's mean that it's not
intended to be maintained by someone else, so expect a high cost of
maintenance, and pray that those devs don't let you down.


El 10/4/2017 12:14, "Peter Cushing"  escribió:

>
> On 08/04/2017 00:50, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
>
>> I've always tried to never go more than 3 deep.  My corporate gig has me
>> digging 11+ levels at times.  Needless to say, it's an "Excedrin moment"
>> when I have to debug that.  The developers are of a genius level--really,
>> so GREAT minds--but I don't like the complexity cost.  I'd rather slightly
>> less than lightspeed performance if it means easier code maintenance.
>>
> If you have to go up to 11 levels deep in classes I can't see you getting
> light speed performance.  I could be wrong but have heard of other apps
> heavily subclassed having speed problems.  That would mean you have an app
> that is hard to debug and not that fast.
>
> I have classes (toolbars and other controls) that are on several forms so
> I can re-use the functionality, but 11 levels deep?   What could possibly
> be that complex?
>
> Peter
>
>
>
> 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:17-19 Foley Street, London W1W 6DW 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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_junzk8p3krcm01w2rtoy84wzsyjugkprpqktgowp1wt...@mail.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: What's your SET ANSI setting? (VFP9SP2)

[Fernando D. Bozzo]

I use it OFF, but then I make exact comparisons using == and using the full
length of the field, not just the length of the string.

In example, if the field is C(20) and the string is "word", I first assign
PADR(lcString, 20) and then I search it, so I make it independent of SET
ANSI.



El 8/4/2017 1:20 a. m., 
escribió:

> Just ran across an instance where I had SET EXACT ON but didn't specify
> SET ANSI (for which the default is OFF).  After seeing a query for CHICAGO
> contain results including others like CHICAGO HEIGHTS, I investigated and
> thought my SET EXACT was OFF.  Nope, it was ON but my SET ANSI was OFF.
> Setting it to ON gave me the results I wanted.
>
> I'm just surprised this never bit me in all my years doing VFP; I guess
> because I've usually been using a RDBMS (like MySQL/MariaDB).
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_Ju=2lc3z4rhfoy1kkzvmp5pfst8yka9eakza+t9batg...@mail.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: Codeplex is shutting down, VFPX.org is spinning up

[Fernando D. Bozzo]

This is true, if a project is stable then could be no commits in a long
time.





2017-04-05 21:00 GMT+02:00 Gene Wirchenko :

> At 01:07 2017-04-03, Alan Bourke  wrote:
>
>> On Fri, 31 Mar 2017, at 09:07 PM, Ted Roche wrote:
>> > You can always count on Microsoft...
>> >
>> > ... to let you down.
>>
>> Less than 350 projects had a commit in the last 30 days - sounds to me
>> like it's the user base letting itself down, or already moving elsewhere
>> for whatever reason.
>>
>
>  OTOH, if a project is complete, how many commits is it likely to get?
>
> Sincerely,
>
> Gene Wirchenko
>
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_Jumfwp5bBHMa+ihbtg=AFT1+9KDmw5=mcgtdjbcydu4...@mail.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: Codeplex is shutting down, VFPX.org is spinning up

[Fernando D. Bozzo]

No shit... moving all the projects will be a hard. Binaries, version
history, documentation, bye bye Thor :_(




2017-03-31 22:07 GMT+02:00 Ted Roche :

> You can always count on Microsoft...
>
> ... to let you down.
>
> Codeplex is shutting down:
>
> https://blogs.msdn.microsoft.com/bharry/2017/03/31/shutting-down-codeplex/
>
> The wise Rick Schummer and company registered vfpx.org, so stay tuned
> for migration news.
>
> --
> Ted Roche
> Ted Roche & Associates, LLC
> http://www.tedroche.com
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_jukaajgbu7wzipsb-e3hyqm47_c918eb9td-b0vc-pm...@mail.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: Retrospective properties - the magic of inheritance

[Fernando D. Bozzo]

Yes, that work, but take care of using more than 3 subclass levels, because
sooner or later you could start having a nightmare with code maintenance
and even strange errors. VFP doesn't always do a very good job with many
subclass levels.


El 31/3/2017 16:22, "Paul Newton"  escribió:

> Hi all
>
> Let's say I have five classes (Class1, Class2  etc.) and that each class
> is a subclass of the one before it (class2 is a subclass of class1, class3
> is a subclass of class2 etc.)
>
> Now let's suppose that I have added a custom property (e.g. "MyProperty")
> to class3 and set its value to "Property3".  At this point class4 and
> class5 will inherit the property MyProperty with the value "Property3".
>
> Now I add the custom property MyProperty to class1 and set its value to
> "Property1" and everything is just fine.
>
> Now class2 will inherit the property MyProperty with the value "Property1"
> and classes class3, class4, class5 will inherit the property MyProperty
> with the value "Property3".
>
> I think that's great and potentially very useful because it means I can
> create a property at the top of the hierarchy without having to worry about
> whether a property of the same name has already been defined lower down the
> hierarchy.
>
> Paul Newton
>
[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: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_junuv_zrq6kkx_9yizmuux9b8xpw65y61cvpgv7w-hb...@mail.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: Modless form out of top-level form

[Fernando D. Bozzo]

If you define the inner form as to show "in a top level form", if you
configure it with desktop=.T. I think that you can do it


El 3/3/2017 11:44, "Man-wai Chang"  escribió:

Given a g_form as top-level form in READ EVENTS, could a new modeless
form be popped out of the top-level form, possibly without
_SCREEN.visible?

Do I need to play with MDI forms?

g_form=Createobject("myform")
DO case
 CASE Type("g_form")="O"
 Set Sysmenu To _Msm_edit
 g_form.Show()
 Read Events

ENDCASE


--
 .~. Might, Courage, Vision. SINCERITY!
/ v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3)
/( _ )\ 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: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagq_jumwbahx30gbrkonrjs6hc3putfwsqssz46u6ujdmip...@mail.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: Hard-Coded Scalar Value Substituted at Run Time

[Fernando D. Bozzo]

Hi Ken,

Seems a difficult one to trace, but just in case I give you some ideas
based on personal experience with strange errors:

* The info collected on the error rutine, put it in a try/catch that adds
info to a var in a step by step basis, so you later can log it to a file.
Must be bomb proof. I've once found an error there when iterating tge stack
array, with some fields that normally are null but somerimes are not. In
any case, an error there must not hide the real error.

* Do not trust UI controls to call or not a method, add validation in the
methods called from UI so even if you call them from VFP command line, if a
condition is noot meet, the method is not executed. Normally can be done an
enabled_funtionallity() like method that can be used by the UI to
enable/disable controls and the same method can be used on the business
methods for the same goal.

In the worst situation, you can generate log info in real time while the
user is working, and save it into a table with info about controls used
(important events like click), screens loaded/unloaded, some meaning
variables and timer events may be, to have some context about executed
order.
Analyzing it later can give you some inside about how the user interacts
with your app.

Once, many years agi, a user notified a bug on which when loading the main
screen all comboboxes where blank.
Tired of not finding the bug days later I did go with the user to watch him
while entering in the app. And found that the user while the app was
loading did hit enter, enter, enter, enter,., many times to bypass the
log screen, but all that enter keystrokes where present in the keyboard
buffer, what caused the comboboxes to not show their default options.
Solution was a clear typeahead before showing the UI :D


El 2/3/2017 5:58 p. m., "Ken Dibble"  escribió:

> To follow up from yesterday evening, now that I'm back at work:
>
> The code in question is a FOR ... ENDFOR loop that iterates an array, with
> the loop limiting value being the number of rows in the array, and there is
> nothing within that loop that removes or adds rows or columns to the array.
>
> It's just:
>
> FOR m.x = 1 TO ALEN(THISFORM.oMail.aSortList,1)
>   thekey = THISFORM.oMail.aSortList(m.x,10)  && "array dimensions
> invalid"
>
>   ** More inoffensive code here.
> ENDFOR
>
> As I've said, I can't reproduce this error myself but I've seen it
> reported by my error handler twice in two days. So I don't know if the
> iteration failed on the first row or some later row of the array.
>
> As I mentioned earlier, my initial assumption that the array was supposed
> to have 5 columns was incorrect, because I was looking at the wrong control.
>
> I've now verified that in this case, when the problem code executes, this
> array can only contain 10 columns:
>
> 1. It is a predefined property of the oMail object (based on the Custom
> class, and defined in a .prg file) and is DIMENSIONed as (1) at the outset.
>
> 2. It is then populated by a SELECT [10 specified fields] FROM [variable
> table/cursor] ... INTO ARRAY expression with no WHERE clause.
>
> 3. Although the name of the FROM table or cursor is variable, the
> specified fields are not, and the expression does not use AS clauses to
> change the names of the result fields or supply default values for them.
> Therefore, if a specified field did not exist in the FROM table, an error
> would be generated at that point. No such error occurs.
>
> 4. It is not possible for the FROM table to contain no records when the
> offending code executes, because in that case the code that generates the
> FROM table would display a message for the user stating that the query
> produced no results and all of the related controls on the form would be
> disabled. As a result, the method containing the SELECT ... INTO ARRAY
> expression would not be called, the list control's array rowsource would
> contain no records, and the list control's sort method, where the error
> occurs, would not be called.
>
> So I am confident that the array can only have 10 columns (no more and no
> less) at the point where the error is generated.
>
> Thus the only "possible" sources of an "array dimensions invalid" error,
> if the error did indeed occur on the line indicated by the trace, would be:
>
> 1. The SELECT ... INTO ARRAY expression somehow generated fewer columns
> than were specified in its field list.
>
> 2. The user was somehow able to induce one of the disabled GUI controls to
> somehow call the sort method when there was no data to sort.
>
> 3. ALEN() returned an incorrect result as to the number of rows in the
> array during the iteration loop.
>
> All of those things should be impossible.
>
> The third possibility is that the trace provided by ASTACKINFO() is wrong.
> In my application I frequently do see very strange things with error
> traces, such as several levels of code that should be in the stack not
> being reported. I have