editable query

[rommeltm00]

hello guys

can i edit query at runtime

inside fox i can edit it using

vfile=cquery
MODIFY QUERY &vfile

how about when the program is standalone executable

 

[Mike Lewis]

No, you can't do that. If you include MODIFY QUERY in a free-standing executable, you'll get a "feature not available" message.

If you want to give your users the ability to create and edit queries, you'll find several third-party components that can do that. Stonefield Query is definitely worth a look (

http://www.stonefieldquery.com/)

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business

 

[Olaf Doschke]

Alternatives to such a poweruser interface are, you make use of parameterized views and let the user enter parameter values. Or even make use of macrosubstitution and use that eg in a where clause or in the field list.

SELECT &lcFields FROM sometable WHERE &lcWhere

You can use macrosubstitution anywhere, you can even do &lcSQL with a user entered SQL string, as long as you can trust the user's input.

If going that route, you would at least ensure the command has no syntax error and better yet, it's not an sql injection, that is a command that will do something else but sql, eg cause an error enabling debugging, decompiling, stealing data, destroying data.

If you are the user, you can trust the entered sql like you can trust any code of yours, of course <s>.

Bye, Olaf.

 

[rommeltm00]

thanks guys ill try all your suggestions.

God Bless.