RE: VFP6: Silly Grid Question

Back to top

VFP6: Silly Grid Question

Author: Desmond Lloyd

Posted: 2014-05-05 14:39:51 Link

OK,

Defined a grid, data is not changed in the grid, display only. Marked

the grid as read only, works fine, however I would like to have the user

double click on a row and execute the click method of a button on the

form. (Display details)

Put the code in the double click event and no joy. Changed grid from read

only and make the individual columns read only. Data is not changeable,

have added the thisform.cmdedit.click() in various double click methods in

the text property, column and the grid, all to no avail...

Is this possible in VFP6, read only data displayed, double click

somewhere and execute a button click?

Regards,

Desmond

--- StripMime Report -- processed MIME parts ---

multipart/alternative

text/plain (text body -- kept)

text/html

---

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/CAAJXvaNt_Mf-=g3S2f=AGDvJ-Sb6na6vkL5UFtL9E0KF_W1cGA@mail.gmail.com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

New Search

Back to top

RE: VFP6: Silly Grid Question

Author: jerry foote

Posted: 2014-05-05 15:14:33 Link

Check AllowCellSelection.

Jerry

-----Original Message-----

From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Desmond Lloyd

Sent: Monday, May 05, 2014 2:40 PM

To: ProFox Email List

Subject: VFP6: Silly Grid Question

OK,

Defined a grid, data is not changed in the grid, display only. Marked

the grid as read only, works fine, however I would like to have the user

double click on a row and execute the click method of a button on the

form. (Display details)

Put the code in the double click event and no joy. Changed grid from read

only and make the individual columns read only. Data is not changeable,

have added the thisform.cmdedit.click() in various double click methods in

the text property, column and the grid, all to no avail...

Is this possible in VFP6, read only data displayed, double click

somewhere and execute a button click?

Regards,

Desmond

--- StripMime Report -- processed MIME parts ---

multipart/alternative

text/plain (text body -- kept)

text/html

---

[excessive quoting removed by server]

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/EDDC684A25834F88A62974167C3F5C4D@jerryfootePC

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

New Search

Back to top

Re: VFP6: Silly Grid Question

Author: Sytze de Boer

Posted: 2014-05-05 15:17:50 Link

What happens if you have a simple Command button (to do exactly the same as

a double click on the highlighted row)

On Tue, May 6, 2014 at 8:14 AM, jerry foote <jerryf@footegroup.com> wrote:

> Check AllowCellSelection.

> Jerry

>

> -----Original Message-----

> From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Desmond Lloyd

> Sent: Monday, May 05, 2014 2:40 PM

> To: ProFox Email List

> Subject: VFP6: Silly Grid Question

>

> OK,

>

> Defined a grid, data is not changed in the grid, display only. Marked

> the grid as read only, works fine, however I would like to have the user

> double click on a row and execute the click method of a button on the

> form. (Display details)

>

> Put the code in the double click event and no joy. Changed grid from read

> only and make the individual columns read only. Data is not changeable,

> have added the thisform.cmdedit.click() in various double click methods in

> the text property, column and the grid, all to no avail...

>

> Is this possible in VFP6, read only data displayed, double click

> somewhere and execute a button click?

>

> Regards,

> Desmond

>

> --- StripMime Report -- processed MIME parts ---

> multipart/alternative

> text/plain (text body -- kept)

> text/html

> ---

>

[excessive quoting removed by server]

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/CAG1nNy-PHS8iADDbVjshyUaF3vq277VLT6P71ckoJXfP2X8dbQ@mail.gmail.com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

New Search

Back to top

RE: VFP6: Silly Grid Question

Author: Jack Skelley

Posted: 2014-05-05 15:35:49 Link

Desmond:

Not sure why your double click in the textbox of a grid does not fire. I have many instances where in a readonly = .t. grid the double click / right click event fires and does 'something' in VFP 6 SP5.

For example a double click in a memo field in the grid takes that content and displays in in a larger editbox on a separate modal form. Also the rightclick event does the doubleclick method.

This is out of a 2 column grid with a checkbox and a textbox.

Grid setup:

ColumnCount = 2

FontBold = .T.

FontSize = 8

AllowRowSizing = .F.

DeleteMark = .F.

Height = 511

Left = 12

Panel = 1

RecordMark = .F.

RowHeight = 17

ScrollBars = 0

TabIndex = 4

ToolTipText = "Click name or check box at left to send the selected file to this scout...click again to uncheck..."

Top = 22

Width = 188

Name = "Grid1"

Column1.FontBold = .T.

