topic-36064

Board index FiveWin for Harbour/xHarbour MariaDB RS to Temporary Table

fraxzi

Posts: 811

Joined: Tue May 06, 2008 04:28 AM

MariaDB RS to Temporary Table
Posted: Thu Sep 06, 2018 12:54 AM

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:

Kind Regards,

Frances

Fivewin for xHarbour v18.07

xHarbour v1.2.3.x

BCC 7.3 + PellesC8 ( Resource Compiler only)

ADS 10.1 / MariaDB

Crystal Reports 8.5/9.23 DE

xMate v1.15

vilian

Posts: 1067

Joined: Wed Nov 09, 2005 02:17 AM

Re: MariaDB RS to Temporary Table
Posted: Thu Sep 06, 2018 01:18 AM

Hi Fraxzi,

I think you can do something like this:

Code (fw): Select all Collapse

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

Sds,
Vilian F. Arraes
vilian@vfatec.com.br
Belém-Pa-Brazil

fraxzi

Posts: 811

Joined: Tue May 06, 2008 04:28 AM

Re: MariaDB RS to Temporary Table
Posted: Thu Sep 06, 2018 05:55 AM

Hi Vilian,

Thanks! I will try this. Let you know.

:wink:

Kind Regards,

Frances

Fivewin for xHarbour v18.07

xHarbour v1.2.3.x

BCC 7.3 + PellesC8 ( Resource Compiler only)

ADS 10.1 / MariaDB

Crystal Reports 8.5/9.23 DE

xMate v1.15

Maurizio

Posts: 842

Joined: Mon Oct 10, 2005 01:29 PM

Re: MariaDB RS to Temporary Table
Posted: Thu Sep 06, 2018 07:05 AM

I use

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

Maurizio

www.nipeservice.com

Maurizio
www.nipeservice.com

FiveTech Support Forums

Continue the discussion