VFP and SSO

[Desmond Lloyd]

Good morning.   Is it possible to integrate SSO with VFP apps?

Would appreciate any input...

Regards,
Desmond


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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/CAAJXvaMhi7D6w4PdUYb+Sph+ki4Y0Z=tcw01zluwlum1po0...@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 9: Invalid Path or File Name

[Desmond Lloyd]

Good Morning,

I wound up doing the copy thing!   Wrote the file using a different name
and then renamed it  That did the trick.   I will definitely look at
the possibility of an arinvt variable

Thank You/Regards,
Desmond



On Mon, 16 May 2022 at 03:36, Richard Quilhot  wrote:

> Also look at using the Safety setting.
> https://hackfox.github.io/section4/s4g170.html
>
> Rick Q
> quilh...@gmail.com
>
>
>
> On Mon, May 16, 2022 at 4:14 AM Alan Bourke 
> wrote:
>
> > On Sun, 15 May 2022, at 2:53 PM, Desmond Lloyd wrote:
> >
> > > if I change the file name after throwing the error the copy
> > > executes just fine if I run the copy again it fails???
> >
> > So at the point of failure if you try to re-execute the COPY TO with the
> > intended filename in the Command Window and it fails also?
> >
> > Is there a hidden ARINVT01.TXT in the output location ?
> >
> > Try
> >
> > erase "output\arinvt01.txt"
> > copy to yada yada
> >
> >
> >
> > --
> >   Alan Bourke
> >   alanpbourke (at) fastmail (dot) fm
> >
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/CAAJXvaPaJ624q=tipfztxq3d2dw2z5iuvwt96hpoukv-v5m...@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 9: Invalid Path or File Name

[Desmond Lloyd]

Good morning,

Thank you for the earlier suggestion

Have tried both quotes and macro substitution and still get the error

When running tthe procedure there are 14 files opened.   The first
statement that uses a copy to a delimited file starts with a select
statement and then the copy

copy to output\womast01.txt type delimited with " with character |
select arinvt01
copy to output\arinvt01.txt type delimited with " with character |

The first copy works fine,   the second statement throws the error..  Now
get this,  if I change the file name after throwing the error the copy
executes just fine if I run the copy again it fails???

Windows 10 64-bit.  Programs are on the network,  running VFP9 from my
local machine.

Am also considering:
1.)  The VFP I'm using was recently installed,  so am going to run from a
remote machine I have to see what happens.
2.)  An alternative method.
3.)  Pathing error...  I set the folder where the fxp file resides as
default (I use set default to getdif())

Hopefully what I have presented makes sense!


On Fri, 13 May 2022 at 03:34, Dave Crozier  wrote:

> Desmond,
> Either as Alan says or:
>
> cName="arinvt01.txt"
> copy to (cName) type delimited with character |
>
> Dave Crozier
> Software Development Manager
> Flexipol Packaging Ltd.
>
> Mob: 07967 671080
>
> ﴾⚆ᨎ⚆﴿
>
>
>
> Flexipol® Packaging Ltd
> T 01706 222 792
> E dcroz...@flexipol.co.uk
> W https://www.flexipol.co.uk/
> Follow us:
> Unit 14 Bentwood Road, Carrs Industrial Estate, Haslingden, Lancashire,
> BB4 5HH
>
> ​This communication and the information it contains is intended for the
> person or organisation to whom it is addressed. Its contents are
> confidential and may be protected in law. If you have received this e-mail
> in error you must not copy, distribute or take any action in reliance on
> it. Unauthorised use, copying or disclosure of any of it may be unlawful.
> If you have received this message in error, please notify us immediately by
> telephone or email.
>
> Flexipol Packaging Ltd. has taken every reasonable precaution to minimise
> the risk of virus transmission through email and therefore any files sent
> via e-mail will have been checked for known viruses. However, you are
> advised to run your own virus check before opening any attachments received
> as Flexipol Packaging Ltd will not in any event accept any liability
> whatsoever once an e-mail and/or any attachment is received.
>
>  It is the responsibility of the recipient to ensure that they have
> adequate virus protection.
>
>
> -
> ​​
> ​Terms & Conditions:
>  Notwithstanding delivery and the passing of risk in the goods, the
> property in the goods shall not pass to the buyer until the seller Flexipol
> Packaging Ltd. ("The Company") has received in cash or cleared funds
> payment in full of the price of the goods and all other goods agreed to be
> sold by the seller to the buyer for which payment is then due. Until such
> time as the property in the goods passes to the buyer, the buyer shall hold
> the goods as the seller's fiduciary agent and bailee and keep the goods
> separate from those of the buyer and third parties and properly stored
> protected and insured and identified as the seller's property but shall be
> entitled to resell or use the goods in the ordinary course of its business.
> Until such time as the property in the goods passes to the buyer the seller
> shall be entitled at any time
> -Original Message-
> From: ProFox  On Behalf Of Alan Bourke
> Sent: 13 May 2022 09:02
> To: profoxt...@leafe.com
> Subject: Re: VFP 9: Invalid Path or File Name
>
> Try wrapping the filename in quotes.
>
> --
>   Alan Bourke
>   alanpbourke (at) fastmail (dot) fm
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/caajxvamqhxzyzlba6nkfp0uz3w__y50ap9sf07hmu3cr_p9...@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.

VFP 9: Invalid Path or File Name

[Desmond Lloyd]

Have some code that does this:

select arinvt01
copy to arinvt01.txt type delimited with * with character |

If I try to execute I get the nasty Invalid Path or File Name! message

If i take out the "01" from  the copy to,  it works

Windows 10, Network Drive'

Possible pathing issue?

TIA Everyone,
Regards,
Desmond


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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/CAAJXvaPeT9s=y4ta4d5hxkh1he1ioamtjzrudl+8uh5dpky...@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: My memo field(s) Are Bloated......

[Desmond Lloyd]

Thanks everyone   Had thought of a separate file for each key
field/Memo field.   Surely this should help with performance.   Have
thought  about doing something like that for years!

Regards,

Desmond



On Mon, 5 Oct 2020 at 15:59, MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> On 10/5/2020 2:30 PM, Charlie wrote:
> > 
> > Or, create additional tables, 1 memo field each (assuming your 8 memo
> > fields hold roughly equivalent amounts of data). Then link them back
> > to the main table - aka main tables primary key. Of course, this would
> > impact your data queries when pulling data. And if you really need all
> > 8 memo fields every time you pull data, this approach will probably
> > hurt performance (8 joins - very fast, but not as fast as pulling from
> > 1 table).
> >
>
> I sometimes think the "penalty" for such an approach is negligible.
> Anyone have experience on that?  I mean, if you get results in 1.5
> seconds compared to 1.2 secondsis that really a big deal?  Even 8
> seconds vs. 7 seconds.  You get my drift.
>
>
> --
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
>
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/caajxvapdjes2e8jgqfj+sunlam6gmmk2r39zte8wqwtcu1g...@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: My memo field(s) Are Bloated......

[Desmond Lloyd]

Fascinating,  original size of the DBF 710448
original size of fpt: 1276848

selecting * from the tabl3
DBF = 710448
FPT =  923354

A drop in the size of the fpt of 353492.. Could i rename the "selected" FPT
and use it.   I treid a pack memo and there no change in thesiz of the FPT?

Regards,
Desmond

/

On Mon, 5 Oct 2020 at 09:06, Tracy Pearson  wrote:

> When you select * to a temp table. What is the size of the files?
> You'll know quickly if you have bloat.
>
> HTH,
> Tracy
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> Desmond
> Lloyd
> Sent: Monday, October 05, 2020 9:49 AM
> To: profoxt...@leafe.com
> Subject: My memo field(s) Are Bloated..
>
> Good Morning!
>
> Have a very wide dbf with about 8 memo fields .   Started
> acteing strange like if I tried to re-index or pack memo it would seem to
> go so far and then freeze!
>
> Found a utility that seemed to repair the file.  The only issue is that the
> DBF is 710mb and the associated memo file is 1.2gb!  Yikes.  Have ran a
> pack memo (with no  issues) and there is no change in the size of the memo
> file,  which I am assuming is boated.
>
> 1.)  Is the memo file really bloated.
> 2.)   Going to look at the individual memo fields and see if any one of the
> records has an unusually large memo field.
> 3.)  Open to any other suggestion that you wise people could recommend
>
> TIA/Regards,
> Desmond
>
>
> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
>   text/plain (text body -- kept)
>   text/html
> ---
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/CAAJXvaN65s_FjTXUv_S-497txp3_5sw0LPwQm0Ze0+jH0uG=d...@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.

My memo field(s) Are Bloated......

[Desmond Lloyd]

Good Morning!

Have a very wide dbf with about 8 memo fields .   Started
acteing strange like if I tried to re-index or pack memo it would seem to
go so far and then freeze!

Found a utility that seemed to repair the file.  The only issue is that the
DBF is 710mb and the associated memo file is 1.2gb!  Yikes.  Have ran a
pack memo (with no  issues) and there is no change in the size of the memo
file,  which I am assuming is boated.

1.)  Is the memo file really bloated.
2.)   Going to look at the individual memo fields and see if any one of the
records has an unusually large memo field.
3.)  Open to any other suggestion that you wise people could recommend

TIA/Regards,
Desmond


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

___
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/caajxvao+0c8wcerza4-7o0o-yp8naihf1j9ebhwcewu4pd0...@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.

ODBC for VFP Tables

[Desmond Lloyd]

Need to add the FoxPro ODBC drivers on a server (2012R2) and they do not
show uip on the list.  Is there a way to add the 32 and 64 bit drivers for
VFP Tables?

TIA,
regards,
Desmond


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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/caajxvancte0eldsgyu65jl-1wgywxgyh575j95swmh3rgne...@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: Decompile FoxPro Windows 2.6?

[Desmond Lloyd]

Won't ReFox decompile an exe?   I just checked their website it says it
does.   I have ReFox installed I can give it a shot if you would like?
(only used with VFP6 & VFP9)

Regards,
Desmond

On Thu, 23 Apr 2020 at 08:17, Ted Roche  wrote:

> A charitable service organization have a custom FPW 2.6 EXE they use for
> some calculations and inventory, and are desperate to get it working on
> something more recent than Windows XP. So far, no source code has turned
> up.
>
> What's out there that would let me decompile an FPW 2.6 EXE?
>
> I'm donating my time on this, so free would be nice, but I'll spend a few
> $$$ if needed.
>
> Ideas?
>
> --
> 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: 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/CAAJXvaN6Gs2e05Ov-u7sN-5N5CmAztQ9D+7mgX8yA5=4nib...@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.

VFP6 and VFP9 Legacy Application Support Help

[Desmond Lloyd]

I had posted this a few months ago and had received several responses,  to
those people I apologize for not getting back to you

I support an application called Quick Aviation.  It is a VFP application
based on SBT Accounting and designed for by Aerospace MRO shops.
Essentially our customer sends a part for a jet engine and we will
repair,   overhaul or test the part based upon  Similar to  ERP with the
exception that we never know what parts will be needed.

Quick Aviation was independently written and we bought the code.   As you
can imagine there have been all sorts of enhancements and custom reports
written.  Originally written for FoxPro for Windows it runs under VFP6,
with a great deal of additional reports and "add-ons" being written in VFP9.

We have approximately 150 users on the system.  Being ran on a VMWare
virtual server.
We ship thousands of parts per month and typically have over 2,000 orders
in process.

Since I am the only person supporting the application and we are part of a
very large aerospace concern,  management is concerned with it's
"stability" and ability to grow with the business. (We all know there
should be no issues with that!)  Also they want to insure that the
application is fully is properly supported.

Am not sure how this would be setup,  but I would envision having a person
available to provide support,   user requested enhancements and report
writing.   Perhaps some sort of monthly fee with additional fees for
completed projects.

Not sure how long this would last,  management is eyeing one of the big ERP
packages.  Our users like Quick  Aviation .

Would appreciate any additional feedback,  plus am interested as to how
other organizations might handle this situation

TIA,
Desmond


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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/caajxvapp78dkrijwdkunrshsdvqncr+x+jvztvmqsvjacta...@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.

VFP9 App: Running VFP executable using UNC

[Desmond Lloyd]

My app has always ran from a mapped drive.  Pathing was set "Relatively".
Worked fine for years.  If I create a shortcut pointing to the executable
using the UNC it runs but won't open the first table.  So I modified the
project so that I would use that relative path for that table and it works!
Including the opening all the other tables.

Does that make sense?

TIA,
Desmond


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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/CAAJXvaP=kfjfvoxtam3q+ft-tegkjv1p-h7ywdpef5-fyvt...@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.

VFP9 App: Running on Windows 7 and Windows 10

[Desmond Lloyd]

Have an issue with an application.   They are reporting that when running
under Windows 10 (Pro) the app is intermittently crashing,  while the
Windows 7 machines are running just fine.

Am supporting another app using both OS's and works fine.

Not even sure at what I should look at.   Am reviewing the tables for any
oddities,

Any suggestions/thoughts?
TIA,
Desmond


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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/CAAJXvaOfSB3ee6t=F5jhGJSZc8Mxd828O=1bugkwzv0cmmo...@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 Application Support

[Desmond Lloyd]

Initially not much.  Perhaps a few hours a month initially.   I am
providing all the support and upgrades.   We want to insure that if I get
hit by a bus we have a resource to turn to maintain the system.   Any
experience with Manufacturing Systems,  Accounting,   Aerospace?

Thoughts?
Regards,
Desmond


On Wed, 18 Sep 2019 at 15:25, MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> Hi Desmond,
>
> How much time does it require?  I'm available if not too much.  I took
> over some of Jeff Johnson's work when he passed away.
>
> Thanks,
> --Michael
>
>
> On 9/18/2019 4:22 PM, Desmond Lloyd wrote:
> > Good afternoon,
> >
> > Am attempting to reach out and locate some potential
> > contractors/programmers that could provide support for VFP based legacy
> > system.
> >
> > The system is over 20 years old and is currently supported by one
> in-house
> > programmer.
> >
> > Would someone please recommend some potential contacts.  We are located
> in
> > the Dallas/Fort Worth area in North Texas but I can see no reason as  to
> > why it could not be supported remotely.
> >
> > TiA,
> > Regards,
> > Desmond
> >
> >
> > --- StripMime Report -- processed MIME parts ---
> > multipart/alternative
> >text/plain (text body -- kept)
> >text/html
> > ---
> >
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/caajxvapq2dxhqsfv8s-h6k_waewd0aquveigdrn7zualrmg...@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.