Column1.FontSize = 8

Column1.ControlSource = ""

Column1.Width = 40

Column1.Movable = .F.

Column1.Resizable = .F.

Column1.ReadOnly = .F.

Column1.Sparse = .F.

Column1.Visible = .T.

Column1.DynamicBackColor = "IIF(MOD(RECNO(),2)=1,RGB(255,255,255),RGB(192,220,192))"

Column1.Name = "Column1"

Column2.FontBold = .T.

Column2.FontSize = 8

Column2.ControlSource = ""

Column2.Enabled = .T.

Column2.Width = 145

Column2.Movable = .F.

Column2.Resizable = .F.

Column2.ReadOnly = .T.

Column2.Visible = .T.

Column2.SelectOnEntry = .F.

Column2.DynamicBackColor = "IIF(MOD(RECNO(),2)=1,RGB(255,255,255),RGB(192,220,192))"

Column2.DynamicForeColor = 'iif(t_level<"3",rgb(255,0,0),rgb(0,0,0))'

Column2.Name = "Column2"

This is in the textbox methods

PROCEDURE DblClick

thisform.cntScouts.grid1.column1.check1.value = .f.

ENDPROC

PROCEDURE Click

if thisform.lstAttachments.listcount = 0 then

thisform.cntScouts.grid1.column1.check1.value = .f.

wait window "Please Make A File Selection Before Selecting A Recipient Scout..." timeout 2

return

endif

if thisform.lstAttachments.listcount > 0 and thisform.lstAttachments.listindex = 0 then

thisform.cntScouts.grid1.column1.check1.value = .f.

wait window "Please Make A File Selection Before Selecting A Recipient Scout..." timeout 2

return

endif

if left(tScouts.t_name,5) = "-----" then

thisform.cntScouts.grid1.column1.check1.value = .f.

wait window "This Entry Can Not Be Selected..." timeout 2

return

endif

if tScouts.t_mail then

thisform.cntScouts.grid1.column1.check1.value = .f.

else

thisform.cntScouts.grid1.column1.check1.value = .t.

endif

thisform.cntScouts.grid1.column1.check1.click()

thisform.cntScouts.grid1.refresh()

ENDPROC

PROCEDURE When

if thisform.lstAttachments.listcount = 0 then

wait window "Please Make A File Selection Before Selecting A Recipient Scout..." timeout 2

return

endif

if thisform.lstAttachments.listcount > 0 and thisform.lstAttachments.listindex = 0 then

wait window "Please Make A File Selection Before Selecting A Recipient Scout..." timeout 2

return

endif

ENDPROC

The checkbox control has basically more of the same...

Perhaps this will allow you to compare why your events are not firing.

Jack

Jack Skelley

Senior Director, Programming/Computer Operations

New Jersey Devils

(973)757-6164

JSkelley@newjerseydevils.com ________________________________________

From: ProfoxTech [profoxtech-bounces@leafe.com] on behalf of Desmond Lloyd [desmond.lloyd@gmail.com]

Sent: Monday, May 05, 2014 3:39 PM

To: profoxtech@leafe.com

Subject: VFP6: Silly Grid Question

OK,

Defined a grid, data is not changed in the grid, display only. Marked

the grid as read only, works fine, however I would like to have the user

double click on a row and execute the click method of a button on the

form. (Display details)

Put the code in the double click event and no joy. Changed grid from read

only and make the individual columns read only. Data is not changeable,

have added the thisform.cmdedit.click() in various double click methods in

the text property, column and the grid, all to no avail...

Is this possible in VFP6, read only data displayed, double click

somewhere and execute a button click?

Regards,

Desmond

--- StripMime Report -- processed MIME parts ---

multipart/alternative

text/plain (text body -- kept)

text/html

---

[excessive quoting removed by server]

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/7D9E7F72B813014C8FD022CF04F820EDF36CE559@EX08.drdad.thenewarkarena.com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

New Search

Back to top

Re: VFP6: Silly Grid Question

Author: Desmond Lloyd

Posted: 2014-05-05 15:42:45 Link

Thank you very much! Am in the middle of wrapping up some of the other

details on the detail screen, simple things like editing etc. Will wrap

up that and utilize your code to see what the blue blazes is going on....

Appreciate your help and input!

Regards,

Desmond

On 5 May 2014 15:35, Jack Skelley <JSkelley@newjerseydevils.com> wrote:

> Desmond:

> Not sure why your double click in the textbox of a grid does not fire. I

> have many instances where in a readonly = .t. grid the double click / right

