[Database] Retrieving sql statement result
sarah.reichelt at gmail.com
Wed Apr 28 05:12:00 EDT 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.
More information about the Use-livecode