VFP Application Support

[Desmond Lloyd]

Good afternoon,

Am attempting to reach out and locate some potential
contractors/programmers that could provide support for VFP based legacy
system.

The system is over 20 years old and is currently supported by one in-house
programmer.

Would someone please recommend some potential contacts.  We are located in
the Dallas/Fort Worth area in North Texas but I can see no reason as  to
why it could not be supported remotely.

TiA,
Regards,
Desmond


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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/caajxvaozs41bqdfbfslli40v7_bgw-4fxnbjxsw3cihtvs+...@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: VF9: Exporting a Memo Field to Excel

[Desmond Lloyd]

Thank you!

On Tue, 30 Apr 2019 at 12:48, Tracy Pearson  wrote:

> I've not done this. I understand there isn't a VFP command that will do it.
> You need to either use Automation of another tool such as XFRX or
> SweetPotatoSoftware FLL that read/writes Excel files.
> I don't know that either will, nor if they have an example if they do.
>
> Maybe someone else will chime in.
>
> HTH,
> Tracy
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> Desmond
> Lloyd
> Sent: Tuesday, April 30, 2019 1:01 PM
> To: profoxt...@leafe.com
> Subject: VF9: Exporting a Memo Field to Excel
>
> Does anyone have a quick and easy way to export a memo field(s) into Excel?
>
> TIA/Appreciate the help.
> 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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/caajxvanwjavk219ektpdvd-o6q+0j55z0u5m2wguov1rr7k...@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.

VF9: Exporting a Memo Field to Excel

[Desmond Lloyd]

Does anyone have a quick and easy way to export a memo field(s) into Excel?

TIA/Appreciate the help.
Regards,
Desmond


--- 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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/caajxvaovzg09rk9631xud5ysvdzmpkoube1jv874q2qbeuc...@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: File Access Issues

[Desmond Lloyd]

Old "legacy" VFP application running under a "VM" environment.   Been
running this way for at least four years.  However,  as of late I am seeing
intermittent "File Read Errors" when a table is used/opened.  Completely
random and intermittent.   Reboot the workstation and they are good.   My
biggest issue,  of course,  is it getting worse  Yikes.  Actually I'm
about to replace a current hardware with a new server and storage devices.
We shall see...

No corruption to indexes,  normal amount of memo field bloat etc.

HTH,
Desmond


On Thu, 21 Mar 2019 at 04:42, Chris Davis  wrote:

> We are seeing increasing problems with VFP applications (some of our own
> and other commercial ones) as our customers have their servers upgraded.
>
> A lot of these servers are now virtual machines hosted on a physical
> machine.  In some instances these are remote desktop servers which access
> the VFP data from a different server.
>
> The file access issues seem to be random, in some instances the indexes
> get corrupted and need to be repaired.
>
> Anti Virus has been ruled out by uninstalling it, but the problems persist.
>
> Any ideas? Any issues with VFP data and VM's?
>
> Regards
>
> Chris.
>
>
> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
>   text/plain (text body -- kept)
>   text/html
> ---
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: 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/caajxvamqaadylppvjcers7zzwuyavtmunuzbkui1vlkckjg...@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.

VF9 - Running an app on a schedule....

[Desmond Lloyd]

Have a small app that queries a table,  pus it in a spreadsheet and emails
it out.  Worked fine for several months using the Windows Task Scheduler.
Now all of a sudden it's refusing to run the app.  If I run it from outside
of the schedule it works fine!

Is there a way to run the app using another VFP app?

TIA,
Desmond


--- 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/caajxvamqpj5oay8wnwqabfsyy_onnxbxebd0u6ikonsy4os...@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: [OT] Nothing runs like the Fox

[desmond . lloyd]

Hang in there! Had both of mine replaced last year! My doctor’s name was 
Pepper!  

You’ll be back to normal in no time! 

Best regards,
Desmond

Sent from my iPhone

> On Feb 23, 2019, at 9:20 AM, Ed Leafe  wrote:
> 
> Ok, this is a stretch, but this past Monday I had my left knee replaced. It's 
> a long story [0], but I got a kick out of the fact that my surgeon's name was 
> Fox! [1]
> 
> So while I'm not running like a Fox yet, I'm progressing better than I could 
> have hoped for, and should be running within a few months.
> 
> 
> [0] https://blog.leafe.com/out-with-the-old/
> [1] https://www.drfoxortho.com/
> 
> -- 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/a0b24ec3-7824-43e0-a6fa-bd1775c0a...@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.

Silly VFP9 Issue....

[Desmond Lloyd]

This is really silly,  never the less...  Recently have installed VFP9 on
a  new computer (Windows 10).   Whenever I do a display stru the columns
are super wide and wrapped??

Have looked at my other installs and for the life of me cannot find what I
need to adjust/change?  (they display fine by the way)

Does anyone remember how to fix this?

Regards,
Desmond


--- 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/CAAJXvaO=fmvsnzyqs8nobhczdaon2kx3c_uibqt_ysv6xy+...@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.

VFP: Using ODBC to connect to a VFP Table...

[Desmond Lloyd]

Would someone mind answering this question please   my company is
trying to automate the removal of users from a variety of systems.For
our old VFP app I have pointed them in the direction of using the ODBC
Drivers to accomplish this...  Essentially all they have to do is open a
table,   and either modify or delete the users record

Would someone please let me know how that might be setup?   As you can tell
I have very little experience with ODBC...

TIA/Happy Holiday!

Regards,
Desmond


--- 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/caajxvapaymhsrpkqxmm4qo5bvhejywbd+p0ibjfmryczajm...@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

[Desmond Lloyd]

Thank you,  will give this a try

Regards,
Desmond


On Thu, 28 Jun 2018 at 12:39, Frank Cazabon  wrote:

