Grid Object in IIS

[olitre86]

Hello

How can seen data from a grid object where data source is Class Tag in IIS web server. In other Way how pass through this limitation :  

"Grid object

The Grid object is supported in project screens on Mobile Access, and it appears and behaves essentially the same as it does in the other, Windows-based thin clients. Nevertheless, you should thoroughly test your project on both types of clients in order to confirm that your Grid object(s) behave as expected during project run time.

The most significant limitation is that only the Database source type is supported; the Text File and Class Tag source types are not supported at this time"

[RicardoMarroni]

You could export your class tag data to an external Database and configure your grid to show the content of the database table. That may sound complex but you can also use a single text file over a database connection using, for instance, the Microsoft Jet 4.0 OLE DB Provider which is available by default on every windows station. 

To export the class tag content, you can use the Report feature unchecking (disabling) the option "Unicode" and having all values delimited by comma (default CSV delimiter).

Once the CSV file is created with the tag values, you can access using a db connection. 

First you need to configure the project "Default Database" under Project >> Options. Pick the Microsoft Jet 4.0 OLE DB Proider (here you find some more details of using DB Connection to a text file). As Datasource you need to give the path of the folder where your file is created - in this case the project folder (you can use the function {GetAppPath()} to retrieve this value). To use a taxt file as source, you also need to add "Extended Properties" that you find on the last tab of the Database configuration dialog. Double click on "Extended Properties" and add the following value "text; HDR=Yes" (without quotes), which means your source is a text based file (also CSV) and it contains a header on the very first line.

On the Grid configuration, set the Datasource as "Database" and on "Database configuration" under "Table" area, uncheck (disable) the option "Use dafault name" and enter with the txt/csv filename containing the tag values.

If you need to export the tag values periodically, you could use a scheduler, for instance.

Attached you find a simple sample application using this approach. 

I hope it helps.

[JenJeff]

You can connect the Class Tag to a database and then use the Database source type for the Grid Object in IIS.