From Clomosy Docs
(Created page with "In Clomosy programming, classes are the fundamental building blocks of object-oriented programming. A class is a structure that encompasses data and behaviors, forming the basis for creating objects. Clomosy's class-based structure enhances the organization, clarity, and manageability of code. The properties of the Clomosy class gather data and behaviors together, enabling the design of complex projects in a more comprehensible manner. = General Features = {| class="w...") |
No edit summary |
||
| Line 40: | Line 40: | ||
[[Clomosy_Scripts|Review example]]. | [[Clomosy_Scripts|Review example]]. | ||
= SQL Servers Feature = | |||
{| class="wikitable" | |||
! Feature !! Use of !!Definition | |||
|- | |||
|Function DBSQLServerConnect(ProviderName, Server, UserName, UserPassword, Database:String; Port:Integer=1433):Boolean;||Clomosy.DBSQLServerConnect('SQL Server', Server, Kull, Sifre, DB, 1433);||It is a component used to connect Clomosy applications with SQL Server. | |||
|- | |||
|Function DBSQLServerQueryWith(SQLStr:String):TUniQuery; ||Clomosy.DBSQLServerQueryWith('SELECT * FROM TBLSTOK'); ||Sql Server database query is made and data is accessed. | |||
|} | |||
= Local Database Feature = | |||
{| class="wikitable" | |||
! Feature !! Use of !!Definition | |||
|- | |||
|Function DBSQLiteConnect(Database, UPassword:String):Boolean;||Clomosy.DBSQLiteConnect(DB, Sifre); ||It is a component used to connect Clomosy applications with SQLite. | |||
|- | |||
|Function DBSQLiteQueryWith(SQLStr:String):TClSQLiteQuery;||Clomosy.DBSQLiteQueryWith('SELECT * FROM TBLSTOK'); ||Sqlite database query is made and data is accessed. | |||
|} | |||
Revision as of 15:11, 17 August 2023
In Clomosy programming, classes are the fundamental building blocks of object-oriented programming. A class is a structure that encompasses data and behaviors, forming the basis for creating objects. Clomosy's class-based structure enhances the organization, clarity, and manageability of code.
The properties of the Clomosy class gather data and behaviors together, enabling the design of complex projects in a more comprehensible manner.
General Features
| Feature | Use of | Definition |
|---|---|---|
| Firm_GUID: String; | Clomosy.Firm_GUID; | The GUID of the company where the user is located is provided. Educational accounts do not have a company GUID. For this reason, it returns "CLOSTARTER." |
| Clomosy.Project_GUID: String; | Clomosy.Project_GUID; | The GUID of the project entered by the user is provided. |
| Procedure RunUnit(AUnitName:String); | Clomosy.RunUnit('MyUnit1'); | When you want to invoke a simple unit in Clomosy, you can use the "RunUnit" property. |
| Function GetProjectUserDefParam(xParamName:String):TClJSonQuery; | Clomosy.GetProjectUserDefParam('harfCombo').FieldByName('Value_Integer').AsInteger; | You can get the values of the variable created in the param template. Not available for free membership. |
| Function RunOpenForm(OpenFormParams:TOpenFormParams):Integer; | Clomosy.RunOpenForm(Clomosy.OpenFormParams); | It was created to enable the execution of the created custom form. Review example. |
| Function OpenForm(FormName:TFormTemplate; OpenStyle:TFormDisplayType; Recording:TFormRecordOption; FilterOption:TFormFilterOption):Integer; | Clomosy.OpenForm(ftItems,fdtSingle,froAddNew,ffoNoFilter); | Used to open custom form. |
| Procedure AskAndCall(xAskStr:WideString; CallYesProc, CallNoProc:String); | Clomosy.AskAndCall('Are You Cola','ProcYes','ProcNo'); | It returns a check box. Operations can be made according to the yes or no option. |
| Function Ask(AskStr:String):Boolean; | Clomosy.Ask('Are You Cola?') | It is the parameter required to write the question in the confirmation box. |
| Function ClomosyID:Integer; | Clomosy.ClomosyID; | If the return value is 0, it is known that you are in Clomosy CRM, and if it is 1, you are in the Clomosy Learn application. |
Send Message/Mail/Notify Feature
| Feature | Use of | Definition |
|---|---|---|
| Function SendNotification(TitleStr, BodyStr, UserGUID :String):Boolean; | Clomosy.SendNotification(notifTitleEdt.Text, notifTextEdt.Text, notifSendToEdt.Text); | Used to send notifications to all users in the project. |
| Function SendNotifyAllUsers(TitleStr, BodyStr, WithoutUsers :String):Boolean; | Clomosy.SendNotifyAllUsers(TitleEdt.Text, TextEdt.Text, SendToEdt.Text); | If there is a user in the project that is not wanted to be notified, by selecting that user, notifications are sent to others. |
| Function SendMailNoReplay(TitleStr, BodyStr, UserGUID :String):Boolean; | Clomosy.SendMailNoReplay('Title:Information',ztStr,'[email protected]'); | It is used to send a message to the desired e-mail address. |
SQL Servers Feature
| Feature | Use of | Definition |
|---|---|---|
| Function DBSQLServerConnect(ProviderName, Server, UserName, UserPassword, Database:String; Port:Integer=1433):Boolean; | Clomosy.DBSQLServerConnect('SQL Server', Server, Kull, Sifre, DB, 1433); | It is a component used to connect Clomosy applications with SQL Server. |
| Function DBSQLServerQueryWith(SQLStr:String):TUniQuery; | Clomosy.DBSQLServerQueryWith('SELECT * FROM TBLSTOK'); | Sql Server database query is made and data is accessed. |
Local Database Feature
| Feature | Use of | Definition |
|---|---|---|
| Function DBSQLiteConnect(Database, UPassword:String):Boolean; | Clomosy.DBSQLiteConnect(DB, Sifre); | It is a component used to connect Clomosy applications with SQLite. |
| Function DBSQLiteQueryWith(SQLStr:String):TClSQLiteQuery; | Clomosy.DBSQLiteQueryWith('SELECT * FROM TBLSTOK'); | Sqlite database query is made and data is accessed. |