September 4th, 2012, 10:38 PM
How To Combine 2 Query
I have 2 tools inside my form ADODC and Datagrid. the recordsource for adodc is
select * from directory where firstname <> 'spare'.
the problem is i have another text for searching purposes and its gonna rewrite the recordsource like this
select * from directory where firstname like '%' & replace(txtName.text), "'", " ' '"
- this will show the results inside the datagrid as it follows and join the recordsource of adodc components.
How to combine both of the query inside one procedure. where its gonna search what he/she want in the textbox and at the same time it filters which records contain 'spare' in firstname field.
NEED URGENT HELP..Thank you
September 5th, 2012, 09:39 AM
select * from directory where firstname <> 'spare' AND
firstname like '%' & replace(txtName.text) ...........
Last edited by debasisdas; September 5th, 2012 at 09:41 AM.