Re: List box issues

[Joe Yoder]

So can we conclude that immediate refresh of another control is probably
not supported in any other event because Interactive Change is a better
design choice?

On Wed, Apr 24, 2024 at 11:52 AM Tracy Pearson 
wrote:

> The Interactive Change event happens when the user makes a selection
> change via arrow keys or mouse click.
> The Lost Focus event happens when the user moves to another control.
>
> Using the Interactive Change event to update other controls is better user
> experience.
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe
> Yoder
> Sent: Wednesday, April 24, 2024 11:34 AM
> To: profoxt...@leafe.com
> Subject: Re: List box issues
>
> Thanks Tracy - Interactive change works!
>
> Is it by design that the refresh is only executed immediately from the
> Interactive vChange?
>
> Thanks,
>
> Joe
>
> On Wed, Apr 24, 2024 at 10:00 AM Tracy Pearson 
> wrote:
>
> > Should the code in the Lost Focus event actually be in the Interactive
> > Change event?
> >
> > -Original Message-
> > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe
> > Yoder
> > Sent: Tuesday, April 23, 2024 9:53 PM
> > To: profoxt...@leafe.com
> > Subject: Fwd: List box issues
> >
> > Thanks to Fletcher for the cursor clue I am closer to what I want.
> >
> > I have 2 files:
> >   Spaces with fields space_id and  descript
> >   Units with fields : unit_id, space_id, and descript
> >
> > I have a form with a list box for each
> >  the Spaces list box has the row source set  to 6 (Fields) of Spaces
> >  the Units list box has the Row Source type set to 3  (SQL Statement)
> >  and the Row Source to:
> >   select Spaces.Descript from Spaces  where Units.space_id =
> > Spaces.space_id int cursor xxx
> >
> > The Spaces listbox lost focus event has the following code:
> >   thisform.list2.requery
> >   this form.list2.refresh
> >
> > For some reason the Units list box does not display updated data before I
> > click on another box.  Actually clicking any other buttom causes the box
> to
> > update.
> >
> > What am I missing now?
> >
> > Thanks in advance.
> >
> > Joe
> >
> >
> > --- StripMime Report -- processed MIME parts ---
> > multipart/alternative
> >   text/plain (text body -- kept)
> >   text/html
> > ---
> >
[excessive quoting removed by server]

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

[Joe Yoder]

Thanks Tracy - Interactive change works!

Is it by design that the refresh is only executed immediately from the
Interactive vChange?

Thanks,

Joe

On Wed, Apr 24, 2024 at 10:00 AM Tracy Pearson 
wrote:

> Should the code in the Lost Focus event actually be in the Interactive
> Change event?
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe
> Yoder
> Sent: Tuesday, April 23, 2024 9:53 PM
> To: profoxt...@leafe.com
> Subject: Fwd: List box issues
>
> Thanks to Fletcher for the cursor clue I am closer to what I want.
>
> I have 2 files:
>   Spaces with fields space_id and  descript
>   Units with fields : unit_id, space_id, and descript
>
> I have a form with a list box for each
>  the Spaces list box has the row source set  to 6 (Fields) of Spaces
>  the Units list box has the Row Source type set to 3  (SQL Statement)
>  and the Row Source to:
>   select Spaces.Descript from Spaces  where Units.space_id =
> Spaces.space_id int cursor xxx
>
> The Spaces listbox lost focus event has the following code:
>   thisform.list2.requery
>   this form.list2.refresh
>
> For some reason the Units list box does not display updated data before I
> click on another box.  Actually clicking any other buttom causes the box to
> update.
>
> What am I missing now?
>
> Thanks in advance.
>
> Joe
>
>
> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
>   text/plain (text body -- kept)
>   text/html
> ---
>
[excessive quoting removed by server]

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

Fwd: List box issues

[Joe Yoder]

Thanks to Fletcher for the cursor clue I am closer to what I want.

I have 2 files:
  Spaces with fields space_id and  descript
  Units with fields : unit_id, space_id, and descript

I have a form with a list box for each
 the Spaces list box has the row source set  to 6 (Fields) of Spaces
 the Units list box has the Row Source type set to 3  (SQL Statement)
 and the Row Source to:
  select Spaces.Descript from Spaces  where Units.space_id =
Spaces.space_id int cursor xxx

The Spaces listbox lost focus event has the following code:
  thisform.list2.requery
  this form.list2.refresh

For some reason the Units list box does not display updated data before I
click on another box.  Actually clicking any other buttom causes the box to
update.

What am I missing now?

Thanks in advance.

Joe


--- 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/cabqednxhep0arpsp0k+bf39+01mxz0m15auhnkfmakbs8sq...@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.

List box issues

[Joe Yoder]

I have 2 files:
  Spaces with fields space_id and  descript
  Units with fields : unit_id, space_id, and descript

I have a form with a list box for each
 the Spaces list box has the row source set  to 6 (Fields) of Spaces
 the Units list box has the Row Source type set to 3  (SQL Statement)
 and the Row Source to:
  select Spaces.Descript from Spaces  where Units.space_id = Spaces.space_id

The Spaces listbox lost focus event calls the requiry event of the Units
listbox to update the choices that appear in the Units list box

Each time the SQL executes the results show up in a query window on the
screen.

How do I suppress the unwanted display?  Should I use another technique?

Thanks in advance.

Joe


--- 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/CABQeDnXXz0K3J4Rutp4t=eh-G=9vfbzuf0sb71ewtstap9q...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [ADMIN] Email issue

[Joe Yoder]

This time when I checked it was in spam so I should be good to go

Thanks very much!

Joe

On Tue, Apr 23, 2024 at 1:12 PM Ed Leafe  wrote:

> On Apr 23, 2024, at 11:22, Joe Yoder  wrote:
> >
> > I no longer get any of the list emails.  The only way for me to get
> answers
> > to my questions is by going to the archive.  Does anyone know how to
> > restore delivery?
>
> I checked the list status, and your account is still active. So I checked
> the logs on the server, and they show mail going out normally via google:
>
> 91011:Apr 23 10:31:35 mail postfix/smtp[268230]: 9BDC5120630: to=<
> j...@wheypower.com>, relay=aspmx.l.google.com[142.251.163.26]:25,
> delay=0.96, delays=0.14/0.31/0.15/0.37, dsn=2.0.0, status=sent (250 2.0.0
> OK  1713886295 s15-20020a0562140caf00b006992314d921si13547765qvs.223 -
> gsmtp)
>
> So if you're not getting emails from the list, check your spam folder, and
> if they aren't there, contact your email provider.
>
>
> -- Ed Leafe
>
>
[excessive quoting removed by server]

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

Email issue

[Joe Yoder]

I no longer get any of the list emails.  The only way for me to get answers
to my questions is by going to the archive.  Does anyone know how to
restore delivery?

I can't reply to an email I don't get so here is a big THANK YOU to Tracy
for the quick solution to my display issue!

Joe


--- 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/CABQeDnX0XmaY9VLP1VK1QXi=o0ww0otqcc_rjf6d+mwd--n...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

VFP Form designer display issue

[Joe Yoder]

 The form designer allows a user to select a screen area by clicking on a
corner of the target area and dragging to the opposite corner. This works
correctly but during the drag, the selected area is incorrectly shown above
and to the left.

This behavior occurs when selecting an area on screen to be highlighted as
well as placing objects from the Toolbar.

How can this be fixed?

Thanks in advance for any help.

Joe


--- 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/cabqednumorpxdrmh5ktt32ycvbovgopdlzewaqk75equ8ho...@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.

Programatically placing text boxes on a form - continued

[Joe Yoder]

Tracy,
Thanks for the help - the first line makessence and executes just fine but
the
"oTextbox = evaluate" line errors with variable "TEXTBOX11" is not found.
Do I need something in my code or on my form to have this work properly?

BTW - sorry for not doing this as a reply.  My email no longer gets posts
from replies to my emails so I need to get them from .the archive.  I
reported the problem to Mailman at the leafe.com but have not
received a response.

Thanks again,
Joe


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

___
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/cabqednvyz4wm27coo7wmftr6qlt57tl0q3tx+t1ffeag_ef...@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.

Programatically placing text boxes on a form

[Joe Yoder]

I know I had code years ago that did this but it apparently got mangled
during computer transitions.  The code below runs in the load event of  a
form but results in a blank form.  The ,"parent = thisform line" is
commented out because it causes a "Property PARENT is read-only" error..

FOR i = 1 TO 4
FOR j = 1 TO 10
oTextbox = CreateOBJECT("TextBox")
WITH oTextbox
.Name = "TextBox" + LTRIM(STR(i)) + LTRIM(STR(j))
.Left = (j - 1) * 10
.Top = (i - 1) * 20
.Width = 100
.Height = 20
.Value = "Data for cell " + LTRIM(STR(i)) + ", " + LTRIM(STR(j))
.Visible = .t.
   * .Parent = thisform
ENDWITH
ENDFOR
ENDFOR

What am I missing?
Thanks in advance,

Joe


--- 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/cabqednw1rrzyn7show1lppcqpnahn6nchova3vvosmt0nfr...@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.

Classlib setting in VFP

[Joe Yoder]

Something has happened to my VFP configuration
When I do a ?set("classlib" ) I get nothing
When I try Set Classlib to "C:\Program Files (x86)\Microsoft Visual FoxPro
9\Wizards\" the system reports "file c:\program files (x86)\microsoft
visual foxpro9\wizards.vcx does not exist.  This seems to indicate that the
final backslash is ignored and the system is looking for a file called
wizards.vcx rather than any .vcx files in the wizards folder. (The Wizards
folder contains 4 folders and 16 .vcx files.)

I also noticed that the path setting is missing.  I have not attempted to
set that yet.  I mention it because I wonder if it got clobbered at the
same time.

Can someone give me a clue how to get my system functional without copying
the .vcx files to each of my working folders?  Any clue what I might have
done to deserve this?

Thanks in advance,

Joe


--- 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/CABQeDnWOs=tmma3m3i80dwcmmt-wzjnatleyqorkvnkvzay...@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.

Installing VFP 9.0 on Windows 10

[Joe Yoder]

Im getting "This App can't run on your PC when I try to run Setup.
Does someone have a sharable installation cheat sheet with the details of
steps and service packs to use?

I have a laptop with VFP 9.0 working just fine but I believe it was
installed before the machine was upgraded to Windows 10.

Thanks in advance,

Joe


--- 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/CABQeDnVtSLVoo+U58Z6f+3nL0L-8QQCEv9YykJXQEaY=5t4...@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: Passing parameters to an external program run from fox

[Joe Yoder]

I solved this by testing parameter passing by shelling to a batch file that
shows the parameters it received and pausing until I can digest it.
Here is the line I use to shell to a program in the current folder that
process the input file and creates the output file:
! ProgramName "" OutputFileName

i have discovered that if one passes the parameters without any attempt to
put elements into quotes or double quotes - things just work.  One does
need double quotes around filenames with embedded spaces and macro
expansion allows using a filename in a variable.

On Fri, May 5, 2023 at 2:12 AM Joe Yoder  wrote:

> I'm pretty sure I have done this before but now I can't figure out the
> syntax to make this happen.  I finally substituted a batch file to display
> the parameters passed in and to pause to allow reading time.  The batch
> file reports parameters passed in from the command linre but none from VFP.
>
> Can someone help me out?
>
> Thanks in advance,
>
> Joe
>


--- 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/cabqednxgtazrxnwwrcotlzxy7s+k3gtnx9awyegejxpbque...@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.

Passing parameters to an external program run from fox

[Joe Yoder]

I'm pretty sure I have done this before but now I can't figure out the
syntax to make this happen.  I finally substituted a batch file to display
the parameters passed in and to pause to allow reading time.  The batch
file reports parameters passed in from the command linre but none from VFP.

Can someone help me out?

Thanks in advance,

Joe


--- 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/CABQeDnWeGCz6C=s7m0kupjvuo13xn9k5vmnw409cwoyqtd4...@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.

Byte Arrays in VFP

[Joe Yoder]

I want to pull a 3.5 meg file into a Byte Array in Fox, make some changes
to individual bytes, and write the array back to another file.

The only way I have found to do so is to build the array one character at a
time.  Is there a better way to do this?

Thanks in advance for any input ,

Joe


--- 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/cabqednvr0dretczbxz4riss-tubx0oaw87chmjwosd71hsq...@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: .csv file imports to VFP

[Joe Yoder]

Alan and all,
I have researched the problem records and find that they have line feed
characters without a leading carriage return.  This results from the
operator hitting a return in a notes field of the accounting package I am
using.

Apparently Excel import  insists on a combination of carriage return and
line feed while VFP's append from delimited accepts a line feed by itself.
It seems to me I am not the first person to figure this out and that surely
there is a parameter to alter this behavior.

I thought I could simply preprocess the file and change each occurrence of
a single line feed with a comma but when I look at functions available I
suspect it will be painfully slow.

Any ideas appreciated,

Joe

On Sun, Apr 16, 2023 at 1:49 PM Alan Bourke  wrote:

> 'Append from' has always been bombproof in my experience, as long as what
> you're giving it is correct. Do those problem rows have any weird non ASCII
> characters ir anything?
>
> --
>   Alan Bourke
>   alanpbourke (at) fastmail (dot) fm
>
> On Sun, 16 Apr 2023, at 3:35 AM, Joe Yoder wrote:
> > I have an accounting system data dump that I export each year at tax
> time,
> > I think I have always had a few records that got mangled but this year I
> > would like to solve the problem.
> >
> > My preferred technique is to create a cursor with the fields I need to
> > import along with any required place holders.  I then append from the
> ,CSV
> > file type delimited.  This is very fast and seems to be perfect except
> for
> > about 24 records out of 10,000.  What happens is that fields that belong
> in
> > later positions in some records show up in the first field position.  It
> > seems some records are handled as though they have a carriage return
> > linefeed too early and what follows ends up at the beginning of the
> > following record.
> >
> > I have investigated Low level file input using an fgets function to pull
> > records out one at a time.  This is obviously slower and still seems to
> > have the same problem.
> >
> > Another possible approach would be to pull the entire file into memory
> and
> > parse everything out from there.  This will take much more time and be a
> > lot of work to set up but might make sense to try.
> >
> > Finally I have opened the file in Excel with no problem.  Some of the
> > fields that want to show up in the left field in VFP stay where they
> belong
> > in Excel.  I don't like to add a process in another package but it may
> make
> > sense to do so.
> >
> > Any wisdom will be much appreciated.
> > Thanks in advance,
> >
> > Joe
> >
> >
> > --- StripMime Report -- processed MIME parts ---
> > multipart/alternative
> >   text/plain (text body -- kept)
> >   text/html
> > ---
> >
[excessive quoting removed by server]

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

.csv file imports to VFP

[Joe Yoder]

I have an accounting system data dump that I export each year at tax time,
I think I have always had a few records that got mangled but this year I
would like to solve the problem.

My preferred technique is to create a cursor with the fields I need to
import along with any required place holders.  I then append from the ,CSV
file type delimited.  This is very fast and seems to be perfect except for
about 24 records out of 10,000.  What happens is that fields that belong in
later positions in some records show up in the first field position.  It
seems some records are handled as though they have a carriage return
linefeed too early and what follows ends up at the beginning of the
following record.

I have investigated Low level file input using an fgets function to pull
records out one at a time.  This is obviously slower and still seems to
have the same problem.

Another possible approach would be to pull the entire file into memory and
parse everything out from there.  This will take much more time and be a
lot of work to set up but might make sense to try.

Finally I have opened the file in Excel with no problem.  Some of the
fields that want to show up in the left field in VFP stay where they belong
in Excel.  I don't like to add a process in another package but it may make
sense to do so.

Any wisdom will be much appreciated.
Thanks in advance,

Joe


--- 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/CABQeDnXgWiz1=hdhcs5yvz++crwqz+nlhpz-zel0tusf+ae...@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.

Nulls and generated HTML

[Joe Yoder]

I have a table deliberately created with null values in numeric fields.
This allows browsing the table and seeing zero value fields as blank rather
than zero..  i want to print the table and expected to use the HTML
generator on the file menu but it turns out that the nulls mess up the
formatting of the output.

Is there away to have the html generator treat the nulls as blanks?
Another non null way to browse a table without zeros in empty numeric
fields?

Thanks in advance,
joe


--- 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/cabqednuegfwnzw1_nu-3mc4u9ajvbo1krcbng4arls2udgy...@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.

Fwd: Issues with referencing an array in a form

[Joe Yoder]

For some reason I usually don't get a copy of my posts but this time around
I did not get any replies either.  When I went to the archive I discovered
two replies that addressed my issues.  Thank you!
I also solved the problem myself when I discovered a technique to create
an array as a form property.
 My form load ewent now contains:

* Add an array property for this form
  THISFORM.Add Property("YearArr[2]"2019)
  SELECT Year(start),distinct from leases into array THISFORM.YearArray

And my combo box properties are:
  RowSource: THISFORM.YearArr
  Row Source Type: 5 - Array

This works fine but I prefer the more elegant solution suggested by Jurgen
which eliminates the array and substitutes the SQL select statement' (Row
Source Type 3).

Thanks again,
Joe

-- Forwarded message -----
From: Joe Yoder 
Date: Sat, Apr 23, 2022 at 7:00 PM
Subject: Issues with referencing an array in a form
To: 


I want to call a  form to select the year for a report and then print the
report.
I do a select into array to get the list of choices into array YearArr in
the load procedure of the form but when the form attempts to load a combo
box using the array as the list of choices I get the message YearArr is not
an array.

Load procedure of form contents:
  SELECT year(start) distinct from leases into array YearArr

Combo box properties:
   Row source : YearArr
   Row source type: 5 - Array

What am I missing that is needed to make this work?

Thanks in advance,

Joe


--- 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/CABQeDnWnAJeqkSHKhxP0FhjCBhf2cvcOoKWkj=8c4r+md8q...@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.

Issues with referencing an array in a form

[Joe Yoder]

I want to call a  form to select the year for a report and then print the
report.
I do a select into array to get the list of choices into array YearArr in
the load procedure of the form but when the form attempts to load a combo
box using the array as the list of choices I get the message YearArr is not
an array.

Load procedure of form contents:
  SELECT year(start) distinct from leases into array YearArr

Combo box properties:
   Row source : YearArr
   Row source type: 5 - Array

What am I missing that is needed to make this work?

Thanks in advance,

Joe


--- 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/CABQeDnUhEfXrFNLDFOUct8MEXazbid5+Q0dmuAKD=0o2azs...@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.

Combining PDFs for printing multiple images on a sheet

[Joe Yoder]

I have G-code that produces PDF images of labeled charts one chart per
day.  I want to combine seven daily charts into a weekly sheet that will be
printed from Acrobat Reader.

As near as I can tell there is no straightforward code in the Google
scripting world to combine multiple pdfs into a single one.  I thought
things would be easier if I switched to VFP to do the combining but have
not found suitable code there either.

Another approach would be to manage printing the PDFs by specifying where
on the page each file should print.  I suspect this would be possible using
HTML but have no experience with that.

Thanks in advance for any suggestions!
Joe


--- 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/cabqednw9y9+qcgmvrdcim1kqps2r+fwwnttxv7sg-vbwo4q...@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: Data transfer design Data transfer design (VFP to Google Sheets)