> Desmond,
>
> from my program I use to send email via blat the error you are getting
> back is "File name (message text) not given or Bad argument given":
>
> Here is my full code in my EmailViaBlat.prg, maybe you can try it with
> your stuff and see if there is any difference:
>
> LPARAMETERS tcReturn, tcFrom, tcTo, tcSubject, tcBody, taFiles, tcCC,
> tcBCC, tcMailServer, tnPort, tcUserName, tcPassword, tnPriority,
> tlHTMLFormat)
> ***
>   LOCAL lcBlatParam, lcBodyFile, lnCountAttachments, lnResult, loError
> as Exception
>
> m.lcBlatParam = m.lcBodyFile&&GetShortPath(lcBodyFile)
>
>   TRY
>*!* Include full path in Declare, such as "C:\Blat240\full\blat.dll"
>*!* or make sure that blat.dll is included in the system's PATH variable
>DECLARE INTEGER Send IN "blat.dll" STRING cParam
>lcBodyFile = ADDBS(SYS(2023)) + SYS(2015) + ".txt"
>STRTOFILE(tcBody, lcBodyFile, 0) && body is placed in a text file to
> be sent by BLAT
>
>lcBlatParam = GetShortPath(lcBodyFile)
>
>IF TYPE("tcTo") = "C"
>  lcBlatParam = lcBlatParam + " -to " + ALLTRIM(tcTo)
>ENDIF
>IF TYPE("tcFrom") = "C"
>  lcBlatParam = lcBlatParam + " -f " + ALLTRIM(tcFrom)
>ENDIF
>IF TYPE("tcCC") = "C"
>  lcBlatParam = lcBlatParam + " -cc " + ALLTRIM(tcCC)
>ENDIF
>IF TYPE("tcBCC") = "C"
>  lcBlatParam = lcBlatParam + " -bcc " + ALLTRIM(tcBCC)
>ENDIF
>IF TYPE("tcSubject") = "C"
>  lcBlatParam = lcBlatParam + [ -s "] + ALLTRIM(tcSubject) + ["]
>ENDIF
>IF TYPE("tcMailserver") = "C"
>  lcBlatParam = lcBlatParam + " -server " + ALLTRIM(tcMailserver)
>ENDIF
>IF TYPE("tnPort") = "N"
>  lcBlatParam = lcBlatParam + ":" + TRANSFORM(tnPort)
>ENDIF
>IF TYPE("tcUsername") = "C"
>  lcBlatParam = lcBlatParam + " -u " + ALLTRIM(tcUsername)
>ENDIF
>IF TYPE("tcPassword") = "C"
>  lcBlatParam = lcBlatParam + " -pw " + ALLTRIM(tcPassword)
>ENDIF
>IF TYPE("tnPriority") = "N" AND BETWEEN(tnPriority, 0, 1)
>  lcBlatParam = lcBlatParam + " -priority " + TRANSFORM(tnPriority)
>ENDIF
>IF TYPE("tlHTMLFormat") = "L" AND tlHTMLFormat
>  lcBlatParam = lcBlatParam + " -html"
>ENDIF
>
>IF TYPE("taFiles", 1) = "A"
>  lcBlatParam = lcBlatParam + " -attach "
> FOR lnCountAttachments = 1 TO ALEN(taFiles)
>   lcBlatParam = lcBlatParam + '"' +
> GetShortPath(ALLTRIM(taFiles(lnCountAttachments))) + '",'
> ENDFOR
> lcBlatParam = LEFT(lcBlatParam, LEN(lcBlatParam) - 1) && Remove
> Extra Comma
>ENDIF
>
>lnResult = Send(ALLTRIM(m.lcBlatParam) + IIF(oAppinfo.BlatLog, " -log
> blat.log -debug", ""))
>
>IF lnResult != 0
> DO CASE
>  CASE lnResult = -2
>   THROW "The server actively denied our connection./The mail server
> doesn't like the sender name. "
>  CASE lnResult = -1
>   THROW "Unable to open SMTP socket or SMTP get line did not return
> 220 or command unable to write to socket or Server does not like To:
> address or Mail server error accepting message data."
>  CASE lnResult = 1
>   THROW "File name (message text) not given or Bad argument given"
>  CASE lnResult = 2
>   THROW "File (message text) does not exist"
>  CASE lnResult = 3
>   THROW "Error reading the file (message text) or attached file"
>  CASE lnResult = 4
>   THROW "File (message text) not of type FILE_TYPE_DISK "
>  CASE lnResult = 5
>   THROW "Error Reading File (message text)"
>  CASE lnResult = 12
>   THROW "-server or -f options not specified and not found in registry"
>  CASE lnResult = 13
>   THROW "Error opening temporary file in temp directory"
>  OTHERWISE
>   THROW "Unknown Error"
> ENDCASE
>ENDIF
>
>   CATCH TO loError
>tcReturn = [Error: ] + STR(loError.ERRORNO) + CHR(13) + ;
> [LineNo: ] + STR(loError.LINENO) + CHR(13) + ;
> [Message: ] + loError.MESSAGE + CHR(13) + ;
> [Pro

VFP9 and Blat

[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 &dll_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
---

___
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/caajxvaoetu-jzl7urafq2zitfjfot_du4629-crdibwq0iu...@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.

FoxPro for Windows: Page Layout

[Desmond Lloyd]

That's right,  FoxPro for Windows!

Have this old application I am supporting.  One report will not print in
the correct orientation.  It should be landscape,  but prints in portrait.
Have tried what I thought would be the "normal" things to do.

1.)  Checked it in the report designer
2.)  "Emptied" tag1 and tag2.

All to no joy

Any suggestions...

Regards/TIA,
Desmond


--- 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/CAAJXvaNu7g5T8WT=hxc0chvjpg7o4y-xnca3pnde8temaxc...@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: Task Scheduler

[Desmond Lloyd]

Thanks everyone!   If I run the executable it dos popup a window,  it's
empty and quickly goes away.
So I can add a config.fpw file to the project to set screen off etc.?

Regards,
Desmond


On Tue, 12 Jun 2018 at 09:05, Ricardo Molina  wrote:

> If it's a modal dialog, then you can use SYS(2335) Unattended Server Mode
> and trap it.
>
> Ricardo.
>
> On 12 June 2018 at 11:44, Ted Roche  wrote:
>
> > On Mon, Jun 11, 2018 at 6:35 PM, Fred Taylor  wrote:
> > > If you're using drive letter mappings, those mappings do not exist for
> > the
> > > Task Scheduler.  Won't find any data.
> > >
> > > You can do the mappings in a batch file,
> > >
> >
> > Or you could use UNC drive pathing.
> >
> > Also, there's an option to set the user context in which to run the
> > job, if you need permissions to access resources.
> >
> > You should have a config file included in the EXE where you set OFF
> > talk, resource, help, etc. so you don't get console or locate dialogs
> > on startup.
> >
> >  And you need logs, of course. Good possibility there's a USE or file
> > function that's popping up a dialog.
> >
> > --
> > 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/CAAJXvaOM5Dk6J9zfyXVhC3enWL9D-5T=hcqh0q3yyjy-mz9...@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: Task Scheduler

[Desmond Lloyd]

Is there a work around?   Am using O365 Outlook in my testing,   actual
environment will be Office 2016 using a "real" exchange server?

Thank You!
Regards,
Desmond


On Tue, 12 Jun 2018 at 03:29, Dave Crozier  wrote:

> Desmond,
> Beware if using different versions of outlook as Createobject() and
> Getobject() behave in differing ways to what you would expect.
>
> CreateObject() will attach itself to the running version of Outlook rather
> than starting a new instance which you would expect. In effect is is just
> as though you had issued a GetObject().
>
> This can have an effect on your program flow if the user uses the instance
> of Outlook whilst you are controlling it in code - worst scenario is to
> close outlook completely of course!
>
> Office 2003 and versions prior did not suffer from this problem and
> CreateObject() always used to start a new instance.
>
> Dave
>
>
>
> ---
> 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
>
> -Original Message-
> From: ProFox  On Behalf Of Desmond Lloyd
> Sent: 11 June 2018 22:33
> To: ProFox Email List 
> Subject: VFP: Task Scheduler
>
> Good afternoon,
>
> Going nuts down here,  have a simple executable generated from a single
> program.  Runs fine by itself.  Grabs s few records then sends out an email
> via Outlook automation.   Which,  btw, does Outlook have to be open to
> run,  or not?  In any event if I run it in the task schedule it shows that
> it is running,  but it never stops or returns to the ready status
>
> 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/caajxvampyorphkgdnkfbgvrx8qk6gri31tyo5v_eg934zkm...@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.

VFP: Task Scheduler

[Desmond Lloyd]

Good afternoon,

Going nuts down here,  have a simple executable generated from a single
program.  Runs fine by itself.  Grabs s few records then sends out an email
via Outlook automation.   Which,  btw, does Outlook have to be open to
run,  or not?  In any event if I run it in the task schedule it shows that
it is running,  but it never stops or returns to the ready status

Regards,
Desmond


--- 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/caajxvao0khryfczhnnti0zof51wxcialc9b_cp-kovxp7n5...@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.

VFP9 - Save as XLSX

[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
---

___
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/caajxvao8weyx8xhag_vpxzk48n2wdbhle9qykdzcvmkmevy...@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

[Desmond Lloyd]

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/caajxvamx+dpahwck1mbed0bjk--mqr3lyydaao12x7c2nhm...@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.

Displaying Content on a TV

[Desmond Lloyd]

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
---

___
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/CAAJXvaPXHqh_0vnXt07Y=oanbrh69v8rrm+jezcnq2wnj6t...@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: VFP9SP2/Windows 10 and Blat

[Desmond Lloyd]

Thank you!  Will give that a shot

Regards,
Desmond


On 16 January 2018 at 17:42, Ted Roche  wrote:

> I suspect there's a runtime DLL dependency other than blat itself.
>
> You might try downloading and installing the full version and test the
> exe to see if that would work.
>
> IIRC, I usually set it up by using the EXE to get the configuration
> options correct, and there was a command-line switch to save a few of
> them (server, port, etc.) and then code those settings using the DLL.
>
> http://www.blat.net/
>
>
> On Tue, Jan 16, 2018 at 12:22 PM, Desmond Lloyd 
> wrote:
> > Thank you...  That is exactly what I have seen with Windows 7,  which is
> > what I had assumed with Windows 10...
> >
> > ...you know what they say about assume
> >
> > Regards,
> > Desmond
> >
> >
> > On 16 January 2018 at 08:07, Dave Crozier  wrote:
> >
> >> Windows 10 here and the old version works fine just with the DLL in the
> >> base folder of the application.
> >>
> >> Dave
> >>
> >>
> >>
> >>
> >> ---
> >> 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
> >>
> >> -Original Message-
> >> From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Jan Bucek
> >> Sent: 16 January 2018 13:59
> >> To: profox@leafe.com
> >> Subject: Re: VFP9SP2/Windows 10 and Blat
> >>
> >> Dne 16.1.2018 v 5:34 Desmond Lloyd napsal(a):
> >> >>
> >> >> Mostly VFP...
> >> >
> >> >
> >> > Been using  Blat  to send out emails for years,  evidently so long
> >> > that I can't remember how to set it up (so to speak)
> >> >
> >> > Copied the Blat.dll file to  a folder on my Windows 10 machine,  when
> >> > trying to send an email I get an error message cannot load 32-bit
> dll
> >>
> >> Download and try 64-bit version:
> >>
> >> https://sourceforge.net/pr

Re: VFP9SP2/Windows 10 and Blat

[Desmond Lloyd]

Thank you...  That is exactly what I have seen with Windows 7,  which is
what I had assumed with Windows 10...

...you know what they say about assume

Regards,
Desmond


On 16 January 2018 at 08:07, Dave Crozier  wrote:

> Windows 10 here and the old version works fine just with the DLL in the
> base folder of the application.
>
> Dave
>
>
>
>
> ---
> 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
>
> -Original Message-
> From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Jan Bucek
> Sent: 16 January 2018 13:59
> To: profox@leafe.com
> Subject: Re: VFP9SP2/Windows 10 and Blat
>
> Dne 16.1.2018 v 5:34 Desmond Lloyd napsal(a):
> >>
> >> Mostly VFP...
> >
> >
> > Been using  Blat  to send out emails for years,  evidently so long
> > that I can't remember how to set it up (so to speak)
> >
> > Copied the Blat.dll file to  a folder on my Windows 10 machine,  when
> > trying to send an email I get an error message cannot load 32-bit dll
>
> Download and try 64-bit version:
>
> https://sourceforge.net/projects/blat/files/Blat%
> 20Full%20Version/64%20bit%20versions/
>
> I have not tested it yet, I do not use Win10 at all.
>
> >
> > Am "assuming" this will work with Windows 10?
> >
> > Suggestions to get this to work?
> >
> > Thank You and 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/CAAJXvaMGidL+f=h5dJsxxjCThO5H7-4h1Y+RrXMpA=seszb...@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: VFP9SP2/Windows 10 and Blat

[Desmond Lloyd]

Not that I am aware off.   In Windows 7 (Professional),  on a network
drive,  and local drive it works fine and does not seem to be registered?

Regards,
Desmond


On 16 January 2018 at 02:34, Alan Bourke  wrote:

> Does it have any dependencies, possibly Visual C++ DLLs that also need to
> be there ?
>
>
> --
>   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/CAAJXvaP-yusCM7WB=CSfxnosV8bp6zg53LX_RX_Ct=mwj--...@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.

VFP9SP2/Windows 10 and Blat

[Desmond Lloyd]

>
> Mostly VFP...


Been using  Blat  to send out emails for years,  evidently so long that I
can't remember how to set it up (so to speak)

Copied the Blat.dll file to  a folder on my Windows 10 machine,  when
trying to send an email I get an error message cannot load 32-bit dll

Am "assuming" this will work with Windows 10?

Suggestions to get this to work?

Thank You and Regards,
Desmond


--- 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/caajxvanf0+mvmi-+doxprmyeh-qlk6mcerjefjs2ms_8tub...@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: hellooo-o

[Desmond Lloyd]

...just nod if you can hear me

On 13 January 2018 at 09:13, Alan Bourke  wrote:

> I'm not.
>
> --
>   Alan Bourke
>   alanpbourke (at) fastmail (dot) fm
>
> On Sat, 13 Jan 2018, at 1:23 PM, AndyHC wrote:
> > Knock knock!
> > Is there anybody there?
> >
[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/CAAJXvaPQrK7B9oKEDLzynmWm8wbq_C=7hvc0xf8r7iw_tyq...@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 App: Sluggish response on network....

[Desmond Lloyd]

We tried the anti-virus,  web filtering,  bad hair day approaches all to no
avail...  Turned out to be a query that was being ran to generate a list of
parts.Ran this way for  years but decided to choke on a machine on the
network.   Move the query before firing the form and all is good.  But get
this,I could run the old version on my local machine (no network),  or
from the server and it was fine.  We monitored network traffic while the
query ran it ramped up to megabytes.

Appreciate the help,
Regards,
Desmond




On 1 May 2017 at 16:17,  wrote:

> On 2017-05-01 10:17, Desmond Lloyd wrote:
>
>> Good Morning,
>>
>> Have an application that has been running for years,   we add transactions
>> via one form that displays the transactions in a grid.  When adding we pop
>> a form, when saving I do the old append blank gather memvar thing.  Has
>> worked well until recently...
>>
>> Now there is a long pause before the screen is displayed to add these
>> transactions,  and a lag when saving a record
>>
>> The odd thing is that running it from the server it runs fine.  If I run
>> from my local machine it is fine.  Even copied it out to another network
>> and it was fine as well...
>>
>> Nothing unusual in getting the form ready to display.  As mentioned just a
>> quick append blank gather memvar on the add
>>
>> Network response from other applications is fine
>>
>> Any thoughts?
>> TIA,
>> Desmond
>>
>
>
> Hi Desmond,
>
> 1) Have you configured the anti-virus and malware scans to EXCLUDE your
> application and data folders?
>
> 2) INSERT INTO (FieldName) FROM NAME thisform.oRecord is better than
> APPEND BLANK and GATHER MEMVAR because the former updates the indexes ONCE
> whereas the latter updates them TWICE.
>
> hth,
> --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/caajxvaneq2ub1souxpnval0z2sod62nmsyjhtxqvcfdx+vd...@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.

VFP App: Sluggish response on network....

[Desmond Lloyd]

Good Morning,

Have an application that has been running for years,   we add transactions
via one form that displays the transactions in a grid.  When adding we pop
a form, when saving I do the old append blank gather memvar thing.  Has
worked well until recently...

Now there is a long pause before the screen is displayed to add these
transactions,  and a lag when saving a record

The odd thing is that running it from the server it runs fine.  If I run
from my local machine it is fine.  Even copied it out to another network
and it was fine as well...

Nothing unusual in getting the form ready to display.  As mentioned just a
quick append blank gather memvar on the add

Network response from other applications is fine

Any thoughts?
TIA,
Desmond


--- 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/caajxvaodexx0yagqmch2ffngbq6rie0kib354zs_ribfu2h...@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: Monday Survey Question

[Desmond Lloyd]

On 20 March 2017 at 13:08, Ted Roche  wrote:

> Greetings, happy campers. Pop quiz this fine Monday.
>
> 1. How many VFP books do you own?  8
>
> 2. How many are dead-tree paper and how many ebooks?   All paper
>
> 3. What is your most well-worn VFP books? Or most referenced ebook?
> Original VFP 6 Manual
>
> 4. What book do you regret not owning?   Not sure (bet there is alot)
>
> 5. Would you buy VFP books if you could find them?   Definitely
>
> 6. Preferred format? Paper, PDF, CHM, ePub, HTML, other (which?)   PDF
> would be nice
>
> --
> 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/caajxvapzzp6lbkze3zjfrja2xat_ug7hrmgya-nca9xw15j...@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: VFP7 SP1, InstallShield MSMs, etc.

[Desmond Lloyd]

Getting an Error 503,  service not available



On 27 September 2016 at 05:49, Dave Crozier  wrote:

> Can anyone else verify that the Fox Wiki site is down please?
>
> Dave
>
> -Original Message-
> From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Paul Hill
> Sent: 27 September 2016 11:07
> To: ProFox Email List 
> Subject: Re: VFP7 SP1, InstallShield MSMs, etc.
>
> On 27 September 2016 at 10:22, Alan Bourke 
> wrote:
> >> I have no idea how to access UNC paths from Bash, only physical
> >> drives show up in /mnt.
> >
> > Same as in CMD.EXE or whatever, except with forward slashes.
>
> Doesn't work here:
>
> ls //server/share/
> ls: cannot access //server/share/: No such file or directory
>
> --
> 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/caajxvamzbfytksy+e3yn8pbmzszfwusropbqg6aymjkvmcg...@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 - Missing Printer Dialog

[Desmond Lloyd]

Woohooo...  that was it!   It was a Foxuser located in  a shared folder on
the network.  Erased the existing foxuser files and the dialogs have
returned   Thanks everyone for your help and patience

Regards,
Desmond



On 29 August 2016 at 02:30, Alan Bourke  wrote:

> You could try opening your FOXUSER.DBF exclusively, taking a backup copy
> and then:
>
> delete for id = "9REPPREVIEW"
>
> and packing.
>
> --
>   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/caajxvan00kkkxuelhmjdt3-kco4e+sawvm9xskwy8rf620-...@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 - Missing Printer Dialog

[Desmond Lloyd]

No not a third party.  report form whatever preview...  When previewing a
report there is a dialog with a printer icon that allows the report to
print...   See attached screen shot.Got to be something really simple I
am missing...

Thank you for your reply!

Reards,
Desmond


On 26 August 2016 at 13:54, Tracy Pearson  wrote:

> Desmond Lloyd wrote on 2016-08-26:
> >  When printing our reports from our VFP app we usually get a "print
> dialog"
> >  (from preview) with a way to navigate from page to page,  and more
> >  importanly print!
> >
> >  Had a user lose that dialog,  am assuming he pressed the escape key.
>  In
> >  any event how do we get it back?
> >
> >  been a long week...
> >  TIA,
> >  Desmond
> >
>
> Desmond,
>
> Too vague..
> Are you using a third party tool to preview your reports? I think
> FoxyPreviewer has a setting one could turn off the Print Dialog with.
>
> Are you talking about the toolbar that appears above the standard VFP
> Report
> Previewer?
> If so, that tool bar position and if it is visible is stored in a FoxUser
> table. UNLESS you have RESOURCE=OFF in the CONFIG.FPW that is built in to
> the EXE. Which is how the main program I work on does it. It also uses a
> compiled in stripped down FoxUser table. It turns it on just before
> printing
> then turns it off after printing.
>
> Tracy Pearson
> PowerChurch Software
>
>
[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/CAAJXvaOmA6_s0s_=xsa=radeyxnkp6byudjv+f9k50emtqe...@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.

VFP - Missing Printer Dialog

[Desmond Lloyd]

When printing our reports from our VFP app we usually get a "print dialog"
(from preview) with a way to navigate from page to page,  and more
importanly print!

Had a user lose that dialog,  am assuming he pressed the escape key.   In
any event how do we get it back?

been a long week...
TIA,
Desmond


--- 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/CAAJXvaOBBWz6C7tzQEeVzvdjBAom8fm5f8C=zkypj4dgzvm...@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: more on PDF and VFP

[Desmond Lloyd]

Fascinating 

On 14 July 2016 at 07:50, Alan Bourke  wrote:

> > (I have the free version of FoxitReader installed in my computer)
>
> Google Chrome's built-in PDF renderer is based on Foxit, fact fans.
>
> --
>   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/CAAJXvaO6_AL_EStHXAQhSEe7nEZvWOFMJwJFM9g6=pmhvbx...@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: ProFox Digest, Vol 159, Issue 7

[Desmond Lloyd]

Good Morning,

One of the things I tried first was the adobe reader control.   What I
could not determine is how to identfiey and load the file that I want.  I
did find a loadfile method assocatied with this control...  Would that do
the trick?

Regards,
Desmond


On 13 July 2016 at 09:04, Claude nikula  wrote:

> You can use the browser control in a VFP form. To test this theory just
> open
> your web browser and then open a PDF file it should display properly. if
> that works for you then that is one solution.
> Another solution is to use the free Adobe reader control with in a VFP
> form.
> I do something like that in one of my C# WinForms desktop applications
>
> Cheers
>
>
>
[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/CAAJXvaMxO=rKk=gspnt5xqz+hhkskesntqzqd5woop_nkoa...@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 Display a PDF

[Desmond Lloyd]

Once again thanks for the input.   Was able to get the "browser" version to
work with the following exception,  it opens the PDF in the reader,  not
the control.  Accordng to the notes you should be able set an option to
display the PDF in the control.  I have Adobe Standard and Adobe DC Reader
installed.   Could not find that option in the internet options for the
reader and "standard version".  Did a search and Adobe says to enable the
reader add on under "manager add ons" which is enabled.  Still no joy...

For now am going to use the _shell execute,  works just like the other. In
the meantime does anyone have any suggestions on how to get the PDF to
display within the control...

Thanks Again,
Desmond



On 13 July 2016 at 09:28, rafael copquin  wrote:

> :-):-)
> Rafael
>
> On 12/07/2016 20:38, Ted Roche wrote:
>
>> On Tue, Jul 12, 2016 at 6:39 PM, rafael copquin 
>> wrote:
>>
>>> In addition to all the answers you've got so far, I use this method:
>>>
>>> Add the _shellexecute class from the _environ.vcx class library that
>>> ships
>>> with VFP 9 to a form
>>>
>>> Name it 'launcher'
>>>
>>> and run this code from the click event of a button:
>>>
>>> Local cDocName
>>>
>>> cDocName = GetFile('doc,xls,pdf,txt','File','Open',0,'Choose file')
>>> thisform.launcher.shellexecute (cDocName)
>>>
>>> That's the best answer, the actual code. I was trolling around the
>> archives, but couldn't locate 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/CAAJXvaND0bdd5xJcPH_obA8BfdaiWcC-F1OwxeGM4UPrj4=m...@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 Display a PDF

[Desmond Lloyd]

Thanks to allAppreciate the  helpe,  despite my inability to locate
the previous posts on this subject...

Regards,
Desmond


On 12 July 2016 at 23:00, 
wrote:

> On 2016-07-12 18:11, Ted Roche wrote:
>
>> Use ShellExecute()
>>
>> http://leafe.com/archives/full_thread/485262
>>
>
>
> Deja Vu!
>
[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/caajxvapbrf0ahf1kvus5fy_uhqecorzywhviptjgfj41dca...@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.

VFP Display a PDF

[Desmond Lloyd]

Good afternoon,

Does anyone have a quick and dirty way to display a PDF from VFP either in
a form,  or natively using Adobe Reader?

Any assistance would be GREATLY appreciated...

Regards,
Desmond


--- 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/caajxvaoc2ygr+jtydpuveqlzucocnhon0+tqlxsxugqv9tz...@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.

VFP9: Outputing a text file with field names

[Desmond Lloyd]

Good afternoon,

Am outputing a text file type delimited with character "" character tab,
works great.The table it is being generated from is a mix of character
and numeric fields...

The only issue I have is that they wnat the fields names to make up the
first record.  My original throught was to build a separate table with the
fields names entered in the record (one record) and then append from my
file.  This would put the field names up top and the rest of the data after
that.   Am concerned about adding the previously numeric fields as a
character field.

Any suggestions?
TIA,
Desmond


--- 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/caajxvapmkzsp8dkp_zgn18wwc_r_x0wgagcoqnbx_vcrogu...@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 Locate the Microsoft Visual FoxPro Support LIbrary

[Desmond Lloyd]

Thank you for the quick response...  Yes I have installers for both VFP6
and VFP9 (thank you Woodie)  Turns out I needed to install the VFP9
runtimes,   right as rain!  As an aside,  I have yet another "report shell"
application that was running just fine prior to installing the runtimes.
Go figure...

Thanks again,
Desmond


On 2 June 2016 at 08:51, Ken Dibble  wrote:

>
> Do you have an installer to do all the copying/registering etc?
>> I think you have to have some files installed on the machine even to use
>> the runtime.
>>
>
> There's a C++ dll that is required in addition to the runtime, and I think
> one other file, at a minimum. If all of the required files are located in
> the same folder as the .exe you want to run, it will run, no "installation"
> or registration necessary.
>
> It's possible that the other machines have a PATH environmental variable
> set that the problem machine doesn't.
>
> 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/CAAJXvaP_jmZ9RMVSGWSsHWfU8oAmEv36FM1JhNX7uc=1elm...@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.

Cannot Locate the Microsoft Visual FoxPro Support LIbrary

[Desmond Lloyd]

Good Morning,

Have several legacy VFP6 applications my users run.   A mixed bag of VFP6
and VFP9 generated executables.

The main application everyone can run,  have another executable in a folder
under the main application,  most people can run. Now have a new person who
cannot run the one in the sub folder,  he can run the main!

Checked the folder where the other application runs and have located vfp6
and vfp7 dll's,  including the respective versions of the "renu" dll's in
the same folder.  The shortcut starts the correct exe and starts where the
dll's are located?It "should" run.

Does anyone see anything blatantly wrong?

Regards,
Desmond


--- 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/CAAJXvaNNOeRWXKg0NRuikRMnzRBMS322Qab=qyn2pumsha_...@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: Grid Question

[Desmond Lloyd]

Thank you everyone for your help...   I wound up  setting the column widths
in the init,  then redefining them when restoring the record source.  A
little painful, I did find the article by Mr.  Kramek...

Thank you again!
Regards,
Desmond



On 19 October 2015 at 13:48, Koen Piller  wrote:

> Hi
> Also read, use Google to find it, the safeselect method developped by Andy
> Kramek for repopulation of your grid
> Rgds
> Koen
>
> Op maandag 19 oktober 2015 heeft Desmond Lloyd 
> het volgende geschreven:
>
> > Good Morning all,
> >
> > A little out of practice
> >
> > Defined a grid,  adjusted my column widths,  added my headers.  Looks
> great
> > in the editor.
> >
> > When I first fire up the form the recordsource is left empty pending the
> > results of a query based upon input from the user.  For some reason the
> > grid blows off my column width!  The first three columns are great, the
> > next few are one chacter wide,  then normal.  Total of 13 columns.
> >
> > After adding the recordsource and manually setting the width on one of
> the
> > one character columns it adjusts itself.  When the user is going to make
> > another inquiry I blank out the record.   Same thing,  i define the width
> > and all is good,  the rest are nasty.
> >
> > Should I define my column widths during the init of the form so it will
> > maintain its neat appearance?
> >
> > Suggestions...
> >
> > 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/CAAJXvaN=h3nn_tvb5vygoqxoacurcalzz0uqaksrcztpzub...@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.

VFP9: Grid Question

[Desmond Lloyd]

Good Morning all,

A little out of practice

Defined a grid,  adjusted my column widths,  added my headers.  Looks great
in the editor.

When I first fire up the form the recordsource is left empty pending the
results of a query based upon input from the user.  For some reason the
grid blows off my column width!  The first three columns are great, the
next few are one chacter wide,  then normal.  Total of 13 columns.

After adding the recordsource and manually setting the width on one of the
one character columns it adjusts itself.  When the user is going to make
another inquiry I blank out the record.   Same thing,  i define the width
and all is good,  the rest are nasty.

Should I define my column widths during the init of the form so it will
maintain its neat appearance?

Suggestions...

TIA,
Desmond


--- 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/CAAJXvaP62JvbExFk0EUzN458e8zvoLVjY3GFQYj=i6=l7ge...@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: Exporting FPD DOS 2.6 reports to Excel

[Desmond Lloyd]

Happen to have my Tom Rettigs FoxPro Handbook handy!.  There is an option
to "copy to type"  Here's the syntax;

COPY TO  | ()
   [TYPE] FOXPLUS | SDF |
   DELIMITED [ WITH  | BLANK | TAB]
   [FIELDS  ] []


HTH,
Desmond



On 30 September 2015 at 10:21, Kurt Wendt  wrote:

> Honestly - I don't remember if the old FPDos has the Copy To command with
> the Excel output option. I suspect it may. Otherwise, you could simply
> export data as a CSV - even just programmatically - and name the file as
> Dummy.csv - and it should easily be able to load up in Excel!
>
> -K-
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of John
> J. Mihaljevic
> Sent: Wednesday, September 30, 2015 11:09 AM
> To: profoxt...@leafe.com
> Subject: Exporting FPD DOS 2.6 reports to Excel
>
> Hi all,
>
>
>
> I haven't used this in forever, but a client with an old FPD DOS 2.6
> system wants the ability to export their reports to Excel. They don't want
> any other changes, so bringing it up to VFP isn't an option.
>
>
>
> Is there a quick-and-easy way to make this happen?
>
> Thanks,
>
>
>
> John
>
>
>
> --- 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/caajxvaowaophmvad5jq+4kyczrh8h94-gyh90wbgku_ffdw...@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.

VFP6 and VMWare

[Desmond Lloyd]

Have a "legacy" VFP6 application that has been running fine on Server 2008
machine.   We have recently moved the application to a VMware 2012
server.   Beyond some initial issues with data file sizes and some slower
responses.  (corrected by reducing the size of some of the most used files)
it has been fine.

However,  here lately (past few weeks)  I have been running into some
issues with:

1.)   Error Reading file when attempting to use a dbf.  Very,  very
intermittent and to only some users.  (like one or two)
2.)Possible record locking issues.  In some parts of the application
there are manual locks and unlocks on records,  otherwise I let VFP do all
the work.  We have some problems with "record is in use by another" in the
past (even on the 2008 server),  but these seem to be growing.
3.) Get this, "has attempted to write to a file that is marked READ
ONLY..."  Had this happen a few weeks ago.  Sure enough I couldn't write to
it,  so I recreated it.  All was good until today when someone got the same
message,  but in this case the file is fine...

