Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

how to detect column3 and recordnumber 3 in a foxpro grid?

70 views
Skip to first unread message

oecoep_kj

unread,
May 13, 2009, 4:05:16 AM5/13/09
to
how to detect column3 and recordnumber 3 in a foxpro grid?

Stefan Wuebbe

unread,
May 13, 2009, 4:37:52 AM5/13/09
to

"oecoep_kj" <u51873@uwe> wrote in message news:9601bc1886225@uwe...

> how to detect column3 and recordnumber 3 in a foxpro grid?
>

Hi oecoep,

The easiest way to get what I think you want is not to ask the Grid object
but rather its .RecordSource alias directly:

Assumed you know alias name and field name in advance, say "customers.cust_name":
luResult = customers.cust_name

If alias name and field name are unknown:
luResult = Evaluate(Thisform.myGrid.Column3.ControlSource)

As for the row number: the record pointer of a grid.RecordSource alias
always points to the row that is currently selected in the grid control by the user.

If you want to get a different one, then you might need to tell what "recordnumber
3" is - IOW, RecNo() might be a little ambiguous since 3<>3 with a given Set
Order To, or in a SQL "Select ... From ... Order By xy" result.


hth
-Setfan

--
|\_/| ------ ProLib - programmers liberty -----------------
(.. ) Our MVPs and MCPs make the Fox run....
- / See us at www.prolib.de or www.AFPages.de
-----------------------------------------------------------

0 new messages