Codejock Developer Community : SOLVED: Locate a row

SOLVED: Locate a row : yup, the more i use it the more...

Mon, 29 Oct 2007 18:05:56 +0000

Author: JKDev
Subject: 8441
Posted: 29 October 2007 at 6:05pm

yup, the more i use it the more i see thus as an absolute must have...

SOLVED: Locate a row : I agree. Looping through EVERY...

Mon, 29 Oct 2007 09:22:04 +0000

Author: johnlewe
Subject: 8441
Posted: 29 October 2007 at 9:22am

I agree. Looping through EVERY row is just not practical. The record object needs a key property. Likewise the column object needs a key. Every time I need to refer to a RecordItem, I need to remember the numerical index value of the column. In the ListView control you can refer to the RecordItem using the NAME/KEY of the column. It makes the code ALOT more readable and easy to maintain. What I have done to workaround this limitation is to store the name of the column in the .tag property of the column and then I have to call a function that loops through every column in the control until it finds that tag and then returns the numerical index of the column.

Is there a specific reason by design why the ReportControl does not have "key" objects? Or is this coming in a future revision? We replaced our listview control with the Codejock ReportControl to get past the limitations of the listview control, but in this case, those limitations are being replaced with Codejock ReportControl limitations which the listview control did not have.

Make us all very happy and add this basic feature that the listview control has...please...

SOLVED: Locate a row : Hmm, it would be great if you...

Fri, 26 Oct 2007 17:30:40 +0000

Author: JKDev
Subject: 8441
Posted: 26 October 2007 at 5:30pm

Hmm, it would be great if you could provide a function to quickly search all of the records .tag property for a match. such as

Report.Records.FindTag "172" etc.

It is essential to be able to locate the record that is associated with a particular database row based on a primary key.

Iterating through all of the records as suggested is time consuming. Perhaps you could add a .Key property for the Record similar to a ListView.ListItem.Key? That way we could retrieve the correct row with code like this

msgID = "M" + ltrim$(str$(rs("msgID")))

set rec = Report.Records.Item(msgID)

SOLVED: Locate a row : No.

Wed, 17 Oct 2007 18:10:26 +0000

Author: sserge
Subject: 8441
Posted: 17 October 2007 at 6:10pm

No.

SOLVED: Locate a row : Isaid a way that Ido not to iterate...

Tue, 16 Oct 2007 19:21:47 +0000

Author: ElvisM
Subject: 8441
Posted: 16 October 2007 at 7:21pm

I said a way that I do not to iterate all the rows to find the row. There is not a method that I can find the desired row only by a column value? (without iterate all the reportcontrol's records)

PD: Excuseme my english

SOLVED: Locate a row : Some thing like this should help: For...

Tue, 16 Oct 2007 17:19:17 +0000

Author: sserge
Subject: 8441
Posted: 16 October 2007 at 5:19pm

Some thing like this should help:


For Each Row In wndReportControl.Rows
    For Each RecordItem In Row.Record
        If RecordItem.Value = "..." Then
...

Also search forum, there were already similar questions.

--
WBR,
Serge

SOLVED: Locate a row : Hi, there is a way to locate a...

Tue, 16 Oct 2007 15:22:29 +0000

Author: ElvisM
Subject: 8441
Posted: 16 October 2007 at 3:22pm

Hi, there is a way to locate a row in the reporcontrol by a column value without iterate all the rows of it?

Excuseme my english, is so bad.

Elvis