🚀 go-pugleaf

>  DataModule1->adoQSchoolTbl->SQL->Add("WHERE LIKE '%" + Filter +
"%'");

First try this...
DataModule1->adoQSchoolTbl->SQL->Add("WHERE SchName LIKE '%" + Filter
+ "%'");



Best regards,
Vladimir Stefanovic

Joe Myburgh <joe@compumail.co.za> wrote in message
news:419625d0@newsgroups.borland.com...
> Hello
>
> I hope someone can help?
>
> I have got code like:
> DataModule1->adoQSchoolTbl->SQL->Add("SELECT");
>  DataModule1->adoQSchoolTbl->SQL->Add("SchID, ProID, RegID,
MedID,");
>  DataModule1->adoQSchoolTbl->SQL->Add("SchName, SchTel, SchFax,
Schemail,
> SchScholars, SchCode");
>  DataModule1->adoQSchoolTbl->SQL->Add("FROM SchoolTbl");
>  DataModule1->adoQSchoolTbl->SQL->Add("WHERE LIKE '%" + Filter +
"%'");
>
> When the dataset open's there is a Exception   class EOleException
with
> message 'Incorrect syntax near the keyword 'LIKE
>
> This is what I try to execute.
>
> select SchID, ProID, RegID, MedID,SchName, SchTel, SchFax, Schemail,
> SchScholars, SchCode  from schoolTbl
> where SchName LIKE '%Jan%'
>
> Regards
>
>