>I need a query tool that will allow my endusers to select data from several tables and produce a data set that I send to a queue in my custom app.
>
>My custom app is a multi-client app.
>
>One requirement is that I need to be able to query tables with the same name across multiple database containers.
>
>For instance, I have two clients. Each client has its own set of tables in its own database container in its own folder.
>
>If I want to see all the active employees for both clients, I need to be able to query the employee table in each database container for both clients.
>
>Another requirement is that the query tool needs to be compatible with the Codemine Framework.
>
>Any recommendations?
>
>Thanks.
>Regards,
>Deb
Hi Deb,
Would that work for you if you just run several SQL SELECTs against the desired employee tables INTO TABLE and then use APPEND FROM to build the result cursor?
As a final touch you may run the SELECT * from the result cursor and ORDER BY the way you want to build the final recordset.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison