mORMot Open Source

jonsafi

Member

Registered: 2011-07-26

Posts: 58

TSynBigTableString: Can't seem to save file...

Hello,

Have just updated the framework and am using Delphi 2009.
Can't seem to get the file saved to disk for the info stored on
TSynBigTableString, perhaps it did save it once out of five trials or so...

Checked that the info does go into TSynBigTableString
before the attempt to save the file..
Also checked that the data indexes are unique..
Could you please help me out as to what could be the reason...?

Var
BT_: TSynBigTableString;
BEGIN

BT_ := TSynBigTableString.Create(stud_dir +GG_STUD_DIR + 'Stud_Info' + GG_TXT_); // create file handle

//....
BT_.Add(student_id_str + GG_SEP + Email_str
                                    + GG_SEP +  FullName_str
                                    + GG_SEP + GPA_str
                                    + GG_SEP + Total_Credits_str,
                                    StringToUtf8(student_id_str)); // add data

write_log(BT_.FileName + ' '+ inttostr(BT_.Count) + ' entries',True); // save to log nr of entries

If   BT_.Get(StringToUtf8('123456'+GG_SEP),Raw_2) Then
     write_log('found ' + Raw_2 + '!',True) // Student '123456' is indeed there
  Else
     write_log('Not found!',True);


BT_.UpdateToFile(); // fails to save file

BT_.UpdateToFile(True); // also fails to save file

BT_.Free;
  

jonsafi

Member

Registered: 2011-07-26

Posts: 58

Re: TSynBigTableString: Can't seem to save file...

Hello,

Tried the above code in a new, separate application and it works just OK.
However, when used together with the original application with the native Oracle
driver unit SynDBOracle, it just won't write a file when called
by UpdateToFile.
It does report a filesize however, using
FileSizeOnDisk,
which is suspiciously large, over 40GB.

Could this be somekind of memory interference...

Much obliged for your comments. In the meantime,
will try  using TSynBigTable instead.

jonsafi

Member

Registered: 2011-07-26

Posts: 58

Re: TSynBigTableString: Can't seem to save file...

Just a quick update, am using the nice
TSynBigTable successfully, the above problem with
TSynBigTableString is still a bit unclear, but
now guess it has something to do with the
fact that the file holding was not being
created successfully and was not checking the
error status...