>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
Brent,
In Fox2.x the SQL is interpreted like it's now with some exceptions. ie:
Fox 2.x SQL doesn't support:
-inner,left,right, full join clauses and companion "on"
-fieldname between rangelow and rangehigh
-size is limited lower than it's now (command line)
-nofilter clause
etc.
If you support us your SQL we could help better.
Cetin