[Joe Yoder]

Thanks Ted and Dave for the reponses!  It turns out that in my current case
the DataToClip approach works perfectly.  I was totally surprised that it
could be so simple. (I was using copy to type XL5 when I wrote to a file so
I expected I would need to pass that detail to DataToClip.  I guess the
clipboard only cares about the values.)  Doing it this way eliminates the
need to create a file, upload the file to Google Drive, and find and import
that file to Sheets

If I get into a situation where I need a more elegant solution I can
consider ODBC or Chilkat.

Thanks again - Joe

On Mon, Sep 20, 2021 at 9:10 AM Dave Crozier 
wrote:

> Joe,
> Data2Clip is a possibility but beware that the data transformation from
> VFP to Spreadsheet can be unpredictable and not result in a data type you
> expect.
>
> Are you uploading the data in Sheet format or in an intermediate FORMAT
> LIKE csv?
>
> I would do as Ted suggests and look at external sources. Personally, I use
> Chilkat Software a lot and there is an interface directly into Google Sheets
>
> https://www.example-code.com/foxpro/googleSheets.asp
>
> Demo version is free.
>
> 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 Joe Yoder
> Sent: 18 September 2021 04:29
> To: profoxt...@leafe.com
> Subject: Data transfer design Data transfer design (VFP to Google Sheets)
>
> I have VFP code that combines multiple events recorded on a phone app into
> a single Timeline table.  The final step in the code is to copy to type
> XL5.  Each time the code is run to include new data, the output file is
> written with the same name
>
> I opened the resulting file in Google sheets with the data in the first
> tab called DATA. Subsequent tabs query the DATA  tab to produce charts with
> various combinations of events for various time frames.  The charts can be
> exported as PDFs for external use.
>
> My issue is figuring out the best way to update the data in the Sheets
> file as new data is available.  Here are some considerations and ideas:
>
> ·Each time I upload the data file to Google Drive the same filename
> is assigned to a different file (all with the same name.) The only way I
> have found to determi

Data transfer design Data transfer design (VFP to Google Sheets)

[Joe Yoder]

I have VFP code that combines multiple events recorded on a phone app into
a single Timeline table.  The final step in the code is to copy to type
XL5.  Each time the code is run to include new data, the output file is
written with the same name

I opened the resulting file in Google sheets with the data in the first tab
called DATA. Subsequent tabs query the DATA  tab to produce charts with
various combinations of events for various time frames.  The charts can be
exported as PDFs for external use.

My issue is figuring out the best way to update the data in the Sheets file
as new data is available.  Here are some considerations and ideas:

·Each time I upload the data file to Google Drive the same filename
is assigned to a different file (all with the same name.) The only way I
have found to determine which is the authority is to look at the last
modified time.  This seems like an invitation to user errors.  Perhaps
there is a configuration change to avoid this behavior.

·Sheets has the capability to query data from an unopened table if
its URL is specified in the query.  Wiping and reimporting the data appears
to be a workable approach but it requires finding the correct file to
import to the DATA sheet with the specified URL used to hold the data,

·Another possibility might be to open the table from VFP in Sheets
and record the URL on the clipboard and then open the Sheets file
containing the chart specs and update the URL in the query.

·Another might be to copy the data to the clipboard and then paste
it into a DATA tab on the Charts sheet.

·Finally, I’m wondering if there is a way to write the data onto
the clipboard from VFP and then paste it directly into the Sheets Chart
sheet.  This would eliminate the nuisance of uploads and filename confusion.

·A pure VFP approach would eliminate the need for data transfer,
but I chose the Google approach because I am new to charts and because I
wanted to learn about Google’s capabilities.

Any suggestions welcome!

Thanks in advance - Joe


--- 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/cabqednxpjiimnjxpejmkpn+wgtx87xjayj9mdbntceuexho...@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.

Time variables

[Joe Yoder]

I want to build a cursor of time fields for export to Excel.  The DateTime
format allows a simple for next loop to increment the time value by a
specified number of seconds.

Is there a function that allows the extraction of the time portion of a
DateTime variable as a time value not as a string?  It seems one could pull
out the hours and minutes as characters and convert them to time via CTOT
but this results in a DateTime result with an embedded date.

Thanks in advance,

Joe


--- 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/cabqednv-ngcjrmfewpmbcgj59sep5y02q73fejhx-hbi_qu...@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: Formset goofy

[Joe Yoder]

I came across the possibility and it fit my goal to do a minimum proof of
concept system.  The forms consist of Pick which allows choosing a record
and Detail which then supplies additional info.

I have no intention to use a scrollable form.  Maybe what happened to me
can only occur when there is a formset.  I thought it is a part of the
development environment and I assumed it can happen with any form.

On Wed, May 26, 2021 at 6:04 PM Tracy Pearson  wrote:

> My work with formsets never got past the "learning" stage. Meaning I never
> put one into a production application.
>
> There are some bits that one really needs to understand to work with them.
> Like common code between them with thisformset.
> It's a big learning curve to use them. And most people are advised to not
> use them.
>
> The notion of having a scrollable area on one form by using the scrollbar
> setting on a second form set on top of the first form was the latest
> tinkering I did. Someone made a container class that emulates that
> functionality though.
>
> If one form is the main form, it can start the secondary form. The main
> form
> would be set to a Private Datasession. The secondary form would not be a
> private datasession. This will allow the secondary form to see and use the
> main forms tables and views.
>
> Why are you wanting to use a formset? I'm sure there are valid reasons to
> use them.
>
> Tracy
>
> -Original Message-----
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe
> Yoder
> Sent: Wednesday, May 26, 2021 5:29 PM
> To: profoxt...@leafe.com
> Subject: Formset goofy
>
> I have been working with two forms in a formset for the first time.  All
> has worked out well as the two forms are simply two perspectives on the
> underlying data. I switch between them by turning visible on and off.
>
> One of the forms somehow got set to max width in the development
> environment.  This is a nuisance to work with but I didn't bother to fix it
> until this morning.  My fix was to scroll to the right bound of the screen
> and drag the right side of the screen to the left as far as I could and
> then repeat.  This made it much easier to switch between the forms.
>
> In the same session I deleted a series of controls from form2 and replaced
> them with new ones.  When I built the formset form 1 no longer has any
> controls showing up either in the form designer or when running the form.
>
> I Investigated and at least some of the form1 controls are still in the
> ,SCX.
>
> Actually I checked details in the Properties of the Formset for the missing
> form and discovered the Left setting was -1946 while the same setting for
> the present form was 8.  Setting the negative value to 8 restored the
> missing controls.  I'm quessing I inadvertently garbed the whole form
> rather than the right bound when I was making the screen narrower.
>
> Now my question is - is there a one click solution in the UI to correct
> this situation or is manual editing of the properties the best approach?
>
> Thanks in advance,
>
> Joe
>
>
> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
>   text/plain (text body -- kept)
>   text/html
> ---
>
[excessive quoting removed by server]

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

Formset goofy

[Joe Yoder]

I have been working with two forms in a formset for the first time.  All
has worked out well as the two forms are simply two perspectives on the
underlying data. I switch between them by turning visible on and off.

One of the forms somehow got set to max width in the development
environment.  This is a nuisance to work with but I didn't bother to fix it
until this morning.  My fix was to scroll to the right bound of the screen
and drag the right side of the screen to the left as far as I could and
then repeat.  This made it much easier to switch between the forms.

In the same session I deleted a series of controls from form2 and replaced
them with new ones.  When I built the formset form 1 no longer has any
controls showing up either in the form designer or when running the form.

I Investigated and at least some of the form1 controls are still in the
,SCX.

Actually I checked details in the Properties of the Formset for the missing
form and discovered the Left setting was -1946 while the same setting for
the present form was 8.  Setting the negative value to 8 restored the
missing controls.  I'm quessing I inadvertently garbed the whole form
rather than the right bound when I was making the screen narrower.

Now my question is - is there a one click solution in the UI to correct
this situation or is manual editing of the properties the best approach?

Thanks in advance,

Joe


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

___
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/cabqednudlaa-ajhqout_9okaut0d1abnbhxn7ws030nbbbf...@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: Form designer rules?

[Joe Yoder]

My data is in a table called labels with three fields, space, location, and
label.
I thought my problems were solved but now when I setup my second combo box
with the row source set to

select location distinct from labels where  labels.space =
thisform.combo1.value = labels.space into cursor T2
I get the message "Thisform can only be used within a method"

When I set  the row source to

select location distinct from labels where  labels.space =combo1.value =
labels.space into cursor T2
I get the message "Ali8as Combo1 is not found."

When I put the SQL code in the load or init methods of the form it works
without error so the code is okay
Is there a different syntax needed here or do I need to handle this in a
different way?

Thanks,

Joe

On Sun, May 23, 2021 at 7:23 PM Joe Yoder  wrote:

> Tracy,
>
> I did another test form using days of the week like yours.  I still got
> the error.  Then I removed the quotes around the CSL statement and it
> worked!  Somewhere in my surfing I had read that the quotes were required
> but that is apparently incorrect.
>
> More details:
>
>1. When does the SQL get executed?  When it is first loaded?  Each
>time the control gets focus? When requiry is called?
>2. Are all cursors created this way in scope for the entire VFP system?
>3. Is there a simple way to see the VFP code generated by the Form
>Designer to understand how it works?
>
> Thanks so much,
>
> Joe
>
> On Sun, May 23, 2021 at 11:41 AM Tracy Pearson 
> wrote:
>
>> Hi Joe,
>>
>> Those settings are working for me in my quick test.
>> Does the SQL statement you have in the RowSource work in code?
>>
>> As a test I built a cursor with the days of the week in it in the Load
>> event
>> of a form.
>> CREATE CURSOR ComboBoxData (id i, displaytext c(30))
>> I set the ComboBox.RowSource to
>> select displaytext from comboboxdata into cursor t1
>> and set the ComboBox.RowSourceType = 3 && SQL statement
>>
>> To be consistent with your select statement I added the "distinct" clause
>> and it still works.
>>
>> I tested in VFP 9 SP2 Hotfix 3
>>
>> HTH,
>> Tracy
>>
>> -Original Message-
>> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe
>> Yoder
>> Sent: Saturday, May 22, 2021 3:04 PM
>> To: profoxt...@leafe.com
>> Subject: Form designer rules?
>>
>> I want to use an sql select statement as the row source for a combo box..
>>
>>-  When I set the row source type to 3-SQL and enter the row source as
>>"select space distinct from map into cursor T1" attempting to run the
>> form
>>results in "Program error Unrecognized command verb"
>>- If I set the row source type to 2-Alias and the row source to T1 and
>>put the SQL select statement into the init method of the control the
>> Combo
>>box populates properly.
>>
>> I would have expected that the system would be smart enough to run the SQl
>> statement before trying to use it's output.  Is there something else I
>> need
>> to call perhaps in the form init method?
>>
>> Thanks in advance,
>>
>> Joe
>>
>>
>> --- StripMime Report -- processed MIME parts ---
>> multipart/alternative
>>   text/plain (text body -- kept)
>>   text/html
>> ---
>>
[excessive quoting removed by server]

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

[Joe Yoder]

Tracy,

I did another test form using days of the week like yours.  I still got the
error.  Then I removed the quotes around the CSL statement and it worked!
Somewhere in my surfing I had read that the quotes were required but that
is apparently incorrect.

More details:

   1. When does the SQL get executed?  When it is first loaded?  Each time
   the control gets focus? When requiry is called?
   2. Are all cursors created this way in scope for the entire VFP system?
   3. Is there a simple way to see the VFP code generated by the Form
   Designer to understand how it works?

Thanks so much,

Joe

On Sun, May 23, 2021 at 11:41 AM Tracy Pearson 
wrote:

> Hi Joe,
>
> Those settings are working for me in my quick test.
> Does the SQL statement you have in the RowSource work in code?
>
> As a test I built a cursor with the days of the week in it in the Load
> event
> of a form.
> CREATE CURSOR ComboBoxData (id i, displaytext c(30))
> I set the ComboBox.RowSource to
> select displaytext from comboboxdata into cursor t1
> and set the ComboBox.RowSourceType = 3 && SQL statement
>
> To be consistent with your select statement I added the "distinct" clause
> and it still works.
>
> I tested in VFP 9 SP2 Hotfix 3
>
> HTH,
> Tracy
>
> -Original Message-----
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe
> Yoder
> Sent: Saturday, May 22, 2021 3:04 PM
> To: profoxt...@leafe.com
> Subject: Form designer rules?
>
> I want to use an sql select statement as the row source for a combo box..
>
>-  When I set the row source type to 3-SQL and enter the row source as
>"select space distinct from map into cursor T1" attempting to run the
> form
>results in "Program error Unrecognized command verb"
>- If I set the row source type to 2-Alias and the row source to T1 and
>put the SQL select statement into the init method of the control the
> Combo
>box populates properly.
>
> I would have expected that the system would be smart enough to run the SQl
> statement before trying to use it's output.  Is there something else I need
> to call perhaps in the form init method?
>
> Thanks in advance,
>
> Joe
>
>
> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
>   text/plain (text body -- kept)
>   text/html
> ---
>
[excessive quoting removed by server]

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

Form designer rules?

[Joe Yoder]

I want to use an sql select statement as the row source for a combo box..

   -  When I set the row source type to 3-SQL and enter the row source as
   "select space distinct from map into cursor T1" attempting to run the form
   results in "Program error Unrecognized command verb"
   - If I set the row source type to 2-Alias and the row source to T1 and
   put the SQL select statement into the init method of the control the Combo
   box populates properly.

I would have expected that the system would be smart enough to run the SQl
statement before trying to use it's output.  Is there something else I need
to call perhaps in the form init method?

Thanks in advance,

Joe


--- 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/cabqednvp-ukjalajct-05bfwe+-46yxdsaqqhgkmpcqveoj...@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: Navigating structure using list boxes?

[Joe Yoder]

Thanks for the reply Tracy,

I think the simplest way to fill the list in a combo box will be to use a
series of arrays that get updated as each choice is made.

I am trying to figure out where in the code to place the select to array
statement so that the  combo box can find ithe array

Maybe you have a better approach.

Thanks,

Joe


On Wed, May 19, 2021 at 7:13 PM Tracy Pearson  wrote:

> Looking at what you have I would consider using a series of drop downs for
> each part.
> If you only have three parts to the location you can setup the selection
> screen in advanced.
> You can populate and enable the next combobox quickly.
> If each subset could have additional subsets, you may need to add or show
> things dynamically.
>
> If you feel the two click method for each part isn't what you want, you
> could use a series listboxes going to the right for each part.
>
> The other might be an <> ActiveX control. The ProjectExplorer
> project Doug Hennig has made available uses the TreeView ActiveX control.
> https://github.com/DougHennig/ProjectExplorer
>
>
> HTH,
> Tracy
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe
> Yoder
> Sent: Wednesday, May 19, 2021 6:41 PM
> To: profoxt...@leafe.com
> Subject: Navigating structure using list boxes?
>
> I am an infrequent user of VFP and have never mastered the GUI.
>
>
> I need to allow a user to choose storage locations from the structure below
> for several fields on a screen where the possible choices are in a
> structure several layers deep.
>
>
> Is there a control to handle this or a simple way to roll my own?
>
>
> This is a simple representation of the locations to chose from.:
>
> Shop/Cabinet/Shelf1
>
> Shop/Cabinet/ Drawer1
>
> Shop/Bench/Shelf1
>
> Office/Bench/Drawer1
>
> Office/Cabinet/ Drawer1
>
> Office/Cabinet/Shelf1
>
> Office/Bench/Shelf1
>
> Office/Bench/Drawer1
>
> Trailer/Bench/Drawer1
>
> Trailer/Cabinet/ Drawer1
>
> Trailer/Cabinet/Shelf1
>
> TrailerBench/Shelf1
>
> Trailer/Bench/Drawer1
>
> Even though the Drawers and Shelves appear to repeat they are all different
> and can add up to 150 choices for a location in my office.  I clearly do
> not want to scroll through the entire list to make a choice.
>
>
> Any help would be appreciated.
>
>
> Thanks in advance,
>
>
> Joe
>
>
> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
>   text/plain (text body -- kept)
>   text/html
> ---
>
[excessive quoting removed by server]

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

Navigating structure using list boxes?

[Joe Yoder]

I am an infrequent user of VFP and have never mastered the GUI.


I need to allow a user to choose storage locations from the structure below
for several fields on a screen where the possible choices are in a
structure several layers deep.


Is there a control to handle this or a simple way to roll my own?


This is a simple representation of the locations to chose from.:

Shop/Cabinet/Shelf1

Shop/Cabinet/ Drawer1

Shop/Bench/Shelf1

Office/Bench/Drawer1

Office/Cabinet/ Drawer1

Office/Cabinet/Shelf1

Office/Bench/Shelf1

Office/Bench/Drawer1

Trailer/Bench/Drawer1

Trailer/Cabinet/ Drawer1

Trailer/Cabinet/Shelf1

TrailerBench/Shelf1

Trailer/Bench/Drawer1

Even though the Drawers and Shelves appear to repeat they are all different
and can add up to 150 choices for a location in my office.  I clearly do
not want to scroll through the entire list to make a choice.


Any help would be appreciated.


Thanks in advance,


Joe


--- 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/CABQeDnXE8=_z-udKtM=oymzpz4_9edrqo5yg4lkkkcliuxv...@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.

_reportlistener.vcx

[Joe Yoder]

I have some code that uses the report listener to create PDF report files
using XFRX.  In May it was functioning properly but now when I load the
program I get the following message:
"File 'C:\...\common files\microsoft shared\vfp\ffc\_reportlistener.vcx'
does not exist" The code runs without error but does not produce the report
files

The error report is correct that the file is not at that location.  A
search finds the file at "C:\Program Files (86) Microsoft\ Visual Foxpro
9\FFC\_reportlistener.vcx.

What could have caused this to happen? How do I fix it:

   - Create the structure where  Foxpro reports that it expects to find it?
   - Somehow tell Foxpro where the file is actually located?
   - Something else?

Thanks in advance,

Joe


--- 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/CABQeDnVNrENourTetvin7LzT=zp8sgg1+8i1g14rqf5ggws...@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: Landscape PDFs using XFRX

[Joe Yoder]

I reread what what I wrote and realize that The first sentence should have
been "Using XFRX in VFP to convert  Reports to create PDF files" - sorry -
Joe

On Tue, Apr 23, 2019 at 1:33 PM Joe Yoder  wrote:

> I have an older version of XFRX that I am converting to create PDF files
> instead of printing reports directly. All reports are working well except
> the one that requires Landscape output. Apparently XFRX just ignores the
> printer orientation information in the Tag1 and Tag2 fields in the
> Report.frx file.
>
> Can someone share what is needed to change the output orientation of the
> XFRX output files?
>
> Thanks in advance,
>
> Joe
>


--- 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/cabqednxflmpie1c1o2uwuocs+8qoe846wmno8dqtbeg-bvr...@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.

Landscape PDFs using XFRX

[Joe Yoder]

I have an older version of XFRX that I am converting to create PDF files
instead of printing reports directly. All reports are working well except
the one that requires Landscape output. Apparently XFRX just ignores the
printer orientation information in the Tag1 and Tag2 fields in the
Report.frx file.