Did some searching and found references to GPF errors being created by VFP6
in a VMware environment,  we do not seem to be experiencing those.
(thankfully)

Has anyone seen this in a VMware environment before?  If so were you able
to correct.  Am I overreacting?

This has me baffled... (among other things)

Thank You,
Desmond


--- 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/CAAJXvaNn9jPJYcb7wFrxMBYVig=q_ormaokckq252cvvrid...@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.

VFP9: Basic Forms Questions

[Desmond Lloyd]

Forgive me for such a basic question...

Have an application,  calls a form (as top level/modal),  click a button
calls a form (as top level/modal) ,  click a button calls a third form (as
top level/modal).  When running the third form from the second it is
displayed BEHIND the second screen.  I can move the second form out of the
way and the third works fine

What am I doing wrong?,  I tried making the second form an in  top-level,
that would display the third form properly but none of the controls on the
third would work...

Regards,
Desmond


--- 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/caajxvamk0ff8eldheiznebj-kfgu0gcn3k3u9fohbmbda7z...@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: Combobox Blues

[Desmond Lloyd]

Tracy,

Seems to be   I think I am going to remove the assignment in the PEM of
the controls,  and define in the init of the form.  I really need to be
more consistent

Appreciate your input!

Regards,
Desmond


On 29 June 2015 at 15:39, Tracy Pearson  wrote:

> Desmond Lloyd wrote on 2015-06-29:
> >  Suggestions/Advise please...
> >
> >  Define a combo box,  source is a cursor of codes and descriptions,
> control
> >  source is a scattered variable from the table I am editing/Adding to...
> >
> >  this.listindex.item = 1 on both,  displays something in the combobox
> versus
> >  the infamous blank
> >
> >  Works fine when adding (scatter memvar blank memo),  in the lost focus
> of
> >  the combo boxes I stuff the description into a variable and then display
> >  that in a description text box next to the appropriate combobox.
> >
> >  Now,  when editing I scatter the record I want to edit,  now when the
> >  comboboxes are displayed I get a blank.  Have added a code to move the
> >  pointer in my lookup cursors to the appropriate position and no joy
> >
> >  I hope I am describing this adequately...
> >
> >  Regards and TIA,
> >  Desmond
> >
>
> Desmond,
>
> Is the ComboBox losing the value stored ControlSource?
>
> The way you described it reminded me of grids losing they column details
> when Select into the Cursor used at the RecordSource.
>
>
> Tracy Pearson
> PowerChurch Software
>
>
[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/caajxvamvfbeyqtebjmetjln31ar0zw6m9lwrymqjkzatadf...@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.

VFP9: Combobox Blues

[Desmond Lloyd]

Suggestions/Advise please...

Define a combo box,  source is a cursor of codes and descriptions,  control
source is a scattered variable from the table I am editing/Adding to...

this.listindex.item = 1 on both,  displays something in the combobox versus
the infamous blank

Works fine when adding (scatter memvar blank memo),  in the lost focus of
the combo boxes I stuff the description into a variable and then display
that in a description text box next to the appropriate combobox.

Now,  when editing I scatter the record I want to edit,  now when the
comboboxes are displayed I get a blank.  Have added a code to move the
pointer in my lookup cursors to the appropriate position and no joy

I hope I am describing this adequately...

Regards and TIA,
Desmond


--- 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/caajxvaps7svmgdqbdrysdyuhzftmmjvgjizcted4a0cvn4w...@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: Some problems receiving ProFox email

[Desmond Lloyd]

In  my case the first are going  to spam (am using gmail)  am seeing this...

*Why is this message in Spam?* It's in violation of Google's recommended
email sender guidelines

Regards,
Desmond



On 11 June 2015 at 16:58, Fred Taylor  wrote:

> Check your spam folder in Gmail.  I see this  alot on some peoples messages
> from ProFox:
>
>
> *This message was not sent to Spam because of a filter you created.* Edit
> Filters
>
> Fred
>
> On Thu, Jun 11, 2015 at 2:57 PM, Fernando D. Bozzo 
> wrote:
>
> > Hi:
> >
> > I'm seeing that I'm not receiving the 1st email of people, and I just
> > receive the answers to them, so many times I find what happens only when
> > someone answer to profox email.
> >
> > Why can this happen?
> >
> >
> > --- 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/caajxvandh4budwomxpconsyvw1_ovdkt7sw4xx3zzxbr6bj...@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: Form Data Environment

[Desmond Lloyd]

Are you referring to when you set step on?  How do you mean "moving the
alias",  selecting another?

Regards
Desmond



On 14 May 2015 at 10:07, Allen  wrote:

> I agree with that
>
> On that subject, is it possible to stop debug from moving the alias? When
> I set debug on its always at a table nothing to do with where it should be.
> Al
>
> -Original Message-
>
> Fascinating   I hate giving up control of anything  a preference!
>
>
>
> ---
> This email is free from viruses and malware because avast! Antivirus
> protection is active.
> http://www.avast.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/caajxvaowmdnbondv2n5grozpwdr14+kuxqcae8pqtagktpl...@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: Form Data Environment

[Desmond Lloyd]

Fascinating   I hate giving up control of anything  a preference!

Regards,
Desmond




On 14 May 2015 at 08:54, Rafael Copquin  wrote:

> I'd rather use the load event to open the tables:
>
> use clients alias myclients in 0 order account shared
>
> in this manner I have absolute control on the table, without having to
> resort to using the mouse to set buffering, ordering,relations or whatever.
>
> I always put the following statement in the unload event
>
> close tables all
>
> which will ensure that not only all tables are closed but also any cursors
> developed in the form.
> Or I can chose to close some of the tables or none.
>
> The dataenvironment forces you to use the ide to handle the table.
>
> Anyways, it is always a matter of preference
>
> Rafael Copquin
>
>
>
> El 14/05/2015 a las 10:38, Kurt Wendt escribió:
>
>> Desmond,
>>
>> A number of years ago - I discovered the use of the Data Environment on
>> Forms. Why did I find it so Exciting? I'm glad you asked! Because - once
>> you put one or more Tables in the Data Environment - you can simply
>> Drag-n-Drop the fields from the Table right onto your Form - allowing you
>> to do true "visual design". I loved being able to do that. And, I also
>> really liked that if you grab Multiple fields - and drop onto the Form - it
>> automatically creates a Grid on your form with those fields.
>>
>> Not sure if this answers your Q - but, figured I would add in my 2
>> cents...
>>
>> -K-
>>
>> -Original Message-
>> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
>> Desmond Lloyd
>> Sent: Thursday, May 14, 2015 9:30 AM
>> To: profoxt...@leafe.com
>> Subject: VFP9: Form Data Environment
>>
>> Good Morning,
>>
>> Thank you Fernando for your response regarding "stacking forms".
>>
>> Odd question.  For years I've always opened my desired forms by including
>> the statement use somewhere in the code...  Is there a benefit to using the
>> data environment.  Being rather set in my ways have always been a little
>> leery of it.
>>
>> Thoughts?
>>
>> Regards and 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/CAAJXvaN__kfnA7HPKdjfagwxuvbRVX=PEsP3NdyYwa6=wzf...@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: Form Data Environment

[Desmond Lloyd]

Appreciate your insight!  The ability to drag and drop sounds nice.  For
now I rely on my familiarity with the data set I am working with...  not
always a good thing!  8-)



