From: Bart Degryse <Bart.Degryse@indicator.be>
To: pgsql-sql@postgresql.org
Subject: Re: slow query execution
Date: Thu, 31 May 2007 09:24:04 +0200
Message-ID: <465E9434.A3DD.0030.0@indicator.be> (raw)
In-Reply-To: <383089.24941.qm@web52712.mail.re2.yahoo.com>
References: <383089.24941.qm@web52712.mail.re2.yahoo.com>
Am I right in assuming that you're working on a VB application with a ListView AxtiveX Control in it?
If so consider putting the value of the ID field of your table in the Tag Property of each item in your listview.
By looping over all items in your listview you can then check the property for certain values and adjust other properties as required (eg highlight them).
Alternatively if you're working with ado you can store the records bookmark in the tag property. That's particulary handy when you want
to look up information in a recordset when clicking on an item in the listview.
>>> Trigve Siver <trigves@yahoo.com> 2007-05-30 21:11 >>>
>----- Original Message ----
>From: Richard Huxton <dev@archonet.com>
>To: Trigve Siver <trigves@yahoo.com>
>Cc: pgsql-sql@postgresql.org
>Sent: Wednesday, May 30, 2007 9:05:09 PM
>Subject: Re: [SQL] slow query execution
>
>Trigve Siver wrote:
>>
>> I seee...when new data will be added to table, then row numbers wouldn''t be valid anymore.
>>
>> Hmmm...looked like I need to find other solution.
>
>Try explaining what it is you're trying to achieve, and maybe someone
>will be able to suggest a solution.
I need to perform search on some query (which is already shown in Listview control) and
highlight items that meet search criteria.
thanks
Trigve
____________________________________________________________________________________
Don't pick lemons.
See all the new 2007 cars at Yahoo! Autos.
http://autos.yahoo.com/new_cars.html
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: Bart.Degryse@indicator.be
Subject: Re: slow query execution
In-Reply-To: <465E9434.A3DD.0030.0@indicator.be>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox