I'm using the MS ADO control for database operations from VB6 to SQL Server.
I want to set the CommandType property of the ADO control to adCmdText at the form load event.
Now based on the different button clicks, I want to query the database varying the filter conditions and bring the values to the recordset so that I can scroll thru the ADO control.Whenever I try to change the filter
conditions using the filter property of the ADO control. It always shows recordcount = 0.I check for BOF & EOF which is always true because no records are selected at the form load time because of the filter conditions.
allthough records are there in the database.What could be the problem.
Any alternate solutions,( but i want to Keep ADO control only)
Thanks in advance.