'COPY TO' problem with timestamp datatype

Board index FiveWin for Harbour/xHarbour 'COPY TO' problem with timestamp datatype

fraxzi

Posts: 811

Joined: Tue May 06, 2008 04:28 AM

'COPY TO' problem with timestamp datatype
Posted: Wed Mar 03, 2010 08:49 AM

Hello all,

I have a table with timestamp datatype field.

when I 'COPY TO' the content to another table.. generates runtime 'data type error'

How to resolved?

Regards,
FAP

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

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: 'COPY TO' problem with timestamp datatype
Posted: Wed Mar 03, 2010 12:53 PM

I presume you are using DBFCDX.
If you use SETRDDDEFAULT( 'DBFCDX' ) and then use COPY TO command, it copies Timestamp fields also correctly.
I have tested on XHarbour.

Regards

G. N. Rao.

Hyderabad, India

fraxzi

Posts: 811

Joined: Tue May 06, 2008 04:28 AM

Re: 'COPY TO' problem with timestamp datatype
Posted: Thu Mar 04, 2010 01:10 AM

Dear RAO,

Thanks again.

I use .ADT tables.

I tried rddsetdefault( 'ADS' ) and/or rddsetdefault( 'ADT' ) on INIT PROCEDURE
but still with error description: 'Data Type Error' on table with timestamp field.

What causing this?

Regards,
FAP

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

fraxzi

Posts: 811

Joined: Tue May 06, 2008 04:28 AM

Re: 'COPY TO' problem with timestamp datatype -- SOMEWHAT SOLVED
Posted: Wed Mar 10, 2010 12:05 AM

Dear All,

I end up using AdsCopyTable().. It works though but I lost gaugebar/meter.. adsRegCallBack() woking only in indexing not in other function like AdsCopyTable()

Regards,
FAP

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

FiveTech Support Forums

Continue the discussion