I thought I'd try migrating my current DBISAM database to EDB via the EDB
Manager database menu item.

Stopped with:

ElevateDB Error #700 An error was found in the default column expression at
line 1 and column 1 (Expected NULL, Date expression but instead found
'2000-01-01')

(Roy was right about giving us a copy/paste path for your error messages


the offending line in the clients table, as reverse-engineered by DBSYS,
is:

"cliAJour" DATE DESCRIPTION 'Dernière date client ne devait rien' NOT NULL
DEFAULT '2000-01-01',

--
Chris
(XP-Pro + Delphi 7 Architect + DBISAM 4.25 + EDB Manager 1.00 build 6)

Chris,

<< (Roy was right about giving us a copy/paste path for your error messages
>>

I'll see what I can do about adding a custom error message dialog to the EDB
Manager.

<< the offending line in the clients table, as reverse-engineered by DBSYS,
is:

"cliAJour" DATE DESCRIPTION 'Dernière date client ne devait rien' NOT NULL
DEFAULT '2000-01-01', >>

Dates, times and timestamps in EDB are SQL standard now:

DATE <DateConstant>
TIME <TimeConstant>
TIMESTAMP <TimestampConstant>
INTERVAL <IntervalConstant> <IntervalType>

http://www.elevatesoft.com/edb1sql_date_time_types.htm

So, the EDB migration code needs to be fixed because it isn't adding the
DATE portion.

--
Tim Young
Elevate Software
www.elevatesoft.com