On 14 May 2015 at 08:38, Kurt Wendt  wrote:

> Desmond,
>
> A number of years ago - I discovered the use of the Data Environment on
> Forms. Why did I find it so Exciting? I'm glad you asked! Because - once
> you put one or more Tables in the Data Environment - you can simply
> Drag-n-Drop the fields from the Table right onto your Form - allowing you
> to do true "visual design". I loved being able to do that. And, I also
> really liked that if you grab Multiple fields - and drop onto the Form - it
> automatically creates a Grid on your form with those fields.
>
> Not sure if this answers your Q - but, figured I would add in my 2 cents...
>
> -K-
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> Desmond Lloyd
> Sent: Thursday, May 14, 2015 9:30 AM
> To: profoxt...@leafe.com
> Subject: VFP9: Form Data Environment
>
> Good Morning,
>
> Thank you Fernando for your response regarding "stacking forms".
>
> Odd question.  For years I've always opened my desired forms by including
> the statement use somewhere in the code...  Is there a benefit to using the
> data environment.  Being rather set in my ways have always been a little
> leery of it.
>
> Thoughts?
>
> Regards and 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/caajxvancczreummtfdw4dtsehubjcbxhiqcfxzd_by5lrze...@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.

VFP9: Form Data Environment

[Desmond Lloyd]

Good Morning,

Thank you Fernando for your response regarding "stacking forms".

Odd question.  For years I've always opened my desired forms by including
the statement use somewhere in the code...  Is there a benefit to using the
data environment.  Being rather set in my ways have always been a little
leery of it.

Thoughts?

Regards and TIA,
Desmond


--- 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/CAAJXvaOdC5gobFitqe3dVk9tAcTi5E-jAGUib6W=8qnqkvm...@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.

VFP9: Stacking forms..

[Desmond Lloyd]

A basic question am sure...

Simple,  run a start up program

do form a - as top level,  modeless
click on button
do form b - as top level, modal
click on button
do form c - as top level modal - works fine except form c is displayed
BEHIND form b!  I can move form c  from behind and it works fine

Does anyone see anything blatantly wrong?

Regards,
Desmond


--- 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/caajxvamwzwo_jx_yjjg1+1quoaxhwdcf89wmhrtlctd9_en...@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: VFP6 Form Problem...

[Desmond Lloyd]

Tried both,  desktop .t. and desktop .f.,  no  change in the forms
behavior

An odd situation indeed.  Checked other forms I am  running in the same
environment and all are fine...  For the time being am going to give it a
rest...   However  any  suggestions/hints would be appreciated...

Really,  this needs VFP9!

Regards,
Desmond




On 7 March 2015 at 04:16, Man-wai Chang  wrote:

> On Sat, Mar 7, 2015 at 5:53 AM, Tracy Pearson 
> wrote:
> > I had one of those @Say forms in one of our projects. When we tested
> things
> > in Windows Vista, that form had a lot of display issues.
> >
> > That aside, You have a test form that behaves as you expect.
> > This rebuilt form where you've copied all the code from the suspect form,
> > still has the problem.
>
> Did you disable Desktop Composition and try again?
>
> --
>  .~. 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/caajxvaminr79mbabpvw-jxc2yhf79jul3vr-desssgnlyi3...@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: VFP6 Form Problem...

[Desmond Lloyd]

Thank you,  I will do that

Regards,
Desmond


On 6 March 2015 at 15:53, Tracy Pearson  wrote:

> Desmond Lloyd wrote on 2015-03-06:
> >  First thanks for the response I got yesterday on what I presented as a
> Tab
> >  Order problem.
> >
> >  Am running a VP6 form from a real old FoxPro accounting system.   It has
> a
> >  bunch of menu generation overhead and these huge procedure files... On
> one
> >  of their screens which is handwritten with says and gets I call this
> >  form.   it is modeless,   default show window,  with a read events
> >  statement after the do myform statement.  Form works fine however,
> after
> >  clicking on the edit button I set focus to one of the controls, if I tab
> >  out of it the cursor progresses to the next control,  if  I use the
> mouse
> I
> >  can progress to the next control.  However pressing enter always
> executes
> >  the buttons click event!
> >
> >  Thought that was strange so I checked the behavior on another form
> (called
> >  from another button on the malfunctioning button).  Exact same scenario,
> >  but after setting focus on the control I can successfully press enter
> and
> >  move to the next
> >
> >  So I wrote a quick test form with three text boxes and executed roughly
> the
> >  same code in a button on that form.  Executed the from the same place
> and
> >  once again I could successfully move from control to control using the
> >  enter button.
> >
> >  The problem I have with pressing the enter key and having the click fire
> is
> >  that the user could save something prematurely and then will have to
> click
> >  the edit button to finish their edits.
> >
> >  I apologize for my long "windedness" ,  but am totally baffled why it
> works
> >  on every other form,  except this one?  BTW I even rebuilt the form
> >  (copying the contents of my methods) and no joy?
> >
> >  Does anyone have any ideas?
> >  Regards,
> >  Desmond
> >
>
> Desmond,
>
> I had one of those @Say forms in one of our projects. When we tested things
> in Windows Vista, that form had a lot of display issues.
>
> That aside, You have a test form that behaves as you expect.
> This rebuilt form where you've copied all the code from the suspect form,
> still has the problem.
>
> You can get the THISFORM.ActiveObject.Name property to determine what
> control really has focus. I would probably put that in a Wait Window in the
> Form.Activate event.
>
> Tracy Pearson
> PowerChurch Software
>
>
[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/CAAJXvaP6PFShWQbCS_outjmUC_RzR1=iaq1ge4a64t6d1e1...@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.

VFP6 Form Problem...

[Desmond Lloyd]

First thanks for the response I got yesterday on what I presented as a Tab
Order problem.

Am running a VP6 form from a real old FoxPro accounting system.   It has a
bunch of menu generation overhead and these huge procedure files... On one
of their screens which is handwritten with says and gets I call this
form.   it is modeless,   default show window,  with a read events
statement after the do myform statement.  Form works fine however,  after
clicking on the edit button I set focus to one of the controls, if I tab
out of it the cursor progresses to the next control,  if  I use the mouse I
can progress to the next control.  However pressing enter always executes
the buttons click event!

Thought that was strange so I checked the behavior on another form (called
from another button on the malfunctioning button).  Exact same scenario,
but after setting focus on the control I can successfully press enter and
move to the next

So I wrote a quick test form with three text boxes and executed roughly the
same code in a button on that form.  Executed the from the same place  and
once again I could successfully move from control to control using the
enter button.

The problem I have with pressing the enter key and having the click fire is
that the user could save something prematurely and then will have to click
the edit button to finish their edits.

I apologize for my long "windedness" ,  but am totally baffled why it works
on every other form,  except this one?  BTW I even rebuilt the form
(copying the contents of my methods) and no joy?

Does anyone have any ideas?
Regards,
Desmond


--- 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/caajxvanq3myo4qqcjdqcjbj1crflvumszlabqnnzj4fnx3u...@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: VFP6: Tab Order Issue (I think)

[Desmond Lloyd]

An impressive answer indeed,  thank you so much!I think so (not having
looked at the particular details of my code yet ).

I will post a reply later today...

Thank You Again,
Desmond



On 5 March 2015 at 10:43, Dave Crozier  wrote:

> ... I forgot to add there is also a section on that page that deals with
> updating data that may shed light on your problem. I wold give it a look
> myself but currently involved in a time critical task...
>
> Dave
>
>
> -Original Message-
> From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Desmond Lloyd
> Sent: 04 March 2015 19:26
> To: ProFox Email List
> Subject: VFP6: Tab Order Issue (I think)
>
> Good Afternoon,
>
> Have an odd problem with a form.  Have an edit button with the caption
> Edit,  Clicking on the edit button changes the caption to Save,  turn off
> some other buttons,  enable some controls and set focus to a combo
> control,  works great.  The only issue is that if I press enter it executes
> the click code in the edit button,  with the caption set to save my update
> procedure executes.  If I tab out of the control it goes to the next field
> properly.
>
> Even tried setting focus to a text box (thinking for some reason the combo
> control was the issue),  no joy...
>
> I have another form that I do the same thing,  setting focus on a text box
> (in this case) and if I press enter it goes to the next field
>
> While I am it,  in the lost focus of the combo box,  if the value is
> changed I enable a previously disabled control box,  works fine if I tab
> out of the comb box,  but if I change the value in the combo box and click
> on the control that should be enabled by the lost focus,  no joy!
>
> What am I missing?
> Any input would be most appreciated!
>
> 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/CAAJXvaP+FMG0txhk2LCS32LB0SZS79ZbkFMq3EN=dqxyrc+...@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: VFP6: Tab Order Issue (I think)

[Desmond Lloyd]

No,  it is set to .f.

On 4 March 2015 at 14:10, Tracy Pearson  wrote:

> Desmond Lloyd wrote on 2015-03-04:
> >  Good Afternoon,
> >
> >  Have an odd problem with a form.  Have an edit button with the caption
> >  Edit,  Clicking on the edit button changes the caption to Save,  turn
> off
> >  some other buttons,  enable some controls and set focus to a combo
> >  control,  works great.  The only issue is that if I press enter it
> executes
> >  the click code in the edit button,  with the caption set to save my
> update
> >  procedure executes.  If I tab out of the control it goes to the next
> field
> >  properly.
> >
> >  Even tried setting focus to a text box (thinking for some reason the
> combo
> >  control was the issue),  no joy...
> >
> >  I have another form that I do the same thing,  setting focus on a text
> box
> >  (in this case) and if I press enter it goes to the next field
> >
> >  While I am it,  in the lost focus of the combo box,  if the value is
> >  changed I enable a previously disabled control box,  works fine if I tab
> >  out of the comb box,  but if I change the value in the combo box and
> click
> >  on the control that should be enabled by the lost focus,  no joy!
> >
> >  What am I missing?
> >  Any input would be most appreciated!
> >
> >  Regards,
> >  Desmond
> >
>
> Desmond,
>
> Is that Edit/Save buttons Default property set to .T. ?
>
>
> Tracy Pearson
> PowerChurch Software
>
>
[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/CAAJXvaPQBU9ChjONicdFfoW10b3DHb3DasS-L8x9kC0mf=y...@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.

VFP6: Tab Order Issue (I think)

[Desmond Lloyd]

Good Afternoon,

Have an odd problem with a form.  Have an edit button with the caption
Edit,  Clicking on the edit button changes the caption to Save,  turn off
some other buttons,  enable some controls and set focus to a combo
control,  works great.  The only issue is that if I press enter it executes
the click code in the edit button,  with the caption set to save my update
procedure executes.  If I tab out of the control it goes to the next field
properly.

Even tried setting focus to a text box (thinking for some reason the combo
control was the issue),  no joy...

I have another form that I do the same thing,  setting focus on a text box
(in this case) and if I press enter it goes to the next field

While I am it,  in the lost focus of the combo box,  if the value is
changed I enable a previously disabled control box,  works fine if I tab
out of the comb box,  but if I change the value in the combo box and click
on the control that should be enabled by the lost focus,  no joy!

What am I missing?
Any input would be most appreciated!

Regards,
Desmond


--- 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/caajxvaoqu0whjtwaxehbbpk9y-04pmqx6zsm6um9zvnznkt...@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: VFP6: Printing to HP Inkjet Printer...

[Desmond Lloyd]

Thank you!

Just tried with VFP9 SP2,  same results.   Checking into drivers now!

Regards,
Desmond


On 28 January 2015 at 09:47, Alan Bourke  wrote:

> On Wed, 28 Jan 2015, at 03:41 PM, Desmond Lloyd wrote:
> >
> > Any hints,
>
>
> 1) VFP9 SP2
> 2) Don't use HP PCL 6 drivers, they are prone to causing issues in VFP.
> Use the PCL 5e or PostScript drivers.
>
> --
>   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/caajxvaoru-s3cecbheg2y8thjfwqg6pwbql2vj8vvvsod_p...@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.

VFP6: Printing to HP Inkjet Printer...

[Desmond Lloyd]

Good Morning,

Anybody seen this before.

Just got a new HP Office Jet Pro  x476dn MFP (color).  Installed on the
network prints wonderfully. However when I print from our classic VFP6
application it either prints partial pages before going to the next,  or a
few lines,  or nothing at all. No errors are being generated when I print.
Simply no content or partial on the paper...

