|
Use this system procedure to register or unregister a .NET method as the script for a table event.
|
Item |
Description |
Remarks |
|---|---|---|
|
1 |
version name |
VARCHAR(128) |
|
2 |
table name |
VARCHAR(128) |
|
3 |
event name |
VARCHAR(128) |
|
4 |
script contents |
For SQL Anywhere and Microsoft SQL Server, this parameter is TEXT. For Adaptive Server Enterprise, this parameter is VARCHAR(16384). For Adaptive Server Enterprise prior to 12.5, this parameter is VARCHAR(255). For DB2 UDB, this parameter is VARCHAR(4000). For Oracle, this parameter is CLOB. |
To unregister a method, set the script contents parameter to NULL.
The script value is a public method in a class in a .NET assembly (for example, MyClass.MyMethod).
When you call ml_add_dnet_table_script, the method is associated with the table, event, and script version that you specify. If the version name is new, it is automatically inserted into the ml_version table.
The following example assigns the empDownloadCursor method of the EgClass class to the download_cursor event for the table emp.
call ml_add_dnet_table_script( 'ver1', 'emp', 'download_cursor',EgPackage.EgClass.empDownloadCursor')