[Database] Retrieving sql statement result

Sarah Reichelt sarah.reichelt at gmail.com
Wed Apr 28 04:12:00 CDT 2010


On Tue, Apr 27, 2010 at 6:36 PM, Marcello Bertoli <mbertoli at libero.it> wrote:
> Hi all,
>
> I have a question about runrev database commands. Is there a way to get the result of a sql statement that doesn't retrieve data (is not a select)? For example:
>
> In a postgresql scenario I need to execute the statement:
>
> "listen foo"
>
> and I need to retrieve the result.
>
> It seems that the only rev command I can use is revExecuteSql but in this way I can't get the result the sql engine gives after the statement is executed. revDataFromQuery seems to work only for retrieving data from a query, not from a statement...


If you check "the result" after your revExecuteSQL statement, it
should contain the data you need.

Cheers,
Sarah



More information about the use-livecode mailing list