Very Computer

by **Hercules Russa** » Sun, 18 May 1997 04:00:00

I need to import data from a .DBF (Clipper) to a Ttable (.DBF), built
as follow:
.....
Add('DT',ftDate,0,false);
...
createtable;

To import the data, I use the follow code:
....
destin.FieldByName('dt').asDateTime :=
lsource.FieldByName('dt').AsDateTime;

The code performs well. But, when I open the file, the BDE yelds the
follow error
message: 'translate error. Value out of bounds'.
I think that this occur due to restriction of the method
'fieldByName', that need
the type AsDateTime (30 caracters) and the destination field was built
with
type ftDate (8 caracters).
But, I need that this field really had type ftDate.
How to resolve this problem?

Hercules Russano
HRsoFT-"Simples, mas funciona!"
S?o Gon?alo-Rio de Janeiro-Brazil

by **Larry Henge** » Mon, 19 May 1997 04:00:00

> I need to import data from a .DBF (Clipper) to a Ttable (.DBF), built
> as follow:
> .....
> Add('DT',ftDate,0,false);
> ...
> createtable;

> To import the data, I use the follow code:
> ....
> destin.FieldByName('dt').asDateTime :=
> lsource.FieldByName('dt').AsDateTime;

> The code performs well. But, when I open the file, the BDE yelds the
> follow error
> message: 'translate error. Value out of bounds'.
> I think that this occur due to restriction of the method
> 'fieldByName', that need
> the type AsDateTime (30 caracters) and the destination field was built
> with
> type ftDate (8 caracters).
> But, I need that this field really had type ftDate.
> How to resolve this problem?

> Hercules Russano
> HRsoFT-"Simples, mas funciona!"
> S?o Gon?alo-Rio de Janeiro-Brazil

To transfer data from a DBF table with a Date field and an Interbase
table, I use the Database Desktop. Worked great, and handled the TDate
to TDateTime translation. That however, is not your problem. There is
no need to translate between 2 DBF tables. Both date fields should be
TDate types.

Very Computer

ftDate, ftDateTime - Problem

ftDate, ftDateTime - Problem

ftDate, ftDateTime - Problem