🚀 go-pugleaf

Thanks
"Vladimir Stefanovic" <spam@not.needed> wrote in message
news:41962d71@newsgroups.borland.com...
> >  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
> >
> >
>
>