Can print to anything else I have in the shop,  Ricoh,  HP,  Brother you
name it...

Tried the following:

1.)  Removed content from Tag1, Tag2 - no joy
2.)  Set the new printer as my default printer,  modified the report.
Checked tag1, tag2,  specifies the new color printer - no joy
3.)  Abusive language at the printer - no joy 8-)

Any hints,
Regards,
Desmond


--- 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/caajxvapud6mechyggd2gaq4mjxcagmv9uwq7a7rkms87zc-...@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: VFP6: Two Sided Printing

[Desmond Lloyd]

Interesting solution,  two printers.  Makes sense (if you don't mind me
saying so).Yeah,  my two sides will be two different layouts...

Appreciate your help!

Regards,
Desmond


On 20 January 2015 at 07:38, Peter Cushing 
wrote:

> Desmond Lloyd wrote:
>
>> Has anyone had experience printing two documents out of VFP6?  Common
>> sense
>> says I can manually set the printer to print on both sides.  However if I
>> do it out of the report writer,  how to turn on and turn off?  Save
>> printer
>> environment perhaps?
>>
>>
>>
>>
> I have some experience of printing duplex but using one report layout.
> Are you talking about using two layouts - one either side?
> I also just create two versions of the printer, one defined as normal and
> the other duplex.  I can then send to either.
>
> HTH
>
> Peter
>
>
[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/caajxvanatordorczjsdvcs3viagztm6wgoahgxc4itxtk44...@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.

VFP6: Two Sided Printing

[Desmond Lloyd]

Has anyone had experience printing two documents out of VFP6?  Common sense
says I can manually set the printer to print on both sides.  However if I
do it out of the report writer,  how to turn on and turn off?  Save printer
environment perhaps?

Any input would be greatly appreciated...
Regards,
Desmond


--- 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/caajxvamnefkuwc3pmbfq5avlggttwtqu1yfvjw2_ee9aq3r...@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: VFP6: And now for something completely different....

[Desmond Lloyd]

Wow,  that was easy  Thank you Sir!



On 25 November 2014 at 11:24, Bill Anderson  wrote:

> Windows menu pad, Arrange All menu bar would do it...
>
> Bill Anderson
>
> On Tue, Nov 25, 2014 at 8:24 AM, Desmond Lloyd 
> wrote:
>
> > Was banging away on a form yesterday and somehow hit a series of key
> > strokes that placed four equal windows in the UI,  form designer,
> > properties window,  command, and a method...
> >
> > Does someone know what that combination was
> >
> > 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/caajxvan4-x8ggxjwxkgb1oa99hfqjsydxxgdmmto8yvuclh...@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.

VFP6: And now for something completely different....

[Desmond Lloyd]

Was banging away on a form yesterday and somehow hit a series of key
strokes that placed four equal windows in the UI,  form designer,
properties window,  command, and a method...

Does someone know what that combination was

TIA,
Desmond


--- 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/CAAJXvaPxe2fwaB77QAsodwD=QntF_kX80uJ1tzVY2_b=1qp...@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: Vision Point - SBT - Help!! Stuck on "l_dtl11()"

[Desmond Lloyd]

Good Morning,

Have you been able to find anything?I work with a modified version of
SBT,   all the GL Account and account summary information is stored in the
glaccntxx, where xx is the company ID.  You could add a field to it (for
the insurance accounts) and summarize from there?

In regards to l_? file,  if you have searched all the associated prg files
and can't find it,  it would suggest that you have a  program that is not
decompiled?  (forgive me if this is not applicable)

Regards,
Desmond




On 15 November 2014 08:25, Wes Wilson  wrote:

> I am making a "simple"change to a report but cannot find the function
> "l_dtl11()" anywhere.  Searched using Code References, all files as well as
> GoFish.  No luck.
> I promised the have this done by 11/17 but now...
> Any suggestions?   There are a few other "l_dtl" functions which I cannot
> find as well.
> Thanks Wes Wilson, President   ERW Custom Programming, Inc. Crescent Lake
> Plaza
> 5459  Elizabeth Lake Rd.
> Waterford, MI 48327
> (248) 683-4182  www.erw.com weswil...@erw.com Visual FoxPro Programmers –
> Your connection to great Visual FoxPro Programmers
> |   |
> |   |   |   |   |   |
> | Visual FoxPro Programmers – Your connection to great Visual FoxPro
> ProgrammersYour connection to great Visual FoxPro Programmers |
> |  |
> | View on www.visual-foxpro-programmer.com | Preview by Yahoo |
> |  |
> |   |
>
>
>
>   From: "profox-requ...@leafe.com" 
>  To: profox@leafe.com
>  Sent: Wednesday, August 20, 2014 5:29 PM
>  Subject: ProFox Digest, Vol 136, Issue 17
>
> - Forwarded Message -
>
> Send ProFox mailing list submissions to
> profox@leafe.com
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://mail.leafe.com/mailman/listinfo/profox
> or, via email, send a message with subject or body 'help' to
> profox-requ...@leafe.com
>
> You can reach the person managing the list at
> profox-ow...@leafe.com
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of ProFox digest..."
>
> Today's Topics:
>
>   1. Re: [NF] Enbedding a PDF (Charles Hart Enzer, M.D.)
>   2. Re: New Job & My Crowd Funding Campaign (Kurt @ VR-FX)
>   3. Re: New Job & My Crowd Funding Campaign (Kurt @ VR-FX)
>   4. Re: Causes of General C5 errors when printing? (Paul Hemans)
>   5. Re: Causes of General C5 errors when printing? (Vince Teachout)
>   6. [OFF] test (Vladimir Aro)
>   7. Re: [OFF] test (G?rard Lochon)
>   8. Re: [OFF] test (Alan Bourke)
>   9. Re: [OFF] test (Alan Bourke)
>   10. Re: [OFF] test (Koen Piller)
>   11. [NF] the guy we all love to hate (Stephen Russell)
>   12. Re: [NF] the guy we all love to hate
>   (mbsoftwaresoluti...@mbsoftwaresolutions.com)
>   13. Re: [NF] the guy we all love to hate (Stephen Russell)
>   14. Re: [OFF] test (G?rard Lochon)
>   15. Re: [NF] the guy we all love to hate (Fred Taylor)
>   16. Re: [NF] the guy we all love to hate (Stephen Russell)
>   17. Date Picker in Grid (Jeff Johnson)
> Dear Dan:
>
> Thank you.
>
> I am almost there.
>
> A new window did open up.
>
>   - You have chosen to open Slides.pdf
>   - [source of PDF]
>   - What should Firefox do with this file?
>   - Open with. . . ..
>   - Save File
>
> I am looking to have it just open in a second window.  Lacking a PDF
> Viewer, a message would pop up:
>
> It appears you don't have a PDF plugin for this browser.
>   No biggie... you can click here to
>   download the PDF file
>
> In other words, how to combine the Attrib Tag with the Object Tag:
>
>  height="100%">
>
>   It appears you don't have a PDF plugin for this browser.
>   No biggie... you can click here to
>   download the PDF file.
>
> 
>
> ​
>
>
> *C​harles​*
> *Charles Hart Enzer, M.D., FAACAP*
>
>
> *Volunteer Associate Professor of PsychiatryUniversity of Cincinnati
> Medical CenterWebSite:http://TinyURL.com/EnzerMD
> *
>
>
>
>
>
>
>
> *If You See What Needs To Be Repaired And How to Repair It,Then You Have
> Found a Piece of The WorldThat G-D Has Left For You to Complete.But If You
> Only See What Is Wrong And How Ugly It Is,Then It Is Yourself That Needs
> Repair.  Menachem Mendel Schneerson*
>
> *Stop **Spammers** and **Virus Propagation*
> *Before forwarding, please delete the history of all email address*
>
>
> On Tue, Aug 19, 2014 at 3:35 PM, Dan Covill 
> wrote:
>
> >  ** That'll teach me to put HTML examples in a modern webmail system!  **
> > Charles:The attribute goes in the  element, thus:
> >  (less than)a href="http://www.mydoc.pdf"; target="_blank">
> > "_blank"  (don't forget the underscore) will cause the browser to open
> the
> > reference in a new tab or window, depending on how the browser is
> > configured.  I've had to do this in several cases, such as Facebook,
> where
> > the referenced site/page/object cannot be opened in a frame.  Works
> fine.If
> > the user doesn't have a PDF viewer as an add-on to the browser they're
> > using, they'll most likely g

Re: VFP6: Calling a Form Method from another form....

[Desmond Lloyd]

Thanks to all,  really appreciate everyone's input.  For now have thrown
the procedure from the other file into "Form B" 8-)   It work and I gotta
get this done.


Regards and Thanks Again...
Desmond


On 6 November 2014 04:57, Rafael Copquin  wrote:

> Yes, of course, formB must be modal, otherwise it will open briefly and
> disappear instantaneously
>
> Rafael Copquin
>
> El 05/11/2014 20:29, Tracy Pearson escribió:
>
>> Desmond, The options given are nice, they work. However, if your Form B
>> is not Modal, then Form A could be closed, yet, not really since Form B has
>> a reference to it. If Form B is Modal, then you can simply call the method
>> on Form A after Form B is released. You might be better putting this code
>> in a Procedure file (or a Class that can be added to the form) and called
>> from both forms.
>>
>
>  Tracy Pearson PowerChurch Software
>>
>
>
[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/CAAJXvaPeKZWOGAxsEwnGkuL9=xY9OtEMy00--d0ACrLYSoqP=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.

VFP6: Calling a Form Method from another form....

[Desmond Lloyd]

An odd question (perhaps)

Old VFP6 Code,  do form A,  button on form A calls form B.  Is there a way
in form B  that I can call a method from form A.

Tried the link thing in the button calling form B in Form A,  but no joy.
Tried referencing the name of form A  frmmyfrm.mymethod in form B but it
complains that it cannot be find...

Would be easy to create the same method in form B,  but would prefer
calling the same method in form B.

Any suggestions or am I barking up the wrong tree

TIA/Regards,
Desmond


--- 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/caajxvamxcismdp+np_qy+gh18yfqhrdeybs7calhthwhhzr...@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: I've resubscribed. Can anyone see this?

[Desmond Lloyd]

Yes we see this



On 21 October 2014 21:49, Lew Schwartz  wrote:

> Or can I see it?
>
>
> -Lew Schwartz
>
>
> --- 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/caajxvammzc0qomxjpms4vcbea85dor1uby7lk9mb4uhnpvm...@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: Table Repair

[Desmond Lloyd]

I recently acquired a file repair utility.  Had  a file with some bad memo
field pointers.  Could run it on your file if you would like  Looks
like you might have  some help already.

Regards,
Desmond



On 7 October 2014 03:49, Peter Cushing  wrote:

> Ken Kixmoeller (ProFox) wrote:
>
>> Hey, Guys - --
>>
>> A table from one of my long-time client's systems is corrupt. I am trying
>> to use SDT to repair it, but nothing is happening. No response, no error
>> messages, no nuttin'.
>>
>> I don't have any other repair utility.
>>
>> Ideas?
>>
>>
>>
> How big is it?  I could have a look if you can email it over.
>
> Peter
>
>
>
[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/CAAJXvaPTbHigfYfcgV=Ceo=73rrwsbsvpaxwmevpvwoptpx...@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: Re:VFP9: Command Box:

[Desmond Lloyd]

Nope on the noconsole...  occurs with reports and with "no desktop"
forms  More irritating than anything

Regards,
Desmond


On 1 October 2014 11:27, Richard Kaye  wrote:

> A bunch of white space in the command window perhaps? Activate the command
> window and press the escape key? Why would be another question. Are you
> using the NOCONSOLE keyword when you run your reports?
>
> --
>
> rk
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> Desmond Lloyd
> Sent: Wednesday, October 01, 2014 12:21 PM
> To: profoxt...@leafe.com
> Subject: Re:VFP9: Command Box:
>
> Least of our worries However,
>
> Has anyone ever experienced running a report,  or a form  from the VFP GUI
> and coming back to the command box and it is empty?   My fix is to drag it
> and align it to the top of the main window and voilla it "reappears"...
>
> Huh?
>
> Regards,
> Desmond
>
>
[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/CAAJXvaOdBh25zYSR6kU-Y5KXi8pH=yol9ggyzxkbpsxudkt...@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: Command Box:

[Desmond Lloyd]

Least of our worries However,

Has anyone ever experienced running a report,  or a form  from the VFP GUI
and coming back to the command box and it is empty?   My fix is to drag it
and align it to the top of the main window and voilla it "reappears"...

Huh?

Regards,
Desmond


--- 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/caajxvaod39vqgzv2-z4mlqh-q0c_uc275i7nf-uk_-n+09e...@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: VFP6 Severe memo bloat

[Desmond Lloyd]

Hope not...

On 29 September 2014 14:14, Allen  wrote:

> Funny this should come up. I just had a missing link problem with a client.
> It's the link to the DBC I think. What's odd is I don't use dbc's. In this
> case I have a repair routine that removes such links. (Years ago I used
> dbc's) and that fixed it second try.
> I wonder if this is a win8.1 issue
> Al
>
> -Original Message-
>
> Hi, Desmond
> Sounds to me like the links in the DBF have lost their way.Do the users see
> the existing memo, and just can't update it, or are the memos missing
> and/or
> scrambled?  I guess I'm asking if you did a repair operation on the DBF/FPT
> or just replaced the FPT file.  Anyway, if the links in the memo field
> don't
> point to the right place in the FPT you are well and truly hosed.
>
>
>
> ---
> This email is free from viruses and malware because avast! Antivirus
> protection is active.
> http://www.avast.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/CAAJXvaOeU3vzFs3NeqxBuj=9_hbfnnhovjujbkxmftz0zz6...@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: VFP6: "Regenerating" a file...

[Desmond Lloyd]

Thank you...

Yes was able to get "most" of the data restored to their original
locations...  Am beginning to think that "my users" might be overreacting a
little.  After the fix was hearing reports of fields not getting updated
(the memo fields).  Wouldn't ya know haven't heard a thing for several
hours..


Regards,
Desmond



On 29 September 2014 13:48, Man-wai Chang  wrote:

> If you worried, you should re-create the set of DBF+FPT files from
> scratch, then use whatever method appropriate to copy data from the
> old set of flles to the new one!
>
> Does your system backup that set of DBF+FPT files periodically?
> Use the backup to look for errors!
>
> On Tue, Sep 30, 2014 at 12:46 AM, Desmond Lloyd 
> wrote:
> > Would someone please recommend the best way to rebuild the file that
> would
> > avoid any entanglements with the original...
> >
> > Copy stru,  append from the original?  copy to new file name?   Magic
> wand?
> > 8-).  This monster has 233 fields, nine of them are memo fields...
>
>
> --
>  .~. 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/caajxvam+hdqs6mqurjgr3vhf4vmsk56de23achwpxotnbgn...@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: VFP6 Severe memo bloat

[Desmond Lloyd]

Thank you Dan,

Actually I acquired Abri,  did a test on an older version and it found
beaucoup problems with the memo field(s).  I did a copy to on the
production file and it found nothing?  Could the "copy to" have resolved
the issue? (gotta be a stretch)

You are the second person to recommend VFP9,  and you are exactly right.
I keep experiencing weird little quirks with VFP6,  like code that process
one way,  but when you step through it it does something else. (really,  no
joke).  After working with the forms designer in VFP9,  working with the
VFP6 is tough!

Regards,
Desmond




On 29 September 2014 13:37, Dan Covill  wrote:

> Hi, Desmond
> Sounds to me like the links in the DBF have lost their way.Do the users
> see the existing memo, and just can't update it, or are the memos missing
> and/or scrambled?  I guess I'm asking if you did a repair operation on the
> DBF/FPT or just replaced the FPT file.  Anyway, if the links in the memo
> field don't point to the right place in the FPT you are well and truly
> hosed.
> Best thing might be to get a repair program (I know nothing about Abri,
> but the one from Canada (Doug ??) is very good), put the original (bad) FPT
> file back, and see what you can do.
> Also, I don't see where the problems would be in upgrading to VFP9, but
> that's another topic.
> Dan CovillSan Diego
>
> > Date: Mon, 29 Sep 2014 11:30:29 -0500
> > Subject: Re: VFP6 Severe memo bloat
> > From: desmond.ll...@gmail.com
> > To: profoxt...@leafe.com
> >
> > Further problems...  Now users are reporting that there updates are not
> > being saved,  it's just a replace mymemo with m.mymemo?
> >
> > Yikes,
> > Regards,
> > Desmond
> >
> >
> > On 29 September 2014 11:23, Desmond Lloyd 
> wrote:
> >
> > > No general fields.  I think the damage occurred when I issued a Pack
> > > Memo,  however I didn't run that until after I had encountered the
> first
> > > error.  (failure to run a report).
> > > Do you think I would be wise I changing the block size?  Sounds like
> it.
> > > I've got about 100 users accessing these memo fields (they're are nine
> in
> > > the file)
> > >
> > > Regards,
> > > Desmond
> > >
> > >
> > > On 29 September 2014 10:25, Jack Skelley  >
> > > wrote:
> > >
> > >> Desmond:
> > >> Are there any general fields in this table?
> > >> I have seen issues when a general field is stored in a table the blot
> can
> > >> be incredible. As you know the general field is stored in the FPT.
> > >> I do store JPGs in general fields to be distributed in the system then
> > >> when received the JPGs are extracted and saved in a separate folder.
> Then
> > >> the distributed table is erased. The memo field of the receiving
> table now
> > >> holds the file name as to where to load the JPG from.
> > >> When I left the JPG in the memo field the blot was crazy large. So I
> > >> wrote procedure that would set the blocksize of the for the FPT. When
> I did
> > >> this the size of the FPT was dramatically reduced.
> > >> I have not experienced much blot in VFP6 when a non-general field
> exists.
> > >> Read in the help file about 'set blocksize' for the memo field.
> > >> Jack
> > >>
> > >> 
> > >> From: ProfoxTech [profoxtech-boun...@leafe.com] on behalf of Desmond
> > >> Lloyd [desmond.ll...@gmail.com]
> > >> Sent: Sunday, September 28, 2014 11:07 AM
> > >> To: profoxt...@leafe.com
> > >> Subject: VFP6 Severe memo bloat
> > >>
> > >> Good morning,
> > >>
> > >> Wanted to share with everyone and solicit any thoughts...
> > >>
> > >> Huge,  233 field,  over 200,000 record table with approximately 20
> index
> > >> tags.
> > >>
> > >> Runs under our manufacturing system,  it has been "relatively fine".
> Have
> > >> some issues with memo fields in the past.  Was able to correct by
> > >> re-writing the file,  packing memo.
> > >>
> > >> About a month a ago started noticing some noticeable delays when
> running
> > >> queries against this table.  Significant but they ran  Last night
> I
> > >> started to run a report and it hung...  No error message,  nothing,
> had
> > >> to
> > >> "force close" VFP...  Tried cop

Re: VFP6 DBF Repair

[Desmond Lloyd]

Thank you...  GREAT idea,  Good be a little painful,   just suck in the
memo fields when needed,  data entry time,  report printing time...  Do you
see any danger/risk with 233 fields,  226 without memo fields?

Regards,
Desmond


On 29 September 2014 13:30, Kevin Cully 
wrote:

> I know this is beyond the topic of fixing your current situation, but I
> wanted to throw this out there.
>
> I had trouble with a table with many memo field.  It caused me no end of
> troubles.  The table held ITEMS that were for sale.  I split out all of the
> fields to another table called ITEMS_EXTRA that held basically all of memo
> field information.
>
> It held the primary key, the foreign key to the item table, the memo field
> type, memo field contents, date created and by who, date last updated and
> by who.
>
> By splitting the memo fields away from the more conventional data, it made
> the entire data system more stable and maintainable.
>
> HTH,
> Kevin
>
>
> On 09/29/2014 01:42 PM, Desmond Lloyd wrote:
>
>> Thank you Sir,
>>
>> Yeah,  yeah I know it is getting older...  I am too actually.  It's all
>> good,  update to VFP9 with this application is going to be most painful...
>> Might just have to bite the bullet...
>>
>> Regards,
>> Desmond
>>
>>
>
[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/caajxvamikacgqutswcsrhbrqx4pfg6nekoa46uuvjmdrxm1...@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: VFP6 DBF Repair

[Desmond Lloyd]

Thank you Sir,

Yeah,  yeah I know it is getting older...  I am too actually.  It's all
good,  update to VFP9 with this application is going to be most painful...
Might just have to bite the bullet...

Regards,
Desmond


On 29 September 2014 12:38, Ted Roche  wrote:

> Abri has worked well for me in the past.
>
> Also, I know we've said it before, but VFP6 is not getting any younger.
> Each version of VFP added stability and patched bugs that could prevent
> many kinds of data corruption from occurring.
>
>
> On Mon, Sep 29, 2014 at 1:00 PM, Desmond Lloyd 
> wrote:
>
> > This is a rather logical follow-up.  What do you guys recommend for DBF
> > Repair?  Someone recommended Abri,  looks good...
> >
> > Any others?
> >
> > Appreciate a quick response,  gotta get this thing fixed!
> >
> > 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/CAAJXvaN72EFN-33AcAO88OFBWuz=+by_mkphhna22zpgjfm...@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: VFP6 Severe memo bloat

[Desmond Lloyd]

No not at all...  I work with a fine group of people,  but you know how it
goes,  if they are having a problem,  it is the most important thing in the
world,  In the meantime I can't get it repaired!  8-)

On 29 September 2014 12:18, Richard Kaye  wrote:

> Deadly serious, I know, Desmond. Apologies if I was stating the obvious.
>
> I feel your pain. It's hard to say what the best solution will be until
> you know the scope of the problem. Off the top of my head it sounds like
> the pointer to where the next chunk of memo data is supposed to be written
> is wrong but there could be other issues as well. My experience has been
> that Recover seems to handle memo field issues better than Foxfix.
>
> Sometimes you can recover from this problem doing a "copy to" a new table.
>
> --
>
> rk
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> Desmond Lloyd
> Sent: Monday, September 29, 2014 12:57 PM
> To: profoxt...@leafe.com
> Subject: Re: VFP6 Severe memo bloat
>
> No kidding...
>
> On 29 September 2014 11:48, Richard Kaye  wrote:
>
> > Smells like you still have database/table corruption that needs to be
> > addressed. Replacing the memo fields that have bad data doesn't
> > necessarily mean that your troubles are over. You need to run some
> > repair tool like Abri Recover or Foxfix against your data and see what
> it tells you.
> >
> > --
> >
> > rk
> > -Original Message-
> > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> > Desmond Lloyd
> > Sent: Monday, September 29, 2014 12:30 PM
> > To: profoxt...@leafe.com
> > Subject: Re: VFP6 Severe memo bloat
> >
> > Further problems...  Now users are reporting that there updates are
> > not being saved,  it's just a replace mymemo with m.mymemo?
> >
> > Yikes,
> > Regards,
> > Desmond
> >
> >
> > On 29 September 2014 11:23, Desmond Lloyd 
> wrote:
> >
> > > No general fields.  I think the damage occurred when I issued a Pack
> > > Memo,  however I didn't run that until after I had encountered the
> > > first error.  (failure to run a report).
> > > Do you think I would be wise I changing the block size?  Sounds like
> it.
> > > I've got about 100 users accessing these memo fields (they're are
> > > nine in the file)
> > >
> > > Regards,
> > > Desmond
> >
> >
[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/caajxvan9sfquvrutqxmlrh9r+zove1p2frsnexkh2hpqtf3...@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: VFP6 DBF Repair

[Desmond Lloyd]

This is a rather logical follow-up.  What do you guys recommend for DBF
Repair?  Someone recommended Abri,  looks good...

Any others?

Appreciate a quick response,  gotta get this thing fixed!

Regards,
Desmond


--- 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/caajxvamfhjmmefska8vja+l4oex_xgw2gqtcnjtp5xb4ja+...@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: VFP6 Severe memo bloat

[Desmond Lloyd]

No kidding...

On 29 September 2014 11:48, Richard Kaye  wrote:

> Smells like you still have database/table corruption that needs to be
> addressed. Replacing the memo fields that have bad data doesn't necessarily
> mean that your troubles are over. You need to run some repair tool like
> Abri Recover or Foxfix against your data and see what it tells you.
>
> --
>
> rk
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> Desmond Lloyd
> Sent: Monday, September 29, 2014 12:30 PM
> To: profoxt...@leafe.com
> Subject: Re: VFP6 Severe memo bloat
>
> Further problems...  Now users are reporting that there updates are not
> being saved,  it's just a replace mymemo with m.mymemo?
>
> Yikes,
> Regards,
> Desmond
>
>
> On 29 September 2014 11:23, Desmond Lloyd  wrote:
>
> > No general fields.  I think the damage occurred when I issued a Pack
> > Memo,  however I didn't run that until after I had encountered the
> > first error.  (failure to run a report).
> > Do you think I would be wise I changing the block size?  Sounds like it.
> > I've got about 100 users accessing these memo fields (they're are nine
> > in the file)
> >
> > Regards,
> > Desmond
>
>
[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/caajxvanzdgzwkptsygyg0qltunm9zsyn_7m8cb+660wfebg...@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.

VFP6: "Regenerating" a file...

[Desmond Lloyd]

I'm the guy with the bad  memo fields.  Was able to update the memo files
from a backup and thought all was good...

Now some people are experience issues with the field being updated.  Bad on
me,  I use a variable so if they click save they think all is good...

Would someone please recommend the best way to rebuild the file that would
avoid any entanglements with the original...

Copy stru,  append from the original?  copy to new file name?   Magic wand?
8-).  This monster has 233 fields, nine of them are memo fields...

Regards,
Desmond


--- 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/CAAJXvaNBZ=U0KD0WJ_W=glwoy59wdstr7v9yzs6oi-rkdjt...@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: VFP6 Severe memo bloat

[Desmond Lloyd]

Further problems...  Now users are reporting that there updates are not
being saved,  it's just a replace mymemo with m.mymemo?

Yikes,
Regards,
Desmond


On 29 September 2014 11:23, Desmond Lloyd  wrote:

> No general fields.  I think the damage occurred when I issued a Pack
> Memo,  however I didn't run that until after I had encountered the first
> error.  (failure to run a report).
> Do you think I would be wise I changing the block size?  Sounds like it.
> I've got about 100 users accessing these memo fields (they're are nine in
> the file)
>
> Regards,
> Desmond
>
>
> On 29 September 2014 10:25, Jack Skelley 
> wrote:
>
>> Desmond:
>> Are there any general fields in this table?
>> I have seen issues when a general field is stored in a table the blot can
>> be incredible. As you know the general field is stored in the FPT.
>> I do store JPGs in general fields to be distributed in the system then
>> when received the JPGs are extracted and saved in a separate folder. Then
>> the distributed table is erased. The memo field of the receiving table now
>> holds the file name as to where to load the JPG from.
>> When I left the JPG in the memo field the blot was crazy large. So I
>> wrote procedure that would set the blocksize of the for the FPT. When I did
>> this the size of the FPT was dramatically reduced.
>> I have not experienced much blot in VFP6 when a non-general field exists.
>> Read in the help file about 'set blocksize' for the memo field.
>> Jack
>>
>> 
>> From: ProfoxTech [profoxtech-boun...@leafe.com] on behalf of Desmond
>> Lloyd [desmond.ll...@gmail.com]
>> Sent: Sunday, September 28, 2014 11:07 AM
>> To: profoxt...@leafe.com
>> Subject: VFP6 Severe memo bloat
>>
>> Good morning,
>>
>> Wanted to share with everyone and solicit any thoughts...
>>
>> Huge,  233 field,  over 200,000 record table with approximately 20 index
>> tags.
>>
>> Runs under our manufacturing system,  it has been "relatively fine".  Have
>> some issues with memo fields in the past.  Was able to correct by
>> re-writing the file,  packing memo.
>>
>> About a month a ago started noticing some noticeable delays when running
>> queries against this table.  Significant but they ran  Last night I
>> started to run a report and it hung...  No error message,  nothing,  had
>> to
>> "force close" VFP...  Tried copying the file (with production) somewhere
>> and that would bomb with fatal exception error.Tried different copy
>> to,  next 100,  next 500 that kind of thing.  Accidentally ran into the
>> fact that if I set a filter or ran a query for a certain condition it
>> would  "would blow".  So I opened the culprit file,  set a filter to that
>> condition,  made a copy of the structure and walked the filtered original
>> scatter memvar appended blank to the copy and when it blew up I know what
>> record was having the issue...
>>
>> ...so,  it turns out that some of the records had memo fields that were
>> stuffed (in one case) with 125,000 characters!   This was after a pack
>> memo.  Replacing the contents of the malcontent memo field resolved the
>> issue  I finally identified six of these puppies,  made the
>> replacement
>> and all is well...
>>
>> Any suggestions, thoughts on how to avoid?  Was thinking of running a
>> query
>> for len(mymemofield) > 5000,  periodically and see what I find...  How in
>> the blue blazes do you get 125,000 characters in a memo field?   obviously
>> VFP6 does not like it...
>>
>> Appreciate the input,
>> 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/caajxvanq0fypz7yb5aivndvb-tzzbr0kun6gwp0pbc8pmwl...@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: VFP6 Severe memo bloat

[Desmond Lloyd]

No general fields.  I think the damage occurred when I issued a Pack Memo,
however I didn't run that until after I had encountered the first error.
(failure to run a report).
Do you think I would be wise I changing the block size?  Sounds like it.
I've got about 100 users accessing these memo fields (they're are nine in
the file)

Regards,
Desmond


On 29 September 2014 10:25, Jack Skelley 
wrote:

> Desmond:
> Are there any general fields in this table?
> I have seen issues when a general field is stored in a table the blot can
> be incredible. As you know the general field is stored in the FPT.
> I do store JPGs in general fields to be distributed in the system then
> when received the JPGs are extracted and saved in a separate folder. Then
> the distributed table is erased. The memo field of the receiving table now
> holds the file name as to where to load the JPG from.
> When I left the JPG in the memo field the blot was crazy large. So I wrote
> procedure that would set the blocksize of the for the FPT. When I did this
> the size of the FPT was dramatically reduced.
> I have not experienced much blot in VFP6 when a non-general field exists.
> Read in the help file about 'set blocksize' for the memo field.
> Jack
>
> ________
> From: ProfoxTech [profoxtech-boun...@leafe.com] on behalf of Desmond
> Lloyd [desmond.ll...@gmail.com]
> Sent: Sunday, September 28, 2014 11:07 AM
> To: profoxt...@leafe.com
> Subject: VFP6 Severe memo bloat
>
> Good morning,
>
> Wanted to share with everyone and solicit any thoughts...
>
> Huge,  233 field,  over 200,000 record table with approximately 20 index
> tags.
>
> Runs under our manufacturing system,  it has been "relatively fine".  Have
> some issues with memo fields in the past.  Was able to correct by
> re-writing the file,  packing memo.
>
> About a month a ago started noticing some noticeable delays when running
> queries against this table.  Significant but they ran  Last night I
> started to run a report and it hung...  No error message,  nothing,  had to
> "force close" VFP...  Tried copying the file (with production) somewhere
> and that would bomb with fatal exception error.Tried different copy
> to,  next 100,  next 500 that kind of thing.  Accidentally ran into the
> fact that if I set a filter or ran a query for a certain condition it
> would  "would blow".  So I opened the culprit file,  set a filter to that
> condition,  made a copy of the structure and walked the filtered original
> scatter memvar appended blank to the copy and when it blew up I know what
> record was having the issue...
>
> ...so,  it turns out that some of the records had memo fields that were
> stuffed (in one case) with 125,000 characters!   This was after a pack
> memo.  Replacing the contents of the malcontent memo field resolved the
> issue  I finally identified six of these puppies,  made the replacement
> and all is well...
>
> Any suggestions, thoughts on how to avoid?  Was thinking of running a query
> for len(mymemofield) > 5000,  periodically and see what I find...  How in
> the blue blazes do you get 125,000 characters in a memo field?   obviously
> VFP6 does not like it...
>
> Appreciate the input,
> 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/caajxvao5u6yhswfhhdpkmxczmvc2z7ntdkgy3edgbke075c...@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.

VFP6 Severe memo bloat

[Desmond Lloyd]

Good morning,

Wanted to share with everyone and solicit any thoughts...

Huge,  233 field,  over 200,000 record table with approximately 20 index
tags.

Runs under our manufacturing system,  it has been "relatively fine".  Have
some issues with memo fields in the past.  Was able to correct by
re-writing the file,  packing memo.

About a month a ago started noticing some noticeable delays when running
queries against this table.  Significant but they ran  Last night I
started to run a report and it hung...  No error message,  nothing,  had to
"force close" VFP...  Tried copying the file (with production) somewhere
and that would bomb with fatal exception error.Tried different copy
to,  next 100,  next 500 that kind of thing.  Accidentally ran into the
fact that if I set a filter or ran a query for a certain condition it
would  "would blow".  So I opened the culprit file,  set a filter to that
condition,  made a copy of the structure and walked the filtered original
scatter memvar appended blank to the copy and when it blew up I know what
record was having the issue...

...so,  it turns out that some of the records had memo fields that were
stuffed (in one case) with 125,000 characters!   This was after a pack
memo.  Replacing the contents of the malcontent memo field resolved the
issue  I finally identified six of these puppies,  made the replacement
and all is well...

Any suggestions, thoughts on how to avoid?  Was thinking of running a query
for len(mymemofield) > 5000,  periodically and see what I find...  How in
the blue blazes do you get 125,000 characters in a memo field?   obviously
VFP6 does not like it...

Appreciate the input,
Regards,
Desmond


--- 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/CAAJXvaNTSRysLrtQpcvRsF7iJ-5bRY5cOc=gz2kq-5uvvec...@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: Adding a Check box control to a grid

[Desmond Lloyd]

Super,  Thank you so much!

On 26 September 2014 12:17, Frank Cazabon  wrote:

> On 26/09/2014 11:51 AM, Desmond Lloyd wrote:
>
>> How do you add a check box to a grid,
>>
>
> ensure you have the column you want the check box in as the currently
> selected control (Shift + Ctrl + click), then click on the check box on the
> toolbar and click on the column (in the white space, not the column
> header).  You can then make the check box the active control of the column
> or you can delete the default text box by selecting it in the Properties
> sheet and then pressing the Delete key on your keyboard.
>
> --
>
> Frank.
>
> Frank Cazabon
>
>
[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/CAAJXvaPNLZOpOi+Cy=_MURDgKWQM5ESwaZ4Fuu=N_34q+7a=p...@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.

VFP9: Adding a Check box control to a grid

[Desmond Lloyd]

Forgive my thickness this morning...

How do you add a check box to a grid,  I remember something about adding it
(whatever that takes) and then you remove the textbox that was originally
associated with that column.

Would someone please point me in the right direction...

Regards,
Desmond


--- 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/caajxvaorhqvqbotr3680mby18mykwhzcty6tdbseb3g9vxw...@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: VFP6: Grid Column Width Issue

[Desmond Lloyd]

Understood  8-)

It frustrating sometimes when the slightest change of who knows hat


On 5 September 2014 09:46, Richard Kaye  wrote:

> Every property you want to set, of course.
>
> --
>
> rk
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> Richard Kaye
> Sent: Friday, September 05, 2014 10:45 AM
> To: profoxt...@leafe.com
> Subject: RE: VFP6: Grid Column Width Issue
>
> Once you start down the road of defining your grid in code it's best to
> handle every property there, imho.
>
> --
>
> rk
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> Desmond Lloyd
> Sent: Friday, September 05, 2014 10:43 AM
> To: profoxt...@leafe.com
> Subject: Re: VFP6: Grid Column Width Issue
>
> Update...
>
> Redefined four columns and good,  fifth column 1 character wide...
> Arrrgh...  Set width,  works!  On with the show...
>
> On 5 September 2014 09:26, Desmond Lloyd  wrote:
>
> > Good point Richard... 8-)  FWIW was "redefining" the grid because I do
> > not create the cursor for the grid until the init of the form.  Had
> > worked before so I saw no reason to change per se...
> >
> > How bizarre,  turns out (final proof pending) that I had moved a
> > column, using the mouse, to the far right and then deleted it by
> > reducing the number of columns in the layout section..  As I had
> > mentioned the first few columns were just fine at about the fourth
> > column (where the moved column
> > was) column width abruptly changed to 1.  Followed Mr. Croziers
> > advice, Mr. Pearson's no joy.  Deleted the original grid,  recreated a
> > new and now have four good columns,  no issues,  same code (with fewer
> columns).
> >
> > So my thinking is that removing the column the way I did caused the
> > problems?
> >
> > Analysis paralysis perhaps?
> >
> > Regards,
> > Desmond
>
>
[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/caajxvaos2smkhggruaazbjokqfaxcdp12gvlcyupfnfv4mq...@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: VFP6: Grid Column Width Issue

[Desmond Lloyd]

Update...

Redefined four columns and good,  fifth column 1 character wide...
Arrrgh...  Set width,  works!  On with the show...



On 5 September 2014 09:26, Desmond Lloyd  wrote:

> Good point Richard... 8-)  FWIW was "redefining" the grid because I do not
> create the cursor for the grid until the init of the form.  Had worked
> before so I saw no reason to change per se...
>
> How bizarre,  turns out (final proof pending) that I had moved a column,
> using the mouse, to the far right and then deleted it by reducing the
> number of columns in the layout section..  As I had mentioned the first few
> columns were just fine at about the fourth column (where the moved column
> was) column width abruptly changed to 1.  Followed Mr. Croziers advice,
> Mr. Pearson's no joy.  Deleted the original grid,  recreated a new and now
> have four good columns,  no issues,  same code (with fewer columns).
>
> So my thinking is that removing the column the way I did caused the
> problems?
>
> Analysis paralysis perhaps?
>
> Regards,
> Desmond
>
>
>
>
>
>
>
>
> On 5 September 2014 08:43, Richard Kaye  wrote:
>
>> If you're going to the effort of building all this in code, why not just
>> add setting width as part of your routine? Or did I miss something?
>>
>> --
>>
>> rk
>> -Original Message-
>> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
>> Desmond Lloyd
>> Sent: Friday, September 05, 2014 9:21 AM
>> To: profoxt...@leafe.com
>> Subject: Re: VFP6: Grid Column Width Issue
>>
>> Thank you,  however no joy...  What am I doing wrong?  (you're supposed
>> to focus your attention to the west and figure it out! 8-))  I have another
>> form that I am doing the same thing with and it works fine,  and I don't
>> even blank the record source.  Create the cursor,  bob.recordsource =
>> 'mycursor' bob.grc1.column1.controlsource = 'mycursor.field1' and off we
>> go... The code is the same in the new...
>>
>> Interesting enough the first three columns are just fine...  Am going to
>> reduce the grid to those first three columns and start building it up one
>> column at a time...   But if anyone has any ideas I would be most
>> interested...
>>
>> Regards,
>> Desmond
>>
>>
[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/caajxvamvbtlo9fxpyejkq-ifvct5aivbwrk3jqzah42nxpk...@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: VFP6: Grid Column Width Issue

[Desmond Lloyd]

Good point Richard... 8-)  FWIW was "redefining" the grid because I do not
create the cursor for the grid until the init of the form.  Had worked
before so I saw no reason to change per se...

