Array and MariaDB

Array and MariaDB

Postby wartiaga » Thu Mar 07, 2019 7:21 pm

Hi Guys,

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

Thanks in advance.
wartiaga
 
Posts: 204
Joined: Wed May 25, 2016 1:04 am

Re: Array and MariaDB

Postby cnavarro » Thu Mar 07, 2019 9:33 pm

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
User avatar
cnavarro
 
Posts: 6520
Joined: Wed Feb 15, 2012 8:25 pm
Location: España

Re: Array and MariaDB

Postby nageswaragunupudi » Fri Mar 08, 2019 2: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: Select all  Expand view

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

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

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10468
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: Array and MariaDB

Postby wartiaga » Fri Mar 08, 2019 10:36 pm

Thank you guys!
wartiaga
 
Posts: 204
Joined: Wed May 25, 2016 1:04 am


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 49 guests