[fpc-devel] TSdfDataset does not work with records larger then 255 chars

[Martin Schreiber]

On Monday 08 September 2008 20.19:27 Felipe Monteiro de Carvalho wrote:
> On Mon, Sep 8, 2008 at 3:14 PM, Martin Schreiber <fpmse at bluewin.ch> wrote:
> > It seems so if you don't define the field size in the TSdfDataset.Schema.
> > Unlike tmsebufdataset, TSdfDataset stores the data in a record with fixed
> > size which can't be changed after open. Is it possible to define the
> > field size in the first data row?
>
> Didn't work:
>
> ID,NAMEEN,NAMEPT,HEIGHT,WIDTH,PINS,DRAWINGCODE = 2048 chars
>
> It hits the same limit as before.
>
ID,NAMEEN,NAMEPT,HEIGHT,WIDTH,PINS,DRAWINGCODE = 2048
works for me, it returns the fieldsize of 53 (the character count of the first 
row) for ID, NAMEEN, NAMEPT, HEIGHT, WIDTH and PINS and 2048 for DRAWINGCODE.
>
> I have found sdf better then sqlite3 (except for the bugs) for my
> small database needs, because I then I don't need an external library
> and I like the fact that i can easely edit the database with a text
> editor.

MSEgui tstatfile or ttextdatastream are other options, probably Lazarus has 
similar components?

Martin