C# Класс EAAddinFramework.Utils.Model

Expose Clipboard.Clear()

Expose Clipboard.SetText()

Exposes ClipboardGetText(TestDataFormat); 0=TextDataFormat.CommaSeparatedValue; 1=TextDataFormat.Html; 2=TextDataFormat.Rtf; 3=TextDataFormat.Text; 4=TextDataFormat.UnicodeText;

Expose Clipboard.SetText()

Exposes ClipboardSetText(text, TestDataFormat); 0=TextDataFormat.CommaSeparatedValue; 1=TextDataFormat.Html; 2=TextDataFormat.Rtf; 3=TextDataFormat.Text; 4=TextDataFormat.UnicodeText;

escapes a literal string so it can be inserted using sql

Execute SQL and catch Exception

formats an xpath according to the type of database. For Oracle and Firebird it should be ALL CAPS

Gets the rep type for this model

Initialize an rep Model object Intended to use from a scripting environment

Make EA XML output format from EA SQLQuery XDocument format (LINQ to XML)

Make EA XML output format from EA SQLQuery XDocument format (LINQ to XML). If nothing found or an error has occurred nothing is displayed.

Make EA XML output format from EA SQLQuery format (string)

Create a model on the first running EA instance

Create a Model

Runs the search (EA search or hoTools SQL file if it's a *.sql file). It handles the exceptions. It converts wild cards of the <Search Term>.

EA Execute SQL: - formatSQL - runSQL - return SQL string

Run EA SQL Query with Exception handling return null if error, it also displays the error message in MessageBox return "" if nothing found return xml string if ok

EA SQL Query with: - formatSQL - runSQL - return SQL string as XmlDocument

EA SQL Query native with: - formatSQL - runSQL - return SQL string

Run EA SQL Query with Exception handling. It deletes the error file and reads it back to detect errors. return null if error, it also displays the error message in MessageBox return "" if nothing found return xml string if ok

Run an SQL string and if query output the result in EA Search Window. If update, insert, delete execute SQL. - replacement of macros - run query - format to output

Empty Query Result

sets the correct wild cards depending on the database type. changes '%' into '*' if on ms access and _ into ? on msAccess

Operation to translate SQL functions in there equivalents in different sql syntaxes supported functions: - lcase -> lower in T-SQL (SqlSvr and Asa)

limiting the number of results in an sql query is different on different platforms.

Format DB specific by removing unnecessary DB specific string parts.

Replace the wild cards in the given sql query string to match either MSAccess or ANSI syntax. It works for: % or * or #WC# Any character _ or ? a single character '^' or '!' a shortcut for XOR