> click event fires and does 'something' in VFP 6 SP5.

> For example a double click in a memo field in the grid takes that content

> and displays in in a larger editbox on a separate modal form. Also the

> rightclick event does the doubleclick method.

> This is out of a 2 column grid with a checkbox and a textbox.

> Grid setup:

> ColumnCount = 2

> FontBold = .T.

> FontSize = 8

> AllowRowSizing = .F.

> DeleteMark = .F.

> Height = 511

> Left = 12

> Panel = 1

> RecordMark = .F.

> RowHeight = 17

> ScrollBars = 0

> TabIndex = 4

> ToolTipText = "Click name or check box at left to send the selected file

> to this scout...click again to uncheck..."

> Top = 22

> Width = 188

> Name = "Grid1"

> Column1.FontBold = .T.

> Column1.FontSize = 8

> Column1.ControlSource = ""

> Column1.Width = 40

> Column1.Movable = .F.

> Column1.Resizable = .F.

> Column1.ReadOnly = .F.

> Column1.Sparse = .F.

> Column1.Visible = .T.

> Column1.DynamicBackColor =

> "IIF(MOD(RECNO(),2)=1,RGB(255,255,255),RGB(192,220,192))"

> Column1.Name = "Column1"

> Column2.FontBold = .T.

> Column2.FontSize = 8

> Column2.ControlSource = ""

> Column2.Enabled = .T.

> Column2.Width = 145

> Column2.Movable = .F.

> Column2.Resizable = .F.

> Column2.ReadOnly = .T.

> Column2.Visible = .T.

> Column2.SelectOnEntry = .F.

> Column2.DynamicBackColor =

> "IIF(MOD(RECNO(),2)=1,RGB(255,255,255),RGB(192,220,192))"

> Column2.DynamicForeColor = 'iif(t_level<"3",rgb(255,0,0),rgb(0,0,0))'

> Column2.Name = "Column2"

>

> This is in the textbox methods

> PROCEDURE DblClick

> thisform.cntScouts.grid1.column1.check1.value = .f.

> ENDPROC

> PROCEDURE Click

> if thisform.lstAttachments.listcount = 0 then

> thisform.cntScouts.grid1.column1.check1.value = .f.

> wait window "Please Make A File Selection Before Selecting A Recipient

> Scout..." timeout 2

> return

> endif

> if thisform.lstAttachments.listcount > 0 and

> thisform.lstAttachments.listindex = 0 then

> thisform.cntScouts.grid1.column1.check1.value = .f.

> wait window "Please Make A File Selection Before Selecting A Recipient

> Scout..." timeout 2

> return

> endif

> if left(tScouts.t_name,5) = "-----" then

> thisform.cntScouts.grid1.column1.check1.value = .f.

> wait window "This Entry Can Not Be Selected..." timeout 2

> return

> endif

> if tScouts.t_mail then

> thisform.cntScouts.grid1.column1.check1.value = .f.

> else

> thisform.cntScouts.grid1.column1.check1.value = .t.

> endif

> thisform.cntScouts.grid1.column1.check1.click()

> thisform.cntScouts.grid1.refresh()

> ENDPROC

> PROCEDURE When

> if thisform.lstAttachments.listcount = 0 then

> wait window "Please Make A File Selection Before Selecting A Recipient

> Scout..." timeout 2

> return

> endif

> if thisform.lstAttachments.listcount > 0 and

> thisform.lstAttachments.listindex = 0 then

> wait window "Please Make A File Selection Before Selecting A Recipient

> Scout..." timeout 2

> return

> endif

> ENDPROC

>

> The checkbox control has basically more of the same...

> Perhaps this will allow you to compare why your events are not firing.

> Jack

>

> Jack Skelley

> Senior Director, Programming/Computer Operations

> New Jersey Devils

> (973)757-6164

> JSkelley@newjerseydevils.com ________________________________________

> From: ProfoxTech [profoxtech-bounces@leafe.com] on behalf of Desmond

> Lloyd [desmond.lloyd@gmail.com]

> Sent: Monday, May 05, 2014 3:39 PM

> To: profoxtech@leafe.com

> Subject: VFP6: Silly Grid Question

>

> OK,

>

> Defined a grid, data is not changed in the grid, display only. Marked

> the grid as read only, works fine, however I would like to have the user

> double click on a row and execute the click method of a button on the

> form. (Display details)

>

> Put the code in the double click event and no joy. Changed grid from read

> only and make the individual columns read only. Data is not changeable,

> have added the thisform.cmdedit.click() in various double click methods in

> the text property, column and the grid, all to no avail...

