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

Felipe Monteiro de Carvalho felipemonteiro.carvalho at gmail.com
Mon Sep 8 20:19:27 CEST 2008


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.

> I never used TSdfDataset, I made the integration
> into MSEgui with tmsesdfdataset only so my knowledge about TSdfDataset is
> limited.
> Is Sqlite3 no option for you? MSEgui and FPC sqldb both have a DB-connection
> component for SQLite3.

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.

-- 
Felipe Monteiro de Carvalho



More information about the fpc-devel mailing list