Cetin,

I do hope that you are correct. When you find some time, could you please let me know if and how you can make SearchByExpression() use a SQL select statement that includes joins to other tables in MapObjects2.

Regards,

Mike



>Mike,
>I don't have time for details now but it can (I think).
>Cetin
>
>>Thanks for the reply Cetin.
>>
>>While this idea works for VFP (and SQL Server/Oracle) I'm trying to do this SQL selecting from within the MapObjects2 ActiveX control. If I'm not mistaken, you may know a bit about that control. In particular I'm trying to use the SearchByExpression() method. I don't think it can use joins.
>>
>>Mike
>>
>>
>>>
>>>This ORing might be many and adds to complexity of SQL even if it could ran.
>>>When I need such things I simply create a cursor and put values there, make an inner join. ie:
>>>
>>>create cursor crsTemp (myField i)
>>>insert into crsTemp values (1234)
>>>insert into crsTemp values (29929)
>>>...
>>>
>>>select .... from myTable mt ;
>>>inner join crsTemp lst on val(mt.Myfield) = lst.myField ...
>>>
>>>Just my .02 cents
>>>Cetin