How to figure out what is the active row in a grid? 1

[Aseem1234]

Hello,

I have a grid and I am trying to figure out which row the user selects in order to pull the information from that particular row and do some processing...however, i can't seem to figure out how to figure out which row is selected! Can someone help? I have the grid recordsource bound to a cursor.

Thanks

 

[craigsboyd]

The record pointer of the cursor will be pointing at the selected record/row...just pull your information from that cursor that you've set up as the recordsource.

[sub]craig1442@mchsi.com[/sub][sup]

"Whom computers would destroy, they must first drive mad." - Anon​

[/sup]

 

[Aseem1234]

So you mean I can just say select * from cursorName and it will pull the data from the row the user selected?

Thanks

 

[craigsboyd]

No, I'm saying that if you have a cursor let's say with 3 rows in it...

Fields:
FirstName LastName

Craig Boyd
John Smith
Bob Williams

...and this cursor is the recordsource for a grid and the user selects the row with John Smith in it then you can access the field values of the cursor...

?MyCursor.FirstName &&John
?MyCursor.LastName &&Smith

...selecting everything from the cursor as you have proposed above would just simply give you everything from the cursor, not the row's values.

[sub]craig1442@mchsi.com[/sub][sup]

"Whom computers would destroy, they must first drive mad." - Anon​

[/sup]