Page 1 of 1

QueryResult 1 row and many rows different array type

Posted: Sun Mar 28, 2021 2:49 pm
by dutch
Dear All,

I use FWMARIADB with MariaDb and I got strange behavior as below;

I use oCon:QueryResult(..).
Result as many rows : got as dimension array
aResult := {{'1','smith', 100 },;
{'2','John', 200 }}

Result as 1 row : got as 1 column array as many rows
aResult := {'1','Smith',100}

But it should be
aResult := {{'1','Smith',100}}

Thanks for any idea or help.

Re: QueryResult 1 row and many rows different array type

Posted: Sun Mar 28, 2021 3:33 pm
by nageswaragunupudi
Please use oCn:Execute( <yourquery> ) to get multi-dim array not oCn:QueryResult() whose purpose is dfferent.