Page 1 of 1

MariaDB RS to Temporary Table

Posted: Thu Sep 06, 2018 12:54 am
by fraxzi
Hi All,

i've been looking our threads related to this but none I found..

I am looking for a way to save oRS to Table (not as .dbf) in MariaDB.. How to do this :?:

any :idea:

Re: MariaDB RS to Temporary Table

Posted: Thu Sep 06, 2018 1:18 am
by vilian
Hi Fraxzi,


I think you can do something like this:

Code: Select all

aValues  :=  oCn:QueryResult("SELECT * FROM yourtable") 
oCn:Insert("newtable",,aValues)
 

Re: MariaDB RS to Temporary Table

Posted: Thu Sep 06, 2018 5:55 am
by fraxzi
Hi Vilian,

Thanks! I will try this. Let you know.

:wink:

Re: MariaDB RS to Temporary Table

Posted: Thu Sep 06, 2018 7:05 am
by Maurizio
I use

oServer:Execute( 'CREATE TABLE tmp_1234 AS select * FROM yourtable ')

Maurizio
www.nipeservice.com