Topic: sqlitepass and Delphi 2009
I am trying to save data to a database but when I load the data back in the string fields are truncated.
I set the database filds up with sqliteadministator with there respective sizes.
I save the data using the following in table tpic
tpic.Insert;
tpic['FileName']:= edit7.Text; // size 15
tpic['Created']:= dtp3.Date;
tpic['Modified']:= dtp4.Date;
tpic['FileType']:= edit8.Text;
tpic['Label']:= edit9.Text;
tpic['Description']:= edit10.Text;
tpic['KeyWords']:= edit11.Text;
tpic['Rating']:= edit12.Text;
tpic['Location']:= edit13.Text; // size 100
tpic.Post;
I save for example john 001.jpeg from edit7 and c:\delphi\photo from edit13
When I save the data it looks fine. Reopen the database and john 001.jpeg now is john 0 and c:\delphi\photo is now
c:\delph
This is such a simple process however I cannot see why the data is truncating.
Any suggestions.
Regards John.