Hi!
Is there a way to execute a SQL query directly from a Win NT machine, on a
pgSQL database that is remotely installed?
I tried using CRecordset Object to connect to this remote pgSQL database.
But if I have a very large database (say 10,000 records), then searching for
a particular record takes lot of time as we need to traverse through all the
records in CRecordset.
I can use m_strFilter property of CRecordset, but then I have to open the
database again and this is also very time consuming process.
So I am looking for a quick way to locate a particular record in a
collection of say 10,000 records.
Is there a work-around for this?
Regards,
Vikram