01-04-2013, 08:57 PM
نجح معي هذا الكود في البحث في عدة جداول
كود :
SQL.text := (' SELECT * FROM [color=Red]science [/color]where author like'+ QuotedStr('%'+edit1.text+'%') + 'UNION SELECT * FROM [color=Red]french [/color]where author like'+ QuotedStr('%'+edit1.text+'%')+ 'UNION all SELECT * FROM [color=Red]English [/color]where author like'+ QuotedStr('%'+edit1.text+'%')+ 'UNION SELECT * FROM [color=Red]Islam [/color]where author like'+ QuotedStr('%'+edit1.text+'%') + 'UNION SELECT * FROM [color=Red]History [/color]where author like'+ QuotedStr('%'+edit1.text+'%') + 'UNION SELECT * FROM [color=Red]Mis [/color]where author like'+ QuotedStr('%'+edit1.text+'%')+ 'UNION SELECT * FROM [color=Red]Arabic [/color]where author like'+ QuotedStr('%'+edit1.text+'%') + 'UNION SELECT * FROM [color=Red]video [/color]where author like'+ QuotedStr('%'+edit1.text+'%') );
