Howdy all.
Looking to convert many of the queries in a program to SQL...

I'd like to somehow be able to use the "Show SQL" feature
programmatically against a number of QBEs in a directory but haven't
found anything that points to this feature as a standalone .exe or
function.

Does anyone have suggestions of how I might go about this? Pulling the
inline QBEs into notepad and then running Show SQL is going to get
mighty tedious 8-)

I understand some complicated queries such as those using the ! will
not be able to be converted but at least I could trap an err and write
the msg to a table field.

Thanks in advance,
Rey

Rey

You can open the QBE files from a form and with the QBE file open have a
form with button with code menuAction(MenuQbeShowSql).


This form has to have MouseActivates unchecked and it should probably be
a dialog.

To open the Query Editor from ObejctPAL, try this

var
P OLEAuto
endVar

P.open("Paradox.Application")
P.QueryDesign("d:\\work\\sample.qbe")

--
Bertil Isberg
CTECH
Paradox Buglist: http://web.comhem.se/~u82608896/

remove spamfilter (reversed) to reply

Howdy, Bertil.
Thanks for reply. Had tried this earlier and didn't work - for me. Just
retried and in conjunction w/sendkeys, worked. Must had to have my mind
on it or something else 8-)

Thanks again.

Rey