Using Seek to find a range

[sjulian]

I am working in VB6 on a SQL2000i database. The date field is indexed. I know how to get a recordset of all records with a certain date in the date field. Can I return a recordset based on a date range?

 

[Linda84]

What interface are you using in VB6? ADO/OLEDB? ActiveX? Btrieve API? The answer really depends on which one you're using.


Linda
Pervasive Software Support

 

[sjulian]

Thank you for your response, I am using ADO and figured out that I could just use >= and <= in my SQL statement and it worked just fine.