Table structure?
Joakim Schramm
joakim at astrocalc.com
Sat Apr 29 21:23:37 CDT 2006
> -----Original Message-----
> From:
> valentina-bounces+joakim=astrocalc.com at lists.macserve.net
> [mailto:valentina-bounces+joakim=astrocalc.com at lists.macserve.
> net] On Behalf Of Joakim Schramm
> Sent: 29 April 2006 20:56
> To: 'Valentina Developers'
> Subject: RE: Table structure?
>
> 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!
>
Aha end of the 400+mb logfile says
VTable.AddRecord...
PARAM: this = 25451568
ERROR: 0x99520 Demo-version time limit reached
But error message say Automation error, Catastrofic! Valentina wasn't fast
enough :-) Well it's not only her...
Joakim
> 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
> >
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>
More information about the Valentina
mailing list