slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Architect Forums - Controls
Forum to discuss usage & tips for SalesLogix controls and other 3rd party ActiveX controls. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Controls | New Thread

View: Search:

Author

Thread: Grid: MultiSelect: how do you reference a specific Column?

RJ Samp
Posts: 973

Grid: MultiSelect: how do you reference a specific Column? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 29 Jan 09 8:13 AM

I know how to get the ID of the selected grid rowS.....

but how do you get the value for column 3 or the "A4_PRODUCTID" field?

Thanks!

[Reply][Quote]

Steve Garner
Posts: 22

Re: Grid: MultiSelect: how do you reference a specific Column? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 30 Jan 09 7:14 AM

Have you tried grdA.recordset.fields("ColName").value?

[Reply][Quote]

RJ Samp
Posts: 973

Re: Grid: MultiSelect: how do you reference a specific Column? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 30 Jan 09 10:10 AM

Quote:

Originally posted by Steve Garner

Have you tried grdA.recordset.fields("ColName").value?

I don't think that would identify the specific row of the multiselect.....the selected grid rows are in a 'Selection' object/collection:

Here's how I get the value today:
For i = 0 to nSelected -1
OWSID = "" & dgokSites.Selection.Item(i)
gAccountID = "" & GetFieldValueFromRS(pRS, "ACCOUNTID", "OPP_WORKSHEETID", OWSID)
OppNumber = cINT("0" & GetFieldValueFromRS(pRS, "A5_OPP_NUMBER", "OPP_WORKSHEETID", OWSID))

''''''
FUNCTION GetFieldValueFromRS(objRS, ReturnField, IDFIELD, RowID) '''quick little function adapted from SLX Utils/Common/Sales Process.
GetFieldValueFromRS = ""
With objRS
If Not (.BOF And .EOF) Then
.MoveFirst
For i = 0 To .RecordCount - 1
If .Fields.Item(IDField).Value = RowID Then
GetFieldValueFromRS = "" & .Fields.Item(ReturnField).Value
'Found record exit loop and return RS
Exit For
End If
.MoveNext
Next
End If
End With
END FUNCTION
'''''
So I was thinking.....
For i = 0 to nSelected -1
OWSID = "" & dgokSites.Selection.Item(i)
FIELDA = "" & dgokSites.Selection.Item(i).FIELDA
or FIELDB = "" & dgokSites.Selection.Item(i)."FIELDB"
or something like that......

it depends on what is in the Selection object/collection?

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/26/2024 11:35:09 AM