Page 1 of 1

Array and MariaDB

Posted: Thu Mar 07, 2019 7:21 pm
by wartiaga
Hi Guys,

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

Thanks in advance.

Re: Array and MariaDB

Posted: Thu Mar 07, 2019 9:33 pm
by cnavarro

Re: Array and MariaDB

Posted: Fri Mar 08, 2019 2:44 am
by nageswaragunupudi
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


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

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

Re: Array and MariaDB

Posted: Fri Mar 08, 2019 10:36 pm
by wartiaga
Thank you guys!