Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread DataSet Column JSON format request
Sat, Jul 23 2016 3:54 AMPermanent Link

thomh

Hi Tim,

It would be nice to be able to set the TGridHeader.Caption, and also other component Caption properties, through the JSON returned by the server used in the TDataSet.LoadColumns method.

So something like <Name> <DisplayLabel> <Type> <Length> <Scale>

<Name> = String (Example: "CustNo")
<DisplayLabel> = String (Example: "Customer No")

Would especially help when coding multilingual applications.

// Thom
Mon, Jul 25 2016 3:34 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Thom,

<< It would be nice to be able to set the TGridHeader.Caption, and also other component Caption properties, through the JSON returned by the server used in the TDataSet.LoadColumns method. >>

The issue is where this information would come from.  Most databases don't have this type of information available, especially through common interfaces such as OLEDB and ODBC.

Tim Young
Elevate Software
www.elevatesoft.com
Wed, Jan 18 2017 4:30 PMPermanent Link

tompaw

Tim Young [Elevate Software] wrote:

<<The issue is where this information would come from.  Most databases don't have this type of information available, especially through common interfaces such as OLEDB and ODBC.>>

Would like this, there are several ways to supply the information:

- from odbc-datasources that support this (DB/2...)
- from custom web servers/datamodules (that's what we are doing...)
- from a JSON-string obtained whatever way and used in the TDataset.LoadRows method

It would also be nice to have properties for DisplayWidth, Alignment, ReadOnly and Required within the JSON.....

Thomas Werner
-DATA
Wed, Jan 25 2017 2:15 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Tom,

You can already save/load TGridColumn instances to/from JSON.  That's how forms load the grid columns at run-time.

However, to do so effectively in method call at the grid level would require me adding specific method calls for the saving/loading of the columns.  I will add it to the list of enhancements.

Tim Young
Elevate Software
www.elevatesoft.com
Image