>

> Is this possible in VFP6, read only data displayed, double click

> somewhere and execute a button click?

>

> Regards,

> Desmond

>

> --- StripMime Report -- processed MIME parts ---

> multipart/alternative

> text/plain (text body -- kept)

> text/html

> ---

>

[excessive quoting removed by server]

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/CAAJXvaPM0uK5cmKo8GDTXx7EncQvfitx6VDthBW133N_KTKYaw@mail.gmail.com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

New Search

Back to top

Re: VFP6: Silly Grid Question

Author: Desmond Lloyd

Posted: 2014-05-05 15:43:09 Link

Thank you,

That's what I've got.... And it works, think it is cool to be able to

double click on the row you are at to display/edit the details for the

record selected.....

On 5 May 2014 15:17, Sytze de Boer <sytze.kiss@gmail.com> wrote:

> What happens if you have a simple Command button (to do exactly the same as

> a double click on the highlighted row)

>

> On Tue, May 6, 2014 at 8:14 AM, jerry foote <jerryf@footegroup.com> wrote:

>

> > Check AllowCellSelection.

> > Jerry

> >

> > -----Original Message-----

> > From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Desmond

> Lloyd

> > Sent: Monday, May 05, 2014 2:40 PM

> > To: ProFox Email List

> > Subject: VFP6: Silly Grid Question

> >

> > OK,

> >

> > Defined a grid, data is not changed in the grid, display only. Marked

> > the grid as read only, works fine, however I would like to have the user

> > double click on a row and execute the click method of a button on the

> > form. (Display details)

> >

> > Put the code in the double click event and no joy. Changed grid from

> read

> > only and make the individual columns read only. Data is not changeable,

> > have added the thisform.cmdedit.click() in various double click methods

> in

> > the text property, column and the grid, all to no avail...

> >

> > Is this possible in VFP6, read only data displayed, double click

> > somewhere and execute a button click?

> >

> > Regards,

> > Desmond

> >

> > --- StripMime Report -- processed MIME parts ---

> > multipart/alternative

> > text/plain (text body -- kept)

> > text/html

> > ---

> >

[excessive quoting removed by server]

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/CAAJXvaN_JU2YUKLitAw7Vw4JcgHy3HG98g2fMWTbKCm+8_fHZA@mail.gmail.com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

New Search

Back to top

Re: VFP6: Silly Grid Question

Author: Laurie Alvey

Posted: 2014-05-06 05:12:33 Link

I don't think you can do this in VFP6. You need BINDEVENT() which arrived

(I think) in VFP8 .

Laurie

On 5 May 2014 21:43, Desmond Lloyd <desmond.lloyd@gmail.com> wrote:

> Thank you,

>

> That's what I've got.... And it works, think it is cool to be able to

> double click on the row you are at to display/edit the details for the

> record selected.....

>

> On 5 May 2014 15:17, Sytze de Boer <sytze.kiss@gmail.com> wrote:

>

> > What happens if you have a simple Command button (to do exactly the same

> as

> > a double click on the highlighted row)

> >

> > On Tue, May 6, 2014 at 8:14 AM, jerry foote <jerryf@footegroup.com>

> wrote:

> >

> > > Check AllowCellSelection.

> > > Jerry

> > >

> > > -----Original Message-----

> > > From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Desmond

> > Lloyd

> > > Sent: Monday, May 05, 2014 2:40 PM

> > > To: ProFox Email List

> > > Subject: VFP6: Silly Grid Question

> > >

> > > OK,

> > >

> > > Defined a grid, data is not changed in the grid, display only.

> Marked

> > > the grid as read only, works fine, however I would like to have the

> user

> > > double click on a row and execute the click method of a button on the

> > > form. (Display details)

> > >

> > > Put the code in the double click event and no joy. Changed grid from

> > read

> > > only and make the individual columns read only. Data is not

> changeable,

> > > have added the thisform.cmdedit.click() in various double click methods

> > in

> > > the text property, column and the grid, all to no avail...

> > >

> > > Is this possible in VFP6, read only data displayed, double click

> > > somewhere and execute a button click?

> > >

> > > Regards,

> > > Desmond

> > >

> > > --- StripMime Report -- processed MIME parts ---

> > > multipart/alternative

> > > text/plain (text body -- kept)

> > > text/html

> > > ---

> > >

[excessive quoting removed by server]

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/CAMvTR9di+HnOL7vNNVjgLqy+1-YV2Yk6ZbNXryvOnx2F-ruuKg@mail.gmail.com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

New Search