How bizarre,  turns out (final proof pending) that I had moved a column,
using the mouse, to the far right and then deleted it by reducing the
number of columns in the layout section..  As I had mentioned the first few
columns were just fine at about the fourth column (where the moved column
was) column width abruptly changed to 1.  Followed Mr. Croziers advice,
Mr. Pearson's no joy.  Deleted the original grid,  recreated a new and now
have four good columns,  no issues,  same code (with fewer columns).

So my thinking is that removing the column the way I did caused the
problems?

Analysis paralysis perhaps?

Regards,
Desmond








On 5 September 2014 08:43, Richard Kaye  wrote:

> If you're going to the effort of building all this in code, why not just
> add setting width as part of your routine? Or did I miss something?
>
> --
>
> rk
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> Desmond Lloyd
> Sent: Friday, September 05, 2014 9:21 AM
> To: profoxt...@leafe.com
> Subject: Re: VFP6: Grid Column Width Issue
>
> Thank you,  however no joy...  What am I doing wrong?  (you're supposed to
> focus your attention to the west and figure it out! 8-))  I have another
> form that I am doing the same thing with and it works fine,  and I don't
> even blank the record source.  Create the cursor,  bob.recordsource =
> 'mycursor' bob.grc1.column1.controlsource = 'mycursor.field1' and off we
> go... The code is the same in the new...
>
> Interesting enough the first three columns are just fine...  Am going to
> reduce the grid to those first three columns and start building it up one
> column at a time...   But if anyone has any ideas I would be most
> interested...
>
> Regards,
> Desmond
>
>
[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/CAAJXvaOnZmzn1J2_LmjVfby0tKEXxdozUbg+42Lt=mx1s+p...@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: VFP6: Grid Column Width Issue

[Desmond Lloyd]

Thank you,  however no joy...  What am I doing wrong?  (you're supposed to
focus your attention to the west and figure it out! 8-))  I have another
form that I am doing the same thing with and it works fine,  and I don't
even blank the record source.  Create the cursor,  bob.recordsource =
'mycursor' bob.grc1.column1.controlsource = 'mycursor.field1' and off we
go... The code is the same in the new...

