You can't use dialect 3 databases with the BDE, at least not without
accepting the current limitations. Is your original field a real date+time
or it only holds date information?
Try with a dialect 1 db. The Borland Dinosaur Engine (the base for
TBatchMove) can't talk with dialect 3 databases if they use the DATE and
TIME new data types. It can't talk to
numeric(n,x) where n>9 if the field was created in dialect 3, too. The old
DATE datatype is now called TIMESTAMP. In dialect 1, however, you can still
use DATE and it will map to TIMESTAMP.
Read the ReleaseNotes.pdf that comes with Interbase v6.

C.

> -----Original Message-----
> From: mss@... [mailto:mss@...]
> Sent: Martes 12 de Septiembre de 2000 11:27
> To: IB-Conversions@egroups.com
> Subject: [IB-Conversions] dBase to Interbase
>
>
> I've been having a lot of trouble converting my dBase tables to
> Interbase. Is there a good way to do this?
>
> I've been attempting to use the BatchMove component of Delphi 5 but I
> receive many errors. For example, here is a typical error:
>
> EDBEngineError
>
> 'Invalid table create request.
> Metadata update statement is not allowed by the current database SQL
> dialect 3
> SQL warning code = 301
> Date data type is now
> General SQL Error
> called TIMESTAMP'
>
> or I might receive a similar error when attempting to convert a
> different dBase table:
>
> EDBEngineError
>
> 'Invalid table create request.
> Metadata update statement is not allowed by the current database SQL
> dialect 3'
>
> Any ideas? Thanks.
>
> - Dale Francis.