Hi,

I've recently purchased dbman sql and am feeling my way around ....

The first major problem I've hit is with the file import facility.

I have a test table with 5 fields as follows:

1 userid VARCHAR(12) Yes TEXT
2 paid_date DATE No 0000-00-00 TEXT
3 company TEXT No TEXT
4 category_code VARCHAR(255) No TEXT
5 paid CHAR(20) No paid TEXT

and I've been trying to import the following dataset (just as a test)

userid|paid_date|company|category_code|paid
a1||(Taiwan Footwear News) Century Exhibitio|OS|no
a2||3M Company|CS|no
a3||3H Machine Industry Company Limited|MC|no

I've tried doing it from file, and by pasting into the box provided. Eventually I got it to import one row out of the three from the box, but the fields were back to front in the table! I then discovered that if I added the fields one by one in the "fields to import" dialogue in the reverse order, they were imported correctly into the table.

Here's a screen print from mysql showing the 3 rows imported:

userid paid_date company category_code paid
a1 0000-00-00 (Taiwan Footwear News) Century Exhibitio OS no Edit Delete
a2 0000-00-00 3M Company CS no Edit Delete
a3 0000-00-00 3H Machine Industry Company Limited MC no Edit Delete

I've tried this several times and got the same result.
This is buggy in the extreme isn't it?? Has anybody else come across this, or got any ideas why dbman sql is behaving so strangely? Has anyone succeeded in getting the file import to work properly. If someone from GT would like to log in and try this for themselves, I'm happy to provide password details.

Tim
Tim Ault
Oxford UK