Kenneth.Rice

Missing "value" field

Discussion created by Kenneth.Rice on Aug 30, 2010
Latest reply on Aug 31, 2010 by spilon

Hi everyone,

 

I decided I would join the "dark" side and learn to create web services and .aspx pages (last programming days were in College).

 

Heres the problem I borrowed the "Building a Web Service that Executes PI SQL and Returns a Data Set". Web Service running well, now I made a aspx page with a gridview object, 4 text boxes and a button.

 

I submit the query

 

SELECT "tag", "time", "value", "status", "questionable", "substituted", "annotated", "annotations" FROM "piarchive".."pisnapshot" WHERE tag = 'sinusoid'

 

Everything returns to the gridview except the value field. What am I missing/doing wrong?

 

Thanks in advance

Outcomes