QueryResult 1 row and many rows different array type

Posts: 1598

Joined: Fri Oct 07, 2005 05:56 PM

QueryResult 1 row and many rows different array type
Posted: Sun Mar 28, 2021 02:49 PM

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.

Regards,

Dutch

FWH 2304 / xHarbour Simplex 1.2.3 / BCC73 / Pelles C / UEStudio

FWPPC 10.02 / Harbour for PPC (FTDN)

ADS V.9 / MySql / MariaDB

R&R 12 Infinity / Crystal Report XI R2

(Thailand)

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: QueryResult 1 row and many rows different array type
Posted: Sun Mar 28, 2021 03:33 PM

Please use oCn:Execute( <yourquery> ) to get multi-dim array not oCn:QueryResult() whose purpose is dfferent.

Regards

G. N. Rao.

Hyderabad, India

FiveTech Support Forums

Continue the discussion