[SQL] multiple insert

2004-09-29 Thread van Elsacker Frans
We developed a program to follow up the time one is working on a particular job. They start and stop the time counter different times a day, now for already tree years. Everything works fine but for a short while (august?) there are very few actions from which the beginning time is inserted t

[SQL] dump and schema

2003-12-15 Thread van Elsacker Frans
I have a problem with date default and schema's and don't know wether I am doing something wrong or not. All my tables (more than 100) have a field datumi of type date default today, as this example: CREATE TABLE tabel ( datumi date DEFAULT 'today', ); taking a dump or a sc