Hello,
I use a NxLookupColumn in a NxDBGrid. How can I change (refresh) the items in the NXLookupColumn, when the ListDataSource of the NxLookupColumn is requery? NxLookupColumn.LoadItems has no effects.
Stefan
0
2 replies to this topic
#2
stefanw
-
- Members
- 6 posts
Posted 15 March 2012 - 03:07 PM
Hello,
I think, I have found my problem.
In my listsource are multiple rows with the same listfieldname but different id (keyfieldname). NxLookupColumn returns the keyfieldname after a DataSet.Lookup with the listfieldname. So the listsource returns allways the first record in the dataset. In Delphi-help: DataSet.Lookup returns a variant array. At seems there is no direct connection to the correspondenting key.
My workarround: use a constructed fieldvalue like 'cast(id as varchar) + name' for the listfieldvalue.
Stefan
I think, I have found my problem.
In my listsource are multiple rows with the same listfieldname but different id (keyfieldname). NxLookupColumn returns the keyfieldname after a DataSet.Lookup with the listfieldname. So the listsource returns allways the first record in the dataset. In Delphi-help: DataSet.Lookup returns a variant array. At seems there is no direct connection to the correspondenting key.
My workarround: use a constructed fieldvalue like 'cast(id as varchar) + name' for the listfieldvalue.
Stefan
#3
Boki (Berg)
-
- Forum Admin
-
- 6,686 posts
Boki (Berg)
- Gender:Male
Posted 20 March 2012 - 04:54 PM
Hi Stefan,
Please sorry for my delay. I will think about this problem and to implement fix directly in grid.
Please sorry for my delay. I will think about this problem and to implement fix directly in grid.
boki@bergsoft.net
--
BergSoft Home Page: www.bergsoft.net
Members Section: bms.bergsoft.net
Articles and Tutorials: dn.bergsoft.net (Developers Network)
--
BergSoft Facebook page
--
Send us applications made with our components and we will submit them on: www.bergsoft.net/apps.htm. Link to this page will be also set on home page too.
--
BergSoft Home Page: www.bergsoft.net
Members Section: bms.bergsoft.net
Articles and Tutorials: dn.bergsoft.net (Developers Network)
--
BergSoft Facebook page
--
Send us applications made with our components and we will submit them on: www.bergsoft.net/apps.htm. Link to this page will be also set on home page too.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users
