Report Control - URGENT!!! how find row in 1000000 Records?

Print Page | Close Window

URGENT!!! how find row in 1000000 Records?

Printed From: Codejock Forums
Category: Codejock Products
Forum Name: Report Control
Forum Description: Topics Related to Codejock Report Control
URL: http://forum.codejock.com/forum_posts.asp?TID=11943
Printed Date: 15 November 2024 at 8:17pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: URGENT!!! how find row in 1000000 Records?

Posted By: mozaheb
Subject: URGENT!!! how find row in 1000000 Records?
Date Posted: 24 August 2008 at 1:08am

hi all

please tell me about how find row in many records?

thank you

Replies:

Posted By: Aaron
Date Posted: 24 August 2008 at 1:36am

Hi,

Just loop trough rows/records collection or use FilterText.

-------------
Product: Xtreme SuitePro (ActiveX) version 15.0.2
Platform: Windows XP (32bit) - SP 2
Language: Visual Basic 6.0

Zero replies is not an option....

Posted By: AndreiM
Date Posted: 24 August 2008 at 12:12pm

for what do you need this?

In some cases you may use more faster algorithms (for example if rows are sorted you may use binary search to find by search key) or create some helper mechanisms to make this faster).

-------------
Regards,
Andrei Melnik

Posted By: mozaheb
Date Posted: 25 August 2008 at 11:05am

i want change date in row after changes data in my database and i want fint row very fast.

how binary search in report control?

Posted By: nenkalo
Date Posted: 27 August 2008 at 8:18am

Hi mozaheb

binary search is a one search method (in fact its a optimal algorithm solution to search). and not uniqe for search in RC .

any data object (like data engine and data grid) have main and basic and fundamentally search method liek togheter . u must use this method with any search solustion to find record .

in other word can i ask from u how u find this record in database to edit date ? u can search in RC like database .

-------------
Product: Xtreme SuitePro (ActiveX) version 12.0.1
Platform: Windows XP (32bit)
Language: Visual Basic 6.0