Interesting enough the first three columns are just fine...  Am going to
reduce the grid to those first three columns and start building it up one
column at a time...   But if anyone has any ideas I would be most
interested...

Regards,
Desmond




On 5 September 2014 02:03, Dave Crozier  wrote:

> I presume that you have set the Recordsource for the grid to a cursor
> initially so you need to set it to be " " immediately before you generate
> the new sql Recordsource and then set it to be that new Recordsource after
> the cursor has been created. This preserves all the column widths etc.
>
> Dave
>
> -Original Message-
> From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Desmond Lloyd
> Sent: 04 September 2014 23:27
> To: ProFox Email List
> Subject: VFP6: Grid Column Width Issue
>
> Odd problem with VFP6 (yes VFP6) 8-)  End of day need some help...
>
> Have a form with grid,  approximated column widths,  entered headings,
> named everything..
>
> in the init of the form I create the cursor for the grid,  then define the
> record source as the new cursor then define each control source with the
> new fields
>
> Form fires and the grid displays,  totally ignoring all my column widths,
> the first few columns look good,  but the rest are all one character
> wide.
>
> Yikes...  What am I missing?
>
>
> 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/CAAJXvaPHQQ1kGnKLbZ5=8_J9=MBHSwrPuce2ivi=0qdmv4w...@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.