Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

MES Stateful API

TABLE OF CONTENTS

GetDSbySQL Method

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL

The GetDSbySQL() method retrieves a new DataSet based on the SQL statement passed as a parameter. The SQL statement must be a single SELECT statement.

Syntax

'Declaration
 
Public Function GetDSbySQL( _
   ByVal sql As String _
) As DataSet
public DataSet GetDSbySQL( 
   string sql
)

Parameters

sql
Required. Holds the SQL SELECT statement to execute.

Return Value

Returns a DataSet based on the supplied SQL SELECT statement.

Remarks

Prior to MES 2017, any SQL statement could be passed as a parameter to this method. With MES 2017 and later, any call not using a single SELECT statement will result in the error "Invalid SQL statement caught by Middleware."

See Also

Reference

ClientSession Class
ClientSession Members

In This Topic
TitleResults for “How to create a CRG?”Also Available in