C-DEngine 5.105

IStorageService..::..EdgeStorageExecuteSql Method

Executes a SQL Command against the StorageService SQL Server. BE VERY CAREFULL! Wrong calls can cause data loss. Currently this call only allowes to be called against a table that was created and owned by this node

Namespace:  nsCDEngine.Engines.StorageService
Assembly:  C-DEngine (in C-DEngine.dll)

Syntax


void EdgeStorageExecuteSql(
	Type MyClass,
	string SQLExec,
	string ColFilter,
	string MagicID,
	Action<TSM> CallBack,
	string pTableName
)
Sub EdgeStorageExecuteSql ( _
	MyClass As Type, _
	SQLExec As String, _
	ColFilter As String, _
	MagicID As String, _
	CallBack As Action(Of TSM), _
	pTableName As String _
)
void EdgeStorageExecuteSql(
	Type^ MyClass, 
	String^ SQLExec, 
	String^ ColFilter, 
	String^ MagicID, 
	Action<TSM^>^ CallBack, 
	String^ pTableName
)

Parameters

MyClass
Type: Type
Class specifying the table to be addressed
SQLExec
Type: String
Valid TSQL code that can be "Executed" against the SQL Server
ColFilter
Type: String
MagicID
Type: String
Cookie to be passed with the Query
CallBack
Type: Action<(Of <(<'TSM>)>)>
This callback is called when the call is finished and contains a TSM with the result. The TXT parameter contains "DATARETREIVED:" and the PLS contains a serialized "TheDataRetreivalRecord"
pTableName
Type: String
Custom TableName if required