SQLite (VB6) Question - RecordSet Search

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello.

(SQLite and VB6)

I have a function that takes a recordset as one of its parameters in
order to create a table based on the current record.

So before I run this function, I need to make sure the recordset is
pointing to the correct record.

So this is a 'search' question. And yes, I'm really new at this.

My recordset is called RsMaster. The fields are:

ID, StockName, StockSymbol, FirstDate, LastDate and FieldCount.

I was trying to go to the correct record using ID, like this:

RsMaster.FindFirst gStockInfo.ID (type LONG), but FindFirst needs type
String. So I get an error.

How do you search for a record by ID?

Thanks.

Webbiz


.