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.
QueryResult 1 row and many rows different array type
QueryResult 1 row and many rows different array type
Regards,
Dutch
FWH 19.01 / 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)
Dutch
FWH 19.01 / 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: 10729
- Joined: Sun Nov 19, 2006 5:22 am
- Location: India
- Been thanked: 10 times
- Contact:
Re: QueryResult 1 row and many rows different array type
Please use oCn:Execute( <yourquery> ) to get multi-dim array not oCn:QueryResult() whose purpose is dfferent.
Regards
G. N. Rao.
Hyderabad, India
G. N. Rao.
Hyderabad, India