'COPY TO' problem with timestamp datatype

'COPY TO' problem with timestamp datatype

Postby fraxzi » Wed Mar 03, 2010 8: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
User avatar
fraxzi
 
Posts: 811
Joined: Tue May 06, 2008 4:28 am
Location: Philippines

Re: 'COPY TO' problem with timestamp datatype

Postby nageswaragunupudi » 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
User avatar
nageswaragunupudi
 
Posts: 10627
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: 'COPY TO' problem with timestamp datatype

Postby fraxzi » Thu Mar 04, 2010 1: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
User avatar
fraxzi
 
Posts: 811
Joined: Tue May 06, 2008 4:28 am
Location: Philippines

Re: 'COPY TO' problem with timestamp datatype -- SOMEWHAT SOLVED

Postby fraxzi » 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
User avatar
fraxzi
 
Posts: 811
Joined: Tue May 06, 2008 4:28 am
Location: Philippines


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: Marc Venken and 64 guests