Data processor not returning primary key from query

Suite and Optimus Suite 5
#1

Hi,
I have a dataprocessor connected to a grid. The grid should contain the primary key returned from the select query but it doesn’t.
My connector is initialised as follows:

        connector = New dhtmlxGridConnector(
            "Select id, Username, AreaID, PointNumber, AreaName, AreaDescription, Latitude, Longitude from AssetTrackAreas where (PointNumber <> 0) order by PointNumber",
            "id",
            dhtmlxDatabaseAdapterType.SqlServer2005,
            ConfigurationManager.ConnectionStrings("myDatabase").ConnectionString)

The connector returns all fields except id (which is the primary key).

This worked fine with the versión 0.9.8.3 of the .NET.dll but it doesn’t work with versión 1.1.0.0

What is wrong?

#2

Hi,
try the latest version of connector. I’ve tested selecting the primary key with the query, it seems working with the samples from package
s3.amazonaws.com/uploads.hipcha … 131213.zip

#3

Hi,
yes this versión Works.
Thanks.