TSQLTableJSON set field size

nirnir · 2013-12-25 20:11:35

I'm using TSQLTableJSON and convert it to Tclientdataset .
the field size in Tclientdataset is automatically defined by the json column content length ,
The current value length shouldn't be the maxsize of the dataset column.
I'm using SetFieldType to define the column type for the created dataset , how can I control the size also ?

ab · 2013-12-26 01:51:34

nirnir wrote:

The current value length shouldn't be the maxsize of the dataset column.

Why not?
If you want to store something bigger?

nirnir · 2013-12-26 06:26:35

suppose the longest first_name in the json database was 'ab' ,
after I converted it to Tdataset the column size would be 2 and I wouldn't be able to insert value longer than two characters .

ab · 2013-12-28 16:34:55

TSQLTable.SetFieldType() method allows now to specify a column size.
See http://synopse.info/fossil/info/a6f2c6965e

Hope it fits your needs.

nirnir · 2013-12-29 08:07:50

Thanks, you are great .

you forgot to change

ContentSize := -1;
TO
ContentSize := FieldSize;
inside SetFieldType

ab · 2013-12-29 16:19:32

Oups...
I did it again!

See http://synopse.info/fossil/info/8be083220d

mORMot Open Source

#1 2013-12-25 20:11:35

TSQLTableJSON set field size

#2 2013-12-26 01:51:34

Re: TSQLTableJSON set field size

#3 2013-12-26 06:26:35

Re: TSQLTableJSON set field size

#4 2013-12-28 16:34:55

Re: TSQLTableJSON set field size

#5 2013-12-29 08:07:50

Re: TSQLTableJSON set field size

#6 2013-12-29 16:19:32

Re: TSQLTableJSON set field size

Board footer