Using OO4O. Any advice?

I am just at the beginning of the learning curve, using the latest Oracle Objects for OLE, with VB5. I've got it working, but this is raising some questions.

In particular, my test application uses

	SqlQuery = "SELECT * FROM COMPANY ORDER BY COMPANY_NAME"
	CoDynaset=OraDatabase.createdynaset(SqlQuery,0&)

	(COMPANY_NAME is an indexed field).

The trouble is, as near as I can tell, the program actually generates the entire list from the select statement and downloads the whole damn thing (I could be wrong). NEXT, PREV, FIRST, and LAST commands work well, but if I try to do a search for a particular name, it takes forever.

For this, I use

	SelStmt="COMPANY_NAME like '"+searchname+%'"
	CoDynaset.findfirst SelStmt

My understanding is that this uses the dataset from the SqlQuery above. But it seems to do a sequential search. Is this because of the LIKE ? Is there a better way to do a random search for a name? Should I be regenerating the SqlQuery each time instead of what I'm doing?

Most importantly: Is there a book on using OO4O efficiently? Or is this one of those folklore things that you have to pick up from others? Received on Tue Sep 02 1997 - 00:00:00 CEST