oRS:QueryResult() AND Fw_arrayToDbf

[vilian]

I'm using oRS:QueryResult() to load data in an array, that after I want to save in a DBF file. Something like this:

aValues := oBD:QueryResult( "SELECT * from clients" )
aux->( FW_ArrayToDBF( aValues ) )

If there is only one record in the table clients, this code does not work.

[nageswaragunupudi]

Code: Select all  Expand view  RUN

aValues := oBD:Execute( "SELECT * from clients" )
aux->( FW_ArrayToDBF( aValues ) )
 

Use QueryResult for results containing one or two items
like:
SELECT SUM(AMT) FROM table WHERE..
SELECT AVG(AGE),SUM(SALARY) FROM tabe ..
etc
For reading several rows, use Execute()

[vilian]

Thank you