I have one field which has to be populated with larger data. I created textField to hold data, but very often, when diagnosing that DB, I get following errors. When trying to access affected records, Valentina Studio crashes with lot of Kernel errors.
.....> SegmentFile:
Segment 40022 has wrong mIndex must be 81 in fact 1
Segment 40022 has wrong mFirstSegment must be 9063 in fact 40022
Segment 40022 has wrong mPrevSegment must be 5298 in fact 0
Problems found! ( SegmentFile: )
Problems found! ( Field: completeInfo , type Text )
Since DB is created in Xojo, this is Generated SQL for completeInfo field:
-- CREATE FIELD "completeInfo" ---------------------------------
ALTER TABLE "asset" ADD COLUMN "completeInfo" TEXT ( 128 );
-- -------------------------------------------------------------
How can I find why these problems keeps happening?
Thank you,
Aleksandar