FiveTech Software tech support forums

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.

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()

Thank you