Vankov
30th July 2009 13:11 UTC

How to get result from OSQL query?
In query with OSQL syntax is ok,but how to get result?
After exec
Pop $0
DetailPrint $0
and result is zero(succes).....
So how to get selected value?

Afrow UK
30th July 2009 13:29 UTC

ExecDos::exec /TOSTACK
Pop
Pop

or
nsExec::ExecToStack
Pop
Pop

Stu

Vankov
30th July 2009 13:56 UTC

the results is:
ver_prop_option
------------------------------------------------------------------------------
-----------------------------------------------------------------------
-----------------------------------------------------------------------
-----------------------------------
3.1.5




(1 row affected)

Completed

I need only "3.1.5"

Afrow UK
30th July 2009 14:37 UTC

Use more Pop instructions.

Stu

Vankov
30th July 2009 22:55 UTC

What are you mean with "Use more Pop instructions." ?????

sgiusto
31st July 2009 08:26 UTC

You can also try the mssql plugin (http://nsis.sourceforge.net/MSSQL_OLEDB_plug-in).
Better control on query and results
Stefano

Afrow UK
31st July 2009 11:41 UTC

The first Pop pops the exit code off the stack. Subsequent Pop instructions read lines of output (only for ExecDos::exec /TOSTACK).

Stu