MariaDB RS to Temporary Table

[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

[vilian]

Hi Fraxzi,


I think you can do something like this:

Code: Select all

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

[fraxzi]

Hi Vilian,

Thanks! I will try this. Let you know.

[Maurizio]

I use

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

Maurizio
www.nipeservice.com