Hi,

I am using Acivex Dll and a Standard Exe form for the query to work,as Active
X Dll is to be put on Server with the Database for executing the Query,now
by putting a Flexgrid on Standard Exe I want to see the output by entering
the selected Value in Text or Combo box and the record shown in the Flexgrid
should be <= the value entered in text or combo box.The Code Written for
ServerSide Compilation in Activex Dll is....


If Strcomp(String1,String2)=0 or StrComp(String1,String2)=1 then
If Strcomp(String1,String2)=0 then
Execute(Select Statement)
Elseif StrComp(String1,Strin2)=0 Then
Execute(Select Statement)
Endif
End if

and for getting the output in FlexGrid on Client Side the code is
...

Set Myclass.Mymethod(Textbox,combobox)
Rs.MoveFirst
Do
X=Rs(0) & vbtab & Rs(1)
form1.FlexGrid.AddItem X
Rs.Movenext
Loop while Rs.Eof<>true

with the above code it compares,if true i get the output,but if false it
gives the error(ADO COULD NOT FIND THE OBJECT IN THE COLLECTION CORRESPONDING
TO THE NAME OR ORDINAL REFERENCE REQUESTED BY THE APPLICATION).But by using
the whole code only on Standard Exe it works properly.SO what Could be the
Problem with working with/in ActiveX Dll or is the logic applied in this
wrong.

Thanks
Nand