RDO and Binding Select Statments

[campbere]

I have been using RDO in my VB 6 application to query the database. I would like to learn how to bind these statements. Does anyone have any information on binding and how to do that in RDO statements?

I am using VB 6, and Oracle 8i.

For example if I have this I want to know how to bind it, and what are the benefits? Someone had told me I should look into it to improve performance.

sqlMaxTest = "SELECT prod_id, product_name " _
& " FROM PRODUCT " _
& " WHERE prod_id = '" & frmprod.prodid.text & "' " _
& " AND model = '" & frmprod.model.text & "' "

Set RSMaxTest = DB.OpenResultset(sqlMaxTest, rdOpenKeyset, rdConcurRowver)

Thank you for any information you are able to provide.