Can someone share what is needed to change the output orientation of the
XFRX output files?

Thanks in advance,

Joe


--- 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/CABQeDnWd0cwqj23iPoJPVDAy7TZ3hoUux-G=3mpeoltd-b0...@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.

[NF] Recomendations for VFP to Python language reference?

[Joe Yoder]

I'm starting a Raspberry Pi project involving lots of temperature sensors
along with some flow meters etc.  I expect to work in Python and realize
that a language reference assuming experience in VFP would be a good idea.
Any recommendations?

Thanks in advance,
Joe


--- 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/CABQeDnW_P_wh9O-9S7_e0Ksr-n=c86r3iaybuhh_jtbjad2...@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: Numbering Scheme

[Joe Yoder]

How about converting to base 26 and printing alpha characters (A-Z)?  This
would allow easy sequencing and a simple program could convert an alpha
string to  a base 10 number when needed.- Joe

On Thu, Oct 11, 2018 at 2:39 PM Frank Cazabon 
wrote:

> They have that already. This is a physical count process to avoid theft.
> They deal in lending money for gold and have to be paranoid.
>
> On 11 October 2018 14:10:36 GMT-04:00, Stephen Russell <
> srussell...@gmail.com> wrote:
> >Why not make a dashboard that has a Count for the Day on it. If you
> >have
> >really simple people this might work?
> >
> >On Thu, Oct 11, 2018 at 9:54 AM Frank Cazabon 
> >wrote:
> >
> >> Thanks, Obscuring the number is not a problem, but I think they want
> >to
> >> be able to read the number off the ticket at the end of the day in
> >> sequential order and I don't see how I can come up with a simple way
> >to
> >> do this.
> >>
> >> Frank.
> >>
> >> Frank Cazabon
> >>
> >> On 10/10/2018 03:48 PM, Richard Kaye wrote:
> >> > One way is to come up with a 10 letter "word" with each letter
> >> representing a digit. You then convert the numeric sequence to alpha
> >> characters. And to avoid the pattern being too easily spotted, add
> >one or
> >> more random characters to the final string. It's not the most robust
> >> encryption scheme in the world but it should obscure it enough.
> >Here's a
> >> bit of VFP code to do this using the non-dictionary phrase MONKEYSHIP
> >as
> >> the rebus. Pass it the number to encode and optionally .t. as the
> >second
> >> parameter to append a single random character at the end.
> >> >
> >> > **
> >> > *  Program: MONKEYSHIP.PRG
> >> > * Date: 05/07/2007 03:26 PM
> >> > *  VFP Version: Visual FoxPro 09.00..7423 for Windows
> >> > *Notes:
> >> > **
> >> >
> >> > FUNCTION MonkeyShip(m.tnStringToEncode AS Number, m.tlRandom AS
> >Boolean)
> >> > LOCAL m.lcRetval AS Character
> >> >
> >>
>
> >m.lcStringToEncode=ALLTRIM(TRANSFORM(m.tnStringToEncode,[999]))
> >> > LOCAL ARRAY laRebus[10,2]
> >> > m.laRebus[1,1]=1
> >> > m.laRebus[1,2]=[M]
> >> > m.laRebus[2,1]=2
> >> > m.laRebus[2,2]=[O]
> >> > m.laRebus[3,1]=3
> >> > m.laRebus[3,2]=[N]
> >> > m.laRebus[4,1]=4
> >> > m.laRebus[4,2]=[K]
> >> > m.laRebus[5,1]=5
> >> > m.laRebus[5,2]=[E]
> >> > m.laRebus[6,1]=6
> >> > m.laRebus[6,2]=[Y]
> >> > m.laRebus[7,1]=7
> >> > m.laRebus[7,2]=[S]
> >> > m.laRebus[8,1]=8
> >> > m.laRebus[8,2]=[H]
> >> > m.laRebus[9,1]=9
> >> > m.laRebus[9,2]=[I]
> >> > m.laRebus[10,1]=0
> >> > m.laRebus[10,2]=[P]
> >> > m.lcRetval=[]
> >> > m.lcChar=[]
> >> > FOR m.x=1 TO LEN(ALLTRIM(m.lcStringToEncode))
> >> >
> >>
>
> >m.lcChar=m.laRebus[ASCAN(m.laRebus,VAL(SUBSTR(m.lcStringToEncode,x,1)),1,-1,1,8),2]
> >> >   m.lcRetval=m.lcRetval+m.lcChar
> >> > NEXT
> >> > IF m.tlRandom
> >> >   LOCAL m.liCounter AS Integer
> >> >   PRIVATE m.pcRandomChar
> >> >   m.pcRandomChar=[ ]
> >> >   m.liCounter=1
> >> > *!* get a bunch of values to work with which will hopefully give at
> >> least one alpha not in monkeyship
> >> >   DO WHILE NOT ReturnRandom()
> >> >   m.liCounter=m.liCounter+1
> >> >   IF m.liCounter=10
> >> >   EXIT
> >> >   ENDIF
> >> >   ENDDO
> >> >   IF m.liCounter=10   && we went through loop 10 times and
> >could
> >> not get a char back
> >> >   m.lcRetval=[Q]+m.lcRetval
> >> >   ELSE
> >> >   m.lcRetval=m.pcRandomChar+m.lcRetval
> >> >   ENDIF
> >> > ENDIF
> >> > RETURN m.lcRetval
> >> > ENDFUNC
> >> >
> >> > FUNCTION ReturnRandom
> >> > LOCAL m.lcRandomSeed AS Character, m.lIsGood AS Boolean
> >> > *!* get a bunch of values to work with which will hopefully give at
> >> least one alpha not in monkeyship
> >> > m.lcRandomSeed=SYS(2015)+SYS(2015)+SYS(2015)+SYS(2015)
> >> > m.lIsGood=.f.
> >> > FOR m.y=LEN(m.lcRandomSeed) TO 2 STEP -1  && don't need to
> >check
> >> first char in sys(2015)
> >> >   IF ISALPHA(SUBSTR(m.lcRandomSeed,y,1)) AND NOT
> >> UPPER(SUBSTR(m.lcRandomSeed,y,1))$[MONKEYSHIP]
> >> >   m.pcRandomChar=SUBSTR(m.lcRandomSeed,y,1)
> >> >   m.lIsGood=.t.
> >> >   EXIT
> >> >   ELSE
> >> >   m.lIsGood=.f.
> >> >   ENDIF
> >> > NEXT
> >> > RETURN m.lIsGood
> >> > ENDFUNC
> >> >
> >> > --
> >> >
> >> > rk
> >> >
> >> > -Original Message-
> >> > From: ProfoxTech  On Behalf Of Frank
> >> Cazabon
> >> > Sent: Wednesday, October 10, 2018 3:25 PM
> >> > To: profoxt...@leafe.com
> >> > Subject: Numbering Scheme
> >> >
> >> > I have a client who issues tickets in numerical sequence (it's a
> >> pawnshop). The sequence helps them balance things back at the end of
> >the
> >> day (read that as check for stealing) when checking the various
> >parcels
> >> received for the tickets issued (they keep a copy of the ticket
> >issued 

Unexpected results from a group by clause

[Joe Yoder]

I have an SQL select statement that includes a group by clause to order the
output for reporting.  It gets its data from a table that potentially
includes legitimate duplicate records.

  SELECT account, date, memo, paid_amoun;
FROM QB;
GROUP BY account, date, memo, paid_amoun;
INTO CURSOR det

I happened to discover that the output of the select statement does not
include duplicate records.  Is this expected behavior? If so , how should
one group data with duplicate records?

Thanks in advance,

Joe


--- 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/CABQeDnUC+QOHyHAkr_eCXL7UmXBqrt1FrrLi7Po-F36MeSO=u...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Automated email utility recommendations

[Joe Yoder]

Kevin - The issue is that the site that needs to end up with the files has
only two known ways to receive images: One at a time selection from their
web app or one at a time via email attachment.  This is probably their way
to limit the volume of images they get.  Perhaps they will reply to my
inquiry that they can handle a zipped batch for a fee.  That would be fine
by me. - Joe

On Mon, Mar 5, 2018 at 2:14 PM, Joe Yoder <j...@wheypower.com> wrote:

> John - I think you mean SweetPotatoSoftware.com.  It looks like there are
> a lot of options there.  Care to share which one you are using or started
> from? - Joe
>
> On Mon, Mar 5, 2018 at 1:33 PM, John Weller <j...@johnweller.co.uk> wrote:
>
>> I use a piece of code from sweetpotato.com which works well.
>>
>> John Weller
>> 01380 723235
>> 07976 393631
>>
>>
[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/CABQeDnVny=btuktzQem96G7xfguAoZ1OjvJHu=2obuxqt61...@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: Automated email utility recommendations

[Joe Yoder]

John - I think you mean SweetPotatoSoftware.com.  It looks like there are a
lot of options there.  Care to share which one you are using or started
from? - Joe

On Mon, Mar 5, 2018 at 1:33 PM, John Weller  wrote:

> I use a piece of code from sweetpotato.com which works well.
>
> John Weller
> 01380 723235
> 07976 393631
>
>
[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/cabqednuhu+sbd5mfx0ookjb6hcdwxdorxbzsyk4qktbw-hi...@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: Automated email utility recommendations

[Joe Yoder]

Thanks Kevin -  Mandrill would certainly handle the volume but their
minimum of 25,000 per month is overkill.  My current folder of less than
1000 represents a whole years worth of files.  Going forward I expect less
than 50 per month.
Another approach would be to find a vendor who could receive all the files
in a single zip and send them out one at a time.  I'm waiting to hear from
the recipient if there is a limit on how many files I can send in a day or
i they have a better way to handle an entire folder at a time.

On Mon, Mar 5, 2018 at 12:49 PM, Kevin J Cully <kjcu...@cherokeega.com>
wrote:

> Hey Joe,
>
> I'm hearing a Ted-ism coming along as a "It depends", but ...
>
> 1. For sending massive amounts of individual emails to external email
> addresses, look at a service such as Mandrill. (https://mandrill.com/)
> It costs money but will keep your domain from getting black-listed, keeping
> you from sending out emails in the future.
>
> 2. For converting documents to an image, look either at ImageMagick  or
> HTMLToPDF.
>
> Hope this helps.  Let us know what you decide to do with your project.
>
> -Kevin
>
>
> -Original Message-----
> From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Joe Yoder
> Sent: Monday, March 05, 2018 12:24 PM
> To: profoxt...@leafe.com
> Subject: Automated email utility recommendations
>
> This could be VFP or otherwise - not sure if there should be [NF] in the
> header?
>
> I have two tasks I would like to automate:
>
>1. Send several hundred .JPG files in a local folder as email
>attachments one at a time.
>2. Convert an Email to an image and send it to an email address as an
>attachment.
>
> Any suggestions welcome!
>
> Thanks in advance
>
> Joe
>
>
> --- StripMime Report -- processed MIME parts --- multipart/alternative
>   text/plain (text body -- kept)
>   text/html
> ---
>
[excessive quoting removed by server]

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

Automated email utility recommendations

[Joe Yoder]

This could be VFP or otherwise - not sure if there should be [NF] in the
header?

I have two tasks I would like to automate:

   1. Send several hundred .JPG files in a local folder as email
   attachments one at a time.
   2. Convert an Email to an image and send it to an email address as an
   attachment.

Any suggestions welcome!

Thanks in advance

Joe


--- 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/cabqednu+fz9syp_61trqo5mdsuorr9pskfdwh6own9bvasc...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Scanned images and Quick Books

[Joe Yoder]

Thanks Richard,

I'm reviewing the HubDoc system  - some great features but I need to
investigate further.  I may give you a call in several weeks if that is
okay.

Joe

On Wed, Jan 17, 2018 at 10:06 AM, Richard Mertl <rame...@richardamertl.ca>
wrote:

> Joe,
>
> I can assure you that the online version of Quickbooks supports the
> attachment of document images.
>
> Also, the desktop version supports that attachment of images, but the
> process is not as computerized.
>
> Using an online app called Hubdoc the document images are retained online
> and with integration with the online version of Quickbooks the images and
> the transaction amounts can be pushed across to the accounting system from
> Hubdoc.
>
> Contact me directly at, if you want further info at 514 885 4257
>
> Regards,
>
> Richard Mertl
>
> On Tue, Jan 16, 2018 at 1:12 PM, Joe Yoder <j...@wheypower.com> wrote:
>
> > I've been handling my accounting by capturing financial items with a Neat
> > scanning system, massaging exported Neat data to create IIF files, and
> > importing them to Quick Books.  The system works but something that
> allows
> > drill down to the original image directly from Quick Books would work
> much
> > better.
> >
> > I have assumed that by now Intuit has the means to store and retrieve
> > scanned images from inside at least one of their products.  When I
> > connected with a rep on their site I was referred to a Small Business
> > Consultant who assured me that both their desktop and online products do
> > what I want.  I asked for some links to videos on their site that
> > demonstrate their implementation.  He promised to Email them to me but
> that
> > has not happened.  I Emailed and left voice but he has not gotten back to
> > me.
> >
> > After waiting a week I restarted the process on the Intuit site.  I was
> > told that someone would get back to me but that has not happened.  At
> this
> > point I am wondering if what the consultant told me was incorrect and no
> > one in their system is willing to admit that they don't support access to
> > scanned imges.  It may be that they rely on third party developers to
> > provide such capabilities.
> >
> > Does someone know if there is a way to store and retrieve scanned images
> > from within Quick Books?  If not - have another product to recommend?
> >
> > Thanks in advance,
> >
> > Joe Yoder
> >
> >
> > --- 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/cabqednw7lp4aygy+e1qffngk61t4_ueme1aw6z9j6j1ysp1...@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.

[NF] Scanned images and Quick Books

[Joe Yoder]

I've been handling my accounting by capturing financial items with a Neat
scanning system, massaging exported Neat data to create IIF files, and
importing them to Quick Books.  The system works but something that allows
drill down to the original image directly from Quick Books would work much
better.

I have assumed that by now Intuit has the means to store and retrieve
scanned images from inside at least one of their products.  When I
connected with a rep on their site I was referred to a Small Business
Consultant who assured me that both their desktop and online products do
what I want.  I asked for some links to videos on their site that
demonstrate their implementation.  He promised to Email them to me but that
has not happened.  I Emailed and left voice but he has not gotten back to
me.

After waiting a week I restarted the process on the Intuit site.  I was
told that someone would get back to me but that has not happened.  At this
point I am wondering if what the consultant told me was incorrect and no
one in their system is willing to admit that they don't support access to
scanned imges.  It may be that they rely on third party developers to
provide such capabilities.

Does someone know if there is a way to store and retrieve scanned images
from within Quick Books?  If not - have another product to recommend?

Thanks in advance,

Joe Yoder


--- 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/cabqednxcgv-cigoyh1aw2wwzqkds7erpn+thlwkao0sarwe...@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.

Fwd: [NF] Syslog server advice

[Joe Yoder]

-- Forwarded message --
From: Joe Yoder <j...@wheypower.com>
Date: Sun, Jan 29, 2017 at 10:55 PM
Subject: [NF] Syslog server advice
To: profoxt...@leafe.com


I'm thinking to setup a syslog server on my workstation to catch entries
from a remote machine over the internet.  Does anyone have a free favorite
to recommend or warn against?

Thanks in advance,

Joe


--- 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/cabqednxnp-kzajndfpn_kqewtftr+a9+3kpqye6wy6dkcky...@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.

[NF] Syslog server advice

[Joe Yoder]

I'm thinking to setup a syslog server on my workstation to catch entries
from a remote machine over the internet.  Does anyone have a free favorite
to recommend or warn against?

Thanks in advance,

Joe


--- 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/cabqednwg4toaw+rpfxsly9u_vbzew0v52jvd0c6tet8rd1e...@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: Processing a long character string one character at a time

[Joe Yoder]

I had a hunch that the SUBSTR approach becomes less and less efficient as
the string length increases in size so I put the following code together.
Note - I commented out the one million test as it takes about 5 minutes on
my machine.  The results are impressive! - Joe

? 'One million Character by character reads from strings of different
lengths'
DO Readc WITH 10
DO Readc WITH 100
DO Readc WITH 1000
DO Readc WITH 1
DO Readc WITH 10
*DO Readc WITH 100

? 'One million Character by character reads from a file'
DO Freadc WITH 100
RETURN

FUNCTION Readc
PARAMETERS m.StrLen
m.String = REPLICATE('t', m.StrLen)
m.cnt = 0
m.Start = SECONDS()

DO WHILE m.cnt < 100
  FOR m.x = 1 TO m.StrLen
m.ch = SUBSTR(m.String, m.x, 1)
m.cnt = m.cnt + 1
  ENDFOR
ENDDO
? m.StrLen, SECONDS() - m.start
return

FUNCTION Freadc
PARAMETERS m.StrLen
m.Start = SECONDS()
STRTOFILE(REPLICATE('t', m.StrLen), 'Ftest.tmp')
m.InFile = FOPEN('Ftest.tmp')
FOR m.x = 1 TO m.StrLen
  m.ch = FREAD(m.InFile, 1)
ENDFOR
FCLOSE(m.InFile)
ERASE Ftest.tmp
? m.StrLen, SECONDS() - m.start
return


On Sun, Sep 11, 2016 at 11:57 AM, Ted Roche <tedro...@gmail.com> wrote:

> The problem with that kind of approach is essentially, the algorithm
> counts words one at a time to get to the one you want: 1,2,3,... which
> is fine for 100 words, but unworkable for a million.
>
> On Sat, Sep 10, 2016 at 9:06 PM, Laurie Alvey <trukke...@gmail.com> wrote:
> > To split a string into words you can use something like this:
> >
> > n = GETWORDCOUNT(mysring)
> > FOR i = 1 TO n
> >  ? GETWORDNUM(mystring,i) && do something with the word
> > ENDFOR
> >
> > Laurie
> >
> > On 10 September 2016 at 16:02, Stephen Russell <srussell...@gmail.com>
> > wrote:
> >
> >> Is there a split function in VFP to take every word of the string into
> an
> >> array?  Then you could parse each array element till done.
> >> C# example here.
> >>
> >> string s = FromYourTextfile;
> >> // Split string on spaces.
> >> // ... This will separate all the words.
> >> string[] words = s.*Split*(' ');
> >> foreach (string word in words)
> >> {
> >> // parse your word here for what you need.
> >> }
> >>
> >>
> >> On Sat, Sep 10, 2016 at 12:32 AM, Joe Yoder <j...@wheypower.com> wrote:
> >>
> >> > I have  a routine that processes each character in a file.  The file
> I am
> >> > working with is over 2 million characters long.  I pull it into a
> memory
> >> > variable with filetostr and then process each character with the
> substr
> >> > command.  Apparently substr has problems when dealing with a long
> string
> >> as
> >> > the process is painfully slow.
> >> >
> >> > I suspect that I will be better off using the low level file routines
> to
> >> > read one character at a time but thought maybe someone knows of a way
> to
> >> > speed up the approach I am using now.
> >> >
> >> > Thanks in advance,
> >> >
> >> > Joe
> >> >
> >> >
> >> > --- StripMime Report -- processed MIME parts ---
> >> > multipart/alternative
> >> >   text/plain (text body -- kept)
> >> >   text/html
> >> > ---
> >> >
[excessive quoting removed by server]

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

Importing a CSV with carriage returns embedded in fields

[Joe Yoder]

When one imports a .CSV file with carriage returns embedded in a field that
is delimited by quotation marks,  Foxpro ignores the quotation marks and
assumes any carriage returns it finds indicate the end of a record.  The
file I am working with ends up with several hundred extra (garbled) records
because of this fact.

When the file is opened by Excel the problem does not occur.  My question
is if someone is aware of a solution to this problem.  In this particular
case, I think I can do a workaround by simply eliminating the problem field
. Sooner or later I will probably get into a situation where I end up
writing my own import but it hasn't happened yet.

Thanks in advance for any solutions or ideas,

Joe


--- 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/CABQeDnWd3BawyvK=o5naOb=Dj=8NEPR2xYE4t=s7p1imnpp...@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.

Processing a long character string one character at a time

[Joe Yoder]

I have  a routine that processes each character in a file.  The file I am
working with is over 2 million characters long.  I pull it into a memory
variable with filetostr and then process each character with the substr
command.  Apparently substr has problems when dealing with a long string as
the process is painfully slow.

I suspect that I will be better off using the low level file routines to
read one character at a time but thought maybe someone knows of a way to
speed up the approach I am using now.

Thanks in advance,

Joe


--- 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/CABQeDnVPzmCc-4h8azeHqu1vPgLy+X9GmMOm7zwZCB=u5um...@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: Report label caption expression

[Joe Yoder]

I thought I had found a way to do it in a label field but maybe I just gave
up and used a textbox. Is that what you are suggesting?

Joe

On Wed, Aug 24, 2016 at 9:58 PM, Fred Taylor <fbtay...@gmail.com> wrote:

> Be sure your putting it into a text field not a label.
>
> Fred
>
> On Wed, Aug 24, 2016 at 6:14 PM, Joe Yoder <j...@wheypower.com> wrote:
>
> > I want the header on a report to display the year from a variable along
> > with some text.  When I set the value to "str(m.Year) + 'Auto Mileage
> > Report'" that string is displayed rather than "2015 Auto Mileage Report."
> >
> > I think I solved this years ago with the use of a special character or
> > syntax but I can't remember what it was.
> >
> > Thanks in advance for any help,
> >
> > Joe
> >
> >
> > --- StripMime Report -- processed MIME parts ---
> > multipart/alternative
> >   text/plain (text body -- kept)
> >   text/html
> > ---
> >
[excessive quoting removed by server]

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

Report label caption expression

[Joe Yoder]

I want the header on a report to display the year from a variable along
with some text.  When I set the value to "str(m.Year) + 'Auto Mileage
Report'" that string is displayed rather than "2015 Auto Mileage Report."

I think I solved this years ago with the use of a special character or
syntax but I can't remember what it was.

Thanks in advance for any help,

Joe


--- 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/cabqednxeugkgtu_vqskmsa0barujcn7m7vbvqsgxopa5e31...@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: Updating a listbox

[Joe Yoder]

I was sure the Requery would do it but I could tell no difference.  I
finally tried GotFocus and that seems to take care of it!  When I have more
time I will do some more experimenting to see if I can figure out why it
works this way.

Thanks everyone for all the input!

Joe

On Tue, Aug 23, 2016 at 11:14 AM, Dave Crozier <da...@flexipol.co.uk> wrote:

> Have you tried opening the second form by passing a reference object to it
> which points to the calling form.
>
> i.e from Form1 issue the following "do Form2 with Thisform"
>
> In the Init of the second form do this:
>
> * Procedure init()
> Parameters toCalling_Form
>
> Thisform.AddProperty("oCalling_Form", null)
>
> Thisform.oCalling_Form = toCalling_Form
> 
>
> You can now use the Thisform.oCalling_Form object to call any
> events/procedures on the first form from the second.
>
> Once you have added all the records you require in the second form you and
> issue an Thisform.oCallingform.<>.Requery immediately before the
> Thisform.Release which should display the added records on the first form.
>
> Dave
>
>
> -Original Message-
> From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Joe Yoder
> Sent: 23 August 2016 15:06
> To: profoxt...@leafe.com
> Subject: Updating a listbox
>
> I have a form that displays records from a table in a listbox.  A "New"
> button adds a record to the table and calls a detail form that allows
> entering data to the blank record.  When the detail form closes I want the
> listbox on the original form to display the new record.
>
> Its not working.automatically.  A mouse click anywhere on the list box
> causes it to resize and display the new record. I looked for a way to
> programatically simulate the physical mouse click but so far haven't found
> one. Here is the code in the button click event:
> GOTO bottom
> APPEND blank
> thisform.list1.refresh
> DO FORM PMdetail
> thisform.list1.refresh
> thisform.UpdateTot  && Update the total and refresh the form
> thisform.list1.click
>
> I know there are better approaches but it seems this should work. Any
> ideas?
>
> TIA - Joe
>
>
> --- StripMime Report -- processed MIME parts --- multipart/alternative
>   text/plain (text body -- kept)
>   text/html
> ---
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: 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/CABQeDnUUnWb_RdLTr0D8=3eydmoorz3rpdkol+kwswehurr...@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: Too simple report?

[Joe Yoder]

Thanks Tracy.  That was exactly what I needed.  I was suspicious that the
use of a variable was required but since I use the report writer so
infrequently I thought I'd ask if there is something I am overlooking.

Thanks agin - Joe

On Tue, Aug 23, 2016 at 10:46 AM, Tracy Pearson <tr...@powerchurch.com>
wrote:

> Joe Yoder wrote on 2016-08-23:
> >  I have a report that amounts to simply printing each record from a
> table.
> >  There is no subgrouping of the data.  All that is needed is a grand
> total
> >  at the bottom. How does one setup the report writer to get and print the
> >  total?
> >
> >  TIA - Joe
> >
>
> Joe,
>
> Under the Reports, menu, select Optional Bands.
> In the Report Properties window on the Optional Bands tab you'll want to
> check Report has summary band.
> Then click over to Variables, I create variables with the m. notation. So I
> add m.summary
> Value to store is the field you want to sum.
> Initial value is 0
> Reset value based on is report
> Calculation type is Sum
>
> Then you add a textbox to the Summary band (the names are at the bottom of
> the band) and put in m.summary. (or the variable name you used)
>
>
> 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/CABQeDnWXkrUfX-YBh5+fMV3HdiOSSQt2JFu_dTqkMdT=xx9...@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: Updating a listbox

[Joe Yoder]

Yes Laurie - both forms are modal.

Alan - your suggestion that there may be a timing issue has prompted my
addition of another test button on the form with the listbox.  The button
code consists of:
thisform.list1.click
thisform.list1.Refresh
thisform.refresh

When I add a record it does not show on the screen.  I can drag the scroll
bar up and down - still no record. I can click the test button - no
effect.  I can click the up arrow on the scroll bar - no effect.  When I
click the down arrow on the scroll bar or any data area in the listbox the
record shows up.

On Tue, Aug 23, 2016 at 10:22 AM, Laurie Alvey  wrote:

> Is the PMDetail form modal?
>
> Laurie
>
> On 23 August 2016 at 15:11, Alan Bourke  wrote:
>
> > If it's bound directly to the table a simple Refresh() should do it.
> > However when you show the form I think it will just show it and then the
> > next lines in your button click will run, i.e. it won't wait for your
> > PMDetail form to close.
> >
> >
> >
> > --
> >   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/CABQeDnVPunneopgR664RvEVbg0u=n=3VuW=znnnytee1ell...@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.

Too simple report?

[Joe Yoder]

I have a report that amounts to simply printing each record from a table.
There is no subgrouping of the data.  All that is needed is a grand total
at the bottom. How does one setup the report writer to get and print the
total?

TIA - Joe


--- 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/CABQeDnXr=OZ+Qxa1Xb91OZ8xNPuBMg=4tvsoxffpoyrhhmh...@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.

Updating a listbox

[Joe Yoder]

I have a form that displays records from a table in a listbox.  A "New"
button adds a record to the table and calls a detail form that allows
entering data to the blank record.  When the detail form closes I want the
listbox on the original form to display the new record.

Its not working.automatically.  A mouse click anywhere on the list box
causes it to resize and display the new record. I looked for a way to
programatically simulate the physical mouse click but so far haven't found
one. Here is the code in the button click event:
GOTO bottom
APPEND blank
thisform.list1.refresh
DO FORM PMdetail
thisform.list1.refresh
thisform.UpdateTot  && Update the total and refresh the form
thisform.list1.click

I know there are better approaches but it seems this should work. Any ideas?

TIA - Joe


--- 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/CABQeDnX9uvC2UPhW8d9Q=_rGdyvPpPha4h=xe9xksbp+b9-...@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: Flat file to Excel....but it's got more than 255 columns!

[Joe Yoder]

How about using the string functions to convert the file to Comma Separated
Values and just having Excel open the .CSV?

Joe

On Thu, Aug 18, 2016 at 12:32 PM, Fred Taylor  wrote:

> Use 2 queries to break up the number of columns.  You can then set the
> active cell and do 2 separate copy/paste calls.
>
> Fred
>
> On Thu, Aug 18, 2016 at 9:28 AM, <
> mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
>
> > VFP9SP2/Win7Pro/SDF fixed width file
> >
> > I've got a flat file that needs to be translated to an Excel file.
> > Traditional program put it into a cursor and then via automation did
> > copy/paste into Excel.  Problem is now that there are more than 255
> columns
> > (410 to be exact) so using a VFP cursor/table won't work.  I was just
> doing
> > direct string manipulations and insertting right to the Excel cells, but
> > it's a SLOW process.  It works, but I'm always looking for a better way.
> >
> > Suggestions for approach?
> >
> > tia!
> >
> >
[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/CABQeDnW3TtPfioJ84Ytfj-4HLPx=QCv7evSvbDGui+N=vQ=e...@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: Scrambled environment?

[Joe Yoder]

Dragging it off was the solution.  What I can't figure out is how it ended
up on the toolbar but I'm back in business.

Thanks everyone - Joe

On Tue, Aug 16, 2016 at 11:55 AM, Tracy Pearson <tr...@powerchurch.com>
wrote:

> Joe Yoder wrote on 2016-08-16:
> >  Thanks Richard,
> >
> >  First off - I think you must be on the right track as I have discovered
> >  that even with a complete machine reboot, when VFP comes up, it already
> has
> >  the tabs at the top of the screen and when I click on the All tab, I can
> >  see that the project I am trying to work on is already selected.
> >
> >  I tried "set resource off" in the command window but could not tell a
> >  difference. I thought the system creates a resource file in the folder
> >  where it is executing but don't see one.  I need to leave the office for
> a
> >  while.  When I get back I'll try to find the resource and config files.
> -
> >  Joe
> >
>
> Joe,
>
> Oh! Now I see, the Project Manager is reduced to a Toolbar.
> You can drag it off if you are used to it being in a window.
>
>
> 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/CABQeDnW+4sUe3ScrO0BQiWvHPr+y8vw5WFs=iWx5mq=opkc...@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: Scrambled environment?

[Joe Yoder]

Thanks Richard,

First off - I think you must be on the right track as I have discovered
that even with a complete machine reboot, when VFP comes up, it already has
the tabs at the top of the screen and when I click on the All tab, I can
see that the project I am trying to work on is already selected.

I tried "set resource off" in the command window but could not tell a
difference. I thought the system creates a resource file in the folder
where it is executing but don't see one.  I need to leave the office for a
while.  When I get back I'll try to find the resource and config files. -
Joe


On Tue, Aug 16, 2016 at 10:57 AM, Richard Kaye <rk...@invaluable.com> wrote:

> First thing I would try is set resource off. You can setup an FPW config
> file that gives you a minimal environment.
>
> --
>
> rk
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe
> Yoder
> Sent: Tuesday, August 16, 2016 10:48 AM
> To: profoxt...@leafe.com
> Subject: Scrambled environment?
>
> I'm running VFP 9.0 sp2.  When I try to modify a project, unselected tabs
> for "All", "Data", "Documents", "Classes", "Code", and "Other" appear.
> When I click on one of the tabs the appropriate items display but I don't
> have the buttons on the right that let me manage the components and compile
> the code.  I have exited and reopened VFP multiple times with no change.
> How do I get my buttons back?
>
> Thanks in advance!
>
> Joe
>
>
>
[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/cabqednxcmuvo+p8r8b_oof6q7oq0e1qwjrank813abvp47g...@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.

Scrambled environment?

[Joe Yoder]

I'm running VFP 9.0 sp2.  When I try to modify a project, unselected tabs
for "All", "Data", "Documents", "Classes", "Code", and "Other" appear.
When I click on one of the tabs the appropriate items display but I don't
have the buttons on the right that let me manage the components and compile
the code.  I have exited and reopened VFP multiple times with no change.
How do I get my buttons back?

Thanks in advance!

Joe


--- 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/cabqednubjltmccfspwpkhyf_51wsu8ud+z9uu6bye0sowar...@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.

Handling POP3 Email in folder structures

[Joe Yoder]

I have a situation where an old Email client is being retired.  That client
stored email in folder structures.  Each Email is a separate file which I
believe remains in the POP3 format in which it was downloaded.  The goal is
to treat the Email as a company resource that can be accessed by anyone who
has a need to see it.

I am thinking of several options and open to suggestions:

   - Process the contents of each folder into an individual text file and
   store that file on the local server where appropriate users can see it.
   - Process the contents of a folder into a format that can be imported
   into a company generic Gmail account along with an origin label. Users with
   the proper clearance could then access the original Email from the generic
   account.

I assume that I am not the first person dealing with this situation.  The
simplest solution might be something off the shelf that does not involve
coding at all.  Otherwise - I know the text portion of the files is easily
manipulated in VFP.  Handling attachments may be much more difficult.  I
have no experience in interfacing with Gmail.

Ultimately I would like to allow a user with a Gmail account to apply a
specific label to an Email in her/his environment and have that Email
automatically copied to the appropriate generic company email account.
This would put information that others need where they can see it without
copying multiple people.  It should allow deleting a users account without
loosing company information.

Any input welcome!

Thanks in advance,

Joe


--- 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/CABQeDnVs_3TX+o6Q1k7_C4zeR5r9-n=gldpvxvt9t0sn-yu...@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: API to find the size of an entire folder structure?

[Joe Yoder]

I was planning to go the recursive ADIR route but am intrigued by the WSH
approach.  I had read about it in the past but always assumed it was only
available on machines that have been configured to run it.  A quick check
of the environments I work in now shows they all have it.

I ran the sample code and discovered if I select a folder too high on the
root I get an "OLE error code 0x800a00046: Unknown COM status code."
error.  Other than that I think I will find the functions quite useful.

Thanks again - Joe

On Sat, Jul 30, 2016 at 10:19 AM, Jean MAURICE 
wrote:

> Why not create a recursive function with ADIR() ?
>
> The Foxil
>
>
[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/cabqednuu0qczzns7ht0-un_elfs8hk67m4-ptvl_w4ccsnv...@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: API to find the size of an entire folder structure?

[Joe Yoder]

Thanks - I suspected that.

On Sat, Jul 30, 2016 at 9:12 AM, Gérard LOCHON <g-loc...@wanadoo.fr> wrote:

> There isn't such a thing in the Win API.
>
> You have to it by yourself, even if it is in C.
>
>
> Gérard.
>
>
>
> Le 30/07/2016 à 13:04, Joe Yoder a écrit :
>
>> Is there a programatic shortcut to finding the size of an entire
>> folder/subfolder structure without recursing through it in VFP?
>>
>> Thanks in advance,
>>
>> Joe
>>
>>
>
[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/cabqednxlmzjeixcyfgzotd+ffyw-q01nxryotyovqbyn4wf...@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.

API to find the size of an entire folder structure?

[Joe Yoder]

Is there a programatic shortcut to finding the size of an entire
folder/subfolder structure without recursing through it in VFP?

Thanks in advance,

Joe


--- 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/cabqednwlrb2gd6czccmbb4x9vtyfo+w_xbaxsumigzafh1g...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Windows 10 upgrade out to lunch

[Joe Yoder]

I bet the problem is that there is not enough disk space! There are only
1.3 gigs of 219 gigs free. I read somewhere that one can check a hidden
$Windows.~BT
 folder
to see if the installation files are present.  I looked for such a folder
and found none.  It would appear that the installer is smart enough to see
that there is not enough space to do the installation but not smart enough
to report that to the user!

Joe

On Fri, Jul 22, 2016 at 11:32 AM, Allen Pollard 
wrote:

> I had problems downloading and had a reboot to continue. For some reason it
> didn't say. On another a reboot made it start from scratch again. No rhyme
> or reason
> Al
>
> -Original Message-
>
> I thought this typically meant that once it has finished downloading the
> 3-6GB of Windows Delight it will let you know it's time to continue. I
> think
> you can just download it directly and create a standalone installer.
>
>
>
>
[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/cabqednwhdc6+fc3tbdxowdmnxcxa1lic+8ui8ptpw1fhwa0...@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.

[NF] Windows 10 upgrade out to lunch

[Joe Yoder]

I have a small laptop with Windows 7 that I would like to upgrade to
Windows 10.  The machine has the Get Windows 10 icon in the system tray.

Every time I click the icon, a Get Windows 10 window opens and after a
brief pause at "Please wait", the screen displays sections "About Windows
10" and "Get the upgrade."  Then at the bottom of the window there is a
large bold font message "All done for now" followed by "There's nothing
else you need to do.  You'll get a notification on your PC or tablet when
Windows 10 is ready for you."

This condition has persisted for weeks and I expect without intervention it
will continue after the end of July.  I have Googled everything I can think
of but no one seems to have the same problem. There are numerous entries
about problems but they are typically accompanied by error messages which I
would welcome but don't get.

Any experience or thoughts?  Perhaps I should take this as a sign that I
should keep this machine on Win 7?

Thanks in advance,

Joe


--- 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/CABQeDnXM4EAJtc5whWji+T=82stdfrqcs-feo27d8kzsmmv...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: GETFILE and SET DEFAULT

[Joe Yoder]

Actually I discovered that my code was disappearing after the commands were
executed so I did some more Googling and found that  the value to be saved
is returned by CURDIR() rather than SET('DEFAULT').  It gets restored with
"SET DEFAULT TO." That explains why things weren't working for me!  Somehow
it seems better terminology could have been chosen!

Thanks,

Joe

On Wed, Jul 20, 2016 at 3:57 PM, rafael copquin <rafael.copq...@gmail.com>
wrote:

> Try this:
>
> m.SaveDef = set('DEFAULT')
>
> set default to ...
>
> do your thing
>
> then get back with
>
> set default to 
>
> or
>
> set default to (m.SaveDef)
>
> Rafael Copquin
>
>
> On 20/07/2016 16:50, Joe Yoder wrote:
>
>> I need to have a user choose a file with a specific extension from a
>> specific folder.  I assumed I could simply pass a file skeleton to GETFILE
>> like one does to ADIR.  When I try that FoxPro seems to navigate to the
>> proper folder but does not show any contents in the folder.
>>
>> I looked up the docs on GETFILE and it appears that specifying the path to
>> a specific folder is not a valid use.  One needs to "SET DEFAULT TO" the
>> desired path in a separate operation and then call GETFILE with the
>> desired
>> extension.  This appears to work but when I tried to save and restore the
>> setting of DEFAULT before and after this use I discovered that no matter
>> what I do,
>> ?SET('DEFAULT') always returns 'C:'.  Since "SET DEFAULT TO" (invalid
>> path)
>> gives an error  and GETFILE respects the setting - apparently the default
>> value is being set but just not reported.  My conclusion is that the
>> recommended "m.SaveDef = SET('DEFAULT')" before and
>> "SET DEFAULT TO m.SaveDef) after really do nothing.
>>
>> Am I missing something?
>>
>> Thanks in advance,
>>
>> Joe
>>
>>
>> --- StripMime Report -- processed MIME parts ---
>> multipart/alternative
>>text/plain (text body -- kept)
>>text/html
>> ---
>>
[excessive quoting removed by server]

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

GETFILE and SET DEFAULT

[Joe Yoder]

I need to have a user choose a file with a specific extension from a
specific folder.  I assumed I could simply pass a file skeleton to GETFILE
like one does to ADIR.  When I try that FoxPro seems to navigate to the
proper folder but does not show any contents in the folder.

I looked up the docs on GETFILE and it appears that specifying the path to
a specific folder is not a valid use.  One needs to "SET DEFAULT TO" the
desired path in a separate operation and then call GETFILE with the desired
extension.  This appears to work but when I tried to save and restore the
setting of DEFAULT before and after this use I discovered that no matter
what I do,
?SET('DEFAULT') always returns 'C:'.  Since "SET DEFAULT TO" (invalid path)
gives an error  and GETFILE respects the setting - apparently the default
value is being set but just not reported.  My conclusion is that the
recommended "m.SaveDef = SET('DEFAULT')" before and
"SET DEFAULT TO m.SaveDef) after really do nothing.

Am I missing something?

Thanks in advance,

Joe


--- 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/CABQeDnWnkDOX95Q1KFRE+Pgj=oodx-uhzhc8vwtwg6zr0jr...@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: Checking for All-Different Characters

[Joe Yoder]

Here is a simple brute force approach with the same count

m.cnt = 0
m.Cdate = {^1900-01-01}
DO WHILE m.Cdate < {^-12-31}
  m.str = dtos(m.cdate)
  FOR m.x = 1 TO 8
IF OCCURS(SUBSTR(m.str, m.x, 1), m.str) > 1
  EXIT
ENDIF
  ENDFOR
  IF m.x = 9
m.cnt = m.cnt + 1
   * WAIT window m.Cdate
  ENDIF
  m.cdate = m.cdate + 1
ENDDO
?m.cnt

It takes a little over 6 seconds on my machine so it's not faster - just
simpler.

Joe


On Sun, Jul 17, 2016 at 9:06 PM, Darren  wrote:

> This will give you all the dates that have a unique set of digits 1900 to
>  - probably more efficient ways to do it but this runs sub second on my
> machine and spits out 44,640 values. Have not done any testing or checking
> but it'll give you at least an idea.
>
> CREATE CURSOR w_dates (uniquedate D)
>
> FOR lnYear = 1900 TO 
>
>   STORE 0 TO lnCheck
>   STORE .F. TO llDuplicate
>
>   *- Check the year part for duplicate number usage
>   STORE STR(m.lnYear, 4) TO lcYear
>   FOR n = 1 TO 4
>
> STORE VAL(SUBSTR(m.lcYear, n, 1)) TO lnVal
>
> IF BITTEST(m.lnCheck, m.lnVal)
>   STORE .T. TO llDuplicate
>   EXIT
> ELSE
>   lnCheck = BITSET(m.lnCheck, m.lnVal)
> ENDIF
>
>   ENDFOR
>
>   IF m.llDuplicate
> LOOP
>   ENDIF
>
>   STORE m.lnCheck TO lnCheckYr
>
>   *---
>   *- Process Months
>   *---
>   FOR lnMth = 1 TO 12
>
> *- Check the mth + year part for duplicate number usage
> STORE .F. TO llDuplicate
>
> STORE PADL(m.lnMth, 2, "0") TO lcMth
> FOR n = 1 TO 2
>
> STORE VAL(SUBSTR(m.lcMth, n, 1)) TO lnVal
>
>   IF BITTEST(m.lnCheck, m.lnVal)
> STORE .T. TO llDuplicate
> EXIT
>   ELSE
> lnCheck = BITSET(m.lnCheck, m.lnVal)
>   ENDIF
>
> ENDFOR
>
> IF m.llDuplicate
>
>   STORE m.lnCheckYr TO lnCheck  && Restore baseline to the year value
>   LOOP
>
> ENDIF
>
> STORE m.lnCheck TO lnCheckYrMth
>
> *---
> *- Process Days
> *---
>
> *- How many days in the month ?
> lnDays = ICASE(;
>   INLIST(m.lnMth, 1, 3, 5, 7, 8, 10, 12), 31, ;
>   m.lnMth = 2, 28, ;
>   30)
>
> *- Is this a leap Year ?
> IF m.lnMth = 2 AND MOD(m.lnYear, 4) = 0 AND IIF(MOD(m.lnYear, 100) = 0,
> IIF(MOD(m.lnYear, 400) = 0, .T., .F.), .T.)
>   STORE 29 TO lnDays
> ENDIF
>
> FOR lnDay = 1 to m.lnDays
>
>   *- Check the mth + year + day parts for duplicate number usage
>   STORE .F. TO llDuplicate
>
>   STORE PADL(m.lnDay, 2, "0") TO lcDay
>   FOR n = 1 TO 2
>
>   STORE VAL(SUBSTR(m.lcDay, n, 1)) TO lnVal
>
> IF BITTEST(m.lnCheck, m.lnVal)
>   STORE .T. TO llDuplicate
>   EXIT
> ELSE
>   lnCheck = BITSET(m.lnCheck, m.lnVal)
> ENDIF
>
>   ENDFOR
>
>   IF NOT m.llDuplicate
>
> INSERT INTO w_dates (;
> uniquedate) ;
>   VALUES (;
> DATE(m.lnYear, m.lnMth, m.lnDay))
>
>   ENDIF
>
>   STORE m.lnCheckYrMth TO lnCheck  && Restore baseline to the year +
> month value - check next day in month.
>
> ENDFOR
>
> STORE m.lnCheckYr TO lnCheck  && Check Next Mth in Year
>
>   ENDFOR
>
> ENDFOR
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Gene
> Wirchenko
> Sent: Monday, 18 July 2016 2:29 AM
> To: profoxt...@leafe.com
> Subject: Checking for All-Different Characters
>
> Hello:
>
>   I write a logic/math puzzle each week.  They appear in my blog
> (http://genew.ca/) and two local newspapers.
>
>   Here is the latest problem:
>
>   "Consider a date in -MM-DD format.  What is the next date where
> all eight digits will be different?"
>
>   I solved this by hand.  I decided to verify my solution with a
> program.  I often cook up something in GW-BASIC, but since VFP has date
> functions, I decided to go with it.
>
>   It was very easy to set up the framework of the loop.  What threw me
> for a loop is how to check that all of the digits are different.  I ended
> up
> converting the date to string with dtos() and then testing the string with
> a
> rather ugly-looking condition.  Is there something faster?
>
> * Start of Code *
> * 16s-16.prg
> * Date Puzzle
> * Last Modification: 2016-07-17
> *
> * Consider a date in -MM-DD format.  What is the next date where all
> * eight digits will be different?
>
> ? "*** Execution begins."
> ? program()
> close all
> clear all
>
> set talk off
> set exact on
> set century on
> set date ansi
>
> *
>
> local startdate
> startdate=date()
>
> ? "Start Date: "+transform(startdate)
>
> local trydate, looping
> trydate=startdate
> looping=.t.
> do while looping
>
>local trydtos
>trydtos=dtos(trydate)
> 

NF - Does anyone have experience with Wyse thin terminals?

[Joe Yoder]

I have 15 identical Wyse VX0 V90L XPEdevices that I purchased used on
Ebay.  I have been trying to get all the parts lined up so the terminals
can connect to an FTP server and download their configuration but I keep
going in circles.  I'm thinking to connect with an expert on JustAnswer.com
or a similar site but thought I would mention my situation here in case
someone can help or point me to the help I need.

I don't know if the devices have been locked so that it is not possible to
get to the configuration or if I simply have not tried the magic
combination.  The devices are supposed to connect to a DHCP server and get
the usual IP address etc.  They are also supposed to receive the address of
the FTP server on option 161.

I have setup a test network with a DHCP server giving out the info complete
with option 161.  This was verified with a program called DHCPtest which
outputs a discovery command and reports what it gets back from the server.

The FTP server is running on my laptop and its function has been verified
by FTPing in and executing the documented commands that the system needs.
This verifies that the FTPserver is accessable and has the proper
information in the appropriate place.

When a Wyse devices attempt to boot I monitored the info it got back from
the DHCP server and discovered that it does not get the option 161 even
though the discovery command from the test program does.  I setup Wireshark
and discovered that the Wyse version of the discovery command specifies the
parameters to be returned and the 161 option is not included.

My conclusion is that there must be a configuration in the device that
controls whether or not an FTP connection is attempted.  I simply haven't
figured out how to get to it.  Probably something really simple.

Any help will be appreciated.

Thanks in advance,

Joe


--- 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/cabqednvcgqmzsvnkqtq8n7ofrwkpau0xdm5qcfwcrc0udqk...@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: Finding which code is executing

[Joe Yoder]

I had  deleted the Visa.fxp and recompiled the project and the .prg
 without any noticable change.  The Visa.prg code is really standalone. The
project calls it as dictated by the control table and my test routine
called it with hard coded parameters.  I realize now that I should have
checked to see if calling the routine from my test caused the fxp to be
recreated.

I'm hearing that executing the code in the debugger may be a useful
exercise.  I suppose by the time I get another opportunity to run this down
I will have forgotten what I learned! _ I' keep a copy of the thread to
improve my chances - Joe

On Wed, May 25, 2016 at 9:40 AM, Ted Roche <tedro...@gmail.com> wrote:

> Have you recompiled your project since you made this change? If you're
> running an APP or EXE and the control table is included inside the
> App/EXE, it would still have a copy of the older version of the table.
>
> If this isn't the case, can you set a breakpoint that will trip when
> the code in question starts to run, for example,
>
> "MyInputTable.DBF" $ DBF()
>
> If this is the only place that the MyInputTable is opened.
>
> On Wed, May 25, 2016 at 8:13 AM, Joe Yoder <j...@wheypower.com> wrote:
> > Thanks guys for the input.  I had assumed there might be a function to
> > figure out which code will run the same way Foxpro does.  The problem
> with
> > sys(16) is how to get it into the code when I don't know where it is.  I
> > concluded that I should try to give the routine something to do that will
> > make it blow up and hopefully give away its location but before I tried
> > that everything appeared to return to normal. (the debug stuff in the
> > edited code started working.)
> >
> > The Visa import routine is included in the project along with others like
> > Discover and Checking.  An Import control table stores the routine names
> > along with appropriate parameters.  The routines are called as my code
> > scans the table and call the appropriate routines.  When I renamed the
> > routine I changed the name in the control table but did not add the new
> > routine to the project. The compiler never noticed that a new routine
> will
> > be called and does not complain or auto add the new routine.  This
> behavior
> > is expected.  As far as I know this approach has nothing to do with the
> > behavior I experienced but it may be that others may see a connection I
> > don't.
> >
> > Thanks again,
> >
> > Joe
> >
> > On Tue, May 24, 2016 at 1:59 PM, Gene Wirchenko <ge...@telus.net> wrote:
> >
> >> At 08:23 2016-05-24, "Tracy Pearson" <tr...@powerchurch.com> wrote:
> >>
> >>> Joe Yoder wrote on 2016-05-24:
> >>> >  I have a small procedure file, visa.prg. in my current project
> folder
> >>> that
> >>> >  imports data from .csv files.  I need to support a slightly
> different
> >>> >  format so I added some debugging code but it does not run.  When I
> >>> made a
> >>> >  copy with a different name it worked as expected.
> >>> >
> >>> >  Is there a way to have the system tell me the location of the
> running
> >>> code?
> >>>
> >>
> >> You can kinda figure some of that out through the debugger.
> >>> I would search for PRGs and Functions/Procedures with of the name you
> were
> >>> calling. (Visa I would assume)
> >>>
> >>> VFP doesn't complain when you have two Functions of the same name in a
> >>> PRG.
> >>> It runs the last one found in the PRG.
> >>>
> >>> I have not tested, and do not know which will fire when you have a PRG
> >>> and a
> >>> Function named the same.
> >>>
> >>
> >>  I was recently bit by having two methods in a class named the same.
> >> You would think that this would generate a compilation error, but it
> does
> >> not.
> >>
> >>  My debugging code was not being executed either.
> >>
> >>  I only discovered it accidentally when I got desperate and started
> >> instrumenting the entire class and saw what looked like (and was) a
> >> duplicate name.
> >>
> >>  I suggest that you check this possibility before writing more
> >> debugging code (which is not going to get executed anyway).
> >>
> >> Sincerely,
> >>
> >> Gene Wirchenko
> >>
> >>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cabqednu+upsc3syoj5pyzqxhc3vpd4gk0oewz0zngo3yfpe...@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: Finding which code is executing

[Joe Yoder]

Thanks guys for the input.  I had assumed there might be a function to
figure out which code will run the same way Foxpro does.  The problem with
sys(16) is how to get it into the code when I don't know where it is.  I
concluded that I should try to give the routine something to do that will
make it blow up and hopefully give away its location but before I tried
that everything appeared to return to normal. (the debug stuff in the
edited code started working.)

The Visa import routine is included in the project along with others like
Discover and Checking.  An Import control table stores the routine names
along with appropriate parameters.  The routines are called as my code
scans the table and call the appropriate routines.  When I renamed the
routine I changed the name in the control table but did not add the new
routine to the project. The compiler never noticed that a new routine will
be called and does not complain or auto add the new routine.  This behavior
is expected.  As far as I know this approach has nothing to do with the
behavior I experienced but it may be that others may see a connection I
don't.

Thanks again,

Joe

On Tue, May 24, 2016 at 1:59 PM, Gene Wirchenko <ge...@telus.net> wrote:

> At 08:23 2016-05-24, "Tracy Pearson" <tr...@powerchurch.com> wrote:
>
>> Joe Yoder wrote on 2016-05-24:
>> >  I have a small procedure file, visa.prg. in my current project folder
>> that
>> >  imports data from .csv files.  I need to support a slightly different
>> >  format so I added some debugging code but it does not run.  When I
>> made a
>> >  copy with a different name it worked as expected.
>> >
>> >  Is there a way to have the system tell me the location of the running
>> code?
>>
>
> You can kinda figure some of that out through the debugger.
>> I would search for PRGs and Functions/Procedures with of the name you were
>> calling. (Visa I would assume)
>>
>> VFP doesn't complain when you have two Functions of the same name in a
>> PRG.
>> It runs the last one found in the PRG.
>>
>> I have not tested, and do not know which will fire when you have a PRG
>> and a
>> Function named the same.
>>
>
>  I was recently bit by having two methods in a class named the same.
> You would think that this would generate a compilation error, but it does
> not.
>
>  My debugging code was not being executed either.
>
>  I only discovered it accidentally when I got desperate and started
> instrumenting the entire class and saw what looked like (and was) a
> duplicate name.
>
>  I suggest that you check this possibility before writing more
> debugging code (which is not going to get executed anyway).
>
> Sincerely,
>
> Gene Wirchenko
>
>
[excessive quoting removed by server]

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

Finding which code is executing

[Joe Yoder]

I have a small procedure file, visa.prg. in my current project folder that
imports data from .csv files.  I need to support a slightly different
format so I added some debugging code but it does not run.  When I made a
copy with a different name it worked as expected.

Is there a way to have the system tell me the location of the running code?

Thanks in advance,

Joe


--- 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/cabqednu49egjmukmqscobbupbdkxfxowzvwdyqxzoicga+2...@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: Help with SQL optimization

[Joe Yoder]

Thanks Ted,

I never really understood the usefulness of a primary key before.  Now I do.

I check with and without the the indexes and saw little difference -  about
1/5 of a second instead of 15!

Thanks again,

Joe

On Sun, May 15, 2016 at 4:50 PM, Ted Roche <tedro...@gmail.com> wrote:

> Yeah, that's just wrong. The query should take 1 second or less.
>
> Index matches only work if the expression of the index is IDENTICAL to
> the expression used in the left side of a WHERE clause.
>
> ALLTRIM does not work in indexes, as VFP indexes have to have the same
> length.
>
> It's a BEST Practice to not create complex expressions, like stringing
> fields together, in order to match records in two tables, as it's
> harder to ensure all of those expressions are Rushmore-optimizable.
>
> So, assuming you have separate index tags for each field (dDate,
> cName, cType, etc.) on both of the tables, and also a separate tag for
> DELETED() on each table, and none of the indexes have "FOR" clauses,
> since they won't be used in Rushmore optimization.
>
> Assuming you have a primary key on the receipts table the query is
> easy. If you don't,... well, it's a lot tougher.
>
>   SELECT *;
> FROM Receipts;
> Where Receipts.PrimaryKey NOT IN
> (SELECT Receipts.PrimaryKey
>  FROM Receipts JOIN Master
>  ON
>   Receipts.dDate = Master.dDate AND
>   Receipts.cName = Master.cName AND
>   Receipts.cType = Master.cType AND
>   Receipts.nAmount = Master.nAmount AND
>   Receipts.cAccount = Master.cAccount AND
>   Receipts.cClass = Master.cClass AND
>   Receipts.cJobCust = Master.cJobCust AND
>   Receipts.cNumber = Master.cNumber AND
>   Receipts.mMemo = Master.mMemo AND
>   Receipts.cSplit_id = Master.cSplit_id
>  )
>      INTO CURSOR Batch READWRITE
>
> should work in subsecond time with 1350 records.
>
> On Sun, May 15, 2016 at 4:05 PM, Joe Yoder <j...@wheypower.com> wrote:
> > I have a process that starts out with a table of about 4300 records.  An
> > SQL select yields a cursor of only the records not already in a master
> > table for processing and gradual addition to the master table.  When the
> > master table was empty my SQL results were sub second.  Now that the
> master
> > table has about 1350 records in it the SQL process takes between 15 and
> 16
> > seconds.  My initial thought was that indexing each field in the master
> > table should speed things up but that seems to have no effect.
> >
> > Here is the code:
> > * Build a cursor of all records from the Receipts table that are not in
> the
> > Master table
> >   SELECT *;
> > FROM Receipts;
> > WHERE (DTOC(dDate);
> >   + ALLTRIM(cName);
> >   + ALLTRIM(cType);
> >   + ALLTRIM(STR(nAmount,10,2));
> >   + ALLTRIM(cAccount);
> >   + ALLTRIM(cClass);
> >   + ALLTRIM(cJobCust);
> >   + ALLTRIM(cNumber);
> >   + ALLTRIMm(Memo);
> >  + cSplit_id;
> >NOT in;
> >   (select DTOC(dDate);
> >  + ALLTRIM(cName);
> >  + ALLTRIM(cType);
> >  + ALLTRIM(STR(nAmount,10,2));
> >  + ALLTRIM(cAccount);
> >  + ALLTRIM(cClass);
> >  + ALLTRIM(cJobCust);
> >  + ALLTRIM(cNumber);
> >  + ALLTRIM(mMemo);
> >  + cSplit_id;
> >  FROM Master));
> >  INTO CURSOR Batch READWRITE
> >
> > Suggestions welcome!
> >
> > Thanks in advance,
> >
> > Joe
> >
> >
> > --- StripMime Report -- processed MIME parts ---
> > multipart/alternative
> >   text/plain (text body -- kept)
> >   text/html
> > ---
> >
[excessive quoting removed by server]

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

Help with SQL optimization

[Joe Yoder]

I have a process that starts out with a table of about 4300 records.  An
SQL select yields a cursor of only the records not already in a master
table for processing and gradual addition to the master table.  When the
master table was empty my SQL results were sub second.  Now that the master
table has about 1350 records in it the SQL process takes between 15 and 16
seconds.  My initial thought was that indexing each field in the master
table should speed things up but that seems to have no effect.

Here is the code:
* Build a cursor of all records from the Receipts table that are not in the
Master table
  SELECT *;
FROM Receipts;
WHERE (DTOC(dDate);
  + ALLTRIM(cName);
  + ALLTRIM(cType);
  + ALLTRIM(STR(nAmount,10,2));
  + ALLTRIM(cAccount);
  + ALLTRIM(cClass);
  + ALLTRIM(cJobCust);
  + ALLTRIM(cNumber);
  + ALLTRIMm(Memo);
 + cSplit_id;
   NOT in;
  (select DTOC(dDate);
 + ALLTRIM(cName);
 + ALLTRIM(cType);
 + ALLTRIM(STR(nAmount,10,2));
 + ALLTRIM(cAccount);
 + ALLTRIM(cClass);
 + ALLTRIM(cJobCust);
 + ALLTRIM(cNumber);
 + ALLTRIM(mMemo);
 + cSplit_id;
 FROM Master));
 INTO CURSOR Batch READWRITE

Suggestions welcome!

Thanks in advance,

Joe


--- 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/cabqednvr8-mfre3t0z6oh_o39vpdtbarjsjkzg-ln5jof2p...@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: Shortcut to generalized click column for sort order browse?

[Joe Yoder]

Thanks guys - the SPS package is even better than I had hoped!  Now I need
to learn how to work with grids!

Joe

On Fri, May 13, 2016 at 3:25 PM, rafael copquin <rcopq...@fibertel.com.ar>
wrote:

> In addition to what Peter says:
>
> when you click on the column you want to, put this code
>
> set order to ... in .(the table or cursor)
>
> this.parent.parent.refresh
>
> Those two lines of code will do what you want. Of course, we are talking
> of a grid here, not a browse
>
> Rafael Copquin
>
>
>
>
> On 13/05/2016 13:21, Peter Cushing wrote:
>
>> On 13/05/2016 16:44, Joe Yoder wrote:
>>
>>> I need to present information from several tables.  I want to enable the
>>> user to click on a column header to control the order in which the
>>> records
>>> are displayed.  At this point it does not need to be very polished so a
>>> simple browse with scrolling, column resizing and repositioning, with
>>> control F find will be fine.
>>>
>>> I do this with a grid on a form.  I create a cursor in the init or load
>> and set that as the recordsource etc. then fill it with data and index on
>> the columns you want to be able to set order to.  To change the order just
>> click on the column header and some code behind that changes the index
>> order.  Grids are definitely more work than a browse but you can do a lot
>> more with them, like the column header click.
>>
>> Peter
>>
>>
>>
>> This communication is intended for the person or organisation to whom it
>> is addressed. The contents are confidential and may be protected in law.
>> Unauthorised use, copying or disclosure of any of it may be unlawful. If
>> you have received this message in error, please notify us immediately by
>> telephone or email.
>> www.whisperingsmith.com
>>
>> Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3
>> 1RR. Tel:0161 831 3700 Fax:0161 831 3715
>> London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960
>>
>>
[excessive quoting removed by server]

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

Shortcut to generalized click column for sort order browse?

[Joe Yoder]

I need to present information from several tables.  I want to enable the
user to click on a column header to control the order in which the records
are displayed.  At this point it does not need to be very polished so a
simple browse with scrolling, column resizing and repositioning, with
control F find will be fine.

A generalized routine like this that would handle most tables would be
quite useful.  Is there something available that I should use rather than
reinventing the wheel?

Thanks in advance,

Joe


--- 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/cabqednxspdlw-hvcjxetm4rrqa9yaynwbtvrujdupxlhadg...@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: Strange " File access is denied" message

[Joe Yoder]

That all makes sense but why wouldn't giving the file a new name let me
start over?  I did look for evidence in the task manager but I am new to
the Windows 10 version and did not spot anything with Foxpro in the name.

Joe

On Fri, May 6, 2016 at 3:53 AM, Dave Crozier <da...@flexipol.co.uk> wrote:

> I guess you crashed the form at some stage and the .scx/sct table was left
> open somewhere hence not being able to open it. The open file could also be
> in another instance of VFP which isn't displayed because it has gone rogue
> at some stage and doesn't present a visual interface.
>
> I have had this happen quite frequently when testing tricky code
> especially when using office automation. The "stranded" instances of VFP or
> office apps can be seen in the task manager and closed accordingly.
>
> Dave
>
> -Original Message-
> From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Joe Yoder
> Sent: 05 May 2016 22:05
> To: Foxpro forum <profox@leafe.com>
> Subject: Re: Strange " File access is denied" message
>
> Thanks Tracy,
>
> I tried using with the share clause and it worked without error.
> I renamed the files and the same files with different names continued to
> give the error, I restarted the computer and the problem went away!
>
> I'm glad to have my code back but am still puzzled about what was
> happening,
>
> Thanks again,
>
> Joe
>
> On Thu, May 5, 2016 at 2:20 PM, Tracy Pearson <tr...@powerchurch.com>
> wrote:
>
> > Joe Yoder wrote on 2016-05-05:
> > >  I have a situation where "File Access is denied" shows up any time
> > > I try
> > to
> > >  open the main form in my current project.  I'm running Windows 10
> > > and
> > when
> > >  I get into File Explorer I can open both the .SCT and the .SCX
> > > files
> > from
> > >  notepad without a problem.  If I double click on either one VFP
> > > opens,  attempts to open the file, and throws the error message.
> > >
> > >  VFP opens other screen files without a problem so it seems there
> > > must be
> > a
> > >  problem with that specific file inside VFP.  I tried opening the
> > > .SCX as
> > a
> > >  table and got the error too.
> > >
> > >  Any ideas about why this is happening and how to get around it will
> > > be
> > most
> > >  welcome!
> > >
> > >  Thanks in advance,
> > >
> > >  Joe
> > >
> >
> > Joe,
> >
> > VFP will open the files exclusive. Notepad will not.
> > Did you try to use the SCX as a table with the SHARE clause?
> >
> > Do you have a process open or hung that still has the form open?
> >
> > 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/cabqednvpncar4_sfc3ankk+n0ojrmf0jgjq2bjrruf7bdhb...@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: Strange " File access is denied" message

[Joe Yoder]

Thanks Tracy,

I tried using with the share clause and it worked without error.
I renamed the files and the same files with different names continued to
give the error,
I restarted the computer and the problem went away!

I'm glad to have my code back but am still puzzled about what was happening,

Thanks again,

Joe

On Thu, May 5, 2016 at 2:20 PM, Tracy Pearson <tr...@powerchurch.com> wrote:

> Joe Yoder wrote on 2016-05-05:
> >  I have a situation where "File Access is denied" shows up any time I try
> to
> >  open the main form in my current project.  I'm running Windows 10 and
> when
> >  I get into File Explorer I can open both the .SCT and the .SCX files
> from
> >  notepad without a problem.  If I double click on either one VFP opens,
> >  attempts to open the file, and throws the error message.
> >
> >  VFP opens other screen files without a problem so it seems there must be
> a
> >  problem with that specific file inside VFP.  I tried opening the .SCX as
> a
> >  table and got the error too.
> >
> >  Any ideas about why this is happening and how to get around it will be
> most
> >  welcome!
> >
> >  Thanks in advance,
> >
> >  Joe
> >
>
> Joe,
>
> VFP will open the files exclusive. Notepad will not.
> Did you try to use the SCX as a table with the SHARE clause?
>
> Do you have a process open or hung that still has the form open?
>
> 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/cabqednu0deyenxjs8sdh0yvhphmbf-z54mu9seg6it5e3z5...@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.

Strange " File access is denied" message

[Joe Yoder]

I have a situation where "File Access is denied" shows up any time I try to
open the main form in my current project.  I'm running Windows 10 and when
I get into File Explorer I can open both the .SCT and the .SCX files from
notepad without a problem.  If I double click on either one VFP opens,
attempts to open the file, and throws the error message.

VFP opens other screen files without a problem so it seems there must be a
problem with that specific file inside VFP.  I tried opening the .SCX as a
table and got the error too.

Any ideas about why this is happening and how to get around it will be most
welcome!

Thanks in advance,

Joe


--- 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/CABQeDnVM-sLqeUE6N=ucc5xes85ddtpp3hlhnp8cmbittqf...@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: Using the when event in a command button

[Joe Yoder]

Thanks Tracy - it's been to long since I did any screen coding!

On Sat, Mar 5, 2016 at 12:49 AM, Tracy Pearson <tr...@powerchurch.com>
wrote:

> The line should be
> Return NOT EMPTY(thisform.combo1.Value)
>
>
>
> On March 4, 2016 10:55:39 PM EST, Joe Yoder <j...@wheypower.com> wrote:
> >No - just the one line or the .f.
> >On Mar 4, 2016 10:28 PM, "Tracy Pearson" <tr...@powerchurch.com> wrote:
> >
> >Is there a RETURN statement in front of the NOT?
>
> --
> Sent from my Android device with K-9 Mail. Please excuse my brevity.
>
[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/cabqednv5nb0_iuaxxdoxtjcvzsr5-ups9skhv3s9tesvcyu...@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: Using the when event in a command button

[Joe Yoder]

No - just the one line or the .f.
On Mar 4, 2016 10:28 PM, "Tracy Pearson" <tr...@powerchurch.com> wrote:

Is there a RETURN statement in front of the NOT?

On March 4, 2016 10:20:09 PM EST, Joe Yoder <j...@wheypower.com> wrote:
>I have a command button on a form that should not be accessible unless
>there is a table selected.  I am attempting to use a expression that
>will
>evaluate to false in the WHEN event when no table is selected:
>
>NOT EMPTY(thisform.combo1.Value)
>
>The message I get is "Error in line 7 of Form1.Command1.When (record
>7):
>Unrecognized command verb."
>
>Even with a .f. as the expression I get the same message.  Am I giving
>the
>fox something she doesn't like or am I working with some bad
>assumption?
>
>Thanks in advance for any help,
>
>Joe
>

--
Sent from my Android device with K-9 Mail. Please excuse my brevity.

[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/cabqednxr2bns_rqbc9+55n-j+vd3tab4wfupogcmudptbjk...@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.

Using the when event in a command button

[Joe Yoder]

I have a command button on a form that should not be accessible unless
there is a table selected.  I am attempting to use a expression that will
evaluate to false in the WHEN event when no table is selected:

NOT EMPTY(thisform.combo1.Value)

The message I get is "Error in line 7 of Form1.Command1.When (record 7):
Unrecognized command verb."

Even with a .f. as the expression I get the same message.  Am I giving the
fox something she doesn't like or am I working with some bad assumption?

Thanks in advance for any help,

Joe


--- 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/cabqednwca1yicdu4kmd32qjgkeeayjqzu7ewtmusvab0aj1...@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: Best way to have multiple projects open simultaneously?

[Joe Yoder]

Thanks guys for all the advice!  Ted's warning is good to know -  the
possibility of tangled memo fields resulting from what I anticipate doing
for this project tells me that I will want to use a different approach for
future projects!

I have now successfully opened multiple projects in a single instance of
VFP and started copying click events etc from test code to the actual
project.

Thanks again - Joe

On Fri, Mar 4, 2016 at 6:34 AM, Ted Roche  wrote:

> On Fri, Mar 4, 2016 at 6:06 AM, Dave Crozier  wrote:
> > Also you can, of course, drag and drop from one project to another with
> no problems.. Something "obvious" which is often overlooked!!
> >
>
> You can, though I generally advise against it. There's a bug that pops
> up rarely where two projects, or two forms, or two class libraries
> open at the same time can get their memo fields hopelessly mangled or
> blanked. Your only resort at that point is to find backups.
>
> My advice:
>
> 1. Get your software in source code control, so you have at least one
> source of backup. Hint: source code control is much easier than you
> think. ZIP files are NOT source code control.
>
> 2. Use the file manager to make a new folder with the source you want
> in your project.
>
> 3. Add a MAIN.PRG that points to the resources you need.
>
> 4. Create a new project by BUILD PROJECT FROM MAIN.PRG
>
> 5. If you have resources that aren't pulled in by #4, you need to
> figure out how to make that happen. Hint: EXTERNAL is your friend.
> This is what the command is for.
>
[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/cabqednua2_nyx-wx3p4ow_q0u0b3o+p80duhc3fu5jesf+f...@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.

Best way to have multiple projects open simultaneously?

[Joe Yoder]

I have code in several projects that I want to drop into a new one.  I
assume there is a way to have multiple VFP projects open at the same time,

Multiple instances of foxpro?  Somehow with a single instance?

Also - I have a two monitor setup - is there a way to have each project on
a separate monitor?

Thanks in advance,

Joe


--- 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/cabqednw68hma_psnit-wx5uuu7hcfbyslgeiozd2orf3vkz...@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.

Using an expression for the RowSource of a textbox

[Joe Yoder]

I am almost certain that I have successfully used an expression as the
field to display in a listbox but I can't figure out the syntax I used or
which RowSourceType needs to be selected.  Can someone help me out?

Thanks in advance,

Joe


--- 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/CABQeDnV7SBp2Wz-vmLqPDNsjCj=BEuVdJBOmL4PWz=n8yzq...@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: Suggestions for closing out simple applications?

[Joe Yoder]

Thanks very much Fred and Darren - That makes things much clearer!

On Tue, Mar 1, 2016 at 6:06 PM, Darren <fox...@ozemail.com.au> wrote:

> Also if the two forms are Modal you do not need READ EVENTS or CLEAR
> EVENTS.
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe
> Yoder
> Sent: Wednesday, 2 March 2016 9:49 AM
> To: profoxt...@leafe.com
> Subject: Re: Suggestions for closing out simple applications?
>
> My application is so simple that it has no menu.  Is there an advantage to
> having the clear events in a form rather than directly following the read
> events in the main program?
>
> Also - what am I missing that would allow the command window to become
> active after my forms close or is moving the clear events what needs to
> happen?
>
> Thank you - Joe
> On Mar 1, 2016 5:09 PM, "Fred Taylor" <fbtay...@gmail.com> wrote:
>
> > You don't need a CLEAR EVENTS after your READ EVENTS.  You need to
> > have a CLEAR EVENTS somewhere else in your code (menu option, last
> > form's Destroy method, etc.)  That will cause the main program to pick
> > up after the READ EVENTS and go from there.
> >
> > Fred
> >
> > On Tue, Mar 1, 2016 at 2:43 PM, Joe Yoder <j...@wheypower.com> wrote:
> >
> > > I have never used a framework and often just execute my stuff in the
> > > VFP environment.  When I do an exe for others to use I am never sure
> > > what commands to include to shut things down.  Sometimes I end up
> > > with applications that can't be shut down without killing them in
> > > Task Manager and sometimes I end up with code that forces me to
> > > re-execute "Modify Project" after a run after build.
> > >
> > > My Simple applications has a main.prg that calls a main form which
> > > calls two other modal forms. Each form shuts down with a
> > > thisform.release.  The main.prg file looks like this:
> > >
> > > USE Simple
> > > DO FORM Main
> > > READ events
> > > CLEAR events
> > > CLEAR PROGRAM
> > > RELEASE all
> > >
> > > Right now this setup forces me to goto Program|Cancel before I get
> > > the command window back after a run.
> > >
> > > Some input from a pro would save me a lot of trial and error!
> > >
> > > Thanks in advance,
> > >
> > > Joe
> > >
> > >
> > > --- StripMime Report -- processed MIME parts ---
> > > multipart/alternative
> > >   text/plain (text body -- kept)
> > >   text/html
> > > ---
> > >
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: 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/cabqednxcqy+_ajcfxtqakljovt9qwxppzk+jc3aeptpevam...@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: Suggestions for closing out simple applications?

[Joe Yoder]

My application is so simple that it has no menu.  Is there an advantage to
having the clear events in a form rather than directly following the read
events in the main program?

Also - what am I missing that would allow the command window to become
active after my forms close or is moving the clear events what needs to
happen?

Thank you - Joe
On Mar 1, 2016 5:09 PM, "Fred Taylor" <fbtay...@gmail.com> wrote:

> You don't need a CLEAR EVENTS after your READ EVENTS.  You need to have a
> CLEAR EVENTS somewhere else in your code (menu option, last form's Destroy
> method, etc.)  That will cause the main program to pick up after the READ
> EVENTS and go from there.
>
> Fred
>
> On Tue, Mar 1, 2016 at 2:43 PM, Joe Yoder <j...@wheypower.com> wrote:
>
> > I have never used a framework and often just execute my stuff in the VFP
> > environment.  When I do an exe for others to use I am never sure what
> > commands to include to shut things down.  Sometimes I end up with
> > applications that can't be shut down without killing them in Task Manager
> > and sometimes I end up with code that forces me to re-execute "Modify
> > Project" after a run after build.
> >
> > My Simple applications has a main.prg that calls a main form which calls
> > two other modal forms. Each form shuts down with a thisform.release.  The
> > main.prg file looks like this:
> >
> > USE Simple
> > DO FORM Main
> > READ events
> > CLEAR events
> > CLEAR PROGRAM
> > RELEASE all
> >
> > Right now this setup forces me to goto Program|Cancel before I get the
> > command window back after a run.
> >
> > Some input from a pro would save me a lot of trial and error!
> >
> > Thanks in advance,
> >
> > Joe
> >
> >
> > --- StripMime Report -- processed MIME parts ---
> > multipart/alternative
> >   text/plain (text body -- kept)
> >   text/html
> > ---
> >
[excessive quoting removed by server]

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

Suggestions for closing out simple applications?

[Joe Yoder]

I have never used a framework and often just execute my stuff in the VFP
environment.  When I do an exe for others to use I am never sure what
commands to include to shut things down.  Sometimes I end up with
applications that can't be shut down without killing them in Task Manager
and sometimes I end up with code that forces me to re-execute "Modify
Project" after a run after build.

My Simple applications has a main.prg that calls a main form which calls
two other modal forms. Each form shuts down with a thisform.release.  The
main.prg file looks like this:

USE Simple
DO FORM Main
READ events
CLEAR events
CLEAR PROGRAM
RELEASE all

Right now this setup forces me to goto Program|Cancel before I get the
command window back after a run.

Some input from a pro would save me a lot of trial and error!

Thanks in advance,

Joe


--- 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/CABQeDnVm=CBnd9coHGiVwKOTCZMfUB6=hedumuzde+rhqsd...@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: How to allow multiple forms to update the same record pointer in a table

[Joe Yoder]

Wow!  I guess that aspect should put hair back on my head!

Do I assume correctly that after the form design is complete one can remove
the data environment without causing issues?

On Tue, Mar 1, 2016 at 1:57 PM, Kurt Wendt <kurt_we...@globetax.com> wrote:

> OK - here's one more insight.
>
> I discovered Visual Design via the Data Env. some years ago - and I "fell
> in love" with working that way.
>
> So - if you open a New Form. Then, open the Data Env. as I mentioned. Then
> you Add a Table to the DE. Now you can do visual design. Simply click on a
> field in the Table and drag it onto your Form. Boom - a Text field And a
> Label are created. Now - select a Bunch of fields in the Table in the DE -
> and drag them onto the form and BOOM - you have a Grid!
>
> Fun - Right???
>
> Regards,
> Kurt Wendt
> Consultant
>
>
> Tel. +1-212-747-9100
> www.GlobeTax.com
>
>
> -Original Message-----
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe
> Yoder
> Sent: Tuesday, March 01, 2016 1:30 PM
> To: profoxt...@leafe.com
> Cc: profoxt...@leafe.com
> Subject: Re: How to allow multiple forms to update the same record pointer
> in a table
>
> Bingo - that was it!  I had tried to figure out how to work with the data
> environment setting but never thought about just deleting the entire
> thing.  I'll want to spend some time learning about how the data
> environment can work to my advantage rather than causing additional hair
> loss!
>
> Thanks to all - Joe
>
> On Tue, Mar 1, 2016 at 12:45 PM, Kurt Wendt <kurt_we...@globetax.com>
> wrote:
>
> > Joe - I believe that's your problem - re: " data environment on each
> > form shows only the one table."
> >
> > If you open the form, right click on an Empty space on the form, then
> > select Data Environment. At that point the graphical version of the DE
> > comes up - and you should be able to simply select that Table (the
> > graphical representation of that Table) - and just hit Delete. That
> > should be all there is too it. Then - you would manually open the file
> > in like the Init or Load of the form.  I think that May solve your
> problem...
> >
> > Regards,
> > Kurt Wendt
> > Consultant
> >
> >
> > Tel. +1-212-747-9100
> > www.GlobeTax.com
> >
> >
> > -Original Message-
> > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> > Joe Yoder
> > Sent: Tuesday, March 01, 2016 12:25 PM
> > To: profoxt...@leafe.com
> > Subject: Re: How to allow multiple forms to update the same record
> > pointer in a table
> >
> > The data environment on each form shows only the one table in the system.
> > Apparently this value gets created when the form is created.  I have
> > not figured out a way to delete it.
> >
> > I have the simple demo created and could zip it up to send to whoever
> > is willing to look at it but I am wondering how it would work to share
> > the folder on Google drive with a link embedded in an Email.  Does
> > anyone have experience or an opinion about such an approach? - Joe
> >
> > On Tue, Mar 1, 2016 at 9:06 AM, Kurt Wendt <kurt_we...@globetax.com>
> > wrote:
> >
> > > Joe - I completely agree with you - that it shouldn't be necessary.
> > >
> > > As another WAG - do you have anything in a Data Environment on
> > > either the 1st form - or the 2nd form that is called?
> > >
> > > Regards,
> > > Kurt Wendt
> > > Consultant
> > >
> > >
> > > Tel. +1-212-747-9100
> > > www.GlobeTax.com
> > >
> > >
> > > -Original Message-
> > > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> > > Joe Yoder
> > > Sent: Tuesday, March 01, 2016 7:48 AM
> > > To: profoxt...@leafe.com
> > > Subject: Re: How to allow multiple forms to update the same record
> > > pointer in a table
> > >
> > > Darren and Rafael
> > > <https://plus.google.com/u/0/114211264208955698806?prsrc=4>I was
> > > thinking of passing the record number between forms but understood
> > > that it should not be necessary.  I plan to build a very simple demo
> > > app from scratch.  If that exercise doesn't shake out the problem I
> > > will zip it up and let you have a look.
> > >
> > > Thanks - Joe
> > >
> > > On Tue, Mar 1, 2016 at 2:44 AM, <rcopq...@fibertel.com.ar> wrote:
> > >
> > > > I may be a  little late on t

Re: How to allow multiple forms to update the same record pointer in a table

[Joe Yoder]

Bingo - that was it!  I had tried to figure out how to work with the data
environment setting but never thought about just deleting the entire
thing.  I'll want to spend some time learning about how the data
environment can work to my advantage rather than causing additional hair
loss!

Thanks to all - Joe

On Tue, Mar 1, 2016 at 12:45 PM, Kurt Wendt <kurt_we...@globetax.com> wrote:

> Joe - I believe that's your problem - re: " data environment on each form
> shows only the one table."
>
> If you open the form, right click on an Empty space on the form, then
> select Data Environment. At that point the graphical version of the DE
> comes up - and you should be able to simply select that Table (the
> graphical representation of that Table) - and just hit Delete. That should
> be all there is too it. Then - you would manually open the file in like the
> Init or Load of the form.  I think that May solve your problem...
>
> Regards,
> Kurt Wendt
> Consultant
>
>
> Tel. +1-212-747-9100
> www.GlobeTax.com
>
>
> -Original Message-----
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe
> Yoder
> Sent: Tuesday, March 01, 2016 12:25 PM
> To: profoxt...@leafe.com
> Subject: Re: How to allow multiple forms to update the same record pointer
> in a table
>
> The data environment on each form shows only the one table in the system.
> Apparently this value gets created when the form is created.  I have not
> figured out a way to delete it.
>
> I have the simple demo created and could zip it up to send to whoever is
> willing to look at it but I am wondering how it would work to share the
> folder on Google drive with a link embedded in an Email.  Does anyone have
> experience or an opinion about such an approach? - Joe
>
> On Tue, Mar 1, 2016 at 9:06 AM, Kurt Wendt <kurt_we...@globetax.com>
> wrote:
>
> > Joe - I completely agree with you - that it shouldn't be necessary.
> >
> > As another WAG - do you have anything in a Data Environment on either
> > the 1st form - or the 2nd form that is called?
> >
> > Regards,
> > Kurt Wendt
> > Consultant
> >
> >
> > Tel. +1-212-747-9100
> > www.GlobeTax.com
> >
> >
> > -Original Message-
> > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> > Joe Yoder
> > Sent: Tuesday, March 01, 2016 7:48 AM
> > To: profoxt...@leafe.com
> > Subject: Re: How to allow multiple forms to update the same record
> > pointer in a table
> >
> > Darren and Rafael
> > <https://plus.google.com/u/0/114211264208955698806?prsrc=4>I was
> > thinking of passing the record number between forms but understood
> > that it should not be necessary.  I plan to build a very simple demo
> > app from scratch.  If that exercise doesn't shake out the problem I
> > will zip it up and let you have a look.
> >
> > Thanks - Joe
> >
> > On Tue, Mar 1, 2016 at 2:44 AM, <rcopq...@fibertel.com.ar> wrote:
> >
> > > I may be a  little late on this thread but this is how I do it:
> > > I set a form property in form1 called nRec which captures the
> > > recno() you are positioned in:
> > > thisform.nRec = recno('yourcursor')
> > > you set a new property in that form called nRec_1 When you call form2:
> > > do form2 with thisform.nRec to thisform.nRec_1
> > >
> > > In the init event of form2:
> > > lparameters pnRec
> > > (you also set a property called nRec or whatever you like in form2,
> > > to receive the number of the record in form1) thisform.nRec = pnRec
> > > in the activate event of form2:
> > > select thecursorlocate for recno() = thisform.nRec In this way,
> > > form2 is positioned in the same record you are positioned in
> > > form1
> > > (I assume you examine the record in a grid here)
> > >
> > > in the afterrowcolchange event of the grid thisform.nRec =
> > > recno('thecursor')
> > >
> > > If you were to move the recordpointer in form2, or even if you
> > > weren't, its unload event should have the following code:
> > >
> > > return thisform.nRec
> > > Now, back to form1In its activate event do this:
> > > select yourcursorlocate for recno() = thisform.nRec_1 So now, the
> > > record pointer is in the same record that form2 is in.
> > > In your particular case you might want to add some control property
> > > to avoid error in the activate event of form1, such as:
> > > if (condition)
> > > select yourcursorlocate for recno() = thisform.nRec

Re: How to allow multiple forms to update the same record pointer in a table

[Joe Yoder]

The data environment on each form shows only the one table in the system.
Apparently this value gets created when the form is created.  I have not
figured out a way to delete it.

I have the simple demo created and could zip it up to send to whoever is
willing to look at it but I am wondering how it would work to share the
folder on Google drive with a link embedded in an Email.  Does anyone have
experience or an opinion about such an approach? - Joe

On Tue, Mar 1, 2016 at 9:06 AM, Kurt Wendt <kurt_we...@globetax.com> wrote:

> Joe - I completely agree with you - that it shouldn't be necessary.
>
> As another WAG - do you have anything in a Data Environment on either the
> 1st form - or the 2nd form that is called?
>
> Regards,
> Kurt Wendt
> Consultant
>
>
> Tel. +1-212-747-9100
> www.GlobeTax.com
>
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe
> Yoder
> Sent: Tuesday, March 01, 2016 7:48 AM
> To: profoxt...@leafe.com
> Subject: Re: How to allow multiple forms to update the same record pointer
> in a table
>
> Darren and Rafael
> <https://plus.google.com/u/0/114211264208955698806?prsrc=4>I was thinking
> of passing the record number between forms but understood that it should
> not be necessary.  I plan to build a very simple demo app from scratch.  If
> that exercise doesn't shake out the problem I will zip it up and let you
> have a look.
>
> Thanks - Joe
>
> On Tue, Mar 1, 2016 at 2:44 AM, <rcopq...@fibertel.com.ar> wrote:
>
> > I may be a  little late on this thread but this is how I do it:
> > I set a form property in form1 called nRec which captures the recno()
> > you are positioned in:
> > thisform.nRec = recno('yourcursor')
> > you set a new property in that form called nRec_1 When you call form2:
> > do form2 with thisform.nRec to thisform.nRec_1
> >
> > In the init event of form2:
> > lparameters pnRec
> > (you also set a property called nRec or whatever you like in form2, to
> > receive the number of the record in form1) thisform.nRec = pnRec in
> > the activate event of form2:
> > select thecursorlocate for recno() = thisform.nRec In this way, form2
> > is positioned in the same record you are positioned in
> > form1
> > (I assume you examine the record in a grid here)
> >
> > in the afterrowcolchange event of the grid thisform.nRec =
> > recno('thecursor')
> >
> > If you were to move the recordpointer in form2, or even if you
> > weren't, its unload event should have the following code:
> >
> > return thisform.nRec
> > Now, back to form1In its activate event do this:
> > select yourcursorlocate for recno() = thisform.nRec_1 So now, the
> > record pointer is in the same record that form2 is in.
> > In your particular case you might want to add some control property to
> > avoid error in the activate event of form1, such as:
> > if (condition)
> > select yourcursorlocate for recno() = thisform.nRec_1
> > endif
> > Needless to say that both forms should have private data sessions Hope
> > it helps Rafael Copquin
> >
> >
> > El Martes, 1 de marzo, 2016 3:30:05, Darren
> > <fox...@ozemail.com.au>
> > escribió:
> >
> >
> >  Joe if you want it zip it all up and send it to me I'll have a look
> > see for you.
> >
> > -Original Message-
> > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> > Joe Yoder
> > Sent: Tuesday, 1 March 2016 4:33 PM
> > To: profoxt...@leafe.com
> > Subject: Re: How to allow multiple forms to update the same record
> > pointer in a table
> >
> > I use a test button on the main form to set the record pointer to 25.
> > As soon as I step into either of the Do Form lines the recno() changes
> > back to a red 1 without the watch firing. The debugger shows that it
> > is still in the click method of the command button that did the call.
> >
> > There must be something I as a dabbler am doing differently than
> > experienced developers - what can it be?
> >
> > I have changed everything except the data file I am trying to display
> > and the behavior persists.  Perhaps tomorrow I will use a different
> > data file as well.
> >
> > Thanks to all for the input so far!
> >
> > Joe
> >
> > On Mon, Feb 29, 2016 at 9:21 PM, Darren <fox...@ozemail.com.au> wrote:
> >
> > > Put the SET STEP immediately before the do form.
> > >
> > > Then on the toolbar click on the symbol with the arrow going into
> > > the bracket

Re: How to allow multiple forms to update the same record pointer in a table

[Joe Yoder]

Darren and Rafael
<https://plus.google.com/u/0/114211264208955698806?prsrc=4>I was thinking
of passing the record number between forms but understood that it should
not be necessary.  I plan to build a very simple demo app from scratch.  If
that exercise doesn't shake out the problem I will zip it up and let you
have a look.

Thanks - Joe

On Tue, Mar 1, 2016 at 2:44 AM, <rcopq...@fibertel.com.ar> wrote:

> I may be a  little late on this thread but this is how I do it:
> I set a form property in form1 called nRec which captures the recno() you
> are positioned in:
> thisform.nRec = recno('yourcursor')
> you set a new property in that form called nRec_1
> When you call form2:
> do form2 with thisform.nRec to thisform.nRec_1
>
> In the init event of form2:
> lparameters pnRec
> (you also set a property called nRec or whatever you like in form2, to
> receive the number of the record in form1)
> thisform.nRec = pnRec
> in the activate event of form2:
> select thecursorlocate for recno() = thisform.nRec
> In this way, form2 is positioned in the same record you are positioned in
> form1
> (I assume you examine the record in a grid here)
>
> in the afterrowcolchange event of the grid
> thisform.nRec = recno('thecursor')
>
> If you were to move the recordpointer in form2, or even if you weren't,
> its unload event should have the following code:
>
> return thisform.nRec
> Now, back to form1In its activate event do this:
> select yourcursorlocate for recno() = thisform.nRec_1
> So now, the record pointer is in the same record that form2 is in.
> In your particular case you might want to add some control property to
> avoid error in the activate event of form1, such as:
> if (condition)
> select yourcursorlocate for recno() = thisform.nRec_1
> endif
> Needless to say that both forms should have private data sessions
> Hope it helps
> Rafael Copquin
>
>
> El Martes, 1 de marzo, 2016 3:30:05, Darren <fox...@ozemail.com.au>
> escribió:
>
>
>  Joe if you want it zip it all up and send it to me I'll have a look see
> for
> you.
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe
> Yoder
> Sent: Tuesday, 1 March 2016 4:33 PM
> To: profoxt...@leafe.com
> Subject: Re: How to allow multiple forms to update the same record pointer
> in a table
>
> I use a test button on the main form to set the record pointer to 25.  As
> soon as I step into either of the Do Form lines the recno() changes back to
> a red 1 without the watch firing. The debugger shows that it is still in
> the
> click method of the command button that did the call.
>
> There must be something I as a dabbler am doing differently than
> experienced
> developers - what can it be?
>
> I have changed everything except the data file I am trying to display and
> the behavior persists.  Perhaps tomorrow I will use a different data file
> as
> well.
>
> Thanks to all for the input so far!
>
> Joe
>
> On Mon, Feb 29, 2016 at 9:21 PM, Darren <fox...@ozemail.com.au> wrote:
>
> > Put the SET STEP immediately before the do form.
> >
> > Then on the toolbar click on the symbol with the arrow going into the
> > brackets. Do that repeatedly and you'll go one line at a time. You'll
> > get the idea.
> >
> > -Original Message-
> > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> > Joe Yoder
> > Sent: Tuesday, 1 March 2016 1:15 PM
> > To: profoxt...@leafe.com
> > Subject: Re: How to allow multiple forms to update the same record
> > pointer in a table
> >
> > Thanks to your instructions I have done that and see that the pointer
> > changes as soon as the "do form" line executes.  I haven't figured out
> > how to single step in the called form code. - Joe
> >
> > On Mon, Feb 29, 2016 at 7:59 PM, Darren <fox...@ozemail.com.au> wrote:
> >
> > > One way ...
> > >
> > > SET STEP ON in the code that calls the 2nd form.
> > >
> > > Go into the breakpoints setup.  (Little hand symbol) Add a
> > > breakpoint
> > > - Type = "Break when expression has changed"
> > > In the expression put in RECNO ("") The go back the command
> > > window and type in RESUME.
> > >
> > > Something like that should get you going.
> > >
> > > -Original Message-
> > > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> > > Joe Yoder
> > > Sent: Tuesday, 1 March 2016 11:38 AM
> > > To: profoxt...@leafe.com
> > > Subject: Re: How to al

Re: How to allow multiple forms to update the same record pointer in a table

[Joe Yoder]

I use a test button on the main form to set the record pointer to 25.  As
soon as I step into either of the Do Form lines the recno() changes back to
a red 1 without the watch firing. The debugger shows that it is still in
the click method of the command button that did the call.

There must be something I as a dabbler am doing differently than
experienced developers - what can it be?

I have changed everything except the data file I am trying to display and
the behavior persists.  Perhaps tomorrow I will use a different data file
as well.

Thanks to all for the input so far!

Joe

On Mon, Feb 29, 2016 at 9:21 PM, Darren <fox...@ozemail.com.au> wrote:

> Put the SET STEP immediately before the do form.
>
> Then on the toolbar click on the symbol with the arrow going into the
> brackets. Do that repeatedly and you'll go one line at a time. You'll get
> the idea.
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe
> Yoder
> Sent: Tuesday, 1 March 2016 1:15 PM
> To: profoxt...@leafe.com
> Subject: Re: How to allow multiple forms to update the same record pointer
> in a table
>
> Thanks to your instructions I have done that and see that the pointer
> changes as soon as the "do form" line executes.  I haven't figured out how
> to single step in the called form code. - Joe
>
> On Mon, Feb 29, 2016 at 7:59 PM, Darren <fox...@ozemail.com.au> wrote:
>
> > One way ...
> >
> > SET STEP ON in the code that calls the 2nd form.
> >
> > Go into the breakpoints setup.  (Little hand symbol) Add a breakpoint
> > - Type = "Break when expression has changed"
> > In the expression put in RECNO ("") The go back the command
> > window and type in RESUME.
> >
> > Something like that should get you going.
> >
> > -Original Message-
> > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> > Joe Yoder
> > Sent: Tuesday, 1 March 2016 11:38 AM
> > To: profoxt...@leafe.com
> > Subject: Re: How to allow multiple forms to update the same record
> > pointer in a table
> >
> > I'm afraid I have forgotten the little I knew about setpoints and
> > stepping in the debugger.  I guess I need to read up on that. - Joe
> >
> > On Mon, Feb 29, 2016 at 7:36 PM, Joe Yoder <j...@wheypower.com> wrote:
> >
> > > Thanks for the idea Kurt but that was one of the first things I
> checked.
> > >
> > > I have now determined that any form I call from the main form will
> > > always start at record 1 even if the record pointer is at a
> > > different value just before the call.  If the called form changes
> > > the record pointer the pointer value will persist after the form
> > > closes.  I have added a button to simply browse the table from the
> > > main form.  That action respects the value of the pointer on entry
> > > and leaves the pointer
> > in the proper place on exit.
> > >
> > > There must be something about the forms I am using that causes this
> > > problem.  I've been looking at the scx files and see that there is a
> > > some information about a cursor there.  Is there a setting I need to
> > > change to get the behaviour I need?  (I have done a test project
> > > where there is only one table and the behavior continues.)
> > >
> > > Thanks for any ideas,
> > >
> > > Joe
> > >
> > > On Mon, Feb 29, 2016 at 11:31 AM, Kurt Wendt
> > > <kurt_we...@globetax.com>
> > > wrote:
> > >
> > >> Just a WAG - but, what is your DataSession property value for the
> > >> Form? I think it should be set to "1-Default Data Session". That
> > >> may be your problem if it says Private!
> > >>
> > >> Regards,
> > >> Kurt Wendt
> > >> Consultant
> > >>
> > >>
> > >> Tel. +1-212-747-9100
> > >> www.GlobeTax.com
> > >>
> > >>
> > >> -Original Message-
> > >> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> > >> Joe Yoder
> > >> Sent: Monday, February 29, 2016 10:22 AM
> > >> To: profoxt...@leafe.com
> > >> Subject: Re: How to allow multiple forms to update the same record
> > >> pointer in a table
> > >>
> > >> Thanks Kurt - your understanding is correct.
> > >>
> > >> I have pinned down the problem to the detail form.  When I call it
> > >> something changes the record poi

Re: How to allow multiple forms to update the same record pointer in a table

[Joe Yoder]

Thanks to your instructions I have done that and see that the pointer
changes as soon as the "do form" line executes.  I haven't figured out how
to single step in the called form code. - Joe

On Mon, Feb 29, 2016 at 7:59 PM, Darren <fox...@ozemail.com.au> wrote:

> One way ...
>
> SET STEP ON in the code that calls the 2nd form.
>
> Go into the breakpoints setup.  (Little hand symbol)
> Add a breakpoint - Type = "Break when expression has changed"
> In the expression put in RECNO ("")
> The go back the command window and type in RESUME.
>
> Something like that should get you going.
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe
> Yoder
> Sent: Tuesday, 1 March 2016 11:38 AM
> To: profoxt...@leafe.com
> Subject: Re: How to allow multiple forms to update the same record pointer
> in a table
>
> I'm afraid I have forgotten the little I knew about setpoints and stepping
> in the debugger.  I guess I need to read up on that. - Joe
>
> On Mon, Feb 29, 2016 at 7:36 PM, Joe Yoder <j...@wheypower.com> wrote:
>
> > Thanks for the idea Kurt but that was one of the first things I checked.
> >
> > I have now determined that any form I call from the main form will
> > always start at record 1 even if the record pointer is at a different
> > value just before the call.  If the called form changes the record
> > pointer the pointer value will persist after the form closes.  I have
> > added a button to simply browse the table from the main form.  That
> > action respects the value of the pointer on entry and leaves the pointer
> in the proper place on exit.
> >
> > There must be something about the forms I am using that causes this
> > problem.  I've been looking at the scx files and see that there is a
> > some information about a cursor there.  Is there a setting I need to
> > change to get the behaviour I need?  (I have done a test project where
> > there is only one table and the behavior continues.)
> >
> > Thanks for any ideas,
> >
> > Joe
> >
> > On Mon, Feb 29, 2016 at 11:31 AM, Kurt Wendt <kurt_we...@globetax.com>
> > wrote:
> >
> >> Just a WAG - but, what is your DataSession property value for the
> >> Form? I think it should be set to "1-Default Data Session". That may
> >> be your problem if it says Private!
> >>
> >> Regards,
> >> Kurt Wendt
> >> Consultant
> >>
> >>
> >> Tel. +1-212-747-9100
> >> www.GlobeTax.com
> >>
> >>
> >> -Original Message-
> >> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> >> Joe Yoder
> >> Sent: Monday, February 29, 2016 10:22 AM
> >> To: profoxt...@leafe.com
> >> Subject: Re: How to allow multiple forms to update the same record
> >> pointer in a table
> >>
> >> Thanks Kurt - your understanding is correct.
> >>
> >> I have pinned down the problem to the detail form.  When I call it
> >> something changes the record pointer to the first record.  When the
> >> calling form gets control back the record pointer is where the detail
> form left it.
> >>
> >>
> >> I have not been able to find any reason for this but wonder if it is
> >> related to the fact that the form was first created using the form
> wizard.
> >> I had grief with changing the table alias with that form so I opened
> >> a new form and copied the complete layout.  That took care of table
> >> name but perhaps there is an "unwanted feature" still in place from
> >> its former life as a wizard created form.  I'd rather not do the
> >> tedious work of regenerating the form - any ideas?
> >>
> >> Thank you,
> >>
> >> Joe
> >>
> >> On Mon, Feb 29, 2016 at 9:21 AM, Kurt Wendt <kurt_we...@globetax.com>
> >> wrote:
> >>
> >> > Fernando - that's just the opposite of what Joe wants. He indeed
> >> > wants Both forms to be looking at the same records - such that if
> >> > he brings up the 2nd form - and Changes to a different record -
> >> > then upon returning back to 1st form - it should now be looking at
> >> > the Same record that Form2 was pointing to!
> >> >
> >> > Regards,
> >> > Kurt Wendt
> >> > Consultant
> >> >
> >> >
> >> > Tel. +1-212-747-9100
> >> > www.GlobeTax.com
> >> >
> >> >
> >&g

Re: How to allow multiple forms to update the same record pointer in a table

[Joe Yoder]

I'm afraid I have forgotten the little I knew about setpoints and stepping
in the debugger.  I guess I need to read up on that. - Joe

On Mon, Feb 29, 2016 at 7:36 PM, Joe Yoder <j...@wheypower.com> wrote:

> Thanks for the idea Kurt but that was one of the first things I checked.
>
> I have now determined that any form I call from the main form will always
> start at record 1 even if the record pointer is at a different value just
> before the call.  If the called form changes the record pointer the pointer
> value will persist after the form closes.  I have added a button to simply
> browse the table from the main form.  That action respects the value of the
> pointer on entry and leaves the pointer in the proper place on exit.
>
> There must be something about the forms I am using that causes this
> problem.  I've been looking at the scx files and see that there is a some
> information about a cursor there.  Is there a setting I need to change to
> get the behaviour I need?  (I have done a test project where there is only
> one table and the behavior continues.)
>
> Thanks for any ideas,
>
> Joe
>
> On Mon, Feb 29, 2016 at 11:31 AM, Kurt Wendt <kurt_we...@globetax.com>
> wrote:
>
>> Just a WAG - but, what is your DataSession property value for the Form? I
>> think it should be set to "1-Default Data Session". That may be your
>> problem if it says Private!
>>
>> Regards,
>> Kurt Wendt
>> Consultant
>>
>>
>> Tel. +1-212-747-9100
>> www.GlobeTax.com
>>
>>
>> -Original Message-
>> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe
>> Yoder
>> Sent: Monday, February 29, 2016 10:22 AM
>> To: profoxt...@leafe.com
>> Subject: Re: How to allow multiple forms to update the same record
>> pointer in a table
>>
>> Thanks Kurt - your understanding is correct.
>>
>> I have pinned down the problem to the detail form.  When I call it
>> something changes the record pointer to the first record.  When the calling
>> form gets control back the record pointer is where the detail form left it.
>>
>>
>> I have not been able to find any reason for this but wonder if it is
>> related to the fact that the form was first created using the form wizard.
>> I had grief with changing the table alias with that form so I opened a
>> new form and copied the complete layout.  That took care of table name but
>> perhaps there is an "unwanted feature" still in place from its former life
>> as a wizard created form.  I'd rather not do the tedious work of
>> regenerating the form - any ideas?
>>
>> Thank you,
>>
>> Joe
>>
>> On Mon, Feb 29, 2016 at 9:21 AM, Kurt Wendt <kurt_we...@globetax.com>
>> wrote:
>>
>> > Fernando - that's just the opposite of what Joe wants. He indeed wants
>> > Both forms to be looking at the same records - such that if he brings
>> > up the 2nd form - and Changes to a different record - then upon
>> > returning back to 1st form - it should now be looking at the Same
>> > record that Form2 was pointing to!
>> >
>> > Regards,
>> > Kurt Wendt
>> > Consultant
>> >
>> >
>> > Tel. +1-212-747-9100
>> > www.GlobeTax.com
>> >
>> >
>> > -Original Message-
>> > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
>> > Fernando D. Bozzo
>> > Sent: Monday, February 29, 2016 1:16 AM
>> > To: profoxt...@leafe.com
>> > Subject: Re: How to allow multiple forms to update the same record
>> > pointer in a table
>> >
>> > Hello joe:
>> >
>> > You may need to use private session en form 2 or on both, so record
>> > pointers do not interfere between forms.
>> >
>> >
>> > --- 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/cabqednwoax1gu_5bpehwdnvjjbt86dwh5swfst7_l3vrwgp...@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: How to allow multiple forms to update the same record pointer in a table

[Joe Yoder]

Thanks for the idea Kurt but that was one of the first things I checked.

I have now determined that any form I call from the main form will always
start at record 1 even if the record pointer is at a different value just
before the call.  If the called form changes the record pointer the pointer
value will persist after the form closes.  I have added a button to simply
browse the table from the main form.  That action respects the value of the
pointer on entry and leaves the pointer in the proper place on exit.

There must be something about the forms I am using that causes this
problem.  I've been looking at the scx files and see that there is a some
information about a cursor there.  Is there a setting I need to change to
get the behaviour I need?  (I have done a test project where there is only
one table and the behavior continues.)

Thanks for any ideas,

Joe

On Mon, Feb 29, 2016 at 11:31 AM, Kurt Wendt <kurt_we...@globetax.com>
wrote:

> Just a WAG - but, what is your DataSession property value for the Form? I
> think it should be set to "1-Default Data Session". That may be your
> problem if it says Private!
>
> Regards,
> Kurt Wendt
> Consultant
>
>
> Tel. +1-212-747-9100
> www.GlobeTax.com
>
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe
> Yoder
> Sent: Monday, February 29, 2016 10:22 AM
> To: profoxt...@leafe.com
> Subject: Re: How to allow multiple forms to update the same record pointer
> in a table
>
> Thanks Kurt - your understanding is correct.
>
> I have pinned down the problem to the detail form.  When I call it
> something changes the record pointer to the first record.  When the calling
> form gets control back the record pointer is where the detail form left it.
>
>
> I have not been able to find any reason for this but wonder if it is
> related to the fact that the form was first created using the form wizard.
> I had grief with changing the table alias with that form so I opened a new
> form and copied the complete layout.  That took care of table name but
> perhaps there is an "unwanted feature" still in place from its former life
> as a wizard created form.  I'd rather not do the tedious work of
> regenerating the form - any ideas?
>
> Thank you,
>
> Joe
>
> On Mon, Feb 29, 2016 at 9:21 AM, Kurt Wendt <kurt_we...@globetax.com>
> wrote:
>
> > Fernando - that's just the opposite of what Joe wants. He indeed wants
> > Both forms to be looking at the same records - such that if he brings
> > up the 2nd form - and Changes to a different record - then upon
> > returning back to 1st form - it should now be looking at the Same
> > record that Form2 was pointing to!
> >
> > Regards,
> > Kurt Wendt
> > Consultant
> >
> >
> > Tel. +1-212-747-9100
> > www.GlobeTax.com
> >
> >
> > -Original Message-
> > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> > Fernando D. Bozzo
> > Sent: Monday, February 29, 2016 1:16 AM
> > To: profoxt...@leafe.com
> > Subject: Re: How to allow multiple forms to update the same record
> > pointer in a table
> >
> > Hello joe:
> >
> > You may need to use private session en form 2 or on both, so record
> > pointers do not interfere between forms.
> >
> >
> > --- 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/CABQeDnUXsbd=979rhaw4ttjeqmef0st0nbzxfgxkq3mqqtg...@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: How to allow multiple forms to update the same record pointer in a table

[Joe Yoder]

Thanks Kurt - your understanding is correct.

I have pinned down the problem to the detail form.  When I call it
something changes the record pointer to the first record.  When the calling
form gets control back the record pointer is where the detail form left it.


I have not been able to find any reason for this but wonder if it is
related to the fact that the form was first created using the form wizard.
I had grief with changing the table alias with that form so I opened a new
form and copied the complete layout.  That took care of table name but
perhaps there is an "unwanted feature" still in place from its former life
as a wizard created form.  I'd rather not do the tedious work of
regenerating the form - any ideas?

Thank you,

Joe

On Mon, Feb 29, 2016 at 9:21 AM, Kurt Wendt  wrote:

> Fernando - that's just the opposite of what Joe wants. He indeed wants
> Both forms to be looking at the same records - such that if he brings up
> the 2nd form - and Changes to a different record - then upon returning back
> to 1st form - it should now be looking at the Same record that Form2 was
> pointing to!
>
> Regards,
> Kurt Wendt
> Consultant
>
>
> Tel. +1-212-747-9100
> www.GlobeTax.com
>
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> Fernando D. Bozzo
> Sent: Monday, February 29, 2016 1:16 AM
> To: profoxt...@leafe.com
> Subject: Re: How to allow multiple forms to update the same record pointer
> in a table
>
> Hello joe:
>
> You may need to use private session en form 2 or on both, so record
> pointers do not interfere between forms.
>
>
> --- 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/cabqednuqbz4g2f7wkcdq021cjebvimw2njqryte70xo0thc...@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: Import/Export with CSV

[Joe Yoder]

Depending on what you are doing with the data you could consider editing
the CSV with notepad.  That would avoid Excels assumptions. - Joe

On Sun, Feb 28, 2016 at 7:30 PM, Darren <fox...@ozemail.com.au> wrote:

> Seems like excel is treating what looks like a number as number and
> discarding insignificant digits.
>
> Have you tried importing the CSV and specifying the data type for each
> column ? e.g Text import Wizard.
>
>
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Sytze
> de
> Boer
> Sent: Monday, 29 February 2016 11:20 AM
> To: profoxt...@leafe.com
> Subject: Re: Import/Export with CSV
>
> The Supplier code could be letters and number, just letters, or just
> numbers.
>
> The supplier code may be 12345.1234567890 It's nothing to do with decimal
> point. It's a character.
> If the code is ABC12345.1234567890 all is fine.
>
> The import routine is append from file IMPFILE type csv
>
>
>
> On Mon, Feb 29, 2016 at 1:15 PM, Joe Yoder <j...@wheypower.com> wrote:
>
> > I only dabble with Excel but I suspect that you can get your expected
> > results by setting it up to use five decimal places instead of two.  I
> > thought you could convert it in Foxpro with str(val( '12345.56'), 10,
> > 5) but for some reason that only gives 4 decimal places even with
> > decimals set to 6.  I guess that leaves string manipulation where you
> > find the location of the dot from the right edge of the trimed string
> > with the RAT function and add as many zero as you need.
> >
> > I'm curious why the extra zeros are important.
> >
> > Joe
> >
> > On Sun, Feb 28, 2016 at 6:36 PM, Sytze de Boer <sytze.k...@gmail.com>
> > wrote:
> >
> > > I have a problem and I hope someone can help
> > >
> > > I export 3 fields to a CSV file
> > > Code C(15), price N(10,2) , supcode C(30)
> > >
> > > The code and the supcode may be pure numbers Example supcode may be
> > > 12345.56000
> > >
> > > I make some changes to the price (using Excel) I now import from
> > > this same file and the supcode has changed to 12345.56
> > >
> > > Whats the best way to overcome this?
> > >
> > > --
> > > Kind regards,
> > > Sytze de Boer
> > >
> > >
> > > --- 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/cabqednwh34lut_ytn6z-tf5bno7d_+bqvewkkfezz2kqpuu...@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: How to allow multiple forms to update the same record pointer in a table

[Joe Yoder]

That all makes sense.  I added wait window alias() and wait window select()
statements in debug buttons on the forms.  They all agree that the same
table is selected in the same work area but the detail always comes up on
record one and the calling form refreshes back to the same record it was on
when the detail form was called. What else could I be overlooking?

Thanks,

Joe

On Sun, Feb 28, 2016 at 7:43 PM, Darren <fox...@ozemail.com.au> wrote:

> Assume : Using the same table / alias / workarea.
>
> Moving record in one form will move in the other form.
>
> I'm assuming you want first form to reflect the move in the second then
> you'll need to refresh that first form when you move record pointer on
> second form.
>
>
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe
> Yoder
> Sent: Monday, 29 February 2016 11:33 AM
> To: profoxt...@leafe.com
> Subject: How to allow multiple forms to update the same record pointer in a
> table
>
> I have a form that displays basic information from a table in a list box
> with its row source as table fields.  When the user clicks a record in the
> list box another form comes up with complete detail for the selected record
> displayed in text boxes with the table fields as their control source.  The
> detail screen allows previous and next choices that move the record
> pointer.
> There is also an exit button to return to the previous screen.
>
> Both forms are modal and use the default data session
>
> What do I need to do to have both screens use the same record pointer?
> Surely I don't need to pass a record number between screens?
>
> Thanks in advance,
>
> Joe
>
>
> --- StripMime Report -- processed MIME parts --- multipart/alternative
>   text/plain (text body -- kept)
>   text/html
> ---
>
[excessive quoting removed by server]

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

How to allow multiple forms to update the same record pointer in a table

[Joe Yoder]

I have a form that displays basic information from a table in a list box
with its row source as table fields.  When the user clicks a record in the
list box another form comes up with complete detail for the selected record
displayed in text boxes with the table fields as their control source.  The
detail screen allows previous and next choices that move the record
pointer.  There is also an exit button to return to the previous screen.

Both forms are modal and use the default data session

What do I need to do to have both screens use the same record pointer?
Surely I don't need to pass a record number between screens?

Thanks in advance,

Joe


--- 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/cabqednwgy55ecfwokzhanxqheqkcke6dvpef+bdwbzdfhyg...@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: Import/Export with CSV

[Joe Yoder]

I only dabble with Excel but I suspect that you can get your expected
results by setting it up to use five decimal places instead of two.  I
thought you could convert it in Foxpro with str(val( '12345.56'), 10, 5)
but for some reason that only gives 4 decimal places even with decimals set
to 6.  I guess that leaves string manipulation where you find the location
of the dot from the right edge of the trimed string with the RAT function
and add as many zero as you need.

I'm curious why the extra zeros are important.

Joe

On Sun, Feb 28, 2016 at 6:36 PM, Sytze de Boer  wrote:

> I have a problem and I hope someone can help
>
> I export 3 fields to a CSV file
> Code C(15), price N(10,2) , supcode C(30)
>
> The code and the supcode may be pure numbers
> Example supcode may be 12345.56000
>
> I make some changes to the price (using Excel)
> I now import from this same file and the supcode has changed to 12345.56
>
> Whats the best way to overcome this?
>
> --
> Kind regards,
> Sytze de Boer
>
>
> --- 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/cabqednxphah_zgp+cmmh5tpop9xxrmj2cxifguzbcmh6bbr...@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.