LiveCode Forums.

It would be very nice if you could execute a procedure or function on a database
For example begin Procedure end

Revexecutesql would be perfect
It is in my opinion not nice livecode is not having this feature .

I can use a plugin be standard livecode would be mice

Hi,

There are a few options. You can do what you want with PHP and you can call a PHP script with a URL in LiveCode. Another possibility is using views and triggers in the database. You could do a query on a view without affecting the database. The query would run a trigger, which could be a lengthy SQL script.

Kind regards,

Mark

Perhaps that is my problem. PHP scripting and URL call is not really my piece of cake.

For one customer I'm not allowed to change the database (SAP BW on ORACLE). I have a readonly account and that is it.

The other customer I have to set the context (user workspace) to retrieve any data at all.
The context is set by executing an PLSQL procedure.

If I would use the trigger approach I have to write many triggers for each different PLSQL execution
If I would ask the DBA he would smile and send me home. Triggers in oracle can be done but it's not done.

a simple "execute immediate" statement would help me in some way.
we can do sqlstatements.

Kind regards DJ

Contact me "off-list". I have a simple, although commercial, PHP solution that you can ask your customer to install on his server.

Kind regards,

Mark