>Ok I am using Fox for DOS. I am using DOS because I am being forced to. Now what I want to know is: How do I write a query in SQL without using that stupid query wizard thing. It is more confusing that just writing the query in SQL. I have already written my SQL as a .prg and I don't think it recongnizes it as SQL code. So any help that anyone may have would be most appreciated.
>
>Thanks

SQL is interpreted in FP Dos the same way it is in VFP. You can invoke a SELECT * FROM SomeTable directly from the command window, or run a program with SQL in it.


Wayne