>I originally started this thread looking for a query tool that would work against both VFP databases and back-end servers.
>
>We have a database consiting of 30 main tables and about 70 lookups. All of the main tables could be related to one another if so desired. The user has to be able to pick any or all tables and the necessary lookups. This means that the result cursor structure will almost always be different. There is no way to determine what the structure would be.
>
>Can FoxFire handle this situation? From what I've read, Foxfire only works against Remote Views based on back-end data.
>
>Thanx

I know that Micromega has done some work on an Oracle BackEnd and I could ask around and find out more ir that is your backend. What IS your backend server? MS SQL SERVER, INFORMIX, ORACLE?

I don't mean to dirty this thread but I am interested in hearing about the speed of SQL Server vs FoxPro. I assume it is. How much ?