RE: It's been a long time...

2024-07-23 Thread Tracy Pearson
We appreciate you stepping in and making this happen. 
I have been blessed with this resource and feel like I have contributed to
others.

Thank you!

Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ed Leafe
Sent: Tuesday, July 23, 2024 11:23 AM
To: profoxt...@leafe.com
Subject: Re: It's been a long time...

On Jul 22, 2024, at 21:45, Kurt Wendt  wrote:
> 
> Yo Ed -- Long Live the Realm of the ProFox World!!!

Just checked the database behind the archives, and there have been 393,559
messages to ProFox(Tech) over the years.

Well, after this message, make that 393,560.


-- 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/00af01dadd16$8958fb20$9c0af160$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: OS(3) number result for Windows 11

2024-07-18 Thread Tracy Pearson
If you start a Command Prompt in Windows, it usually tells you what the
version is as it enters.
This is the same version information that VFP Advanced is returning. 

Microsoft Windows [Version 10.0.22631.3880]
(c) Microsoft Corporation. All rights reserved.

And this is on a Windows 10 system I have
Microsoft Windows [Version 10.0.19045.4651]
(c) Microsoft Corporation. All rights reserved.


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Philip
Borkholder
Sent: Thursday, July 18, 2024 5:53 PM
To: profoxt...@leafe.com
Subject: RE: OS(3) number result for Windows 11

Interesting...
Thanks

-- Original Message --
From: "Tracy Pearson" 
To: profoxt...@leafe.com
Subject: RE: OS(3) number result for Windows 11
Date: Thu, 18 Jul 2024 17:50:23 -0400

In VFP Advance on Windows 11 Pro Version 23H2:
1 - Windows 10.00
2 - 
3 - 10
4 - 0
5 - 22631
6 - 2
7 - 
8 - 0
9 - 0
10 - 256
11 - 1

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard
Kaye
Sent: Thursday, July 18, 2024 5:14 PM
To: profoxt...@leafe.com
Subject: RE: OS(3) number result for Windows 11

End of my day and I'm easily distracted.

1 - Windows 6.02
2 - 
3 - 6
4 - 2
5 - 9200
6 - 2
7 - 
8 - 0
9 - 0
10 - 256
11 - 1

ACTIVATE SCREEN 
CLEAR
lcresult=[]
FOR xx=1 TO 11
lcResult = lcResult + TRANSFORM(xx)+[ -
]+TRANSFORM(OS(xx))+CHR(13)+CHR(10) 
NEXT 
_cliptext = lcresult


--

rk

From: ProfoxTech  On Behalf Of Philip
Borkholder
Sent: Thursday, July 18, 2024 4:28 PM
To: profoxt...@leafe.com
Subject: OS(3) number result for Windows 11

Hello all,
Could someone with Windows 11 run :
? OS(3) 

To tell me what the number is?
Windows 10 is 6

Thank you
Philip Borkholder
Vicksburg, MI

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/007e01dad95f$452d05f0$cf8711d0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: OS(3) number result for Windows 11

2024-07-18 Thread Tracy Pearson
In VFP Advance on Windows 11 Pro Version 23H2:
1 - Windows 10.00
2 - 
3 - 10
4 - 0
5 - 22631
6 - 2
7 - 
8 - 0
9 - 0
10 - 256
11 - 1

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard
Kaye
Sent: Thursday, July 18, 2024 5:14 PM
To: profoxt...@leafe.com
Subject: RE: OS(3) number result for Windows 11

End of my day and I'm easily distracted.

1 - Windows 6.02
2 - 
3 - 6
4 - 2
5 - 9200
6 - 2
7 - 
8 - 0
9 - 0
10 - 256
11 - 1

ACTIVATE SCREEN 
CLEAR
lcresult=[]
FOR xx=1 TO 11
lcResult = lcResult + TRANSFORM(xx)+[ -
]+TRANSFORM(OS(xx))+CHR(13)+CHR(10) 
NEXT 
_cliptext = lcresult


--

rk

From: ProfoxTech  On Behalf Of Philip
Borkholder
Sent: Thursday, July 18, 2024 4:28 PM
To: profoxt...@leafe.com
Subject: OS(3) number result for Windows 11

Hello all,
Could someone with Windows 11 run :
? OS(3) 

To tell me what the number is?
Windows 10 is 6

Thank you
Philip Borkholder
Vicksburg, MI

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/007d01dad95c$7e145010$7a3cf030$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Southwest Fox 2024: in-person, in jeopardy

2024-07-12 Thread Tracy Pearson
I prefer the in person conferences. This year the conference is earlier than
usual and conflict with a family obligation. 

If you can attend in person, please do, the conversations at the meals and
evenings are worth the money and time you spend.

Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Rick
Schummer
Sent: Tuesday, July 09, 2024 1:29 AM
To: profoxt...@leafe.com
Subject: Southwest Fox 2024: in-person, in jeopardy

We really want to have an in-person conference. We love the chance to see
members of our community face-to-face and
interact both during conference hours and outside them. If that matters to
you, we need you to show up this year.
Without at least 15 more in-person registrations by July 26, we will have to
switch to an all-virtual conference, and we
won't be planning any future in-person events. For those signed up for the
in-person conference, do not make plane
reservations until we announce the decision for the in-person conference,
which we expect to make soon after July 26th.

We extended the Super-Saver rate through the end-of-the-day Tuesday, July 9,
2024 as an added incentive.

The conference takes place September 26-29, 2024 in Scottsdale, Arizona and
we really hope you can be there. Head over
to the registration Web site today: https://geekgatherings.com/Registration

Contact Us: 
* Interested in being a sponsor? Contact our sponsor representative:
spons...@geekgatherings.com 
* If you have ideas or suggestions for this year's Southwest Fox, please
email them to: i...@geekgatherings.com
* If you have a friend who wants to be on our mailing list, please tell them
to go to the conference home page and sign
up https://swfox.net.
* Call: 586.254.2530

Rick
White Light Computing, Inc.




[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/003201dad472$cbfda950$63f8fbf0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Class code issue

2024-07-11 Thread Tracy Pearson

Should I be able to run code that I copy from the View Code button in Class
Designer?  Would posting it here let others help determine whether my
errors are a result of a corrupted system or my own bugs?


I usually have not been able to get that code to run the first time. Especially 
if it contains a subclass that isn't referenced.

Posting that code here could help, it could also distract from the actual 
problem.

When you need to share forms and class libraries, sharing sample code in a 
public source control system like a github repository may be the easiest.

Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe Yoder
Sent: Thursday, July 11, 2024 9:16 AM
To: profoxt...@leafe.com
Subject: Re: Class code issue

Thanks Tracy - very helpful as usual!
Essentially to make my code work you added the objects to the container and
then configured them instead of trying to configure them before adding them
to the container.  Your solution is so much more elegant!

Now some additional questions:

Is it essential to have a separate method to Add Controls or can it be done
in the Init method? (The separate method in the original code was added to
try to eliminate the error.)

Should I be able to run code that I copy from the View Code button in Class
Designer?  Would posting it here let others help determine whether my
errors are a result of a corrupted system or my own bugs?

Thanks in advance,
Joe

On Wed, Jul 10, 2024 at 11:43 PM Tracy Pearson 
wrote:

> Hi Joe,
>
> VFP isn't able to add an existing object to the form to be displayed.
> It instantiates an object on the form with the AddObject or NewObject
> commands.
> When you add an object this way it will not display until you set the
> Visible property.
>
> I have two examples below.
>
> Here is how that code could be written:
> * Create a blank form
> loMyForm = CREATEOBJECT("Form")
>
> MESSAGEBOX("Form created successfully")
>
>
> * Add the spotpick1 to the form
> loMyForm.AddObject("SpotPick1", "spotpick1")
> loMyForm.SpotPick1.Visible = .T.
>
> * Show the form, in a Modal state
> loMyForm.Show(1)
>
> RETURN
>
> DEFINE CLASS spotpick1 AS container
> WIDTH = 100
>
> PROCEDURE Init
> * Add your custom logic here (e.g., create controls, set
> properties)
> THIS.AddControls()
> ENDPROC
>
> PROCEDURE AddControls
> * Add a textbox to the container
> THIS.AddObject("Textbox1", "TextBox")
> THIS.Textbox1.Value = "Hello from TextBox 1"
> THIS.TextBox1.Visible = .T.
> * Add a second textbox to the container
> THIS.AddObject("Textbox2", "TextBox")
> THIS.Textbox2.Value = "Hello from TextBox 2"
> THIS.TextBox2.Visible = .T.
> THIS.Textbox2.Top = 30
> ENDPROC
> ENDDEFINE
>
> Here is an example of defining the classes in a prg and using it in a form
> class two ways
>
> * Create class form
> loMyForm = CREATEOBJECT("FormClass")
>
> * Show the form
> loMyForm.Show()
>
> RETURN
>
> * Define the customized container
> DEFINE CLASS spotpick1 AS container
> WIDTH = 200
> ADD OBJECT Textbox1 as TextBox WITH Value = "Hello from TextBox 1",
> Width = 200
> ADD OBJECT Textbox2 as TextBox WITH Value = "Hello from TextBox 2",
> Width = 200, Top = 30
>
> ENDDEFINE
>
>
> * define the customized form
> DEFINE CLASS formclass as Form
>WindowType = 1
>
>ADD OBJECT spotpick1 as spotpick1
>
>PROCEDURE init
>   This.AddSecondContainer()
>ENDPROC
>
>PROCEDURE AddSecondContainer
>   This.AddObject("spotpick2", "spotpick1")
>   This.spotpick2.top = 100
>   This.spotpick2.visible = .T.
>ENDPROC
> ENDDEFINE
>
> HTH,
> Tracy
>
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe
> Yoder
> Sent: Wednesday, July 10, 2024 10:02 PM
> To: profoxt...@leafe.com
> Subject: Class code issue
>
> I am developed a custom class based on a container that worked properly
> when it was on a form but when I converted it to a class I have issues I
> can't resolve.  I have only one installation of VFP and sometimes I wonder
> if it might be corrupt.
>
> In order to avoid any corruption of the visual tools I have attempted to
> come up with a small .prg program that c

RE: Class code issue

2024-07-10 Thread Tracy Pearson
Hi Joe,

VFP isn't able to add an existing object to the form to be displayed. 
It instantiates an object on the form with the AddObject or NewObject
commands.
When you add an object this way it will not display until you set the
Visible property.

I have two examples below.

Here is how that code could be written:
* Create a blank form
loMyForm = CREATEOBJECT("Form")

MESSAGEBOX("Form created successfully")


* Add the spotpick1 to the form
loMyForm.AddObject("SpotPick1", "spotpick1")
loMyForm.SpotPick1.Visible = .T.

* Show the form, in a Modal state
loMyForm.Show(1)

RETURN

DEFINE CLASS spotpick1 AS container
WIDTH = 100

PROCEDURE Init
* Add your custom logic here (e.g., create controls, set
properties)
THIS.AddControls()
ENDPROC

PROCEDURE AddControls
* Add a textbox to the container
THIS.AddObject("Textbox1", "TextBox")  
THIS.Textbox1.Value = "Hello from TextBox 1"
THIS.TextBox1.Visible = .T.
* Add a second textbox to the container
THIS.AddObject("Textbox2", "TextBox")  
THIS.Textbox2.Value = "Hello from TextBox 2"
THIS.TextBox2.Visible = .T.
THIS.Textbox2.Top = 30
ENDPROC
ENDDEFINE

Here is an example of defining the classes in a prg and using it in a form
class two ways

* Create class form
loMyForm = CREATEOBJECT("FormClass")

* Show the form
loMyForm.Show()

RETURN

* Define the customized container
DEFINE CLASS spotpick1 AS container
WIDTH = 200
ADD OBJECT Textbox1 as TextBox WITH Value = "Hello from TextBox 1",
Width = 200
ADD OBJECT Textbox2 as TextBox WITH Value = "Hello from TextBox 2",
Width = 200, Top = 30

ENDDEFINE


* define the customized form
DEFINE CLASS formclass as Form
   WindowType = 1
   
   ADD OBJECT spotpick1 as spotpick1
   
   PROCEDURE init
  This.AddSecondContainer()
   ENDPROC 
   
   PROCEDURE AddSecondContainer
  This.AddObject("spotpick2", "spotpick1")
  This.spotpick2.top = 100
  This.spotpick2.visible = .T.
   ENDPROC 
ENDDEFINE

HTH,
Tracy


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe
Yoder
Sent: Wednesday, July 10, 2024 10:02 PM
To: profoxt...@leafe.com
Subject: Class code issue

I am developed a custom class based on a container that worked properly
when it was on a form but when I converted it to a class I have issues I
can't resolve.  I have only one installation of VFP and sometimes I wonder
if it might be corrupt.

In order to avoid any corruption of the visual tools I have attempted to
come up with a small .prg program that creates a form, defines a custom
class in code, and puts an instance of the class on the form.
,The following code was written by Microsoft's CoPilot but the author has
not been able to make it work!
The problem seems to be that the definition code needs to reference the
class before it is instantiated.

* Create a blank form
loMyForm = CREATEOBJECT("Form")

MESSAGEBOX("Form created successfully")

* Create an instance of your spotpick1 class
loSpotPick1 = CREATEOBJECT("spotpick1")

MESSAGEBOX("Class created successfully")

* Add the spotpick1 to the form
loMyForm.AddObject("SpotPick1", loSpotPick1)

* Show the form
loMyForm.Show()

RETURN

DEFINE CLASS spotpick1 AS container
PROCEDURE Init
* Add your custom logic here (e.g., create controls, set properties)
THIS.AddControls()
ENDPROC

PROCEDURE AddControls
LOCAL oTextbox1, oTextbox2
oTextbox1 = CREATEOBJECT("TextBox")
oTextbox2 = CREATEOBJECT("TextBox")
oTextbox1.Value = "Hello from TextBox 1"
oTextbox2.Value = "Hello from TextBox 2"
THIS.AddObject("Textbox1", oTextbox1)  && Errors here
THIS.AddObject("Textbox2", oTextbox2)  && Errors here
ENDPROC
ENDDEFINE

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: 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/001201dad344$6f844ff0$4e8cefd0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Combo box issues

2024-06-27 Thread Tracy Pearson
Hi Joe,

Here are some examples using different controls sources. 
There is also the Sorted property that can be used.
The Sorted property is only available if the RowSourceType property is set
to 0 (None) or 1 (Value).

HTH,
Tracy


LOCAL testForm
testForm = CREATEOBJECT("formClass")
testForm.Show()

DEFINE CLASS formClass as Form 

WindowType = 1
SelectedValue = 0

ADD OBJECT AddComboBoxButton as CommandButton WITH Top = 10, Left = 10,
Caption = "Add Combobox 1"
ADD OBJECT AddComboBoxButton2 as CommandButton WITH Top = 10, Left =
130, Caption = "Add Combobox 2"
ADD OBJECT SelectedValueTextBox as TextBox WITH TOP = 10, Left = 260,
Width = 40, ControlSource = "THISFORM.SelectedValue"

PROCEDURE AddComboBoxButton.Click
THISFORM.AddComboBox()
ENDPROC 

PROCEDURE AddComboBoxButton2.Click
THISFORM.AddComboBox2()
ENDPROC 

PROCEDURE SelectedValue_Assign
LPARAMETERS newValue
THISFORM.SelectedValue = newValue
THISFORM.SelectedValueTextBox.Refresh()
ENDPROC 

PROCEDURE AddComboBox
DEFINE POPUP ComboPopup FONT "Comic Sans MS", 16 
DEFINE BAR 1 OF ComboPopup PROMPT "Option 1"
DEFINE BAR 2 OF ComboPopup PROMPT "Option 2"
DEFINE BAR 3 OF ComboPopup PROMPT "Option 3" STYLE "B" 
DEFINE BAR 4 OF ComboPopup PROMPT "Option 4"

IF TYPE("THISFORM.addedCombobox.Name") = "C"
THISFORM.RemoveObject("addedCombobox")
ENDIF 
THISFORM.AddObject("addedCombobox", "Combobox")
THISFORM.addedCombobox.Top = ThisForm.AddComboBoxButton.Top +
ThisForm.AddComboBoxButton.Height + 10
THISFORM.addedCombobox.Left = 10
THISFORM.addedCombobox.RowSourceType = 9
THISFORM.addedCombobox.RowSource = "ComboPopup"
THISFORM.addedCombobox.ControlSource = "THISFORM.SelectedValue"
THISFORM.addedCombobox.Visible = .T.
* THISFORM.addedCombobox.DropDown() && This didn't drop it down
*-- This drops down the list
THISFORM.addedCombobox.SetFocus()
KEYBOARD '{ALT+DNARROW}'
ENDPROC 

PROCEDURE AddCombobox2
CREATE CURSOR comboCursor (value c(20), id i)
INSERT INTO comboCursor VALUES ("Option 1", 1)
INSERT INTO comboCursor VALUES ("Option 2", 2)
INSERT INTO comboCursor VALUES ("Option 3", 3)
IF TYPE("THISFORM.addedCombobox.Name") = "C"
THISFORM.RemoveObject("addedCombobox")
ENDIF 
THISFORM.AddObject("addedCombobox", "Combobox")
THISFORM.addedCombobox.Top = ThisForm.AddComboBoxButton.Top +
ThisForm.AddComboBoxButton.Height + 10
THISFORM.addedCombobox.Left = 10
THISFORM.addedCombobox.RowSourceType = 2 
THISFORM.addedCombobox.RowSource = "comboCursor"
THISFORM.addedCombobox.BoundColumn = 2
THISFORM.addedCombobox.ControlSource = "THISFORM.SelectedValue"
THISFORM.addedCombobox.Visible = .T.
* THISFORM.addedCombobox.DropDown() && This didn't drop it down
*-- This drops down the list
THISFORM.addedCombobox.SetFocus()
KEYBOARD '{ALT+DNARROW}'
ENDPROC

ENDDEFINE


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe
Yoder
Sent: Wednesday, June 26, 2024 8:19 PM
To: profoxt...@leafe.com
Subject: Combo box issues

I am looking for a way to have a combo box display its dropdown
programmatically. I want to do this to make it obvious that the user needs
to make a choice.  I have read that 'thisform.combobox.dropdown()' should
do the trick but the form comes up with the proper information in the
dropdown which can only be seen after clicking the control.

Another less important feature would be a way to control the position of
the list of choices when the dropdown is accessed.

Any help will be appreciated,

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


RE: Combobox followup

2024-06-19 Thread Tracy Pearson
Your function should return the object it created on the form. 
You will use that return value to set properties on.
You can use the AMembers() function to see all the available properties and 
methods available. I will say my experience with COM objects the properties do 
not show unless you have already accessed them. 

Here is something I had written some time ago testing pageframes in pageframes.
I define the form adding a pageframe during the design. 
In the forms init, I add the second pageframe and an editbox to the pageframe.
Then I add a combobox through a function to the first pageframe

Hope this gives you some ideas and directions.
Tracy

oTest = CREATEOBJECT("pageframeartifact")
oTest.SHOW()

oTest = .NULL.
CLEAR CLASS pageframeartifact

DEFINE CLASS pageframeartifact AS FORM

WINDOWTYPE = 1
CAPTION = "Active Page 2 of both pageframes - Pull down quickly"

ADD OBJECT pgf AS PAGEFRAME WITH ;
PAGECOUNT = 2, ANCHOR = 5, WIDTH = 450


PROCEDURE INIT
THIS.HEIGHT = 250
THIS.WIDTH = 450
THIS.pgf.page2.ADDOBJECT("pgf", "pageframe")
THIS.pgf.page2.pgf.HEIGHT = 100
THIS.pgf.page2.pgf.TOP = 116
THIS.pgf.page2.pgf.WIDTH = 450
THIS.pgf.page2.pgf.PAGECOUNT = 2
THIS.pgf.page2.pgf.ANCHOR = 14
THIS.pgf.page2.pgf.VISIBLE = .T.
THIS.pgf.page2.pgf.page2.ADDOBJECT("edt", "editbox")
THIS.pgf.page2.pgf.page2.edt.TOP = 10
THIS.pgf.page2.pgf.page2.edt.LEFT = 10
THIS.pgf.page2.pgf.page2.edt.WIDTH = THIS.WIDTH - 20
THIS.pgf.page2.pgf.page2.edt.HEIGHT = 60
THIS.pgf.page2.pgf.page2.edt.VISIBLE = .T.

LOCAL cmb 
cmb = AddComboBox("cmb", this.pgf.Page1)
cmb.left = 20
cmb.top = 20

ENDPROC

ENDDEFINE


FUNCTION AddComboBox
LPARAMETERS comboboxName, containerClass as Container 
containerClass.AddObject(comboboxName, "Combobox")
containerClass.&comboboxName..Visible = .T.
RETURN containerClass.&comboboxName.
ENDFUNC

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe Yoder
Sent: Tuesday, June 18, 2024 9:56 PM
To: profoxt...@leafe.com
Subject: Re: Combobox followup

Thanks guys!  Now I can name and place Combos at will.

The next thing I would like to do is to update the ComboBox properties from
the program calling the creation procedure.
My first attempt was This,oComboBox1.rowsourcetype = '1 (value)' but it
fails (This can only be used within a method)

i also wish for a way to see all the properties of the created object.  I
have read that some can only be accessed if a custom class has been defined
but I don't understand why that would be the case or how to figure out what
should be accessible.

Any help would be appreciated,
Joe

On Tue, Jun 18, 2024 at 5:42 AM  wrote:

> You should do it differently:
>
> toForm.AddObject(cName, "ComboBox")
> With toForm.&cName
> .AddItem(Item 1")
> .AddItem("Item 2")
> .Top = nTop
> .Left = nLeft
> .Visible = .T.
> Endwith
>
>
> wOOdy
>
> -Ursprüngliche Nachricht-
> Von: ProFox  Im Auftrag von Joe Yoder
> Gesendet: Dienstag, 18. Juni 2024 02:33
> An: profoxt...@leafe.com
> Betreff: Combobox followup
>
> Thanks Eric for the input.  I think I have correctly made the changes you
> suggested but the code fails with "Unknown member oComboBox"
> Here is the code as I have it now:
>
> * Procedure to add a ComboBox to the form PROCEDURE
> AddComboBoxToForm(toForm, nTop, nLeft, cname)
> LOCAL oComboBox
> oComboBox = CREATEOBJECT("ComboBox")
> oComboBox.AddItem("Item 1")
> oComboBox.AddItem("Item 2")
> toForm.oComboBox.Top = nTop
> toForm.oComboBox.Left = nLeft
> toForm.oComboBox.Visible = .T.
> toForm.AddObject(cname, "oComboBox")
>
> ENDPROC
> For some reason I need to go to the archive to get any responses to my post
> so this will appear as a new thread.
>
> Thanks again,
> Joe
>
>
> --- StripMime Report -- processed MIME parts --- multipart/alternative
>   text/plain (text body -- kept)
>   text/html
> ---
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/005001dac255$bc337ab0$349a7010$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: VFP 8, ODBC connection to Azure SQL Server Pausing

2024-06-18 Thread Tracy Pearson
Hi Philip,

I don't use the SQL connection ability in VFP often.
I do remember it is possible to set the DispLogin on the VFP level using a 0
for the Connection parameter.
I'm sure the ConnectTimeOut can be set that way as well.

Tracy


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Philip
Borkholder
Sent: Tuesday, June 18, 2024 2:21 PM
To: profoxt...@leafe.com
Subject: RE: VFP 8, ODBC connection to Azure SQL Server Pausing

Hi Tracy,
The SQLSETPROP() works once there is a connection I believe.
SQLSTRINGCONNECT() also returns a negative 1 however, the ODBC Login screen
pops up before that return.
I'm trying to figure out a way to hide/stop that annoying ODBC SQL Login
prompt. :-)

I think I'm going to see if the ConnectTimeOut can be added in the
connection string.

Thank you,

-- Original Message ------
From: "Tracy Pearson" 
To: profoxt...@leafe.com
Subject: RE: VFP 8, ODBC connection to Azure SQL Server Pausing
Date: Tue, 18 Jun 2024 10:18:04 -0400

I haven't worked with Azure SQL. 

You could set some setting with SQLSETPROP() Function
Look at ConnectTimeOut and DispLogin settings. 

The SQLConnect function returns a -1 when the connection isn't created.

HTH,
Tracy


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Philip
Borkholder
Sent: Tuesday, June 18, 2024 9:34 AM
To: profoxt...@leafe.com
Subject: VFP 8, ODBC connection to Azure SQL Server Pausing

Hello,

I have been having issues with MS Azure SQL Server going to a "pause state"
at night after no activity.
Then when I try to connect with :

lnConnection = SQLSTRINGCONNECT(lcConnString,.T.)


Because the Azure SQL Server is paused, the SQLSTRINGCONNECT() times out and
prompts with the ODBC failed to connect and SQL Server login prompt.

This is annoying when I don't want that to pop up because the end user will
not know what to do.
All the help online just says an Azure SQL Server resumes once an attempt to
connect is made...

Does anyone have any experience with this?

Is it a timeout issue that we can set in our connection string?
Is there a setting on the Azure SQL server we need to set to not allow it to
pause?

Thanks for any guidance,

Philip Borkholder
Bison Tech Plus
Vicksburg, MI



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/004301dac1b1$da165600$8e430200$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: VFP 8, ODBC connection to Azure SQL Server Pausing

2024-06-18 Thread Tracy Pearson
I haven't worked with Azure SQL. 

You could set some setting with SQLSETPROP() Function
Look at ConnectTimeOut and DispLogin settings. 

The SQLConnect function returns a -1 when the connection isn't created.

HTH,
Tracy


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Philip
Borkholder
Sent: Tuesday, June 18, 2024 9:34 AM
To: profoxt...@leafe.com
Subject: VFP 8, ODBC connection to Azure SQL Server Pausing

Hello,

I have been having issues with MS Azure SQL Server going to a "pause state"
at night after no activity.
Then when I try to connect with :

lnConnection = SQLSTRINGCONNECT(lcConnString,.T.)


Because the Azure SQL Server is paused, the SQLSTRINGCONNECT() times out and
prompts with the ODBC failed to connect and SQL Server login prompt.

This is annoying when I don't want that to pop up because the end user will
not know what to do.
All the help online just says an Azure SQL Server resumes once an attempt to
connect is made...

Does anyone have any experience with this?

Is it a timeout issue that we can set in our connection string?
Is there a setting on the Azure SQL server we need to set to not allow it to
pause?

Thanks for any guidance,

Philip Borkholder
Bison Tech Plus
Vicksburg, MI



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/003f01dac18a$55ecf090$01c6d1b0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: ODBC / VFPA / 64 Bit

2024-06-11 Thread Tracy Pearson
A 64-bit application requires a 64-bit ODBC driver to connect to the data.
I know the OleDb also requires a 64-bit driver.

What data are you connecting?

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Chris
Davis
Sent: Tuesday, June 11, 2024 7:00 AM
To: profoxt...@leafe.com
Subject: ODBC / VFPA / 64 Bit

Hi All

Does the 64Bit VFPA imply that if not already a 64Bit ODBC driver could be
provided?  Are their any alternatives, we have tried the paid for DevArt one
but get mixed results.

TIA

Chris.


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

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/015d01dabc2e$1dc5c9f0$59515dd0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Re[2]: Network issue

2024-05-28 Thread Tracy Pearson
Did you recently change the user that runs VFP (Run as Administrator)? 
By default the administrator user doesn't see the mappings of the logged in
user.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ken
Watkins
Sent: Sunday, May 26, 2024 3:18 PM
To: profoxt...@leafe.com
Subject: Re[2]: Network issue

Thanks Richard, I'll give it a shot!


-- Original Message --
From: "Richard Quilhot" 
To: "ProFox Email List" 
Sent: 5/26/2024 12:01:02 PM
Subject: Re: Network issue

>VFP's file permissions have changed with the update. You will have to grant
>file create, modify and delete to VFP and your application.
>
>On Sun, May 26, 2024, 11:00 AM Ken Watkins  wrote:
>
>>  Greetings!
>>
>>  For years I have been able to copy files to another computer by using a
>>  command like this from VFP's Command Window:  "copy file my.exe to
>>  y:\folder". After I received a Windows Update a few months ago, it no
>>  longer works. I get the error "cannot create file". It's not a huge
>>  problem because I can use File Explorer to copy/paste the file, but it
>>  saves a step.
>>
>>  Just wondering what the Windows Update may have changed? I'm using
>>  Windows 10 Home and VFP9.
>>
>>  Thanks.
>>
>>  Ken Watkins
>>
>>  --
>>  This email has been checked for viruses by Avast antivirus software.
>>  www.avast.com
>>
>>  --- StripMime Report -- processed MIME parts ---
>>  multipart/alternative
>>text/plain (text body -- kept)
>>text/html
>>  ---
>>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/009301dab10b$999e83b0$ccdb8b10$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: List box issues

2024-04-24 Thread Tracy Pearson
Yes.

There are a couple of points to add to that.
- The Event should call a method. My experience has shown switching forms that 
are configured as private data sessions may not be in the right memory space in 
some event code. However, that problem appears to go away when the event calls 
a method. 
An explanation of not being in the right memory space is the event code 
references a table in the forms data session or object on the form, VFP throws 
an error that it wasn't found. When the event calls a method on the control or 
the form it is contained in, that has not happened that I have seen. Though, I 
won't guarantee it will not happen. When the event tries to call a method on a 
hierarchy like `This.Parent.AnotherObject`, I have seen it error.
- How you want the user to experience the system may change which event you 
want to use. 
The Got Focus and Lost Focus events are a good place for code that changes 
the background of the current item to help the user know what control has 
focus. 
The Valid event can be used to validate the data in the control and 
returning .F. from the event prevents the control from losing focus. (textbox 
validations)
- There a many events, most of them I don't use.


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe Yoder
Sent: Wednesday, April 24, 2024 12:19 PM
To: profoxt...@leafe.com
Subject: Re: List box issues

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/00f001da9675$3170d870$94528950$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: List box issues

2024-04-24 Thread Tracy Pearson
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/00ef01da965f$5bc222c0$13466840$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: List box issues

2024-04-24 Thread Tracy Pearson
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/00eb01da964f$aed999d0$0c8ccd70$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: VFP Form designer display issue

2024-04-23 Thread Tracy Pearson
This behavior occurs when Windows Display Scale setting is greater than
100%.

HTH,
Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe
Yoder
Sent: Tuesday, April 23, 2024 11:11 AM
To: profoxt...@leafe.com
Subject: VFP Form designer display issue

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

[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/00db01da9593$4dce2e60$e96a8b20$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Hidden windows in the Window menu

2024-02-06 Thread Tracy Pearson
Hello all,

Is it possible to hide hidden windows in the System _MSM_WINDO menu?

I wrote this code attempting to find a way. The only thing I was able to do
is prevent the window from popping up when it is selected in the menu.
The button on the visible menu enables the form before showing it.

Thanks for looking,
Tracy

LOCAL loTestForm
loTestForm = CREATEOBJECT("TestFormClass")
loTestForm.RunTest()

loTestForm = .NULL.
CLEAR CLASS "TestFormClass"
CLEAR CLASS "HiddenFormClass"

DEFINE CLASS TestFormClass as Form 
Height = 200
Width = 400
AllowOutput = .F.
Caption = "Visible form"

oHidden = null

ADD OBJECT lblInfo as Label WITH caption = "A hidden window was also
opened.", left = 12, top = 12, autosize = .T.
ADD OBJECT cmdShowHidden as CommandButton WITH Caption = "Show Hidden",
left = 12, top = 40, autosize = .T.

PROCEDURE cmdShowHidden.Click
   IF TYPE("ThisForm.oHidden.Name") = "C"
  ThisForm.oHidden.Enabled = .T.
  ThisForm.oHidden.Show()
   ENDIF
ENDPROC 

PROCEDURE queryunload
   CLEAR EVENTS 
ENDPROC 

PROCEDURE RunTest
   this.oHidden = CREATEOBJECT("HiddenFormClass")
   this.Show()
   READ EVENTS
ENDPROC 

ENDDEFINE 

DEFINE CLASS HiddenFormClass as Form
height = 200
width = 400
allowoutput = .F.
autocenter = .T.
caption = "Hidden form"
ShowInTaskBar = .F.
Enabled = .F.
Visible = .F.

ADD OBJECT lblInfo as label WITH caption = "This was a hidden window",
left = 12, right = 12, autosize = .T.

ENDDEFINE


___
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/01df01da592b$28ec6de0$7ac549a0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Class definition is cyclical error

2023-12-27 Thread Tracy Pearson
I have a base class library. In it I have a ccontainer class that is (no
surprise here) based on the vfp container.

I have a test class library (testlibrary) that I have subsclassed ccontainer
(testcon) and added a ccontainer (innerContainer) in. Then added another
container (innerInnerContainer).

When I add the testlibrary to the Form Controls Toolbar and attempt to add
the testcon class to a form I get the following:

Error loading file - record number 21.  innerInnerContainer .  Parent : Cannot add INNERINNERCONTAINER.  Class definition is
cyclical

If you drag the control from the Project Explorer (Project Manager) the
error appears during runtime.

In all the time I have been building apps, I'm not sure I have ever seen
this happen. 
It was originally seen as a problem when my coworker was building a new
class that gets loaded dynamically.
He was building a UI that changes what is visible depending on what options
are set. A pageframe changes pages depending what is selected. His is
container with a pageframe and another pageframe on page2.

Error loading file - record number 25.  InnerPageFrame .  Parent : Cannot add INNERPAGEFRAME.  Class definition is cyclical



Is there a way around this?

Thank you,
Tracy


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/00cc01da38f4$ca767ef0$5f637cd0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: Programatically placing text boxes on a form

2023-10-30 Thread Tracy Pearson
The textbox needs to be added with a method on the form.

thisform.addobject( "TextBox" + LTRIM(STR(i)) + LTRIM(STR(j)), "textbox")

oTextbox = evaluate( "TextBox" + LTRIM(STR(i)) + LTRIM(STR(j)))


HTH,
Tracy


On October 29, 2023 11:43:13 PM EDT, Joe Yoder  wrote:
>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
>---
>
[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/44bd27a7-797d-4d3e-8d81-cf2acab82...@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Passing parameters to an external program run from fox

2023-05-05 Thread Tracy Pearson
Hi Joe,

If you don't mind a command window opening you can use the ! or RUN.
!c:\temp\params.cmd def abc

I wrote a cmd file that has the following
echo %1, %2
pause

I have these procedures I have used as well
Procedure StartExplorer1
   *-- Start a Windows Explorer window in the current path
   Local oShell As wScript.Shell
   oShell = Createobject("wScript.Shell")
   *-- If the folder list is prefered use "Explorer /e,"
*   oShell.Run("Explorer " + Fullpath(""))
   oShell.Exec("Explorer " + Fullpath(""))
   Release oShell
ENDPROC

PROCEDURE StartExplorer
   DECLARE INTEGER ShellExecute IN Shell32.DLL ;
  INTEGER nWinHandle, ;
  STRING  cOperation, ;
  STRING  cFileName,  ;
  STRING  cParameters, ;
  STRING  cDirectory,  ;
  INTEGER nShowWindow
   LOCAL lcExec, lnRet
   lcExec = ADDBS(GETENV("windir")) + "system32\explorer.exe"
   lnRet = ShellExecute(_Screen.HWnd, "open", SYS(5)+SYS(2003), "",
SYS(5)+SYS(2003), 1)
   *MESSAGEBOX(lcExec + CHR(13) + TRANSFORM(lnRet))
ENDPROC

HTH,
Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe
Yoder
Sent: Friday, May 05, 2023 2:13 AM
To: profoxt...@leafe.com
Subject: Passing parameters to an external program run from fox

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

[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/01f101d97f59$4654a6b0$d2fdf410$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: VFP Report Dynamics Tab Missing

2023-04-20 Thread Tracy Pearson
Hi Frank,

My only thoughts is you need to be sure you have the updated Report*.app
files.

HTH,
Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank
Cazabon
Sent: Thursday, April 20, 2023 3:27 PM
To: profoxt...@leafe.com
Subject: VFP Report Dynamics Tab Missing

Hi,

I've got version 09.00..7423 and SET("ReportBehavior") = 90 yet when 
I double click a report control on a report I don't see the Dynamics Tab 
or the Advanced Tab. Windows 11 Pro 22H2

What am I doing wrong?

-- 

Frank.

Frank Cazabon


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/00c501d973ca$8f6eeda0$ae4cc8e0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: HTTPS GET using Winsock

2023-04-03 Thread Tracy Pearson
I have used the MSXML ActiveX control in the past. 

LOCAL xml as MSXML2.XMLHTTP60
xml = CREATEOBJECT("MSXML2.XMLHTTP.6.0")
xml.open("GET","https://www.google.com";)
xml.send()
?xml.status,xml.statusText
* ?xml.responseText

These days I do use the Chilkat ActiveX control, but it isn't free.

HTH,
Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Man-wai 
Chang
Sent: Monday, April 03, 2023 7:48 AM
To: profoxt...@leafe.com
Subject: HTTPS GET using Winsock

Are there free Visual Foxpro source codes that do HTTPS GET via Winsock?

The following example does non-SSL HTTP GET:

Win32API/sample_383.md at master · VFPX/Win32API · GitHub
Winsock: retrieving Web pages using sockets (HTTP, port 80)
Retrieved data is stored in a Memo field of a cursor
https://github.com/VFPX/Win32API/blob/master/samples/sample_383.md

-- 
 .~. Might, Courage, Vision. SINCERITY!
/ v \   https://github.com/changmw/changmw
/( _ )\ http://sites.google.com/site/changmw
^ ^ May the Force and farces be with you!

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/019901d96633$f6749120$e35db360$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Error instantiating class when opening a form

2023-03-20 Thread Tracy Pearson
I think I have done this at one time by:
Place the ocx in a class of your own.
Add the class during the Init wrapped in a Try/Catch.

It adds an extra level to the hierarchy. 

HTH,
Tracy


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Eric Selje
Sent: Monday, March 20, 2023 10:30 AM
To: profoxt...@leafe.com
Subject: Re: Error instantiating class when opening a form

 Timely question! I just had this happen to a client last Thursday. App has
been working for years, but they called to say it suddenly doesn't work
with a "Cannot load class" type of error.

After some troubleshooting we determined the issue was their MSP's security
software determined that RichTxt32.ocx was malicious and blocked it. It
would have been nice if the app could catch that particular error and load
the form without those controls present rather that fail altogether. It may
cause deleterious side effects though. I may give this some thought...

Eric

On Sat, Mar 18, 2023 at 8:26 AM Man-wai Chang  wrote:

> I had a form without the class lib. Could I force open the form
> ignoring the class instantiation error?
>
> Other than opening the form.scx,  delete those references and pack it ...
> :)
>
> --
>  .~. Might, Courage, Vision. SINCERITY!
> / v \   https://github.com/changmw/changmw
> /( _ )\ http://sites.google.com/site/changmw
> ^ ^ May the Force and farces be with you!
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/004b01d95b40$ff82b150$fe8813f0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Error instantiating class when opening a form

2023-03-18 Thread Tracy Pearson
You could also create a temporary classlib.

Tracy

On March 18, 2023 9:26:05 AM EDT, Man-wai Chang  wrote:
>I had a form without the class lib. Could I force open the form
>ignoring the class instantiation error?
>
>Other than opening the form.scx,  delete those references and pack it ... :)
>
>-- 
> .~. Might, Courage, Vision. SINCERITY!
>/ v \   https://github.com/changmw/changmw
>/( _ )\ http://sites.google.com/site/changmw
>^ ^ May the Force and farces be with you!
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/c41cf83d-1e5c-416a-95c5-9609e3200...@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Report with 2 Columns, Left to Right and Groups

2023-01-16 Thread Tracy Pearson
Digging around I found this note in the VFP 9 SP2 help file:
How to: Define Columns in Reports

In Visual FoxPro 9.0, setting label-style print order has some
additional impact on reports. When you use this option to make columns flow
from left to right, group and detail header and footer bands extend across
the page, so they can provide true header information for the entire row.
The detail band starts one row down from any header bands you design in the
layout. In earlier versions, **Column print order** did not change the
behavior of group header and footer bands, so the first detail item printed
adjacent to the innermost group header on the same row.

The logic to display only specific data that is gathered in variables in the
report should be printed in a group footer. 
The group footer no longer moves from column to column. 

Setting the "Associated header and footer bands" in the Detail Band
Properties results in the detail band never going to the right columns. 

May this help someone in the future.
Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Tracy
Pearson
Sent: Monday, January 16, 2023 12:28 PM
To: profoxt...@leafe.com
Subject: Report with 2 Columns, Left to Right and Groups

Hello everyone,
I don't work with the VFP reports very often.
My coworker brought up a problem he has found when building a custom report
for a customer.

Using a single flat table and building a report with multiple columns and
have it go left to right the details properly go left to right.

Once a grouping is added to the report, everything prints in the left column
only.  Switch the report to be Top to Bottom and both columns are used. 

For what is in this report, it would be better to have this left to right. 
Custom programming to group things before going to the report is not an
option. 

Creating a similar report in the IDE, not the runtime, does not exhibit this
behavior.

Does anyone have an idea on how to get the report to behave?

We have tried this in  VFP 9 SP 2 HF 3

Thank you,
Tracy


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/005301d929f5$f18a0160$d49e0420$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Report with 2 Columns, Left to Right and Groups

2023-01-16 Thread Tracy Pearson
Hello everyone,
I don't work with the VFP reports very often.
My coworker brought up a problem he has found when building a custom report
for a customer.

Using a single flat table and building a report with multiple columns and
have it go left to right the details properly go left to right.

Once a grouping is added to the report, everything prints in the left column
only.  Switch the report to be Top to Bottom and both columns are used. 

For what is in this report, it would be better to have this left to right. 
Custom programming to group things before going to the report is not an
option. 

Creating a similar report in the IDE, not the runtime, does not exhibit this
behavior.

Does anyone have an idea on how to get the report to behave?

We have tried this in  VFP 9 SP 2 HF 3

Thank you,
Tracy


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/004901d929cf$dca21880$95e64980$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: Dymo Twin Turbo

2022-11-13 Thread Tracy Pearson
I had used the Dymo ActiveX to switch which side the job needed to print to.
I printed everything through the ActiveX. 
I don't know if the latest software ships the ActiveX control.
I know the .NET library they have available doesn't work in .NET 6. That and 
the expensive 550 printers and the requirements to use their labels with it got 
me to abandon supporting the Dymo twin printers.

There might be something like an old Epson dot matrix type code that switches 
sides. I didn't research that. Without knowing the printer has two paper feeds. 
Time was not on my side.

Tracy

On November 13, 2022 12:12:29 PM EST, Graham Brown  wrote:
>Hi all
>
> 
>
>Probably a long shot but has anyone managed to get labels printing to a Dymo
>450 Twin Turbo. 
>
>I am trying to get it to choose the correct spool (printer has two) . It
>always defaults to the last one printed to.
>
> 
>
>There is sample code for VB but nothing for Fox. Would've expected if I have
>the driver installed I can just put the info into the frx memo field but
>doesn't seem to want to play.
>
> 
>
>Thanks
>
>Graham
>
> 
>
> 
>
>
>
>--- 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/50488650-7c53-4c63-8ea2-a06617ef9...@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: dreaming of vfp and vscode integration

2022-10-25 Thread Tracy Pearson
There are two ways to make that happen from what I recall.
You can automate VFP with COM.

You can use a config.fpw and launch VFP with the -C "path\config.fpw" 
The config.fpw needs to have a COMMAND for what you want to do.
It could be the COMPILE command or a PRG you want to run.

I have used both, but prefer the config.fpw method.

HTH,
Tracy 

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff
Roberts
Sent: Tuesday, October 25, 2022 10:17 AM
To: profoxt...@leafe.com
Subject: dreaming of vfp and vscode integration

This morning I've been doing some refactoring (I use that term loosely) and
listening to some guys talk in one of the rooms at Virtual Fox Fest. I'm
splitting long lines and cleaning up comments, etc in vscode then switching
over to VFP (Version 6 still I am ashamed to say) and compiling the prg to
make sure I'm not getting any errors. I was thinking it would be convenient
if I could make VFP compile the file I'm working on when I save it and then
maybe have something look for ERR files to show up and send me a
notification if it does. Does anyone have any experience doing something
like this? I'd be willing to put some time into the tooling to do this.
Seems like it is possible. I do realize I'd get a little more syntax
checking with VFP6 and a lot more with VFP9, but I am more used to the text
manipulation in vscode. Maybe I am just dreaming!

-- 
Jeff Roberts | jefflrobe...@gmail.com


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

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/00ba01d8e87f$58ad1b60$0a075220$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Breakpoint, click Resume, nothing happens

2022-09-16 Thread Tracy Pearson
I haven't seen before.

I start my debug session with a config-code.fpw.
screen=off
Resource=off
Safety=off
Title=KIOSK11-CODE
Command=Do ..\pckiosk11.resource\StartUp-Code.prg

The StartUp-Code sets a few extra things, opens the debug window and starts
the code
DEBUG 

SET ASSERTS ON 
SET PATH TO 
SET CENTURY ON 

DO checkin.prg  
ON SHUTDOWN
QUIT

I have a "SET STEP ON" in my code to step through a bit of code.
Well, I am unable to step through the code. Resume fails as well.
The Cancel button works. When I close the Debugger the _Screen appears.
Oh, this is an app that the ShowWindow is set to 2 - As Top-Level Form.

Once the Screen appears, I need to type ON SHUTDOWN in the Command window to
be able to quit.

As I typed all this out. I continued to think of things I should try.

So I added a _Screen.Show() just before the DEBUG and I'm able to Resume and
stop through my code now.

Hope this helps someone in the future.

Have fun, see you at Virtual Fox Fest 2022 soon!
Tracy


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/004601d8ca03$bc7386b0$355a9410$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


VFPa oddness

2022-08-26 Thread Tracy Pearson
Here's the scenario
I use the third party Crystal Reports 8.5 in my software. 
Ver 12 of our software works on Server 2019 without a problem.
Ver 14 of our software does not.
When printing or exporting a report that can be viewed it is looking for
files that are installed and hardcoded by Crystal  Reports to be in the
C:\Windows\Crystal folder.
In VFP9 this works.
In VFPA this is actually looking for these files in
C:\Users\\WINDOWS\Crystal.
The server has RDS installed and both The VFP9 and VFPA versions of our
software was installed the same way.
(RDS - Remote Desktop Services {the new Terminal Services})

Is this a Roaming profile issue (though their IT person states this isn't a
Roaming profile)?
Is there another thought I can research? 
I'm going to get my IT person to setup a private area for us to test this
and hopefully reproduce the problem.


Any (and all sarcastic and/or funny) comments welcome. It's been a little
quiet here lately.

Thank you,
Tracy


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/010e01d8b974$5cd5a5c0$1680f140$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Document View magic inside a long PRG

2022-08-10 Thread Tracy Pearson
It will, if the order of Document View is by Location. If it is by Name, or
Type it may not.

All is good here,
Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB
Software Solutions, LLC
Sent: Wednesday, August 10, 2022 11:12 AM
To: profoxt...@leafe.com
Subject: Document View magic inside a long PRG

Well, maybe not magic...and maybe many of you already knew thisbut 
if you wondered "what method am I in right now?" whilst looking at a 
super long section of code in a PRG, opening up Document View will 
highlight the current method you're in.

Again...probably "nothing to see here...please disperse" but I thought 
I'd share it in case somebody else wondered this.

Happy hump day!

-- 
Michael J. Babcock, MCP
Fox/VFP dev since 1997
Developer of FabNet estimating software - mbsoftwaresolutions.com

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/001201d8acce$5300ee40$f902cac0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Problem setting ActiveX control property (Folderview and Fileview controls)

2022-06-02 Thread Tracy Pearson
Have you tried to use the STORE command 
STORE 240 TO MyFileView.ColumnWidth("Name",0)

It might not work either. 

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul
Newton
Sent: Thursday, June 02, 2022 12:20 PM
To: profoxt...@leafe.com
Subject: Re: Problem setting ActiveX control property (Folderview and
Fileview controls)

Thanks for the suggestion Eric but the first column is in fact 0 because 
the following

? MyFileView.ColumnWidth("Name",0) gives the correct result for the 
width of the first column Paul

On 02/06/2022 16:59, Eric Selje wrote:
> It's interesting that the VB syntax has the first column as 0 when VB is a
> one-based array language. Have you tried a 1 there instead for the 2nd
> parameter?
>
> On Wed, Jun 1, 2022 at 7:55 PM Paul Newton
> wrote:
>
>> Hi
>>
>> It's a few years old now, but I have the Sky Software Shell Megapack
>> suite (V8) which contains the two (ActiveX) controls above as well as a
>> drive combo control.  I have used these successfully in the past but
>> have run into a problem.  The Fileview control has a Public Read-Write
>> Property ColumnWidth which, according to the help file, "Gets/Sets the
>> width of the column in pixels".  The VB syntax in the help is:
>>
>> Public Property ColumnWidth(ByVal ColumnName As String, ByVal
>> ColumnIndex As Long) As Long
>>
>> ? MyFileView.ColumnWidth("Name",0) and ?
>> MyFileView.Object.ColumnWidth("Name",0)  both work fine and return 120.
>>
>> Trying to set the column width as follows
>>
>> MyFileView.ColumnWidth("Name",0) = 240 gives "Function argument value,
>> type or count is invalid"
>>
>> and MyFileView.Object.ColumnWidth("Name",0) = 240 gives "Syntax error"
>>
>> Am I missing something (I have checked and there is no method or event
>> on the control which references ColumnWidth).
>>
>> Alternatively, can anybody suggest affordable (aka cheap, preferably
>> free) alternatives to these controls which are designed to closely mimic
>> the behaviour of Windows Explorer?
>>
>> Many thanks
>>
>> Paul Newton
>>
>> --- StripMime Report -- processed MIME parts ---
>> multipart/alternative
>>text/plain (text body -- kept)
>>text/html
>> ---
>>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/014c01d8769f$5f1e5290$1d5af7b0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Foxfest Tomorrow.... Help

2022-05-04 Thread Tracy Pearson
Dave,

I got emails Update 2 and 3 from that email address.
The first Update 1 email came from Rick Schummer's email directly. It arrived 
4/27.

Rick is in the Central time zone. 

HTH,
Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave Crozier
Sent: Wednesday, May 04, 2022 9:26 AM
To: profoxt...@leafe.com
Subject: Foxfest Tomorrow Help

I do not seem to have received any login info regarding getting access to the 
conference tomorrow desp[ite having received registration info and payment 
confirmation from Rick and the gang.

Has anyone else had this issue as I don’t want to miss the party tomorrow.

I have emailed i...@geekgatherings.com as to 
the issues I am having but not received anything back as of yet.

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

Disclaimer

The information contained in this communication from the sender is 
confidential. It is intended solely for use by the recipient and others 
authorized to receive it. If you are not the recipient, you are hereby notified 
that any disclosure, copying, distribution or taking action in relation of the 
contents of this information is strictly prohibited and may be unlawful.

This email has been scanned for viruses and malware, and may have been 
automatically archived by Mimecast Ltd, an innovator in Software as a Service 
(SaaS) for business. Providing a safer and more useful place for your human 
generated data. Specializing in; Security, archiving and compliance. To find 
out more visit the Mimecast website.


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

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: 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/00a701d85fbd$20dc8450$62958cf0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: visual foxpro advanced table size limits

2022-04-19 Thread Tracy Pearson
Jeff,

In the version you can download without a subscription you need to enable
large files sizes in the 64-bit version
http://www.baiyujia.com/vfpdocuments/f_vfp9fix112.asp

HTH,
Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff
Roberts
Sent: Tuesday, April 19, 2022 7:40 PM
To: profoxt...@leafe.com
Subject: visual foxpro advanced table size limits

I recently ran across Ajit Abraham's github repo at
https://github.com/Ajitweb/vfp10LargeTables where he guides you through
importing a large dataset from imdb to show Visual Foxpro Advanced breaking
the 2GB table size limit. I already had the 32bit version of Visual Foxpro
Advanced installed so I tried this exercise with it and still got the table
size large error that you'd get with VFP9. So I downloaded the 64bit
version and installed and tried that with the same result. I am guessing
that I am missing something simple or maybe the 32bit version I had on my
laptop was too old and is causing a conflict of some kind? Anybody else
seen this behaviour and know what I need to change? I am not trying to do
this in production I was just curious and really wanted to see it for
myself. Thanks!

-- 
Jeff Roberts | jefflrobe...@gmail.com


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

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/003401d8544b$46da1f50$d48e5df0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: can visual foxpro create a table inside a sql statement?

2022-04-15 Thread Tracy Pearson
It's a pain to accomplish, and would probably be faster just to create the
cursor in code

CREATE CURSOR tempCursor (selected l)
INSERT INTO tempCursor VALUES (.T.)

SELECT "short" as desc, 0 as min, 60 as max FROM tempCursor ;
union SELECT "medium" as desc, 60 as min, 120 as max FROM tempCursor ;
union SELECT "long" as desc, 120 as min, 1000 as max FROM tempCursor
INTO CURSOR testing

SELECT testing
BROWSE

In this scenario the tempCursor needs to exist and have only 1 record in it
for the speed of the Unions to be fast.
Each of those select statements will create a result with the number of
records in tempCursor. 
Sure, you could use and Order By clause and Top 1 to get just one result,
but the Order By could slow it down.

I'm with Mike, just don't do it.

Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff
Roberts
Sent: Friday, April 15, 2022 9:49 AM
To: profoxt...@leafe.com
Subject: can visual foxpro create a table inside a sql statement?

I've been watching a video tutorial called "Mastery with SQL" that uses
Postgres for the back end. At one point while talking about subqueries the
instructor runs the following SQL query:

SELECT * FROM (values ('short', 0, 60), ('medium', 60, 120), ('long', 120,
1)) as c("desc", "min", "max");

This query more or less creates a table and then selects everything out of
it. Not very useful on its own but could be handy when joined up to a real
table. I get a syntax error running this in Visual Foxpro 9 so I was
wondering if the syntax can be changed so that it will work, or is this
type of query even possible with Visual Foxpro? I think it could be done
with a create cursor statement ahead of the query but I'm just curious if
it can be done with a one-liner. FYI the query as-is works in Postgres but
not VFP, Sqlite, or Mysql (at least the versions I have on my machine).

-- 
Jeff Roberts | jefflrobe...@gmail.com


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

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/001801d850f6$2dd65df0$898319d0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: VFP to SharePoint Spreadsheet Dashboard

2022-04-06 Thread Tracy Pearson
James,

The listserve does not send the HTML portion of emails through. If you can,
send messages as plain text.

Tracy



-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of James
Trogdon
Sent: Wednesday, April 06, 2022 8:01 AM
To: profoxt...@leafe.com
Subject: RE: VFP to SharePoint Spreadsheet Dashboard

--- StripMime Report -- processed MIME parts ---
multipart/alternative
--- StripMime Errors ---
A message with no text/plain section was received.
The entire body of the message was removed.  Please
resend the email using plaintext formatting
---

[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/005e01d849bc$1b9ca680$52d5f380$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: VFP to SharePoint Spreadsheet Dashboard

2022-04-05 Thread Tracy Pearson
It was a long time ago I heard a talk about SharePoint. Does the Spreadsheet
basically use an Access database, or an MSSql server for the backend data?
Wouldn't you just be updating that table and the SharePoint site will take
care of the rest?

I haven't done this myself, I only remember bits of the talk and none of the
front end implementation.

Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of James
Trogdon
Sent: Tuesday, April 05, 2022 2:08 PM
To: profoxt...@leafe.com
Subject: VFP to SharePoint Spreadsheet Dashboard


Hi All,

The company I work for is eventually going to a new ERP but until that time
I still must maintain some VFP (version 6 and 9) apps.  I have a trailer
assigning project that will allow people to scan orders to a trailer.  The
orders are then scanned when they begin loading and when they finish
loading.  After the loading, a query is run to determine if all the orders
for that trailer is complete.  I had thought to just email the information,
but the users are wanting a live dashboard configured as a SharePoint
Spreadsheet where everybody in the company can see it.  The shipping tower
would like to mark when an order has been picked and delivered.  I've never
done any development accessing SharePoint with VFP so I thought I would ask
how you would display a dashboard that would refresh every 5 minutes or so
but still allow certain fields to be marked as complete on the spreadsheet.
I would assume the program would be setup as scheduled task running every 5
minutes to update the spreads
 heet.  Any help would be greatly appreciated.  Thanks!






[Prestige Fabricators, Inc.]   James Trogdon
IT Manager
jtrog...@prestigefab.com
O: 336.626.4596 ext. 12051
905 NC Highway 49 S, Asheboro, NC 27205

The content of this email is confidential and intended for the recipient
specified in message only. It is strictly forbidden to share any part of
this message with any third party, without a written consent of the sender.
If you received this message by mistake, please reply to this message and
follow with its deletion, so that we can ensure such a mistake does not
occur in the future.

Disclaimer

The information contained in this communication from the sender is
confidential. It is intended solely for use by the recipient and others
authorized to receive it. If you are not the recipient, you are hereby
notified that any disclosure, copying, distribution or taking action in
relation of the contents of this information is strictly prohibited and may
be unlawful.

This email has been scanned for viruses and malware, and may have been
automatically archived by Mimecast Ltd, an innovator in Software as a
Service (SaaS) for business. Providing a safer and more useful place for
your human generated data. Specializing in; Security, archiving and
compliance. To find out more visit the Mimecast website.


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

[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/004601d8491b$8355c2d0$8a014870$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Problem replacing/deleting temporary picture file

2022-04-05 Thread Tracy Pearson
Hi Paul,

I have a couple of places that have an BMP loaded in the Image control on a
form. The user can change the picture in a popup modal form. The original
image is overwritten on disk with code in the modal. When the modal closes,
the image is refreshed on the original form.

I'm curious if the GDIPlusX method is leaving the control open with a file
handle to the image. 

HTH,
Tracy



-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
paul.newton.h...@gmail.com
Sent: Sunday, April 03, 2022 2:55 PM
To: profoxt...@leafe.com
Subject: Problem replacing/deleting temporary picture file

Hi all

 

I have an image control whose Picture property is a temporary BMP (say
Temp1.BMP).  I am trying to redisplay the image control with a new Picture
property of Temp2.BMP or with a modified Temp1.BMP

 

Using GDIPlusX, I am creating the BMPs with the BitMap.Save method.  Once I
have used Temp1.BMP as the picture and later trying to use BitMap.Save again
to overwrite Temp1.BMP, the changes are not saved (no error though)

 

So I used BitMap.Save to create Temp2.BMP, set Temp2.BMP as the picture
(which worked fine) and then tried to delete Temp1.BMP.  Again this failed
(file in use or similar).

 

I tried Clear Resource Temp1.BMP before Erase Temp1.BMP but that didn't work
either.

 

Any suggestions would be welcome.

 

Many thanks

 

Paul Newton 



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

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/003f01d848f3$467b5410$d371fc30$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: FoxBin2PRG vs TwoFox

2022-03-30 Thread Tracy Pearson
+1

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard
Kaye
Sent: Wednesday, March 30, 2022 4:26 PM
To: profoxt...@leafe.com
Subject: RE: FoxBin2PRG vs TwoFox

I've had no issues with doing just that, Jeff. Works a treat. In some cases
I found it more efficient to edit the text files and gen new binaries then
using the IDE GUI to edit. 

--

rk

From: ProfoxTech  On Behalf Of Jeff Roberts
Sent: Wednesday, March 30, 2022 4:02 PM
To: profoxt...@leafe.com
Subject: Re: FoxBin2PRG vs TwoFox

I use FoxBin2Prg with git and Beyond Compare but I also store my binaries
in git so I rarely if ever go from text back to bin. I am afraid of it but
it would be nice if it was dependable. Maybe it is and I just didn't get
the memo. -Jeff

On Wed, Mar 30, 2022 at 2:45 PM Richard Kaye 
wrote:

> Hey let's start another VFP thread here. I just noticed that Doug Henning
> released an update a few days ago for ProjectExplorer (and if you don't
> know what PEx is and you actively develop in VFP you should) which adds
the
> ability to use different converters for VFP binaries. I've been using
> FoxBin2PRG in a Bitbucket environment with no significant issues for a
> while but am curious about the collective experience.
>
> Talk amongst ourselves...
>
> --
>
> rk
>
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/00b201d84476$142ca710$3c85f530$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: FoxBin2PRG vs TwoFox

2022-03-30 Thread Tracy Pearson
I use FoxBin2Prg with git.
>From time to time, when I'm reviewing what needs to be committed I notice
the order of objects change. If I open the form and close it with CTRL+W,
the order is switched back. I haven't researched why it does it.
When it isn't caught the update is bigger, and doing code reviews is
something else that needs to be looked at and questioned.

I'm using v1.19.64 currently.

I'm fairly happy with the process. 

Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard
Kaye
Sent: Wednesday, March 30, 2022 3:46 PM
To: profoxt...@leafe.com
Subject: FoxBin2PRG vs TwoFox

Hey let's start another VFP thread here. I just noticed that Doug Henning
released an update a few days ago for ProjectExplorer (and if you don't know
what PEx is and you actively develop in VFP you should) which adds the
ability to use different converters for VFP binaries. I've been using
FoxBin2PRG in a Bitbucket environment with no significant issues for a while
but am curious about the collective experience.

Talk amongst ourselves...

--

rk


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/00b101d84474$20fbd620$62f38260$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: CURSORTOXML and NULLs

2022-03-29 Thread Tracy Pearson
I tend to create the cursor and use flags to append to the existing cursor.

Tracy

On March 29, 2022 7:01:47 PM EDT, Richard Kaye  wrote:
>While I'm poking away at this, I thought I'd check with the collective wisdom. 
>I've found a situation where I want to take advantage of CURSORTOXML and 
>XMLTOCURSOR. The issue I'm running into is if the cursor being converted to 
>XML has fields with NULL values in the first record, this appears to affect 
>the resulting XMLTOCURSOR conversion. Any NULL columns will be missing from 
>the result cursor even if later rows in the XML contain values. The hacky 
>workaround seems to be I have to make sure that the first record has non-null 
>values for all columns I want in the cursor. Anyone have any other magic 
>tricks?
>
>TIA
>
>--
>
>rk
>
>
>
>--- StripMime Report -- processed MIME parts ---
>multipart/alternative
>  text/plain (text body -- kept)
>  text/html
>---
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/583bd170-69ee-4337-95f6-083c29bb0...@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Using gmail to send emails from your VFP apps -- deadline approaching for shutoff

2022-03-04 Thread Tracy Pearson
Actually, VFP 9 has the ability built in.
_cliptext = STRCONV(_cliptext,14)

Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt @
Gmail
Sent: Friday, March 04, 2022 3:14 PM
To: profoxt...@leafe.com
Subject: Re: Using gmail to send emails from your VFP apps -- deadline
approaching for shutoff

Ah Cool - so that's how Tracy did it! I do remember someone posted about 
that in the past - because I have seen this problem many times before.

But, now I'm curious. Is the problem related to my email reader - or it 
really is related to how Mike transmitted the message? Does it occur 
because someone tried to transmit a message to the forum here, and it 
included some HTML formatting? As I know this forum does Not support 
that kind of formatting.

I just posted something today - am wondering if my own posting got 
transmitted as Alien-Speak as well...

-Kurt

On 3/4/2022 11:32 AM, Ed Leafe wrote:
> On Mar 4, 2022, at 12:01, MB Software Solutions, LLC
 wrote:
>>
Z290IHRoaXMgbm90aWNlIGZyb20gZ29vZ2xlIHRvZGF5OgoKCiAgTGVzcyBzZWN1cmUgYXBwcyAm
> ... etc.
>
> Try this site: https://www.base64decode.org
>
>
> -- 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/000401d83013$cccb7f70$66627e50$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Using gmail to send emails from your VFP apps -- deadline approaching for shutoff

2022-03-04 Thread Tracy Pearson
I have one of those:

I needed to implement this for users some time ago. The Chilkat control has 
support for this.
If you need to update your old legacy apps to continue sending those emails.
Or you might need to setup an online server that has an SMTP server in a way 
that only a specific email will be forwarded and any attempt to use it is just 
dropped. 

Workflow idea is you have a guid email address that you use to send an email to 
another email on the same server. Then that forwards emails to you only if it 
was sent from that email address. 
The email account that sends you an email should have a very complicated 
password, or no access to be connected from outside.
The guid email address should not be configured to send emails to other 
accounts. 
That’s all complicated and probably not worth the resources. 
Updating the old legacy apps to use modern security for emailing is an option.

If you were thinking of creating an email server solution. Maybe you just need 
to host an API that accepts the error report and it can email you. 

Now that I typed all this stuff. I would opt for the API.

Tracy

Here's what the alien text said:

got this notice from google today:


  Less secure apps & your Google Account

To help keep your account secure, starting*May 30, 2022*, ​​Google will 
no longer support the use of third-party apps or devices which ask you 
to sign in to your Google Account using only your username and password.

Please note this deadline does not apply to Google Workspace or Google 
Cloud Identity customers. The enforcement date for these customers will 
be announced on the Workspace blog at a later date.

For more information, please continue reading.

*Special Note on Apple Device Sign-Ins.*Users who have not recently 
signed into their Google Account using only username and password will 
be able to only make new sign in attempts using the Google account type 
starting from*February 28, 2022*. Existing users may continue to sign 
into their Google Account using their username and password until*May 
30, 2022*.

If an app or site doesn’t meet oursecurity standards 
,
 
Google might block anyone who’s trying to sign in to your account from 
it. Less secure apps can make it easier for hackers to get in to your 
account, so blocking sign-ins from these apps helps keep your account safe.


...so I'm guessing my legacy apps out there at clients will no longer be 
able to use the internal error reporting (that sends an email to me from 
my gmail account).

FYI for those of you who use gmail in our apps for this kind of emailing 
purpose.


-- 
Michael J. Babcock, MCP
Fox/VFP dev since 1997
Developer of FabNet estimating software - mbsoftwaresolutions.com

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt @ Gmail
Sent: Friday, March 04, 2022 1:26 PM
To: profoxt...@leafe.com
Subject: Re: Using gmail to send emails from your VFP apps -- deadline 
approaching for shutoff

Gosh Mike - that looks like Alien speak. You might want to run this 
message thru your ACTU (Alien Communication Translation Unit)!

-Kurt

On 3/4/2022 10:01 AM, MB Software Solutions, LLC wrote:
> Z290IHRoaXMgbm90aWNlIGZyb20gZ29vZ2xlIHRvZGF5OgoKCiAgTGVzcyBzZWN1cmUgYXBwcyAm 
>
> IHlvdXIgR29vZ2xlIEFjY291bnQKClRvIGhlbHAga2VlcCB5b3VyIGFjY291bnQgc2VjdXJlLCBz 
>
> dGFydGluZypNYXkgMzAsIDIwMjIqLCDigIvigItHb29nbGUgd2lsbCAKbm8gbG9uZ2VyIHN1cHBv 
>
> cnQgdGhlIHVzZSBvZiB0aGlyZC1wYXJ0eSBhcHBzIG9yIGRldmljZXMgd2hpY2ggYXNrIHlvdSAK 
>
> dG8gc2lnbiBpbiB0byB5b3VyIEdvb2dsZSBBY2NvdW50IHVzaW5nIG9ubHkgeW91ciB1c2VybmFt 
>
> ZSBhbmQgcGFzc3dvcmQuCgpQbGVhc2Ugbm90ZSB0aGlzIGRlYWRsaW5lIGRvZXMgbm90IGFwcGx5 
>
> IHRvIEdvb2dsZSBXb3Jrc3BhY2Ugb3IgR29vZ2xlIApDbG91ZCBJZGVudGl0eSBjdXN0b21lcnMu 
>
> IFRoZSBlbmZvcmNlbWVudCBkYXRlIGZvciB0aGVzZSBjdXN0b21lcnMgd2lsbCAKYmUgYW5ub3Vu 
>
> Y2VkIG9uIHRoZSBXb3Jrc3BhY2UgYmxvZyBhdCBhIGxhdGVyIGRhdGUuCgpGb3IgbW9yZSBpbmZv 
>
> cm1hdGlvbiwgcGxlYXNlIGNvbnRpbnVlIHJlYWRpbmcuCgoqU3BlY2lhbCBOb3RlIG9uIEFwcGxl 
>
> IERldmljZSBTaWduLUlucy4qVXNlcnMgd2hvIGhhdmUgbm90IHJlY2VudGx5IApzaWduZWQgaW50 
>
> byB0aGVpciBHb29nbGUgQWNjb3VudCB1c2luZyBvbmx5IHVzZXJuYW1lIGFuZCBwYXNzd29yZCB3 
>
> aWxsIApiZSBhYmxlIHRvIG9ubHkgbWFrZSBuZXcgc2lnbiBpbiBhdHRlbXB0cyB1c2luZyB0aGUg 
>
> R29vZ2xlIGFjY291bnQgdHlwZSAKc3RhcnRpbmcgZnJvbSpGZWJydWFyeSAyOCwgMjAyMiouIEV4 
>
> aXN0aW5nIHVzZXJzIG1heSBjb250aW51ZSB0byBzaWduIAppbnRvIHRoZWlyIEdvb2dsZSBBY2Nv 
>
> dW50IHVzaW5nIHRoZWlyIHVzZXJuYW1lIGFuZCBwYXNzd29yZCB1bnRpbCpNYXkgCjMwLCAyMDIy 
>
> Ki4KCklmIGFuIGFwcCBvciBzaXRlIGRvZXNu4oCZdCBtZWV0IG91cnNlY3VyaXR5IHN0YW5kYXJk 
>
> cyAKPGh0dHA6Ly90cmFjay5zbXRwc2VuZGVtYWlsLmNvbS85MDc0OTY3L2M/cD1tbGw1RTgxdWFt 
>
> b3UtSUszVjFuNDlNNjhDMDdmTjJ

Re: Problem moving controls on a form at runtime

2022-02-26 Thread Tracy Pearson
This happens to me when the anchor is set on the control.

Tracy

On February 26, 2022 6:08:22 PM EST, paul.newton.h...@gmail.com wrote:
>Hi all
>
> 
>
>I am trying to reposition controls on a form at runtime and all is working
>well, except for one control (Microsoft Web Browser olecontrol).  I can
>adjust its width and height, but whatever I have tried fails to move the
>control to a new Top and Left position on the form.
>
> 
>
>I have tried setting Top and Left on the control and its object (i.e. on
>MyOLEControl and on MyOLEControl.Object.  I have tried in the form Init, in
>the form Activate and from a command button Click event after the form has
>displayed.  All to no avail.
>
> 
>
>Am I missing something here?  I can probably resolve the problem by putting
>the oleControl inside a container and then moving the container, but I would
>rather not have to do that.
>
> 
>
>Many thanks
>
> 
>
>Paul Newton
>
> 
>
>
>
>--- StripMime Report -- processed MIME parts ---
>multipart/alternative
>  text/plain (text body -- kept)
>  text/html
>---
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/c8557d5a-c727-4e80-801e-5859a378d...@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Back from the Dead & MS PowerApps...

2022-02-24 Thread Tracy Pearson
Good luck,  Kurt.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt @
Gmail
Sent: Thursday, February 24, 2022 5:32 PM
To: profoxt...@leafe.com
Subject: Re: Back from the Dead & MS PowerApps...

Thanks SO Much RK - its Great to hear from you again!!

-K

On 2/24/2022 2:30 PM, Richard Kaye wrote:
> Good luck with the latest search, Kurt.
>
> --
>
> rk
>
> From: ProfoxTech  On Behalf Of Kurt @ Gmail
> Sent: Thursday, February 24, 2022 5:27 PM
> To: profoxt...@leafe.com
> Subject: Back from the Dead & MS PowerApps...
>
> Hey there folks,
>
> I know its been a while since many of you last heard from me. Yeah, I
> used to be Very Active on this forum some years ago. I did manage to get
> an Awesome 3D Printing job last year in July, it was Truly my Dream Job.
> And, that's not an exaggeration. But, alas - situation went FUBAR, and
> the co. let go 40% of workforce between Cali & Texas operations -
> including me...
>
> So, I'm Back to Searching for a job, and also back to maybe being a
> little more active on here. As I'm now looking at programming jobs, as
> well as 3D Printing related jobs.
>
> Anyway, I came across this job listing, which of course mentioned
> FoxPro. But, then it also mentioned MS PowerApps. I'd Never heard of
> that. And, a quick search seems to show you can do Drag&Drop screen
> design, with little coding required.
>
> As such, I was curious to know if Anyone here had any experience with
> that!?!?
>
> OK, its back to the job search now. I look forward to hearing back from
> the Hive Mind here.
>
> Regards,
> Kurt
>
>
>
> --- 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/001201d829d1$555ab020$00101060$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: Problem with bbControls and MFC70.DLL

2022-02-13 Thread Tracy Pearson
Place it in the same directory as the OCX file.

Tracy

P.S. It could be in the path environment variable. This is not recommended as 
older versions have vulnerabilities, or could be changed to be a vulnerability.

On February 13, 2022 7:52:24 AM EST, paul.newton.h...@gmail.com wrote:
>Hi all
>
> 
>
>I am trying to install a couple of Bela Bodec's ActiveX controls but the
>OCXs fail to load - "Unable to load OCX!"
>
> 
>
>I know that MFC70.DLL is required and I have a copy which came with the
>controls but I am not sure what to do with it: 
>
> 
>
>Which place(s) should I copy it to (I am running Win 10) and will I need to
>register it with REGSVR32?  I have already tried to run REGSVR32 against
>MFC70.DLL in its present location but that also fails ("The module MFC70.DLL
>failed to load").
>
> 
>
>Many thanks
>
> 
>
>Paul Newton
>
>
>
>--- StripMime Report -- processed MIME parts ---
>multipart/alternative
>  text/plain (text body -- kept)
>  text/html
>---
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/97328481-c687-4d3c-b715-4c0e0813e...@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Pictures and fontnames in dropdown lists and listboxes

2022-02-11 Thread Tracy Pearson
One of the RowSourceTypes for these controls is Popup. 
A Popup can be configured to have different fonts and images.

   LOCAL oForm
   oForm = CREATEOBJECT("formtest")
   oForm.Show(1)

   DEFINE CLASS formtest as Form 
   width = 400

   ADD OBJECT myListBox as Listbox WITH RowSourceType = 9, RowSource =
"listBoxPopup", width = 400
   
   PROCEDURE Load 
  DEFINE POPUP listBoxPopup 
  DEFINE BAR 1 OF listBoxPopup PROMPT "Comic Sans MS" FONT "Comic Sans
MS", 24 
  DEFINE BAR 2 OF listBoxPopup PROMPT "Consolas" FONT "Consolas", 14
  DEFINE BAR 3 OF listBoxPopup PROMPT "Segoe UI" FONT "Segoe UI", 18
   ENDPROC 
   
   ENDDEFINE

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
paul.newton.h...@gmail.com
Sent: Friday, February 11, 2022 9:00 AM
To: profoxt...@leafe.com
Subject: Pictures and fontnames in dropdown lists and listboxes

Hi all

 

I have come up with a rather frustrating anomaly.  In the debugger I can set
the picture of a particular item in a listbox or dropdown list like this
(THIS is either one of the two controls)

 

THIS.Picture(nListIndex) = "SomePicture.BMP" and it works in both cases.
But if I try this

THIS.FontNamer(nListIndex) = "SomeFontName" it does not work even though
THIS.FontNamer(nListIndex) is a property which I can change in the debugger.

 

Does anybody have any thoughts or insights on this or is it "just one of
those things".

 

Many thanks

 

Paul Newton

 



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

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/000c01d81f52$88f9c800$9aed5800$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Transparent commandbuttons in Windows 11

2022-01-31 Thread Tracy Pearson
I see this is only happening when the SpecialEffect is set to 0 - 3D which
is the default.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Tracy
Pearson
Sent: Monday, January 31, 2022 3:43 PM
To: profoxt...@leafe.com
Subject: Transparent commandbuttons in Windows 11

Nothing fancy, it appears to come for free when running on Windows 11.

If you have a button hiding something under it, it might show up through it.

Tracy


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/007301d816e4$39558490$ac008db0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Transparent commandbuttons in Windows 11

2022-01-31 Thread Tracy Pearson
Nothing fancy, it appears to come for free when running on Windows 11.

If you have a button hiding something under it, it might show up through it.

Tracy


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/007201d816e3$1af96990$50ec3cb0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: CABuilder Revisited

2022-01-17 Thread Tracy Pearson
The _browser variable is a VFP variable pointing to the Class Browser. 
If you are using VFP Advanced, the Windows file virtualization is turned
off. By default this will attempt to access and write a file in the Program
Files directory. This will only work if you are running VFP in
administrative mode. 

If you are using VFP 9 SP 2, the browser.dbf will be virtualized and all
should still work.

Tracy


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Man-wai
Chang
Sent: Sunday, January 16, 2022 9:27 AM
To: profoxt...@leafe.com
Subject: Re: CABuilder Revisited

Knowing nothing about CABuilder:

I would just trace variables _browser and lcClassList in the source
codes and hopefully something could be found  it looked like it's
trying to bring up the web browser? Or was _browser a form? Well
:)

On Sun, Jan 16, 2022 at 12:29 AM Graham Brown  wrote:
> I posted before about the CABuilder tool asking for the original disk then
> failing to find anything.
> I traced the code and found the last line "Do (_browser) with
(lcClassList)"
> was causing the error and commenting this line allowed the code to
complete
> correctly. I have no idea what dependencies this needs and why it would
> fail.

[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/000f01d80bae$f3980170$dac80450$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Problem trying to run a Powershell script as an Explorer shell command (Fox related)

2022-01-07 Thread Tracy Pearson
Now it might be the quote marks and the parameters. Perhaps a single quote
mark. 

"C:\Temp\Test1.PS1 '%1'"

Embedded quotes. 

I'm grabbing at straws here.
The original entry was this:
"C:\Program Files (x86)\Microsoft Visual FoxPro 9\vfp9.exe" -SHELLOPEN "%1"


Me, I had created config.fpw files for each of my projects that have a
command entry to run a startup.prg that does my environment setup and opens
my project files.

I've not gotten myself into PowerShell. I'm so used to a command prompt from
the DOS days when we started Windows from a command.

HTH,
Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
paul.newton.h...@gmail.com
Sent: Friday, January 07, 2022 6:10 PM
To: profoxt...@leafe.com
Subject: RE: Problem trying to run a Powershell script as an Explorer shell
command (Fox related)

Hi Tracy

I tried setting the command in the registry to 
"C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe"
"C:\Temp\Test1.PS1" "%1"

I no longer get an error but all I see is a PowerShell window which flashes
on the screen briefly and then closes ...

Paul

-Original Message-
From: ProfoxTech  On Behalf Of Tracy Pearson
Sent: 07 January 2022 22:55
To: profoxt...@leafe.com
Subject: RE: Problem trying to run a Powershell script as an Explorer shell
command (Fox related)

You may need the fully qualified path to the PowerShell executable for it to
work.

HTH,
Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
paul.newton.h...@gmail.com
Sent: Friday, January 07, 2022 5:43 PM
To: profoxt...@leafe.com
Subject: Problem trying to run a Powershell script as an Explorer shell
command (Fox related)

Hi all

 

I have been toying on and off over several years with a method of opening
VFP with a MODIFY command when double-clicking a file in Explorer.  For
example, double-clicking on a PJX in Explorer should open VFP with the
command MODIFY PROJECT  NOWAIT.

 

I am almost there, maybe.  At the moment everything is in C:\Temp

 

ConFig.FPW contains

Command = C:\Temp\FoxOpen.PRG 

*FoxOpen.PRG is constructed on-the fly by a PowerShell script TEST.PS1 as
follows:

 

TEST.PS1

Param([string]$a)

$file=Get-Item "$a"

$Extension = $file.Extension.ToUpper()

$Command = ""

switch ($Extension)

{

.PJX

{

$Command = "Modify Project '"+ $a + "' NOWAIT"

}

   # Other cases follow

}

Set-Content -Path C:\Temp\FoxOpen.PRG -Value $Command

& "C:\Program Files (x86)\Microsoft Visual FoxPro 9\vfp9.exe"
-CC:\Temp\Config.FPW

 

I have tested this in a PowerShell console like this

PS C:\Temp> C:\Temp\Test.PS1  where  is a fully qualified
path to a PJX, enclosed in single quotes

 

I have also tested in a COMMAND window like this

C:\Temp> PowerShell C:\Temp\Test.PS1  again where  is a
fully qualified path to a PJX, enclosed in single quotes

 

So far, so good.  Now for how to implement the shell command.  My registry
settings are as follows:

 

Computer\HKEY_CLASSES_ROOT

PJXFile  (Default)  REG-SZ Project (FoxPro)

Shell  (Default)  REG_SZ (value not set)

Modify project  (Default) REG_SZ (value not
set)

Command   (Default)
REG_SZ "POWERSHELL C:\Temp\Test1.PS1" "%1"

 

However, double-clicking on a PJX results in:

Windows cannot access the specified device, path or file. You may not have
the appropriate permissions to access the item.

 

It seems as if I am nearly there, so any suggestions will be very gratefully
received.  Many thanks

 

Paul Newton

 

P.S. My first attempt at doing anything useful with PowerShell



--- 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/00f401d8041d$2206bfe0$66143fa0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Problem trying to run a Powershell script as an Explorer shell command (Fox related)

2022-01-07 Thread Tracy Pearson
You may need the fully qualified path to the PowerShell executable for it to
work.

HTH,
Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
paul.newton.h...@gmail.com
Sent: Friday, January 07, 2022 5:43 PM
To: profoxt...@leafe.com
Subject: Problem trying to run a Powershell script as an Explorer shell
command (Fox related)

Hi all

 

I have been toying on and off over several years with a method of opening
VFP with a MODIFY command when double-clicking a file in Explorer.  For
example, double-clicking on a PJX in Explorer should open VFP with the
command MODIFY PROJECT  NOWAIT.

 

I am almost there, maybe.  At the moment everything is in C:\Temp

 

ConFig.FPW contains

Command = C:\Temp\FoxOpen.PRG 

*FoxOpen.PRG is constructed on-the fly by a PowerShell script TEST.PS1 as
follows:

 

TEST.PS1

Param([string]$a)

$file=Get-Item "$a"

$Extension = $file.Extension.ToUpper()

$Command = ""

switch ($Extension)

{

.PJX

{

$Command = "Modify Project '"+ $a + "' NOWAIT"

}

   # Other cases follow

}

Set-Content -Path C:\Temp\FoxOpen.PRG -Value $Command

& "C:\Program Files (x86)\Microsoft Visual FoxPro 9\vfp9.exe"
-CC:\Temp\Config.FPW

 

I have tested this in a PowerShell console like this

PS C:\Temp> C:\Temp\Test.PS1  where  is a fully qualified
path to a PJX, enclosed in single quotes

 

I have also tested in a COMMAND window like this

C:\Temp> PowerShell C:\Temp\Test.PS1  again where  is a
fully qualified path to a PJX, enclosed in single quotes

 

So far, so good.  Now for how to implement the shell command.  My registry
settings are as follows:

 

Computer\HKEY_CLASSES_ROOT

PJXFile  (Default)  REG-SZ Project (FoxPro)

Shell  (Default)  REG_SZ (value not set)

Modify project  (Default)
REG_SZ (value not set)

Command   (Default)
REG_SZ "POWERSHELL C:\Temp\Test1.PS1" "%1"

 

However, double-clicking on a PJX results in:

Windows cannot access the specified device, path or file. You may not have
the appropriate permissions to access the item.

 

It seems as if I am nearly there, so any suggestions will be very gratefully
received.  Many thanks

 

Paul Newton

 

P.S. My first attempt at doing anything useful with PowerShell



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


RE: ProTip: Still using the Project Manager?

2021-12-29 Thread Tracy Pearson
Yes. That is true. 
So you can use "COMMAND" in the place of "PROJECT MANAGER". 
Or make it Procedure you call passing in what the Title of the Outer window
and what Window it should hold.

Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff
Roberts
Sent: Wednesday, December 29, 2021 3:08 PM
To: profoxt...@leafe.com
Subject: Re: ProTip: Still using the Project Manager?

If the command window is dockable you get the odd frame issue and if not
dockable you cannot move it outside the main Visual Foxpro window, correct?
-Jeff

On Wed, Dec 29, 2021 at 2:01 PM Tracy Pearson  wrote:

> You can turn Docking off on the Command window. You do not need to wrap
it.
> WDockable("COMMAND", .F.)
> OR
>Right click the title bar of the Command window and unselect Dockable
>
> That works for the Document View, Properties and Data Session windows.
>
>
> Have fun!
> Tracy
>
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff
> Roberts
> Sent: Wednesday, December 29, 2021 2:54 PM
> To: profoxt...@leafe.com
> Subject: Re: ProTip: Still using the Project Manager?
>
> I was curious if the same thing could be done to the Command window so I
> took Tracy's code and replaced "MyProjectWindow" with "MyCommandWindow"
and
> "Project Manager" with "Command". It did not seem to work as I wanted. Is
> the command window referenced by something other than "Command" or is it
> just a special window so it can't be manipulated the same way the "Project
> Manager" window can?
>
> On Wed, Dec 29, 2021 at 1:32 PM Tracy Pearson 
> wrote:
>
> > LOL
> >
> > It's fun to find a keyword that is in the product for backward
> > compatibility
> > that actually does something useful.
> >
> >
> > -Original Message-
> > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB
> > Software Solutions, LLC
> > Sent: Wednesday, December 29, 2021 2:21 PM
> > To: profoxt...@leafe.com
> > Subject: Re: ProTip: Still using the Project Manager?
> >
> > "This just inVisual FoxPro 9 support for *Mac Desktops*!"
> >
> > LOL!
> >
> >
> > On 12/28/2021 3:06 PM, Tracy Pearson wrote:
> > > If you are still using the Project Manager and are on a High DPI
> screen.
> > > When you move the window around it is not a very pleasant experience.
> > >
> > > This code will put the window in an outer window that does not have
the
> > > border issue.
> > >
> > >  DEFINE WINDOW MyProjectWIndow ;
> > >  FROM 0,0 ;
> > >  TO WROWS("Project Manager"),WCOLS("Project Manager") ;
> > >  CLOSE FLOAT GROW ZOOM MINIMIZE NOMDI ;
> > >  TITLE "Project Manager" ;
> > >  FONT WFONT(1,"Project Manager"), WFONT(2, "Project Manager")
> > >  SHOW WINDOW MyProjectWindow
> > >  ACTIVATE WINDOW "Project Manager" IN MyProjectWindow
> > >  MOVE WINDOW "Project Manager" TO 0,0
> > >
> > > And if you want the Project Manager to live outside the VFP window,
and
> > be
> > > available in the Windows Task Bar change the SHOW WINDOW command to
> this.
> > >
> > > SHOW WINDOW MyProjectWindow IN macdesktop
> > >
> > > If you do not need it in the Windows Task Bar, you could change the
> > DEFINE
> > > WINDOW line to include this.
> > >
> > >  IN DESKTOP
> > >
> > >
> > > The project manager needs to be open before you run this. You could
add
> a
> > > this before it.
> > >
> > >  MODIFY PROJECT 'TheAwesomeProject' NOWAIT
> > >
> > > Do you sometimes maximize windows you don't mean to? Change ZOOM to
> > NOZOOM.
> > >
> > > Works in VFP 9 and VFP Advanced.
> > >
> > > OR
> > >
> > > You could use Doug Hennig's Project Explorer
> > > https://github.com/DougHennig/ProjectExplorer
> > >
> > > Happy Coding!
> > > Tracy
> > >
> > >
> > > ___
> > > Post Messages to:ProFox@leafe.com
> > > Subscription Maintenance:
> https://mail.leafe.com/mailman/listinfo/profox
> > > OT-free version of this
> > list:https://mail.leafe.com/mailman/listinfo/profoxtech
> > > Searchable Archive:http

RE: ProTip: Still using the Project Manager?

2021-12-29 Thread Tracy Pearson
You can turn Docking off on the Command window. You do not need to wrap it.
WDockable("COMMAND", .F.)
OR
   Right click the title bar of the Command window and unselect Dockable

That works for the Document View, Properties and Data Session windows.


Have fun!
Tracy


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff
Roberts
Sent: Wednesday, December 29, 2021 2:54 PM
To: profoxt...@leafe.com
Subject: Re: ProTip: Still using the Project Manager?

I was curious if the same thing could be done to the Command window so I
took Tracy's code and replaced "MyProjectWindow" with "MyCommandWindow" and
"Project Manager" with "Command". It did not seem to work as I wanted. Is
the command window referenced by something other than "Command" or is it
just a special window so it can't be manipulated the same way the "Project
Manager" window can?

On Wed, Dec 29, 2021 at 1:32 PM Tracy Pearson  wrote:

> LOL
>
> It's fun to find a keyword that is in the product for backward
> compatibility
> that actually does something useful.
>
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB
> Software Solutions, LLC
> Sent: Wednesday, December 29, 2021 2:21 PM
> To: profoxt...@leafe.com
> Subject: Re: ProTip: Still using the Project Manager?
>
> "This just inVisual FoxPro 9 support for *Mac Desktops*!"
>
> LOL!
>
>
> On 12/28/2021 3:06 PM, Tracy Pearson wrote:
> > If you are still using the Project Manager and are on a High DPI screen.
> > When you move the window around it is not a very pleasant experience.
> >
> > This code will put the window in an outer window that does not have the
> > border issue.
> >
> >  DEFINE WINDOW MyProjectWIndow ;
> >  FROM 0,0 ;
> >  TO WROWS("Project Manager"),WCOLS("Project Manager") ;
> >  CLOSE FLOAT GROW ZOOM MINIMIZE NOMDI ;
> >  TITLE "Project Manager" ;
> >  FONT WFONT(1,"Project Manager"), WFONT(2, "Project Manager")
> >  SHOW WINDOW MyProjectWindow
> >  ACTIVATE WINDOW "Project Manager" IN MyProjectWindow
> >  MOVE WINDOW "Project Manager" TO 0,0
> >
> > And if you want the Project Manager to live outside the VFP window, and
> be
> > available in the Windows Task Bar change the SHOW WINDOW command to
this.
> >
> > SHOW WINDOW MyProjectWindow IN macdesktop
> >
> > If you do not need it in the Windows Task Bar, you could change the
> DEFINE
> > WINDOW line to include this.
> >
> >  IN DESKTOP
> >
> >
> > The project manager needs to be open before you run this. You could add
a
> > this before it.
> >
> >  MODIFY PROJECT 'TheAwesomeProject' NOWAIT
> >
> > Do you sometimes maximize windows you don't mean to? Change ZOOM to
> NOZOOM.
> >
> > Works in VFP 9 and VFP Advanced.
> >
> > OR
> >
> > You could use Doug Hennig's Project Explorer
> > https://github.com/DougHennig/ProjectExplorer
> >
> > Happy Coding!
> > Tracy
> >
> >
> > ___
> > Post Messages to:ProFox@leafe.com
> > Subscription Maintenance:https://mail.leafe.com/mailman/listinfo/profox
> > OT-free version of this
> list:https://mail.leafe.com/mailman/listinfo/profoxtech
> > Searchable Archive:https://leafe.com/archives
> > This
> message:
> https://leafe.com/archives/byMID/009c01d7fc26$5bcdcdd0$13696970$@pow
> erchurch.com
>
<https://leafe.com/archives/byMID/009c01d7fc26$5bcdcdd0$13696970$@powerchurc
h.com>
> > ** All postings, unless explicitly stated otherwise, are the opinions of
> the author, and do not constitute legal or medical advice. This statement
> is
> added to the messages for those lawyers who are too stupid to see the
> obvious.
>
> --
> Michael J. Babcock, MCP
> Fox/VFP dev since 1997
> Developer of FabNet estimating software - mbsoftwaresolutions.com
>
>
> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
>   text/plain (text body -- kept)
>   text/html
> ---
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/00a401d7fcee$d01c71a0$705554e0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: ProTip: Still using the Project Manager?

2021-12-29 Thread Tracy Pearson
LOL

It's fun to find a keyword that is in the product for backward compatibility
that actually does something useful.


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB
Software Solutions, LLC
Sent: Wednesday, December 29, 2021 2:21 PM
To: profoxt...@leafe.com
Subject: Re: ProTip: Still using the Project Manager?

"This just inVisual FoxPro 9 support for *Mac Desktops*!"

LOL!


On 12/28/2021 3:06 PM, Tracy Pearson wrote:
> If you are still using the Project Manager and are on a High DPI screen.
> When you move the window around it is not a very pleasant experience.
>
> This code will put the window in an outer window that does not have the
> border issue.
>
>  DEFINE WINDOW MyProjectWIndow ;
>  FROM 0,0 ;
>  TO WROWS("Project Manager"),WCOLS("Project Manager") ;
>  CLOSE FLOAT GROW ZOOM MINIMIZE NOMDI ;
>  TITLE "Project Manager" ;
>  FONT WFONT(1,"Project Manager"), WFONT(2, "Project Manager")
>  SHOW WINDOW MyProjectWindow
>  ACTIVATE WINDOW "Project Manager" IN MyProjectWindow
>  MOVE WINDOW "Project Manager" TO 0,0
>
> And if you want the Project Manager to live outside the VFP window, and be
> available in the Windows Task Bar change the SHOW WINDOW command to this.
>
> SHOW WINDOW MyProjectWindow IN macdesktop
>
> If you do not need it in the Windows Task Bar, you could change the DEFINE
> WINDOW line to include this.
>
>  IN DESKTOP
>
>
> The project manager needs to be open before you run this. You could add a
> this before it.
>
>  MODIFY PROJECT 'TheAwesomeProject' NOWAIT
>
> Do you sometimes maximize windows you don't mean to? Change ZOOM to
NOZOOM.
>
> Works in VFP 9 and VFP Advanced.
>
> OR
>
> You could use Doug Hennig's Project Explorer
> https://github.com/DougHennig/ProjectExplorer
>
> Happy Coding!
> Tracy
>
>
> ___
> Post Messages to:ProFox@leafe.com
> Subscription Maintenance:https://mail.leafe.com/mailman/listinfo/profox
> OT-free version of this
list:https://mail.leafe.com/mailman/listinfo/profoxtech
> Searchable Archive:https://leafe.com/archives
> This
message:https://leafe.com/archives/byMID/009c01d7fc26$5bcdcdd0$13696970$@pow
erchurch.com
> ** All postings, unless explicitly stated otherwise, are the opinions of
the author, and do not constitute legal or medical advice. This statement is
added to the messages for those lawyers who are too stupid to see the
obvious.

-- 
Michael J. Babcock, MCP
Fox/VFP dev since 1997
Developer of FabNet estimating software - mbsoftwaresolutions.com


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

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/00a301d7fcea$bc94e3a0$35beaae0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


ProTip: Still using the Project Manager?

2021-12-28 Thread Tracy Pearson
If you are still using the Project Manager and are on a High DPI screen.
When you move the window around it is not a very pleasant experience.

This code will put the window in an outer window that does not have the
border issue.

DEFINE WINDOW MyProjectWIndow ;
FROM 0,0 ;
TO WROWS("Project Manager"),WCOLS("Project Manager") ;
CLOSE FLOAT GROW ZOOM MINIMIZE NOMDI ;
TITLE "Project Manager" ;
FONT WFONT(1,"Project Manager"), WFONT(2, "Project Manager")
SHOW WINDOW MyProjectWindow
ACTIVATE WINDOW "Project Manager" IN MyProjectWindow
MOVE WINDOW "Project Manager" TO 0,0

And if you want the Project Manager to live outside the VFP window, and be
available in the Windows Task Bar change the SHOW WINDOW command to this.

   SHOW WINDOW MyProjectWindow IN macdesktop

If you do not need it in the Windows Task Bar, you could change the DEFINE
WINDOW line to include this.

IN DESKTOP


The project manager needs to be open before you run this. You could add a
this before it.

MODIFY PROJECT 'TheAwesomeProject' NOWAIT

Do you sometimes maximize windows you don't mean to? Change ZOOM to NOZOOM.

Works in VFP 9 and VFP Advanced.

OR

You could use Doug Hennig's Project Explorer
https://github.com/DougHennig/ProjectExplorer

Happy Coding!
Tracy


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/009c01d7fc26$5bcdcdd0$13696970$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Windows 11 ads and unexpected restarts on Win 10 Pro

2021-12-27 Thread Tracy Pearson
I don't work in a Windows 11 every day.
I have upgraded one of my laptops with VFP 9 and VFP Advanced.
As long as I am running Windows scaling at 100% I haven't seen any problems.
I don't work with reports much. But what I did work with them recently, they
worked. Until you went above 100%. Then the fonts in the report designer
were a bit wonky.

Pageframes in Windows 11 seem to have changed color in the runtime. Other
than that, I didn't see anything different.

HTH,
Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB
Software Solutions, LLC
Sent: Monday, December 27, 2021 4:26 PM
To: profoxt...@leafe.com
Subject: Re: Windows 11 ads and unexpected restarts on Win 10 Pro

Anybody else upgrade to Win11 yet and can comment on how your Fox IDE 
(and exes/rpts/etc) works with it?


On 12/16/2021 11:55 PM, data...@adam.com.au wrote:
> I have updated to windows 11 on 3 of my old laptops by editing the TPM
> settings in one of the DLLs of the setup. Windows 11 works and works well.
> IN fact it has made two of my laptops that were incredibly slow to become
> usable again. It looks like MS has finally broken the tradition of every
> second Windows release being garbage.
>
> -Original Message-
> From: ProFox  On Behalf Of Michael Oke, II
> Sent: Friday, 17 December 2021 3:13 PM
> To: ProFox Email List 
> Subject: Re: Windows 11 ads and unexpected restarts on Win 10 Pro
>
> Age perhaps.  My desktop is a few years old as is my laptop so they both
> lack the TPM 2.0 support as well as at least the laptop sporting an
> unsupported processor.
>
> -
> Michael Oke, II
> oke...@gmail.com
> 661-349-6221
> -
>
>
> On Thu, Dec 16, 2021 at 5:58 PM MB Software Solutions, LLC <
> mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
>
>> I wonder how my Win10Pro machine would differ from yours?
>>
>> On 12/16/2021 6:13 PM, Michael Oke, II wrote:
>>> I haven't seen anything of the sort but I'm not sure that either of
>>> my physical Windows 10 machines qualifies for the update.
>>>
>>> -
>>> Michael Oke, II
>>> oke...@gmail.com
>>> 661-349-6221
>>> -
>>>
>>>
>>> On Thu, Dec 16, 2021 at 2:21 PM MB Software Solutions, LLC <
>>> mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
>>>
 My Win10Pro dev machine decided to reboot overnight without any
 warning to me TWICE in the past week, and it had me quite pissed off.
 Thankfully my code was all saved (or at least 99% of it), but
 admittedly, I often leave my VFP window open and pick up where I
 left off the next day.

 As some of you may recall, I designed an app for managing my Beer
 League Hockey group (called the "Babs Hockey Fraternity" on
 Facebook--locations in two states now!), and initially, because it
 was so quick to get it up and going, I used a VFP DBC backend.  I
 also use Mr. Chen's VFP 10 exclusively for that too.  After a few
 crashes from VFP 10 corrupting the DBFs, I swapped out to the
 MariaDB backend instead.  (I've been using MySQL/MariaDB since I
 saw Bob Lee's n-tier presentation at GLGDW back in 2003.)

 Anyhooo.did anybody else get a similar behavior recently, with
 your computer asking you if you wanted the free upgrade to Win 11?


 --
 Michael J. Babcock, MCP
 Fox/VFP dev since 1997
 Developer of FabNet estimating software - mbsoftwaresolutions.com


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/008601d7fb6a$abc41ae0$034c50a0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Anyone on here involved with Virtual Fox Fest?

2021-12-21 Thread Tracy Pearson
Hi Chris,

Rick Schummer would be the better person to answer. I heard at the
conference they are considering having a one day Virtual FoxFest in the
spring and the live SWFox conference in the fall of 2021.

Hopefully Rick will confirm or deny.

Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Chris
Davis
Sent: Tuesday, December 21, 2021 8:54 AM
To: profoxt...@leafe.com
Subject: Anyone on here involved with Virtual Fox Fest?

Any idea if this link will be made available again?

https://virtualfoxfest.com/2020/

Thanks

Chris.



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

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/002701d7f678$74d84d40$5e88e7c0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: sftp for vfp6?

2021-12-01 Thread Tracy Pearson
I haven't used it for SFTP, but the Chilkat COM control has it.
https://chilkatsoft.com/

https://www.example-code.com/foxpro/sftp_uploadFile.asp

It looks like SFTP requires a license.

HTH,
Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff
Roberts
Sent: Wednesday, December 01, 2021 8:48 PM
To: profoxt...@leafe.com
Subject: sftp for vfp6?

Could anyone recommend a class or control I can use to add the ability to
send a file using sftp without too much complication to a VFP6 app? The ocx
we've using forever only does FTP. I looked at the old version of West Wind
Client Tools that works with VFP 6 but it looks like it only does FTP as
well.

-- 
Jeff Roberts | jefflrobe...@gmail.com


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

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/01a301d7e720$c8024280$5806c780$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: ReFox Or Something Like It

2021-11-19 Thread Tracy Pearson
If you have access to a command window in the app, and the app was built
with debug information. 
You may be able to access the form without Refox. 
If you have the ability to edit a report that is outside the App, you have
the ability to "MODIFY FORM" where you will get access to save it as
something different.
If you are in a VFP session, and you DO APP.EXE, you may be able to still
have the Command Window available to run the Modify Form.

Christof did a presentation demonstrating this many years ago.

HTH,
Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul H.
Tarver
Sent: Friday, November 19, 2021 12:21 PM
To: profoxt...@leafe.com
Subject: ReFox Or Something Like It

Ok, confession time: I've never had to un-compile a Foxpro .exe file. I've
prided myself on doing a pretty good job of backing up and protecting my
source code. Until today when I ran into a situation with a client who has
an application I last compiled in 2018. At some point after that
compilation, I must have accidently deleted one of the forms used by the
application. I still have a previous copy of the form from 2016, but there
changes made in between. I've checked every backup I have and apparently the
deletion must have occurred more than a year ago. 

 

I was aware that ReFox exists and since I do have the 2018 version of the
compiled application, I figured I would try ReFox to extract the form so I
could edit the 2016 version of the form to update the old version to the
latest version. 

 

However, every time I try to download the latest version of Refox, it gets
either blocked by my browser or it immediately gets deleted by my antivirus
even though I've told both to allow the download. So my question is this: Is
ReFox the way to go or is there another way I can accomplish this?

 

Thanks in advance!

 

Paul H. Tarver 
Tarver Program Consultants, Inc. 



 



--- 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/00b201d7dd86$4c5bf4d0$e513de70$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Reprots Field Properties override options

2021-11-18 Thread Tracy Pearson
I've been digging in to the code.
I have found that since I'm working in VFPAdvanced. The OS(3) is returning
"10" in Windows 10 and Windows 11.
So it is defaulting to the 8pt font size. Since the Case statement doesn't
have a setting for "10". 
Also, it only increases the font to 10pt when at 200% it should be 16pt.

The dpiaware classlib handles multiple scale factors. And I'm implementing
that in a local build for the needs I currently have. 

I will reach out to Joel as well.

Thank you,
Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Rick
Schummer
Sent: Thursday, November 18, 2021 1:31 PM
To: profoxt...@leafe.com
Subject: RE: Reprots Field Properties override options

You might want to reach out to Joel and ask him about his experience,
because I know he did this work to deal with this
problem.

Rick
White Light Computing, Inc.

www.whitelightcomputing.com

-Original Message-----
From: ProfoxTech  On Behalf Of Tracy Pearson
Sent: November 18, 2021 10:07 AM
To: profoxt...@leafe.com
Subject: RE: Reprots Field Properties override options

I have a 15" 4K laptop that I have configured my display to 2048x1152 at
100%. 
For a 13" you may need to go smaller. 
VFPAdvanced behaves better at higher DPIs, but there are still odd UI things
to contend with.

Tracy


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff
Roberts
Sent: Wednesday, November 17, 2021 10:07 AM
To: profoxt...@leafe.com
Subject: Re: Reprots Field Properties override options

I feel your pain. My laptop is 13" with a 4k screen and I have yet to find a
combination of settings that displays my
Visual Foxpro dev environment in a way that is overall pleasing to me. In
hindsight, I wish I would have just gotten the
HD screen. It's not only Foxpro that I have display issues with but it is a
big part of my overall dissatisfaction with
my new nearly $2k laptop...

On Wed, Nov 17, 2021 at 8:26 AM Eric Selje  wrote:

> / 13" 4K /  There's the problem.
>
> On Tue, Nov 16, 2021 at 4:46 PM Tracy Pearson 
> wrote:
>
> > I have gotten the latest build from VFPX. The dialogs are not 
> > increasing the size of the fonts as I need.
> > Sometimes I forget that the app I maintain has the Query Manager in 
> > it
> that
> > customers use for custom reports.
> > A customer reported that they have a 13" 4K laptop that custom 
> > reports
is
> > unusable.
> > So my task is working with this.
> > I'm looking at integrating the vfp_dpi_aware class I have shared in 
> > to
it
> > currently.
> > Though it will take some time for me to do a pull request.
> >
> > Tracy
> >
> >
> > -Original Message-
> > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of 
> > Rick Schummer
> > Sent: Tuesday, November 16, 2021 5:35 PM
> > To: profoxt...@leafe.com
> > Subject: RE: Reprots Field Properties override options
> >
> > Joel Leach made some changes to deal with DPI issues in the Report Apps.
> I
> > don't recall the specifics, but they are available already on 
> > VFPX.org
> >
> > Rick
> > White Light Computing, Inc.
> >
> > www.whitelightcomputing.com
> >
> > -Original Message-
> > From: ProfoxTech  On Behalf Of Tracy
> Pearson
> > Sent: November 15, 2021 04:10 PM
> > To: profoxt...@leafe.com
> > Subject: RE: Reprots Field Properties override options
> >
> > xSource - contains the ReportBuilder project.
> > These dialogs are part of the APP and can be adjusted.
> >
> > -Original Message-
> > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> Tracy
> > Pearson
> > Sent: Monday, November 15, 2021 11:31 AM
> > To: profoxt...@leafe.com
> > Subject: Reprots Field Properties override options
> >
> > Hello everyone,
> >
> > Is there something someone has already done to override the Fox Pro
> reports
> > Field Properties and Page Setup dialogs?
> >
> > When the application is configured to be DPI Aware, these will not
bitmap
> > scale and become fuzzy. They remain small and unreadable.
> >
> > There are other issues with the report writer as well that may need 
> > to addressed in VFP A.
> >
> > Thank you,
> > Tracy
> >
> >
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/009f01d7dcb0$5c468800$14d39800$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Reprots Field Properties override options

2021-11-18 Thread Tracy Pearson
I have a 15" 4K laptop that I have configured my display to 2048x1152 at
100%. 
For a 13" you may need to go smaller. 
VFPAdvanced behaves better at higher DPIs, but there are still odd UI things
to contend with.

Tracy


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff
Roberts
Sent: Wednesday, November 17, 2021 10:07 AM
To: profoxt...@leafe.com
Subject: Re: Reprots Field Properties override options

I feel your pain. My laptop is 13" with a 4k screen and I have yet to find
a combination of settings that displays my Visual Foxpro dev environment in
a way that is overall pleasing to me. In hindsight, I wish I would have
just gotten the HD screen. It's not only Foxpro that I have display issues
with but it is a big part of my overall dissatisfaction with my new nearly
$2k laptop...

On Wed, Nov 17, 2021 at 8:26 AM Eric Selje  wrote:

> / 13" 4K /  There's the problem.
>
> On Tue, Nov 16, 2021 at 4:46 PM Tracy Pearson 
> wrote:
>
> > I have gotten the latest build from VFPX. The dialogs are not increasing
> > the
> > size of the fonts as I need.
> > Sometimes I forget that the app I maintain has the Query Manager in it
> that
> > customers use for custom reports.
> > A customer reported that they have a 13" 4K laptop that custom reports
is
> > unusable.
> > So my task is working with this.
> > I'm looking at integrating the vfp_dpi_aware class I have shared in to
it
> > currently.
> > Though it will take some time for me to do a pull request.
> >
> > Tracy
> >
> >
> > -Original Message-
> > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Rick
> > Schummer
> > Sent: Tuesday, November 16, 2021 5:35 PM
> > To: profoxt...@leafe.com
> > Subject: RE: Reprots Field Properties override options
> >
> > Joel Leach made some changes to deal with DPI issues in the Report Apps.
> I
> > don't recall the specifics, but they are
> > available already on VFPX.org
> >
> > Rick
> > White Light Computing, Inc.
> >
> > www.whitelightcomputing.com
> >
> > -Original Message-
> > From: ProfoxTech  On Behalf Of Tracy
> Pearson
> > Sent: November 15, 2021 04:10 PM
> > To: profoxt...@leafe.com
> > Subject: RE: Reprots Field Properties override options
> >
> > xSource - contains the ReportBuilder project.
> > These dialogs are part of the APP and can be adjusted.
> >
> > -Original Message-
> > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> Tracy
> > Pearson
> > Sent: Monday, November 15, 2021 11:31 AM
> > To: profoxt...@leafe.com
> > Subject: Reprots Field Properties override options
> >
> > Hello everyone,
> >
> > Is there something someone has already done to override the Fox Pro
> reports
> > Field Properties and Page Setup dialogs?
> >
> > When the application is configured to be DPI Aware, these will not
bitmap
> > scale and become fuzzy. They remain small and
> > unreadable.
> >
> > There are other issues with the report writer as well that may need to
> > addressed in VFP A.
> >
> > Thank you,
> > Tracy
> >
> >
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/009801d7dc8d$f3e79960$dbb6cc20$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Reprots Field Properties override options

2021-11-16 Thread Tracy Pearson
I have gotten the latest build from VFPX. The dialogs are not increasing the
size of the fonts as I need.
Sometimes I forget that the app I maintain has the Query Manager in it that
customers use for custom reports.
A customer reported that they have a 13" 4K laptop that custom reports is
unusable. 
So my task is working with this.
I'm looking at integrating the vfp_dpi_aware class I have shared in to it
currently. 
Though it will take some time for me to do a pull request.

Tracy


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Rick
Schummer
Sent: Tuesday, November 16, 2021 5:35 PM
To: profoxt...@leafe.com
Subject: RE: Reprots Field Properties override options

Joel Leach made some changes to deal with DPI issues in the Report Apps. I
don't recall the specifics, but they are
available already on VFPX.org

Rick
White Light Computing, Inc.

www.whitelightcomputing.com

-Original Message-
From: ProfoxTech  On Behalf Of Tracy Pearson
Sent: November 15, 2021 04:10 PM
To: profoxt...@leafe.com
Subject: RE: Reprots Field Properties override options

xSource - contains the ReportBuilder project. 
These dialogs are part of the APP and can be adjusted.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Tracy
Pearson
Sent: Monday, November 15, 2021 11:31 AM
To: profoxt...@leafe.com
Subject: Reprots Field Properties override options

Hello everyone,

Is there something someone has already done to override the Fox Pro reports
Field Properties and Page Setup dialogs?

When the application is configured to be DPI Aware, these will not bitmap
scale and become fuzzy. They remain small and
unreadable.

There are other issues with the report writer as well that may need to
addressed in VFP A.

Thank you,
Tracy 


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/006a01d7db3b$cffb3820$6ff1a860$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Reprots Field Properties override options

2021-11-15 Thread Tracy Pearson
xSource - contains the ReportBuilder project. 
These dialogs are part of the APP and can be adjusted.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Tracy
Pearson
Sent: Monday, November 15, 2021 11:31 AM
To: profoxt...@leafe.com
Subject: Reprots Field Properties override options

Hello everyone,

Is there something someone has already done to override the Fox Pro reports
Field Properties and Page Setup dialogs?

When the application is configured to be DPI Aware, these will not bitmap
scale and become fuzzy. They remain small and unreadable.

There are other issues with the report writer as well that may need to
addressed in VFP A.

Thank you,
Tracy 


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/005a01d7da65$1c520b90$54f622b0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Reprots Field Properties override options

2021-11-15 Thread Tracy Pearson
Hello everyone,

Is there something someone has already done to override the Fox Pro reports
Field Properties and Page Setup dialogs?

When the application is configured to be DPI Aware, these will not bitmap
scale and become fuzzy. They remain small and unreadable.

There are other issues with the report writer as well that may need to
addressed in VFP A.

Thank you,
Tracy 


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/005001d7da3e$200ab880$60202980$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Open Web Site and Pass Login Info

2021-10-26 Thread Tracy Pearson
Chilkat is a third party tool that may be able to help with that. They have
VFP based examples.
https://www.chilkatsoft.com/

HTH,
Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Carl
Lindner
Sent: Tuesday, October 26, 2021 12:43 PM
To: profoxt...@leafe.com
Subject: Open Web Site and Pass Login Info

I want to use a form to open a web site and pass a user name and password.
I am lost!  How is it done?

 

Carl Lindner



--- 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/002a01d7ca89$c3681eb0$4a385c10$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Matt Slay

2021-10-11 Thread Tracy Pearson
That is sad to hear. He will be missed.
May his family be cared for and find blessings and comfort in this time.

Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Rick
Schummer
Sent: Monday, October 11, 2021 6:18 PM
To: profoxt...@leafe.com
Subject: Matt Slay

It is with great sadness and a heavy heart to share the news that Matt Slay
has passed away from COVID-19 earlier today.
You may recognize Matt for his many contributions to the Fox Community on
VFPX with the next generation of GoFish,
DynamicForms, assisting Jim Nelson and Doug Hennig with the development and
testing of Thor, inspiring the Go To
Definition feature in Thor, and the VFP language template for VS Code, just
to name a few of his contributions. Matt
also inspired other developers to create things for our community when he
was not tackling them himself. He was very
good at twisting arms of fellow Visual FoxPro developers to get other things
contributed.

Matt leaves behind his wife Sharon and two teenage sons. This is an absolute
gut punch and is a terrible way to
extinguish a shining star in our community.

Rick Schummer

Rick
White Light Computing, Inc.

www.whitelightcomputing.com



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/001201d7bef0$1f37d460$5da77d20$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Virtual Fox Fest 2021 (Oct): Early-Bird Ends Thursday

2021-10-01 Thread Tracy Pearson
It's saddens me to hear about your dad Paul. 
May you and your family have a positive experience and blessings.
Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard
Kaye
Sent: Friday, October 01, 2021 3:25 PM
To: profoxt...@leafe.com
Subject: RE: Virtual Fox Fest 2021 (Oct): Early-Bird Ends Thursday

Sorry to hear about your dad, Paul. I hope things move in a positive
direction for you and your family.

--

rk

-Original Message-
From: ProfoxTech  On Behalf Of Paul H. Tarver
Sent: Friday, October 1, 2021 3:10 PM
To: profoxt...@leafe.com
Subject: RE: Virtual Fox Fest 2021 (Oct): Early-Bird Ends Thursday

I hate I won't be able to attend this year as I was very much looking
forward to it. However, my father is currently in the hospital and we are
not sure if his next step is to rehab or what, so I can't commit to being
able to participate in this year's event. 

Have fun y'all!

Paul H. Tarver
Tarver Program Consultants, Inc.



[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/009001d7b6fc$14d4c060$3e7e4120$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Grid column text alignment shifts on first focus

2021-08-19 Thread Tracy Pearson
True or false have the same affect.

On August 19, 2021 12:05:26 PM EDT, Richard Kaye  wrote:
>How is sparse set?
>
>--
>
>rk
>
>-Original Message-
>From: ProfoxTech  On Behalf Of Tracy Pearson
>Sent: Thursday, August 19, 2021 11:51 AM
>To: profoxt...@leafe.com
>Subject: Grid column text alignment shifts on first focus
>
>I have a grid in my application that allows users to edit some columns.
>(Most of my grids don't allowCellSelection) There is 15 columns, the first two 
>do not allow editing, the rest do.
>The 2nd column alignment appears as top left until it is clicked in at which 
>time it aligns middle left like the other read only column.
>The other 13 columns are numeric and are all aligned middle right.
>The first 3 columns are locked. (lockcolumns = 3)
>
>I have set the alignment to middle left on the column and the textbox, yet it 
>still wants to first appear top left.
>
>I have set this in the properties on the grid class and in the init event I 
>also set them in the grid class.
>I have set this in the properties on the grid in the form and in the init 
>event of the form.
>I have placed a button on the form that when clicked it sets these properties.
>I have used the Grid.ActivateCell(1,2) to try to trick the grid. I set the 
>ReadOnly to false before I did.
>The When event returns a value on the form to prevent focus. It was allowing 
>focus when I attempted the ActivateCell.
>
>The text in that column does not align correctly until a row in that column is 
>clicked. I also notice a white line (highlight?) around the inside of the cell 
>when the cell is clicked. Once focus moves from that cell the highlight goes 
>away.
>
>Has anyone seen this and discovered the trouble behind it?
>
>Thank you,
>Tracy
>
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/f6ff5446-339a-47ab-8b9e-a38514699...@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Grid column text alignment shifts on first focus

2021-08-19 Thread Tracy Pearson
I have a grid in my application that allows users to edit some columns.
(Most of my grids don't allowCellSelection)
There is 15 columns, the first two do not allow editing, the rest do.
The 2nd column alignment appears as top left until it is clicked in at which
time it aligns middle left like the other read only column.
The other 13 columns are numeric and are all aligned middle right.
The first 3 columns are locked. (lockcolumns = 3)

I have set the alignment to middle left on the column and the textbox, yet
it still wants to first appear top left.

I have set this in the properties on the grid class and in the init event I
also set them in the grid class.
I have set this in the properties on the grid in the form and in the init
event of the form.
I have placed a button on the form that when clicked it sets these
properties.
I have used the Grid.ActivateCell(1,2) to try to trick the grid. I set the
ReadOnly to false before I did.
The When event returns a value on the form to prevent focus. It was allowing
focus when I attempted the ActivateCell.

The text in that column does not align correctly until a row in that column
is clicked. I also notice a white line (highlight?) around the inside of the
cell when the cell is clicked. Once focus moves from that cell the highlight
goes away.

Has anyone seen this and discovered the trouble behind it?

Thank you,
Tracy


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/001901d79511$f813aa60$e83aff20$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Virtual Fox Fest 2021 (October): Speakers, Sessions, and Registration

2021-08-17 Thread Tracy Pearson
It's now officially in the public view.
And you said something before me. 
I'm looking forward to the conference.

Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye
Sent: Tuesday, August 17, 2021 6:18 PM
To: profoxt...@leafe.com
Subject: RE: Virtual Fox Fest 2021 (October): Speakers, Sessions, and 
Registration

I see Tracy has signed up again as a speaker. 😊 Representing ProFox...

--

rk

-Original Message-
From: ProfoxTech  On Behalf Of Rick Schummer
Sent: Tuesday, August 17, 2021 5:13 PM
To: profoxt...@leafe.com
Subject: Virtual Fox Fest 2021 (October): Speakers, Sessions, and Registration

Speakers and sessions for Virtual Fox Fest 2021 (October) have been announced, 
and registration is open!
https://www.virtualfoxfest.com 

Rick
White Light Computing, Inc.

www.whitelightcomputing.com

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/008401d793b8$d6bdafa0$84390ee0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Disappearing pop-up windows (like the Find window dialog in Code References, and sometimes the entire Debug window)

2021-08-10 Thread Tracy Pearson
Hi Mike,

I suspect when your laptop is open in the dock it becomes Monitor #1, and the 
main monitors are in the negative numbers then.
Are these windows in the Screen or on the Desktop directly?

Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank 
Cazabon
Sent: Tuesday, August 10, 2021 8:58 AM
To: profoxt...@leafe.com
Subject: Re: Disappearing pop-up windows (like the Find window dialog in Code 
References, and sometimes the entire Debug window)

Hi Michael,

the resource file will store the position of the various windows, as I'm 
sure you know. If the left or top value gets set to something negative 
then it won't be visible. So maybe in your screen setup somehow things 
are getting changed around and you are ending up with a position off the 
screen somewhere?

If you know the debug window is the active window, you can press Alt, 
then left arrow, then down arrow, then "M" and you will be able to move 
the window with the arrow keys. That might give you a better idea of 
where the window is.

Frank.

Frank Cazabon

On 09/08/2021 9:57 pm, MB Software Solutions, LLC wrote:
> My workaround is to delete all the foxuser.id rows with 'debug' in 
> them but that's a PITA.
>
>
> On 8/9/2021 7:56 PM, MB Software Solutions, LLC wrote:
>> VFP9SP2 Win10Pro Dell Latitude 3400 and my favorite color today is red.
>>
>> Has anyone come across where your resource file just seems to get 
>> crazy and show windows in coordinates that are entirely off-monitor 
>> and you cannot see them?  I do!  Started not too long ago.  I use a 
>> dual-monitor setup and on very rare occasion have my laptop lid open 
>> too while on the dock for a (unintended) 3rd monitor display.  I can 
>> only guess that my re-arrange monitors perhaps has caused this.  It's 
>> very frustrating.  I've nuked the resource.dbf file a couple times 
>> but it repeats behavior.  (Off the top of my head, I can't recall if 
>> the ZAP of resource.dbf fixes it or not, but if it does, eventually 
>> it happens again where I cannot see the Find window.)
>>
>> Only thing more I can contribute: leftmost monitor is #1 and right 
>> (and sometimes middle) is #2.  Laptop sits at far right of my desk.
>>
>> Ideas?  Tia.
>>

[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/015001d78dea$cbd6bab0$63843010$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: New Job & The Silence is Killing Me...

2021-07-21 Thread Tracy Pearson
+1

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye
Sent: Wednesday, July 21, 2021 5:57 PM
To: profoxt...@leafe.com
Subject: RE: New Job & The Silence is Killing Me...

Congrats on the new gig, Kurt.

--

rk

-Original Message-
From: ProfoxTech  On Behalf Of Kurt at VR-FX
Sent: Tuesday, July 20, 2021 10:33 PM
To: profoxt...@leafe.com
Subject: New Job & The Silence is Killing Me...

Wow - seems like in the past month or so - its gotten VERY Quiet around here!!!

Seems an oddity occured - and I started getting these ProFox emails again to my 
main email addy. So - just noticed this recently...

And - for those that follow my Meanderings thru this thing we call life
- I was last working Tech support at Northrop-Grumman in Redondo Beach, CA - 
and was there for like 1 year and 2 months. Well - I know moved onto a New Gig 
- which may be my true DREAM JOB - as its a 3D Printing co. in Irvine - 
building Big and Hi-Tech and FAST 3D Printers! So - its VERY Cool indeed!!!

For those interest:Essentium.com

-Kurt

P.S. OK - my bad - after I started to write this I realized I should probably 
tag this as NF - although I DID start with a Q re: Quiet ProFox list...

[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/004301d77eba$5db07060$19115120$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Help or Opinions on GKKTools / VFP-Editors from ggreen86 from VFPX on github

2021-07-16 Thread Tracy Pearson
Hi Jeff,

I tried to get this working earlier this year. 
https://leafe.com/archives/full_thread/516219

Matt suggested I reach out on Foxite because that is where the author is
active.
I never did that. I did respond to one of the Issues on github, and never
saw a response from Greggory.

HTH,
Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff
Roberts
Sent: Friday, July 16, 2021 9:14 AM
To: profoxt...@leafe.com
Subject: Help or Opinions on GKKTools / VFP-Editors from ggreen86 from VFPX
on github

Hi everyone,

I've recently been working in Visual Foxpro again and while looking around
to see if I can improve my workflow I ran across the VFP-Editors and wanted
to try them out. I am not exactly sure where to put the files though and
what kind of setup needs to be done. I looked at the Editors zip and the
Support Files zip but it is not clear to me how to get up and running. Do
any of you use these tools, and if so, do you recommend them and/or know
how to get them working? Are you guys with active FoxPro projects using
anything else for editing or is the best solution to still use the VFP IDE
for everything? VFP seems to work pretty well on my Windows 10 Desktop but
I can't seem to get things the right size on my laptop. I think it may have
something to do with my laptop having a fancy screen with a high dpi. In my
perfect world, I think I would use vs code to do all my editing and build
with VFP but I do not think that is really possible is it? Thanks in
advance for any advice!

-- 
Jeff Roberts | jefflrobe...@gmail.com


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

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/002e01d77a48$2e9dda90$8bd98fb0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: VFP Label Height changes

2021-07-14 Thread Tracy Pearson
Crazy!

I tracked down what was happening.
There is a caption_assign method on the base label class.
This is triggered before the init event. 
The code in the caption_assign did not change the height of the label. It
did adjust the width of a label.
When the width was adjusted the height would change, but there is not a way
to capture that change and where it comes from.
I stepped through the code and never saw anything when I put an
height_assign method in there.

So to correct this, I have to change the width of the label after the form
has initialized.

BINDEVENT(THISFORM, "INIT", THIS, "AFTER_FORM_INIT", 1)

Awesome, it's working. 

Well, now I'm trying to launch a form that takes a parameter.

Local nId
nId = 2547
DO FORM TestForm with nId

That errors with something that makes no sense. (Function argument value,
type, or count is invalid.)

DO FORM TestForm with 2547

That works without an error.

Should I attempt to bind to the forms Show event? 
Should I trigger something in the forms visible_assign code?

I went with the visible_assign code today and the error isn't happening
anymore.

So, if you need to resize something that needs to reference the parent of an
object, don't do it in the child init method. Some properties don't stay as
you suspect them to. 

Have Fun!
Tracy


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Tracy
Pearson
Sent: Friday, July 09, 2021 9:44 AM
To: profoxt...@leafe.com
Subject: RE: VFP Label Height changes

Frank,

I originally went down that path. Then I put some code in the INIT of the
control on the form.
?PROGRAM(PROGRAM(-1)),"Height:",THIS.Height
DODEFAULT()

That was when I decided I needed to figure out a hack to get around the
problem. If it is telling me the height of the control at the INIT was 17
instead of 19 that was a problem.

When I changed the Height to be overwritten to 19 in the cNavButton class,
the above code correctly showed 19.
When I reset Height to default, it again showed 17.

I spent a few hours attempting to reproduce it in a new project. I am not
seeing the behavior currently. I'll may get some more time this weekend to
continue my efforts.


Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank
Cazabon
Sent: Thursday, July 08, 2021 10:48 AM
To: profoxt...@leafe.com
Subject: Re: VFP Label Height changes

Tracy,

you able to recreate this with base VFP controls and then maybe add in 
your controls one by one to see where it's happening?

Maybe there's some resizing code running or bindevents that does 
something "special"?

Frank.

Frank Cazabon

On 07/07/2021 4:46 pm, Tracy Pearson wrote:
> On cLabel and default everywhere used in this scenario.
> FontName: Segoe UI
> FontSize: 10
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
Richard
> Kaye
> Sent: Wednesday, July 07, 2021 4:40 PM
> To: profoxt...@leafe.com
> Subject: RE: VFP Label Height changes
>
> What is the default height for the font name and size used?
>
> --
>
> rk
>
> -Original Message-
> From: ProfoxTech  On Behalf Of Tracy Pearson
> Sent: Wednesday, July 7, 2021 3:37 PM
> To: profoxt...@leafe.com
> Subject: RE: VFP Label Height changes
>
> Autosize = .F.
> Alignment is centered
> The Label class doesn't have IntegralHeight.
>
>
> Tracy
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
Richard
> Kaye
> Sent: Wednesday, July 07, 2021 3:17 PM
> To: profoxt...@leafe.com
> Subject: RE: VFP Label Height changes
>
> Autosize? IntegralHeight?
>
> --
>
> rk
>
>
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/000601d778ec$dc6e4c70$954ae550$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: VFP Label Height changes

2021-07-09 Thread Tracy Pearson
Frank,

I originally went down that path. Then I put some code in the INIT of the
control on the form.
?PROGRAM(PROGRAM(-1)),"Height:",THIS.Height
DODEFAULT()

That was when I decided I needed to figure out a hack to get around the
problem. If it is telling me the height of the control at the INIT was 17
instead of 19 that was a problem.

When I changed the Height to be overwritten to 19 in the cNavButton class,
the above code correctly showed 19.
When I reset Height to default, it again showed 17.

I spent a few hours attempting to reproduce it in a new project. I am not
seeing the behavior currently. I'll may get some more time this weekend to
continue my efforts.


Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank
Cazabon
Sent: Thursday, July 08, 2021 10:48 AM
To: profoxt...@leafe.com
Subject: Re: VFP Label Height changes

Tracy,

you able to recreate this with base VFP controls and then maybe add in 
your controls one by one to see where it's happening?

Maybe there's some resizing code running or bindevents that does 
something "special"?

Frank.

Frank Cazabon

On 07/07/2021 4:46 pm, Tracy Pearson wrote:
> On cLabel and default everywhere used in this scenario.
> FontName: Segoe UI
> FontSize: 10
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
Richard
> Kaye
> Sent: Wednesday, July 07, 2021 4:40 PM
> To: profoxt...@leafe.com
> Subject: RE: VFP Label Height changes
>
> What is the default height for the font name and size used?
>
> --
>
> rk
>
> -Original Message-
> From: ProfoxTech  On Behalf Of Tracy Pearson
> Sent: Wednesday, July 7, 2021 3:37 PM
> To: profoxt...@leafe.com
> Subject: RE: VFP Label Height changes
>
> Autosize = .F.
> Alignment is centered
> The Label class doesn't have IntegralHeight.
>
>
> Tracy
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
Richard
> Kaye
> Sent: Wednesday, July 07, 2021 3:17 PM
> To: profoxt...@leafe.com
> Subject: RE: VFP Label Height changes
>
> Autosize? IntegralHeight?
>
> --
>
> rk
>
>
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/000c01d774c8$68a3b780$39eb2680$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: VFP Label Height changes

2021-07-07 Thread Tracy Pearson
There was no code in the Init of the subclass or form instances. 
I put that hack in the subclass, I followed it with a DODEFAULT().

Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jan
Bucek
Sent: Wednesday, July 07, 2021 4:44 PM
To: profoxt...@leafe.com
Subject: Re: VFP Label Height changes

DODEFAULT in Init?


Dne 7.7.2021 v 22:40 Richard Kaye napsal(a):
> What is the default height for the font name and size used?
> 
> --
> 
> rk
> 
> -Original Message-
> From: ProfoxTech  On Behalf Of Tracy Pearson
> Sent: Wednesday, July 7, 2021 3:37 PM
> To: profoxt...@leafe.com
> Subject: RE: VFP Label Height changes
> 
> Autosize = .F.
> Alignment is centered
> The Label class doesn't have IntegralHeight.
> 
> 
> Tracy
> 
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
Richard Kaye
> Sent: Wednesday, July 07, 2021 3:17 PM
> To: profoxt...@leafe.com
> Subject: RE: VFP Label Height changes
> 
> Autosize? IntegralHeight?
> 
> --
> 
> rk
> 
> 
> 
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/005d01d77371$7efb8330$7cf28990$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: VFP Label Height changes

2021-07-07 Thread Tracy Pearson
On cLabel and default everywhere used in this scenario.
FontName: Segoe UI
FontSize: 10

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard
Kaye
Sent: Wednesday, July 07, 2021 4:40 PM
To: profoxt...@leafe.com
Subject: RE: VFP Label Height changes

What is the default height for the font name and size used?

--

rk

-Original Message-
From: ProfoxTech  On Behalf Of Tracy Pearson
Sent: Wednesday, July 7, 2021 3:37 PM
To: profoxt...@leafe.com
Subject: RE: VFP Label Height changes

Autosize = .F. 
Alignment is centered
The Label class doesn't have IntegralHeight.


Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard
Kaye
Sent: Wednesday, July 07, 2021 3:17 PM
To: profoxt...@leafe.com
Subject: RE: VFP Label Height changes

Autosize? IntegralHeight?

--

rk



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/005c01d77371$2e403ee0$8ac0bca0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: VFP Label Height changes

2021-07-07 Thread Tracy Pearson
Autosize = .F. 
Alignment is centered
The Label class doesn't have IntegralHeight.


Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard
Kaye
Sent: Wednesday, July 07, 2021 3:17 PM
To: profoxt...@leafe.com
Subject: RE: VFP Label Height changes

Autosize? IntegralHeight?

--

rk

-Original Message-
From: ProfoxTech  On Behalf Of Tracy Pearson
Sent: Wednesday, July 7, 2021 2:07 PM
To: profoxt...@leafe.com
Subject: VFP Label Height changes

Maybe someone can tell me why this happens occasionally.

I have a base label (cLabel) in class library A.
I have a container (cNavButton) containing cLabel in class library B.
I have another container (cNavGroup) that will contain cNavButton also in
class library B.
There is a form (frm1 (based on cForm in class library A)) that has the
cNavGroup and 5 cNavButtons in it.
cLabel has a height set to 19.
cNavButton.cLabel is default
The cNavGroup.cNavButton.cLabel.Height in frm1 all show they are still
default (19).
Yet I have placed code in the Init event of cLabel to display the Height
onto the screen and I get 17.

VFP can be so random sometimes.

My hack to get around this behavior: in cNavButton, I have placed code in
cLabel.Init to see if the height is < 19 and reset the height to default.


[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/005001d77367$6e491cf0$4adb56d0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


VFP Label Height changes

2021-07-07 Thread Tracy Pearson
Maybe someone can tell me why this happens occasionally.

I have a base label (cLabel) in class library A.
I have a container (cNavButton) containing cLabel in class library B.
I have another container (cNavGroup) that will contain cNavButton also in
class library B.
There is a form (frm1 (based on cForm in class library A)) that has the
cNavGroup and 5 cNavButtons in it.
cLabel has a height set to 19.
cNavButton.cLabel is default
The cNavGroup.cNavButton.cLabel.Height in frm1 all show they are still
default (19).
Yet I have placed code in the Init event of cLabel to display the Height
onto the screen and I get 17.

VFP can be so random sometimes.

My hack to get around this behavior: in cNavButton, I have placed code in
cLabel.Init to see if the height is < 19 and reset the height to default.


___
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/004b01d7735a$f0389590$d0a9c0b0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Strange display of DropDownList in Grid

2021-06-28 Thread Tracy Pearson
Frank,

I think what happened with me was the font was getting to large. I was
attempting to get my font larger and possibly varied using the Popup
RowSourceType. It's only supported for backward compatibility so I'm not
going to use it. And it didn't work as I wanted it to.

Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank
Cazabon
Sent: Monday, June 28, 2021 8:07 AM
To: profoxt...@leafe.com
Subject: Re: Strange display of DropDownList in Grid

Hi Tracy,

sorry for the delay. I tried to stay away from the computer this 
weekend. My rowsourcetype = 1-value, style = 2-dropdown list

Frank.

Frank Cazabon

On 25/06/2021 5:18 pm, Tracy Pearson wrote:
> Frank,
> I'm tinkering with a dropdown for something completely different than this
> post, and what do I see? That picture you posted of the odd caret on the
> left of the dropdown and no text included.
>
> By chance, is your dropdown being populated with a RowSourceType = 9
> (popup) ???
>
>
> Tracy
>
> -Original Message-
> From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Frank Cazabon
> Sent: Wednesday, June 02, 2021 8:32 AM
> To: profox@leafe.com
> Subject: Re: Strange display of DropDownList in Grid
>
> Thanks for checking this out Tracy. It's a subclass from the framework I
> use (Visual MaxFrame Professional).
>
> I'll experiment some more today and see if I can tie it down.
>
> Frank.
>
> Frank Cazabon
>
> On 01/06/2021 5:12 pm, Tracy Pearson wrote:
>> I took another look at that. And I think that might be an odd scrollbar
>> happening because the height of the dropdown got screwed up. That is very
>> odd.
>>
>> Is that a standard combobox or one that has some customization?
>>
>> Tracy
>>
>>
>>
>> -Original Message-
>> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank
>> Cazabon
>> Sent: Tuesday, June 01, 2021 5:08 PM
>> To: profoxt...@leafe.com
>> Subject: RE: Strange display of DropDownList in Grid
>>
>> Thanks, I don't think that's the case here but I'll double check. I
hardly
>> ever use combo boxes, not sure why I did in this case. Maybe I'll just go
>> back to my normal way and replace this combo.
>>
>> On 1 June 2021 16:57:23 GMT-04:00, Tracy Pearson 
>> wrote:
>>> I see that on a ComboBox on a form when the underlying controlsource is
>>> a
>>> value that is not in the RowSource.
>>> I think it might be the reason in the grid as well.
>>>
>>> HTH,
>>> Tracy
>>>
>>> -Original Message-
>>> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
>>> Frank
>>> Cazabon
>>> Sent: Tuesday, June 01, 2021 3:22 PM
>>> To: profoxt...@leafe.com
>>> Subject: Re: Strange display of DropDownList in Grid
>>>
>>> Doh! forgot about the pictures not coming in the list. I've put it on
>>> imgur: https://imgur.com/a/eYWgr1b
>>>
>>> It's the only control in the column so sparse shouldn't be a problem.
>>>
>>> Not sure where/when to try calling thisform.cls()
>>>
>>> The problem seems to happen if I click anywhere in the combo, then move
>>>
>>> the mouse to try to select an item in the list (but don't actually
>>> click
>>> on anything).
>>>
>>> Frank.
>>>
>>> Frank Cazabon
>>>
>>> On 01/06/2021 3:05 pm, Tracy Pearson wrote:
>>>> Pictures don't come through the list.
>>>>
>>>> I have learned if one drags the scrollbar of a listbox below or above
>>> the
>>>> listbox, then select an item, the Item is not changed.
>>>>
>>>> I don't think that's what you are talking about.
>>>>
>>>> Does it have to do with the Column Sparse property?
>>>>
>>>> Does calling THISFORM.CLS() clear any odd drawing over the grid?
>>>>
>>>> The system I maintain has a ComboBox configured as a DropDown in a
>>> grid.
>>>> I've not heard any complaints about it.
>>>>
>>>> HTH,
>>>> Tracy
>>>>
>>>> -Original Message-
>>>> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
>>> Frank
>>>> Cazabon
>>>> Sent: Tuesday, June 01, 2021 2:56 PM
>>>> To: profoxt...@leafe.com
>>>> Subject: Strange display of DropDownList in Grid
>>>>
&

RE: Strange display of DropDownList in Grid

2021-06-25 Thread Tracy Pearson
Frank, 
I'm tinkering with a dropdown for something completely different than this
post, and what do I see? That picture you posted of the odd caret on the
left of the dropdown and no text included.

By chance, is your dropdown being populated with a RowSourceType = 9
(popup) ???


Tracy

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Frank Cazabon
Sent: Wednesday, June 02, 2021 8:32 AM
To: profox@leafe.com
Subject: Re: Strange display of DropDownList in Grid

Thanks for checking this out Tracy. It's a subclass from the framework I 
use (Visual MaxFrame Professional).

I'll experiment some more today and see if I can tie it down.

Frank.

Frank Cazabon

On 01/06/2021 5:12 pm, Tracy Pearson wrote:
> I took another look at that. And I think that might be an odd scrollbar
> happening because the height of the dropdown got screwed up. That is very
> odd.
>
> Is that a standard combobox or one that has some customization?
>
> Tracy
>
>
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank
> Cazabon
> Sent: Tuesday, June 01, 2021 5:08 PM
> To: profoxt...@leafe.com
> Subject: RE: Strange display of DropDownList in Grid
>
> Thanks, I don't think that's the case here but I'll double check. I hardly
> ever use combo boxes, not sure why I did in this case. Maybe I'll just go
> back to my normal way and replace this combo.
>
> On 1 June 2021 16:57:23 GMT-04:00, Tracy Pearson 
> wrote:
>> I see that on a ComboBox on a form when the underlying controlsource is
>> a
>> value that is not in the RowSource.
>> I think it might be the reason in the grid as well.
>>
>> HTH,
>> Tracy
>>
>> -Original Message-
>> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
>> Frank
>> Cazabon
>> Sent: Tuesday, June 01, 2021 3:22 PM
>> To: profoxt...@leafe.com
>> Subject: Re: Strange display of DropDownList in Grid
>>
>> Doh! forgot about the pictures not coming in the list. I've put it on
>> imgur: https://imgur.com/a/eYWgr1b
>>
>> It's the only control in the column so sparse shouldn't be a problem.
>>
>> Not sure where/when to try calling thisform.cls()
>>
>> The problem seems to happen if I click anywhere in the combo, then move
>>
>> the mouse to try to select an item in the list (but don't actually
>> click
>> on anything).
>>
>> Frank.
>>
>> Frank Cazabon
>>
>> On 01/06/2021 3:05 pm, Tracy Pearson wrote:
>>> Pictures don't come through the list.
>>>
>>> I have learned if one drags the scrollbar of a listbox below or above
>> the
>>> listbox, then select an item, the Item is not changed.
>>>
>>> I don't think that's what you are talking about.
>>>
>>> Does it have to do with the Column Sparse property?
>>>
>>> Does calling THISFORM.CLS() clear any odd drawing over the grid?
>>>
>>> The system I maintain has a ComboBox configured as a DropDown in a
>> grid.
>>> I've not heard any complaints about it.
>>>
>>> HTH,
>>> Tracy
>>>
>>> -Original Message-
>>> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
>> Frank
>>> Cazabon
>>> Sent: Tuesday, June 01, 2021 2:56 PM
>>> To: profoxt...@leafe.com
>>> Subject: Strange display of DropDownList in Grid
>>>
>>> It's just come to my attention that in a certain instance, if I have
>> a
>>> drop down list in a grid and I click on it then move the mouse as if
>> I
>>> am going to select one of the options, the display changes to this:
>>>
>>> Anyone seen this before and got a way to fix it?
>>>
>>> Sometimes it fixes itself other times it's a real pain to get rid of
>> and
>>> display the list properly.
>>>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/00aa01d76a07$b59dc510$20d94f30$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Builders and the VFP Undo function

2021-06-18 Thread Tracy Pearson
For those that have worked with builders. Has anyone noticed if the Undo
button on the toolbar worked to undo what a builder changed?

Thank you,
Tracy


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/004c01d76456$cc0f2a70$642d7f50$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Strange display of DropDownList in Grid

2021-06-01 Thread Tracy Pearson
I took another look at that. And I think that might be an odd scrollbar
happening because the height of the dropdown got screwed up. That is very
odd.

Is that a standard combobox or one that has some customization?

Tracy



-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank
Cazabon
Sent: Tuesday, June 01, 2021 5:08 PM
To: profoxt...@leafe.com
Subject: RE: Strange display of DropDownList in Grid

Thanks, I don't think that's the case here but I'll double check. I hardly
ever use combo boxes, not sure why I did in this case. Maybe I'll just go
back to my normal way and replace this combo.

On 1 June 2021 16:57:23 GMT-04:00, Tracy Pearson 
wrote:
>I see that on a ComboBox on a form when the underlying controlsource is
>a
>value that is not in the RowSource.
>I think it might be the reason in the grid as well.
>
>HTH,
>Tracy
>
>-Original Message-
>From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
>Frank
>Cazabon
>Sent: Tuesday, June 01, 2021 3:22 PM
>To: profoxt...@leafe.com
>Subject: Re: Strange display of DropDownList in Grid
>
>Doh! forgot about the pictures not coming in the list. I've put it on 
>imgur: https://imgur.com/a/eYWgr1b
>
>It's the only control in the column so sparse shouldn't be a problem.
>
>Not sure where/when to try calling thisform.cls()
>
>The problem seems to happen if I click anywhere in the combo, then move
>
>the mouse to try to select an item in the list (but don't actually
>click 
>on anything).
>
>Frank.
>
>Frank Cazabon
>
>On 01/06/2021 3:05 pm, Tracy Pearson wrote:
>> Pictures don't come through the list.
>>
>> I have learned if one drags the scrollbar of a listbox below or above
>the
>> listbox, then select an item, the Item is not changed.
>>
>> I don't think that's what you are talking about.
>>
>> Does it have to do with the Column Sparse property?
>>
>> Does calling THISFORM.CLS() clear any odd drawing over the grid?
>>
>> The system I maintain has a ComboBox configured as a DropDown in a
>grid.
>> I've not heard any complaints about it.
>>
>> HTH,
>> Tracy
>>
>> -Original Message-
>> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
>Frank
>> Cazabon
>> Sent: Tuesday, June 01, 2021 2:56 PM
>> To: profoxt...@leafe.com
>> Subject: Strange display of DropDownList in Grid
>>
>> It's just come to my attention that in a certain instance, if I have
>a
>> drop down list in a grid and I click on it then move the mouse as if
>I
>> am going to select one of the options, the display changes to this:
>>
>> Anyone seen this before and got a way to fix it?
>>
>> Sometimes it fixes itself other times it's a real pain to get rid of
>and
>> display the list properly.
>>
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/005701d7572a$cecdb670$6c692350$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Strange display of DropDownList in Grid

2021-06-01 Thread Tracy Pearson
I see that on a ComboBox on a form when the underlying controlsource is a
value that is not in the RowSource.
I think it might be the reason in the grid as well.

HTH,
Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank
Cazabon
Sent: Tuesday, June 01, 2021 3:22 PM
To: profoxt...@leafe.com
Subject: Re: Strange display of DropDownList in Grid

Doh! forgot about the pictures not coming in the list. I've put it on 
imgur: https://imgur.com/a/eYWgr1b

It's the only control in the column so sparse shouldn't be a problem.

Not sure where/when to try calling thisform.cls()

The problem seems to happen if I click anywhere in the combo, then move 
the mouse to try to select an item in the list (but don't actually click 
on anything).

Frank.

Frank Cazabon

On 01/06/2021 3:05 pm, Tracy Pearson wrote:
> Pictures don't come through the list.
>
> I have learned if one drags the scrollbar of a listbox below or above the
> listbox, then select an item, the Item is not changed.
>
> I don't think that's what you are talking about.
>
> Does it have to do with the Column Sparse property?
>
> Does calling THISFORM.CLS() clear any odd drawing over the grid?
>
> The system I maintain has a ComboBox configured as a DropDown in a grid.
> I've not heard any complaints about it.
>
> HTH,
> Tracy
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank
> Cazabon
> Sent: Tuesday, June 01, 2021 2:56 PM
> To: profoxt...@leafe.com
> Subject: Strange display of DropDownList in Grid
>
> It's just come to my attention that in a certain instance, if I have a
> drop down list in a grid and I click on it then move the mouse as if I
> am going to select one of the options, the display changes to this:
>
> Anyone seen this before and got a way to fix it?
>
> Sometimes it fixes itself other times it's a real pain to get rid of and
> display the list properly.
>

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/005601d75728$b8ef7c50$2ace74f0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Strange display of DropDownList in Grid

2021-06-01 Thread Tracy Pearson
Pictures don't come through the list.

I have learned if one drags the scrollbar of a listbox below or above the
listbox, then select an item, the Item is not changed.

I don't think that's what you are talking about.

Does it have to do with the Column Sparse property?

Does calling THISFORM.CLS() clear any odd drawing over the grid?

The system I maintain has a ComboBox configured as a DropDown in a grid.
I've not heard any complaints about it.

HTH,
Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank
Cazabon
Sent: Tuesday, June 01, 2021 2:56 PM
To: profoxt...@leafe.com
Subject: Strange display of DropDownList in Grid

It's just come to my attention that in a certain instance, if I have a 
drop down list in a grid and I click on it then move the mouse as if I 
am going to select one of the options, the display changes to this:

Anyone seen this before and got a way to fix it?

Sometimes it fixes itself other times it's a real pain to get rid of and 
display the list properly.

-- 

Frank.

Frank Cazabon



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

[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/005501d75719$1b41e060$51c5a120$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Formset goofy

2021-05-26 Thread Tracy Pearson
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/001601d7527b$0f7c7a30$2e756e90$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Form designer rules?

2021-05-26 Thread Tracy Pearson
I admit, I prefer to not use the UI controls that way. 
I also admit that I'm an enabler, and if people want to use the controls
that way I help. 
I should probably start adding something like: You could do it that way,
though it may not be as maintainable if you did X.

Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan
Bourke
Sent: Wednesday, May 26, 2021 8:42 AM
To: profoxt...@leafe.com
Subject: Re: Form designer rules?

On Mon, 24 May 2021, at 3:54 PM, Eric Selje wrote:

> I know you're all probably tired of hearing this drumbeat, but having SQL
> statements in UI controls is a bad idea. Do what you can to separate that
> out.

I agree.

[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/000301d75241$8b42ed50$a1c8c7f0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: Form designer rules?

2021-05-23 Thread Tracy Pearson
Combobox1 selects into a cursor. Use that cursor name in the where clause of 
the select statement in combobox2. 
In the valid event of combobox1, call the requery method of combobox2. 
The initial queries are processed after the form load event. They only requery 
when told to.

HTH
Tracy

On May 23, 2021 11:26:11 PM EDT, Joe Yoder  wrote:
>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/1f1ea044-67b3-4487-9573-71c08d7ba...@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Form designer rules?

2021-05-23 Thread Tracy Pearson
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/006801d74fea$04077c60$0c167520$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Navigating structure using list boxes?

2021-05-21 Thread Tracy Pearson
Hi Joe,

You can trigger the code in the Valid event of the Combobox.
Ted has frequently said that events should call methods. 
The Valid event may only have one line of code in it. 
   ThisForm.PopulateLevelTwo()

When the combobox is configured as a DropDown list the user may be more
keyboard focused, and type to get to the selection.
The Valid may fire for each keystroke. This is when you might consider using
the LostFocus event to prevent heavy IO related code.

Or what I consider might be one good use of a timer, the timer is enabled
and reset each time Valid fires. 
The Timer code will verify it is enabled, then disable itself, then call the
population code. If you can avoid using a timer, I would. They can stack up
and get triggered multiple times. 


HTH,
Tracy


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe
Yoder
Sent: Friday, May 21, 2021 3:37 PM
To: profoxt...@leafe.com
Subject: Re: Navigating structure using list boxes?

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/005d01d74e7d$d2e23e80$78a6bb80$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


AW: Searching classes and forms for something specific

2021-05-20 Thread Tracy Pearson
I spent some time last night looking at this unique repository. 
It's a nice idea, and I would enjoy using it, were it able to be used on my 
system.
There is no installer. There are inno script files that reference an E: drive. 
I would need to edit these.
There are two ActiveX controls that need to be registered. 
I was able to register the editor that is used by the PRG editor and I got to 
see that in action.
The other "ax_ug.ocx" would not register due to the side-by-side configuration 
is incorrect.
Looking at the manifest it requires Microsoft.VC80.CRT and Microsoft.VC80.MFC 
version 8.0.50727.6195. 
That is not on my system.

The intellisense I saw has less information about commands than is built in to 
VFP.

The first time I ran the PRG editor app, it asked me for a System.APP. I 
pointed it to the one I found in Doug Hennig's Project Explorer project. I 
found that it stored that location in the Windows Registry.
\HKEY_CURRENT_USER\SOFTWARE\GKK Industries\GKK Tools in the key SystemAPP.

This repository was created and all zip files uploaded April 16, 2021.
It has been forked by 3 others. The fork by s-s-a has pulled everything out of 
the zip files. It has an installer for each ActiveX control. Though I don't see 
a script for the installers. The installers are not signed either. I don't know 
who s-s-a is so I will not be running the installers on my systems.

So, I like the screenshots, the idea looks exciting. I do not want to take more 
time attempting to get it to work for me.

Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software 
Solutions, LLC
Sent: Wednesday, May 12, 2021 7:30 PM
To: profoxt...@leafe.com
Subject: Re: AW: Searching classes and forms for something specific

That looks REALLY COOL!!  Thanks for posting that!!!  Gonna try that soon!


On 5/12/2021 6:19 PM, Jürgen Wondzinski wrote:
> Maybe that's what you're looking for:
> VFPX VFP-Editors:
> https://github.com/ggreen86/VFP-Editors
>
> wOOdy
>
> -----Ursprüngliche Nachricht-
> Von: ProFox  Im Auftrag von Tracy Pearson
> Gesendet: Mittwoch, 12. Mai 2021 04:12
> An: profox@leafe.com
> Betreff: Searching classes and forms for something specific
>
> Is there a search tool out there that can search for criteria such as the
> following:
> The Column.Sparse is set to False. That same Column has a TextBox baseclass
> in it.
>
> I have already slowly parsed most instances of the Sparse property in my
> search.
> I know I can write something that can search for this specific query as
> well.
> I'm curious if there is a tool to help in the future.
>
> Thank you,
> Tracy
>
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/003a01d74d77$ea6e67b0$bf4b3710$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Navigating structure using list boxes?

2021-05-19 Thread Tracy Pearson
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/003601d74d04$91910fd0$b4b32f70$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Searching classes and forms for something specific

2021-05-11 Thread Tracy Pearson
Is there a search tool out there that can search for criteria such as the
following:
The Column.Sparse is set to False. That same Column has a TextBox baseclass
in it.

I have already slowly parsed most instances of the Sparse property in my
search. 
I know I can write something that can search for this specific query as
well.
I'm curious if there is a tool to help in the future.

Thank you,
Tracy


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/002101d746d4$3c71c8e0$baa0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: _framewk,vct is missing or invalid, but it isn't and it's not.

2021-05-04 Thread Tracy Pearson
Just a side note:
VFP A turns off the Virtualization that VFP 9 has.

I learned that when I was setting up FoxCodePlus to work in VFP A. It
doesn't work out of the box. And I type too fast for it. So I need to spend
some more time in the code. I have made notes in my forked repository.
https://github.com/Tracy-P/FoxcodePlus/blob/master/Installing_to_VFPA.md



-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted
Roche
Sent: Tuesday, May 04, 2021 9:53 AM
To: profoxt...@leafe.com
Subject: Re: _framewk,vct is missing or invalid, but it isn't and it's not.

Tracy: I do find the files in the Virtual Store. What's the best way to
fix, should I delete them?

On Tue, May 4, 2021 at 9:52 AM Ted Roche  wrote:

> I'm concerned that's solving a little problem with a big shotgun. This is
> a developer workstation that has been working okay for years, and a set of
> apps that do a lot of interprocess communication like Automation to
Office,
> and I don't want to create a bigger problem.
>
> On Tue, May 4, 2021 at 9:31 AM Frank Cazabon 
> wrote:
>
>> Grant the user (or everyone) full control?
>>
>> Could it be anything to do with that old virtualisation thing that
>> Windows used to do?
>>
>> Frank.
>>
>> Frank Cazabon
>>
>> On 04/05/2021 9:24 am, Ted Roche wrote:
>> > Rebuilding a project that includes c:\program files (x86)\microsoft
>> visual
>> > foxpro 9\wizards\_framewk.vcx gives the error
>> >
>> > Memo file c:\program files (x86)\microsoft visual foxpro
>> > 9\wizards\_framewk.VCT is missing or invalid.
>> >
>> > But it isn't and it's not.
>> >
>> > I copied both _framewk files from another machine where it works, no
>> > change. I opened the file exclusively and tried to PACK and get the
same
>> > error. I copy the two files to C:\temp and they pack fine, and compile
>> > classlib works there (after I also copied over _framewk.h) but moving
>> the
>> > files back to the above directory and attempting a build project,
>> rebuild
>> > all throws the same error.
>> >
>> > This is a permissions issue with the program files (x86) folder and
I've
>> > tried turning off the "Read Only" settings and in the folder
permissions
>> > granting Modify and Write to the Users group, but the errors continue.
>> >
>> > Any suggestions on how to get the Program files (x86) to be read-write
>> for
>> > VFP? Moving the files to the project folder would be my preference, but
>> it
>> > is not my project.
>> >
>> >
>> > --- StripMime Report -- processed MIME parts ---
>> > multipart/alternative
>> >text/plain (text body -- kept)
>> >text/html
>> > ---
>> >
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/000801d740ed$9268fda0$b73af8e0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: _framewk,vct is missing or invalid, but it isn't and it's not.

2021-05-04 Thread Tracy Pearson
I frequently just delete them when they corrupt there. The originals are
still in the protected place.


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted
Roche
Sent: Tuesday, May 04, 2021 9:53 AM
To: profoxt...@leafe.com
Subject: Re: _framewk,vct is missing or invalid, but it isn't and it's not.

Tracy: I do find the files in the Virtual Store. What's the best way to
fix, should I delete them?

On Tue, May 4, 2021 at 9:52 AM Ted Roche  wrote:

> I'm concerned that's solving a little problem with a big shotgun. This is
> a developer workstation that has been working okay for years, and a set of
> apps that do a lot of interprocess communication like Automation to
Office,
> and I don't want to create a bigger problem.
>
> On Tue, May 4, 2021 at 9:31 AM Frank Cazabon 
> wrote:
>
>> Grant the user (or everyone) full control?
>>
>> Could it be anything to do with that old virtualisation thing that
>> Windows used to do?
>>
>> Frank.
>>
>> Frank Cazabon
>>
>> On 04/05/2021 9:24 am, Ted Roche wrote:
>> > Rebuilding a project that includes c:\program files (x86)\microsoft
>> visual
>> > foxpro 9\wizards\_framewk.vcx gives the error
>> >
>> > Memo file c:\program files (x86)\microsoft visual foxpro
>> > 9\wizards\_framewk.VCT is missing or invalid.
>> >
>> > But it isn't and it's not.
>> >
>> > I copied both _framewk files from another machine where it works, no
>> > change. I opened the file exclusively and tried to PACK and get the
same
>> > error. I copy the two files to C:\temp and they pack fine, and compile
>> > classlib works there (after I also copied over _framewk.h) but moving
>> the
>> > files back to the above directory and attempting a build project,
>> rebuild
>> > all throws the same error.
>> >
>> > This is a permissions issue with the program files (x86) folder and
I've
>> > tried turning off the "Read Only" settings and in the folder
permissions
>> > granting Modify and Write to the Users group, but the errors continue.
>> >
>> > Any suggestions on how to get the Program files (x86) to be read-write
>> for
>> > VFP? Moving the files to the project folder would be my preference, but
>> it
>> > is not my project.
>> >
>> >
>> > --- StripMime Report -- processed MIME parts ---
>> > multipart/alternative
>> >text/plain (text body -- kept)
>> >text/html
>> > ---
>> >
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/000701d740ed$110de8b0$3329ba10$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: _framewk,vct is missing or invalid, but it isn't and it's not.

2021-05-04 Thread Tracy Pearson
Ted,

In the Windows Explorer there is a bar above the tree and file area that has
the path.
Click in the white space to the right and type the following
%localappdata%\VirtualStore\Program Files (x86)

You may find there is a "Micorsoft Visual FoxPro 9" folder there. It may
contain a corrupt _framewk.vcx.

HTH,
Tracy


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted
Roche
Sent: Tuesday, May 04, 2021 9:25 AM
To: profoxt...@leafe.com
Subject: _framewk,vct is missing or invalid, but it isn't and it's not.

Rebuilding a project that includes c:\program files (x86)\microsoft visual
foxpro 9\wizards\_framewk.vcx gives the error

Memo file c:\program files (x86)\microsoft visual foxpro
9\wizards\_framewk.VCT is missing or invalid.

But it isn't and it's not.

I copied both _framewk files from another machine where it works, no
change. I opened the file exclusively and tried to PACK and get the same
error. I copy the two files to C:\temp and they pack fine, and compile
classlib works there (after I also copied over _framewk.h) but moving the
files back to the above directory and attempting a build project, rebuild
all throws the same error.

This is a permissions issue with the program files (x86) folder and I've
tried turning off the "Read Only" settings and in the folder permissions
granting Modify and Write to the Users group, but the errors continue.

Any suggestions on how to get the Program files (x86) to be read-write for
VFP? Moving the files to the project folder would be my preference, but it
is not my project.


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

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/000301d740ea$3e1382f0$ba3a88d0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: VFP9 (and VFPA) on Windows 10 -- wish Mr. Chen would fix the visual bugs!

2021-04-30 Thread Tracy Pearson
Is this what you are talking about?
http://www.baiyujia.com/vfpdocuments/f_vfp9fix18.asp

This is what you need to do change the behavior. It does make it so you cannot 
dock the window by dragging it. You can still Dock the window with a command.  
(DOCK WINDOW)
http://www.baiyujia.com/vfpdocuments/f_vfp9fix19.asp

HTH, 
Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software 
Solutions, LLC
Sent: Friday, April 30, 2021 9:15 AM
To: profoxt...@leafe.com
Subject: Re: VFP9 (and VFPA) on Windows 10 -- wish Mr. Chen would fix the 
visual bugs!

No.  When I'm dragging the Project window (or is it the Properties 
window?) horizontally, it instantly shows a phantom outline to the 
right, far right of where I actually am in my drag/move operation.

On 4/29/2021 3:49 PM, Eric Selje wrote:
> One of the very first bugs he fixed was a phantom shadow bug. Are you
> talking about the one where if you drag a window it will leave a shadow of
> the frame of the window artifcated all over the screen?
>
> Eric
>
> On Thu, Apr 29, 2021 at 11:29 AM MB Software Solutions, LLC <
> mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
>
>> I finally moved my dev to a Windows 10 laptop.  Was using Win7 forever
>> prior.  The window dialog border "phantoms/shadows" is very annoying.
>> It'd be great if Mr. Chen fixed in addition to the other bugs he's fixed!
>>
>> (I think I have his name wrong...I've looked on his
>> http://www.baiyujia.com/vfpadvanced/f_vfpa_gotovfpa64.asp site but I
>> just see CCB)
>>
>>
[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/002a01d73dd3$426de0d0$c749a270$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Variations in CSV settings by region

2021-04-16 Thread Tracy Pearson
Richard,

I remember talking with Jean-Marie Laeremans about troubles he had with
imports. Different rows of data had a different number of delimiters. He
probably has some stories to tell about those days. Though I don't know how
traumatic it was for him.

Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard
Kaye
Sent: Friday, April 16, 2021 10:18 AM
To: profoxt...@leafe.com
Subject: RE: Variations in CSV settings by region

Thanks, Adam. I'm thinking we'll probably have to go down the road of
pre-parsing the CSV to determine what delimiters are being used and then
converting as needed. 

--

rk

-Original Message-
From: ProfoxTech  On Behalf Of Adam Buckland
Sent: Friday, April 16, 2021 10:01 AM
To: profoxt...@leafe.com
Subject: Re: Variations in CSV settings by region

When I worked for a data prep house (Late 1980s)  we used to use pipe
delimited files and wrote a C utility to strip files back removing the local
oddities.

Excel etc can import using various versions if you are using the GUI, not
sure about actually coding it but a short fox pro routing could read a line
at a time and replace commas with escaped commas and then replace semi
colons with commas.



On 16 Apr 2021, at 14:42, Richard Kaye  wrote:

Throwing this one out to the collective wisdom. We're doing a lot with CSV
import/experts these days with our web-based WWC application and are running
into issues with regionalization. Here in the US, a "standard" CSV means
commas between data elements and double quotes around text elements. But in
Belgium, the delimiter is the semi-colon and text elements are not wrapped
in double quotes. As best I can tell, Excel determines what format to use by
the OS settings and not its own application settings. This makes importing
from a CSV a bit of a dance for our Belgian clients as they have to change
their regional settings, import the file that was received in US format, and
then change their settings back. And, of course, changing region affects
date and currency formats. For those of you working with clients from
multiple locations where the standards may be different, what strategies do
you use to deal with this?

TIA

--

rk



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

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/003401d732cc$f6a8e520$e3faaf60$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Virtual Fox Fest 2021 (May): Time to Register

2021-04-06 Thread Tracy Pearson
Okay, I got my Virtual Fox Fest 2021 shirt. I'm ready for the gathering in a
month!

Tracy

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Rick Schummer
Sent: Tuesday, March 23, 2021 3:57 PM
To: profox@leafe.com
Subject: Virtual Fox Fest 2021 (May): Time to Register

Thanks to all who have already registered for Virtual Fox Fest
(https://virtualfoxfest.com; May 6, 2021); we appreciate
your support and our speakers are excited to share their sessions with you
soon.

That said, we know there are those who have not registered and have good
intentions to do so before the conference
starts. Please do so sooner than later. It literally takes minutes to
register. Here is the link:
http://geekgatherings.com/Registration

Our Virtual Fox Fest shirt store has been updated for 2021! Check it out at
https://geekgatherings.logosoftwear.com/.
You can choose your favorite color or put the VFF logo on any item
LogoSoftwear sells. You'll find instructions for
customizing your purchase at https://virtualfoxfest.com/geekwear.aspx.

After much consideration, we've decided to stick with a virtual event this
fall. It will be structured similarly to
Virtual Fox Fest 2020. Dates will be announced later. We're already looking
forward to a live Southwest Fox in 2022.

Rick
White Light Computing, Inc.

www.whitelightcomputing.com



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/002501d72b0c$40fbe190$c2f3a4b0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


  1   2   3   4   5   6   7   8   9   10   >