I'm in the process of integrating with a 3rd party database application and experienced some problems.

The 3rd party database application provides some user interfaces. It allows me to query and retrieve records meeting one requirement, for example, find people with (age=20) or find people with (job=engineer). However, it does not provide an interface to do the combined search, e.g. find people with (age=20 and job=engineer).

Could you please suggest some solutions? Your reply will be greatly appreciated!

Julia

Depending on your particular requirements, use the and or or keyword in your query.

Hi Learning Newbie,

Thanks for your reply.

However the problem I have here is that the 3rd party application does not provide an interface that recognizes the key words like "AND" or "OR". It does not have the combined query ability.

Is there any way for me to use the available query functions to do the combined search?

Regards,
Julia

If it's a database application, skip the front end and send a SQL query directly to the database.

You have some application we don't know what is but you say doesn't allow it. All we can conclude is, no you can't do it with that application. You will need another way to access the database.