FiveTech Support Forums

mtajkov wrote:Hi,

how to assign the sql query results

Code (fw): Select all Collapse

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

to the variable?


regards
Miloš

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

What is oSql? Can I see a complete sample?

EMG

Try

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

Maurizio

www.nipeservice.com

mtajkov wrote:The result is constantly 0?

Code (fw): Select all Collapse

Function New() 
Local NewName:=0

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

MsgInfo(NewName)

return

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

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

NewName := aData[1][1]

Thank you, it works.