I'm looking for either a 3rd party addition (or Fox 7.0?)
to improve remote view/query generation. Basic problem is
non editable SQL statement window.
I have tested queries from other applications that I'd
like to just paste and go. Length and complexity make
building query manually basically impossible. You might
do it once, then kill yourself before doing again. Add in
inability to have single letter alias and better
statement line breaks (for readability) and it's a losing
cause.
I use Quest SQL Navigator 4 for now and run it into FoxPro
via tab-delimited file. Clumsy clumsy clumsy.
Would like better SQL tool to generate views I can access
directly within programs (the actual use).
.