Brent,

Putting the SQL in a prg is correct. If you stick with the basic SQL commands then you should be ok. Then DO MySQLPrg when you need to call it. Of course this will only work on native Fox tables. If you need to do SQL pass-through against an ODBC database you will need the FoxPro Connectivity Kit, which may be hard to find at this point.

If you're having trouble, post some code.


>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