how to assign the sql query results to the variable

[mtajkov]

Hi,

how to assign the sql query results

Code: Select all

select sum(value) from invoice where poz='123'

to the variable?


regards
Miloš

[Enrico Maria Giordano]

Hi,

how to assign the sql query results

Code: Select all

select sum(value) from invoice where poz='123'

to the variable?


regards
Miloš

Code: Select all

select sum(value) as newname from invoice where poz='123'

EMG

[mtajkov]

The result is constantly 0?

Code: Select all

Function New() 
Local NewName:=0

 oSql:exec("SELECT sum(Value) AS NewName FROM Invice WHERE poz='123')

MsgInfo(NewName)

return

[Enrico Maria Giordano]

What is oSql? Can I see a complete sample?

EMG

[Maurizio]

Try

Local oN
oN := oSql:exec("SELECT sum(Value) AS NewName FROM Invice WHERE poz='123')
xbrowse(oN)

Maurizio
www.nipeservice.com

[fafi]

The result is constantly 0?

Code: Select all

Function New() 
Local NewName:=0

 oSql:exec("SELECT sum(Value) AS NewName FROM Invice WHERE poz='123')

MsgInfo(NewName)

return

Code: Select all

cSQL := "SELECT sum(Value) AS NewName FROM Invice WHERE poz='123'"

oSql:exec( cSql,,.t.,@aData )

NewName := aData[1][1]

 

[mtajkov]

Thank you, it works.

[joseluisysturiz]

Obteniendo resultado a una variable, saludos...

Code: Select all

oQryId := TDolphinQry():New( "SELECT last_insert_id() AS nId", oDatos:oConex )
nVar := oQryId:nId