ADODB find

Posted on 2007-10-03
Last Modified: 2010-04-14
Hi Experts

Using two adodb recordsets I want to find a record in rst1 that is equivalent to a record in recordset2. How would I achieve this.

rst1.find(rst2.fields(ID).value = & rst1.fields(ID).value)

The values are integers

Question by:JoeBo747
    LVL 53

    Accepted Solution

    I guess something like this:

    rst1.find("ID = " & rst1.fields("ID").value)
    LVL 1

    Author Comment

    Hi Dhaest

    Thanks for your reply. Thats exactly what I needed>


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    The object model of .Net can be overwhelming at times – so overwhelming that quite trivial tasks often take hours of research. In this case, the task at hand was to populate the datagrid from SQL Server database in Visual Studio 2008 Windows applica…
    This article describes relatively difficult and non-obvious issues that are likely to arise when creating COM class in Visual Studio and deploying it by professional MSI-authoring tools. It is assumed that the reader is already familiar with the cla…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now