Hi all,
I am trying to display the return data from the cache web service into
VS.NET using
the data grid. But it happens that only the column name are displayed, but
with no data.
Below shows the web method that I have used to return the data from the
cache samples:
/// A sample class query as a WebMethod that defines a typed dataset that
returns Person data
/// ordered by <property>Name</property>
/// This query also generates a WebMethod of the same name that may be
called using SOAP
/// in order to return a typed .Net DataSet.
Query QueryByName(name As %String = "") As %SQLQuery(CONTAINID = 1, ROWSPEC
= "ID:%Integer,Name:%String(MAXLEN=30),DOB,SSN", SELECTMODE = "RUNTIME") [
WebMethod ]
{
SELECT ID, Name, DOB, SSN
FROM Sample.Person
WHERE (Name %STARTSWITH :name)
ORDER BY Name
}
If I use %XML.DataSet instead of %SQLQuery for the web method, I can recieve
the data with the column name.
My question is, why can't I receive any data using %SQLQuery ?
