From Clomosy Docs
No edit summary |
No edit summary |
||
| Line 59: | Line 59: | ||
|- | |- | ||
|Function DBSQLiteQueryWith(SQLStr:String):TClSQLiteQuery;||Clomosy.DBSQLiteQueryWith('SELECT * FROM TBLSTOK'); ||Sqlite database query is made and data is accessed. | |Function DBSQLiteQueryWith(SQLStr:String):TClSQLiteQuery;||Clomosy.DBSQLiteQueryWith('SELECT * FROM TBLSTOK'); ||Sqlite database query is made and data is accessed. | ||
|} | |||
= Cloud Database Feature = | |||
{| class="wikitable" | |||
! Feature !! Use of !!Definition | |||
|- | |||
|Function DBCloudSQLSelectWith(SQLStr:String):TClJSonQuery;||Clomosy.DBCloudSQLSelectWith(sqlString); ||It can be used to retrieve data from a specific database table or view or to execute an SQL query. | |||
|- | |||
|Function DBCloudQueryWith(CloudDataSource:TFormTemplate;Filter_GUID, FilterStr:String):TClJSonQuery;||Clomosy.DBCloudQueryWith(ftProducts,'','1=1'); ||Cloud database query is made and data is accessed. | |||
|- | |||
|Function DBCloudPostJSON(CloudDataSource:TFormTemplate; DataJSON:String):Boolean; ||Clomosy.DBCloudPostJSON(ftThreads,'[{"Thread_Value_Str":"Test Exam"}]'); ||It is a process used to handle JSON data from a database. | |||
|} | |||
= Data Source Process = | |||
{| class="wikitable" | |||
! Feature !! Use of !!Definition | |||
|- | |||
|function ClDataSetFromJSON(payload : String):TClJSonQuery;||Clomosy.ClDataSetFromJSON('[{"name":"Jack","age":22}]');||It can represent the process of converting data that comes in JSON format into a dataset. | |||
|} | |||
= Image Procedure and Functions Feature= | |||
{| class="wikitable" | |||
! Feature !! Use of !!Definition | |||
|- | |||
|Procedure GlobalBitmapSaveToFile(aFileName:String);||Clomosy.GlobalBitmapSaveToFile('x:\GlobalBitmap.png');||It allows converting an image or bitmap into a file and saving it to a desired directory. | |||
|} | |||
= System Feature = | |||
{| class="wikitable" | |||
! Feature !! Use of !!Definition | |||
|- | |||
|Procedure ProcessMessages;||Clomosy.GlobalBitmapSaveToFile('x:\GlobalBitmap.png');||It allows converting an image or bitmap into a file and saving it to a desired directory. | |||
|} | |} | ||
Revision as of 11:13, 21 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. |
Cloud Database Feature
| Feature | Use of | Definition |
|---|---|---|
| Function DBCloudSQLSelectWith(SQLStr:String):TClJSonQuery; | Clomosy.DBCloudSQLSelectWith(sqlString); | It can be used to retrieve data from a specific database table or view or to execute an SQL query. |
| Function DBCloudQueryWith(CloudDataSource:TFormTemplate;Filter_GUID, FilterStr:String):TClJSonQuery; | Clomosy.DBCloudQueryWith(ftProducts,,'1=1'); | Cloud database query is made and data is accessed. |
| Function DBCloudPostJSON(CloudDataSource:TFormTemplate; DataJSON:String):Boolean; | Clomosy.DBCloudPostJSON(ftThreads,'[{"Thread_Value_Str":"Test Exam"}]'); | It is a process used to handle JSON data from a database. |
Data Source Process
| Feature | Use of | Definition |
|---|---|---|
| function ClDataSetFromJSON(payload : String):TClJSonQuery; | Clomosy.ClDataSetFromJSON('[{"name":"Jack","age":22}]'); | It can represent the process of converting data that comes in JSON format into a dataset. |
Image Procedure and Functions Feature
| Feature | Use of | Definition |
|---|---|---|
| Procedure GlobalBitmapSaveToFile(aFileName:String); | Clomosy.GlobalBitmapSaveToFile('x:\GlobalBitmap.png'); | It allows converting an image or bitmap into a file and saving it to a desired directory. |
System Feature
| Feature | Use of | Definition |
|---|---|---|
| Procedure ProcessMessages; | Clomosy.GlobalBitmapSaveToFile('x:\GlobalBitmap.png'); | It allows converting an image or bitmap into a file and saving it to a desired directory. |