Table structure?

[Joakim Schramm]

I must do something wrong, import of data crashes after about 80% with
automation error, it's on AddRecord call. Also, the data which I read from
text files occupy 11Mb on disc, but on scrash the db .dat file is 333Mb!

I expet this to be more then the text files, as when imoprting to my old db
it takes 46Mb - 333 sounds rediculus much and the import isn't even ready!
Ok, this is no complain, I realize something must be wrong with my code. I
was able to open the db in Vstudio and noticed that nothing had gone inte to
my zone table and probably I assign value to DateTime field wrongly
(Table.Field("DateTime").SetString "1999/10/04 13:23:00") but I couldn't
find anywere in the docs about how to format the string to add to this
field.

Does VarChar fields affect size depending on maxsize aka 1022, if only 3 or
4 charcters is stored in field?

Joakim
>