topic-36864

Board index FiveWin for Harbour/xHarbour Array and MariaDB

wartiaga

Posts: 253

Joined: Wed May 25, 2016 01:04 AM

Array and MariaDB
Posted: Thu Mar 07, 2019 07:21 PM

Hi Guys,

How I can create a array with a mariadb query result to use in fastreport?

Thanks in advance.

cnavarro

Posts: 6755

Joined: Wed Feb 15, 2012 08:25 PM

Re: Array and MariaDB
Posted: Thu Mar 07, 2019 09:33 PM

Try with this

viewtopic.php?f=6t=36808#p219600

Cristobal Navarro

Hay dos tipos de personas: las que te hacen perder el tiempo y las que te hacen perder la noción del tiempo

El secreto de la felicidad no está en hacer lo que te gusta, sino en que te guste lo que haces

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: Array and MariaDB
Posted: Fri Mar 08, 2019 02:44 AM

If you have already opened a Rowset with the query, you may do as advised by Mr. Cristobal in the above post.

There is even a simpler way:

Code (fw): Select all Collapse

aStates := oCn:Execute( "select * from states" )

aStates is a 2-dimensional array of the result of the query.

Regards

G. N. Rao.

Hyderabad, India

wartiaga

Posts: 253

Joined: Wed May 25, 2016 01:04 AM

Re: Array and MariaDB
Posted: Fri Mar 08, 2019 10:36 PM

Thank you guys!

FiveTech Support Forums

Continue the discussion