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