Hi ,
Just a quick question to run by all.
I have a program which contains an SDO and a smart Data Browser.
I have a number of fields that i want to search on and pass into the sdo to get the results back.
my question is , is it possible to use CONTAINS in the where clause like as follows:-
tmpqrystring = "name contains '*r*'
{set queryWhere tmpqrystringdisp h_searchsdo}.
{set querySort cSort h_searchsdo}.
{fn openQuery h_searchsdo}.
Thanks for all your help
Roy
Just a quick question to run by all.
I have a program which contains an SDO and a smart Data Browser.
I have a number of fields that i want to search on and pass into the sdo to get the results back.
my question is , is it possible to use CONTAINS in the where clause like as follows:-
tmpqrystring = "name contains '*r*'
{set queryWhere tmpqrystringdisp h_searchsdo}.
{set querySort cSort h_searchsdo}.
{fn openQuery h_searchsdo}.
Thanks for all your help
Roy