From Clomosy Docs
| Quick Look | Entry Level | Advanced Level |
| Caption | Value |
|---|---|
| String | String |
| Integer | Integer |
| Float | Float |
| Double | Double |
| Boolean | Boolean |
| True | True |
| False | False |
| Caption | Value |
|---|---|
| True | True |
| False | False |
| Caption | Value |
|---|---|
| Clomosy | Clomosy |
| OpenForm | OpenForm |
| ResumeLocalEvent | ResumeLocalEvent |
| LocalScripterLog | LocalScripterLog |
| Caption | Value |
|---|---|
| Clomosy.OpenForm(ft,fdt,fro,ffo) | Clomosy.OpenForm() |
| StandartOpenForm | Clomosy.OpenForm(ftItems,fdtSingle,froAddNew,ffoNoFilter); |
| NextOpenForm | Clomosy.ResumeLocalEvent := False; Clomosy.OpenForm(ftItems,fdtSingle,froAddNew,ffoNoFilter); |
| AsString | AsString |
| ShowMessage() | ShowMessage('') |
| Caption | Value |
|---|---|
| ftNone | ftNone |
| ftItems | ftItems |
| ftProducts | ftProducts |
| ftCustomers | ftCustomers |
| ftTasks | ftTasks |
| ftEmployees | ftEmployees |
| ftThreads | ftThreads |
| ftTypes | ftTypes |
| ftMembers | ftMembers |
| ftGroups | ftGroups |
| ftMasters | ftMasters |
| ftActivities | ftActivities |
| ftThreadDetails | ftThreadDetails |
| ftBaseCustoms | ftBaseCustoms |
| ftThreadsView | ftThreadsView |
| ftSurexams | ftSurexams |
| Caption | Value |
|---|---|
| fdtNone | fdtNone |
| fdtSingle | fdtSingle |
| fdtBasket | fdtBasket |
| fdtGuide | fdtGuide |
| fdtBasketPopup | fdtBasketPopup |
| fdtBasketCheckList | fdtBasketCheckList |
| fdtBasketWithMaster | fdtBasketWithMaster |
| Caption | Value |
|---|---|
| froReadOnly | froReadOnly |
| froAddNew | froAddNew |
| froAddNewDetail | froAddNewDetail |
| froUpdate | froUpdate |
| Caption | Value |
|---|---|
| ffoNoFilter | ffoNoFilter |
| ffoDoFilter | ffoDoFilter |
| ffoDoFilterWithEmpty | ffoDoFilterWithEmpty |
| Caption | Value |
|---|---|
| loProListView | loProListView |
| Caption | Value |
|---|---|
| OpenFormTemplate | OpenFormTemplate |
| OpenDisplayType | OpenDisplayType |
| OpenListObject | OpenListObject |
| RecordOption | RecordOption |
| FilterOption | FilterOption |
| QueryFilter | QueryFilter |
| CustomDataSource | CustomDataSource |
| CustomDataSourceDirectRefreshable | CustomDataSourceDirectRefreshable |
| CustomDataProcedureName | CustomDataProcedureName |
| CustomFormName | CustomFormName |
| CustomFormDisplayName | CustomFormDisplayName |
| CustomFormGUIDFieldName | CustomFormGUIDFieldName |
| CustomFormNameFieldName | CustomFormNameFieldName |
| CustomFormCodeFieldName | CustomFormCodeFieldName |
| CustomBackFormGUIDFiledValue | CustomBackFormGUIDFiledValue |
| CustomBackFormSelectedFilter | CustomBackFormSelectedFilter |
| CustomFormReferenceFieldName | CustomFormReferenceFieldName |
| CustomParamID | CustomParamID |
| CustomBackFormValuesOverWrite | CustomBackFormValuesOverWrite |
| OwnerForm | OwnerForm |
| Caption | Value |
|---|---|
| RemoteServiceName | RemoteServiceName |
| RemoteServiceParams | RemoteServiceParams |
| RemoteServiceAddr | RemoteServiceAddr |
| RemoteServiceIsRegistered | RemoteServiceIsRegistered |
| RemoteServiceRegisterDate | RemoteServiceRegisterDate |
| RemoteServiceSingleToken | RemoteServiceSingleToken |
| RemoteServiceActiveToken | RemoteServiceActiveToken |
| RemoteServiceUseCryption | RemoteServiceUseCryption |
| RemoteServiceUseZipCompress | RemoteServiceUseZipCompress |
| RemoteConnected | RemoteConnected |
| RemoteResult | RemoteResult |
| Connect | Connect |
| RemoteExec | RemoteExec |
| Caption | Value |
|---|---|
| Text | Text(aText:String); |
| AddException | AddException(ExceptMessage:String); |
| Show | Show(IsReadOnly:Boolean = False); |
| Caption | Value |
|---|---|
| LocalScripterLog | LocalScripterLog |
| Firm_GUID | Firm_GUID |
| Project_GUID | Project_GUID |
| ProjectOnTimerScriptText | ProjectOnTimerScriptText |
| Global_ProjectParamJSON | Global_ProjectParamJSON |
| ScripterActiveForm | ScripterActiveForm |
| ScripterList | ScripterList |
| MainScripter | MainScripter |
| Create | Create(AOwner: TComponent); |
| Destroy | Destroy; |
| PrepareScripter | PrepareScripter(ScripterObj:TatScripter; FormObj:TForm = Nil; FormName:String='') |
| Load | Load |
| LoadByProject | LoadByProject |
| clWriteLog | clWriteLog(LogStr:String); |
| ExecProjectProcedure | ExecProjectProcedure(xProcedureName:String; FormObj:TForm = Nil; FormName:String=''); |
| GetProjectUserDefParam | GetProjectUserDefParam(xParamName:String); |
| RunOpenForm | RunOpenForm(OpenFormParams:TOpenFormParams); |
| OpenForm | OpenForm(FormName:TFormTemplate; OpenStyle:TFormDisplayType; Recording:TFormRecordOption; FilterOption:TFormFilterOption); |
| AskAndCall | AskAndCall(xAskStr:WideString; CallYesProc, CallNoProc:String); |
| Ask | Ask(AskStr:String); |
| DateDiff | DateDiff(DatePart:String; StartDate,EndDate:TDateTime); |
| SendNotification | SendNotification(TitleStr, BodyStr, UserGUID :String); |
| SendNotifyAllUsers | SendNotifyAllUsers(TitleStr, BodyStr, WithoutUsers :String); |
| SendMailNoReplay | SendMailNoReplay(TitleStr, BodyStr, UserGUID :String); |
| GetFormVariable | GetFormVariable(SourceForm:TFormTemplate;VarName:String); |
| ReloadFormData | ReloadFormData |
| DBXCopyRecord | DBXCopyRecord(SourceQ, DestQ: TDataSet); |
| DBDatasetGetAsJSON | DBDatasetGetAsJSON(SourceQ: TDataSet); |
| DBSQLServerConnect | DBSQLServerConnect(ProviderName, Server, UserName, UserPassword, Database:String; Port:Integer=1433) |
| DBSQLServerQueryWith | DBSQLServerQueryWith(SQLStr:String); |
| DBLocalConnect | DBLocalConnect(ProviderName, Server, UserName, UserPassword, Database:String); |
| DBLocalQueryWith | DBLocalQueryWith(SQLStr:String); |
| DBCloudSQLSelectWith | DBCloudSQLSelectWith(SQLStr:String); |
| DBCloudQueryWith | DBCloudQueryWith(CloudDataSource:TFormTemplate;Filter_GUID, FilterStr:String); |
| ClDataSetFromJSON | ClDataSetFromJSON(payload : String); |
| DBCloudPostQuery | DBCloudPostQuery(CloudDataSource:TFormTemplate; DataObject:TClJSonQuery); |
| DBCloudPostJSON | DBCloudPostJSON(CloudDataSource:TFormTemplate; DataJSON:String); |
| BtAssignToBeforeDataSet | BtAssignToBeforeDataSet(xdsSource:TClJSonQuery); |
| BtAssignToAfterDataSet | BtAssignToAfterDataSet(xdsSource:TClJSonQuery); |
| BtAssignToSelectedItemDataSet | BtAssignToSelectedItemDataSet(xdsSource:TClJSonQuery; xSourceFilter:String =''); |
| BtAssignToSelectedItemDataSetGuide | BtAssignToSelectedItemDataSetGuide(xdsSource:TClJSonQuery; xSourceFilter:String =''); |
| GlobalBitmapSaveToFile | GlobalBitmapSaveToFile(aFileName:String); |
| AppID | AppID |
| AppProjectName | AppProjectName |
| AppUserDisplayName | AppUserDisplayName |
| AppUserGUID | AppUserGUID |
| OpenFormEvent | OpenFormEvent |
| OpenFormParams | OpenFormParams |
| RunOpenFormEvent | RunOpenFormEvent |
| GlobalResult | GlobalResult |
| GlobalResultInteger | GlobalResultInteger |
| GlobalVariableString | GlobalVariableString |
| GlobalVariableInteger | GlobalVariableInteger |
| GlobalVariableDateTime | GlobalVariableDateTime |
| GlobalBitmap | GlobalBitmap |
| CommonResultJSON | CommonResultJSON |
| ResumeLocalEvent | ResumeLocalEvent |
| DBSQLServerConnection | DBSQLServerConnection |
| DBSQLServerQuery | DBSQLServerQuery |
| DBLocalConnection | DBLocalConnection |
| DBLocalQuery | DBLocalQuery |
| DBCloudQuery | DBCloudQuery |
| LocationIsActive | LocationIsActive |
| LocationValue | LocationValue |
| RefreshTimePerMS | RefreshTimePerMS |
| AppBasePath | AppBasePath |
| AppFilesPath | AppFilesPath |
| PlatformIsMobile | PlatformIsMobile |
| ProjectTimer | ProjectTimer |
| TimerProgressIn | TimerProgressIn |
| TimerProgressBreak | TimerProgressBreak |
| EventLog | EventLog |
| ShowExceptions | ShowExceptions |
| FormMain | FormMain |
| LocationManager | LocationManager |
| DBPostQueryBefore | DBPostQueryBefore |
| DBPostQueryAfter | DBPostQueryAfter |
| DBSelectedQItemForThread | DBSelectedQItemForThread |
| DBSelectedQItemForGuide | DBSelectedQItemForGuide |
| ActiveScripter | ActiveScripter |
| Caption | Value |
|---|---|
| clFindComponent | clFindComponent(xObjectName : String); |
| AddNewEvent | AddNewEvent(EventControl:TControl; BasisEvent:TBasisEvent; xCode:String); |
| AddNewLabel | AddNewLabel(xOwner:TComponent; xName,xCaption:String); |
| AddNewEdit | AddNewEdit(xOwner:TComponent; xName,xPromptText:String); |
| AddNewButton | AddNewButton(xOwner:TComponent; xName,xCaption:String); |
| AddNewImage | AddNewImage(xOwner:TComponent; xName:String); |
| AddNewListView | AddNewListView(xOwner:TComponent; xName:String); |
| AddNewVertScrollBox | AddNewVertScrollBox(xOwner:TComponent; xName:String); |
| AddNewHorzScrollBox | AddNewHorzScrollBox(xOwner:TComponent; xName:String); |
| AddNewRadioButton | AddNewRadioButton(xOwner:TComponent; xName,xCaption:String); |
| AddNewCheckBox | AddNewCheckBox(xOwner:TComponent; xName,xCaption:String); |
| AddNewComboBox | AddNewComboBox(xOwner:TComponent; xName:String); |
| AddNewChart | AddNewChart(xOwner:TComponent; xName,xTitle:String); |
| AddNewMemo | AddNewMemo(xOwner:TComponent; xName,xCaption:String)(xObjectName : String); |
| AddNewQRCodeGenerator | clFindComponent(xObjectName : String); |
| AddNewTimer | AddNewTimer(xOwner:TComponent; xName:String; xInterval:Integer); |
| AddNewLayout | AddNewLayout(xOwner:TComponent; xName:String); |
| AddNewPanel | AddNewPanel(xOwner:TComponent; xName,xCaption:String); |
| AddNewMenuFrame | AddNewMenuFrame(xOwner:TComponent; xName:String); |
| AddNewNumberBox | AddNewNumberBox(xOwner:TComponent; xName:String); |
| AddNewProLabel | AddNewProLabel(xOwner:TComponent; xName,xCaption:String); |
| AddNewProImage | AddNewProImage(xOwner:TComponent; xName:String); |
| AddNewProDateEdit | AddNewProDateEdit(xOwner:TComponent; xName:String); |
| AddNewProButton | AddNewProButton(xOwner:TComponent; xName,xCaption:String); |
| AddNewProEdit | AddNewProEdit(xOwner:TComponent; xName,xPromptText:String); |
| AddNewProPanel | AddNewProPanel(xOwner:TComponent; xName:String); |
| AddNewProSearchEdit | AddNewProSearchEdit(xOwner:TComponent; xName,xPromptText:String); |
| AddNewProListView | AddNewProListView(xOwner:TComponent; xName:String); |
| AddNewProListViewDesignerPanel | AddNewProListViewDesignerPanel(xOwner:TComponent; xName:String); |
| SetImage | SetImage(xComponent:TComponent; xImageFile:String); |
| CallBarcodeReader | CallBarcodeReader(TargetObject:TComponent); |
| Run | Run; |
| clSQLDateTimeToDateTime | clSQLDateTimeToDateTime(AnsiDate : string); |
| clDateTimeToSQLStr | clDateTimeToSQLStr(DateTimeValue : TDateTime); |
| SetFormColor | SetFormColor(color1:String;color2:String;clGNone); |
| SetFormBGImage | SetFormBGImage(imgURL : String); |
| Caption | Value |
|---|---|
| Found | Found |
| Insert | Insert |
| Edit | Edit |
| Post | Post |
| Next | Next |
| FieldByName() | FieldByName('') |
| EmptyDataSet | EmptyDataSet |
| EOF | EOF |
| ztKeylocate | CloudQ.KeyLocate('Product_Code' ,LokalQ.FieldByName('Product_Code').AsString) |
| ztFormSearch | Clomosy.DBSelectedQItemForThread.FieldByName('Activity_Code').AsString ='002' |
| ztPostJson | Clomosy.DBCloudPostJSON(ftProducts,CloudQ.GetJSONString); |
| DBRemoteToCloudXCopyRecord | DBRemoteToCloudXCopyRecord |
| DBRemoteQueryWith | DBRemoteQueryWith |
| DBCloudQueryWith | DBCloudQueryWith |
| DBSQLServerQueryWith | DBSQLServerQueryWith |
| Close | Close |
| Sql.Text | Sql.Text |
| ExecSql | ExecSql |
| Free | Free |
| AppUserGUID | Clomosy.AppUserGUID
|
| Clomosy.AppUserGUID | Clomosy.AppUserGUID |
| ztRunOpenForm | Clomosy.OpenFormParams.OpenFormTemplate := ftTasks;
Clomosy.OpenFormParams.CustomBackFormGUIDFiledValue:=Clomosy.AppUserGUID; Clomosy.OpenFormParams.CustomBackFormSelectedFilter:='; Clomosy.OpenFormParams.CustomBackFormValuesOverWrite:=True; Clomosy.OpenFormParams.OpenDisplayType := fdtsingle;//ftactivities; Clomosy.OpenFormParams.RecordOption := froReadOnly;//froAddNew; Clomosy.OpenFormParams.FilterOption := ffoDoFilter;//ftactivities; Clomosy.RunOpenForm(Clomosy.OpenFormParams); |
| With Do | With WITH {QRY} DO BEGIN END; |
| bfCreate | MyForm := TFrmClomosyBasisForm.Create(Self); MyForm.Run; |
| bfPanel | ztPnl:=MyForm.AddNewPanel(MyForm,'ztPanel','); MyForm.NewObject := TBasisControl(ztPnl);MyForm.NewObject.Align := alCenter; |
| bfEdit | ztEdt:=MyForm.AddNewEdit(MyForm,'ztEdit','); MyForm.NewObject := TBasisControl(ztEdt);MyForm.NewObject.Align := alCenter; |
| bfLabel | ztLbl:=MyForm.AddNewLabel(MyForm,'ztEdit','); MyForm.NewObject := TBasisControl(ztLbl);MyForm.NewObject.Align := alCenter; |
| bfButton | ztBtn:=MyForm.AddNewButton(MyForm,'ztBtn','Ztac Button'); MyForm.NewObject := TBasisControl(ztBtn);MyForm.NewObject.Align := alCenter; |
| bfImage | ztImg:=MyForm.AddNewImage(MyForm,'ztImg'); MyForm.SetImage(ztImg,'https://cdn-icons-png.flaticon.com/512/84/84555.png'); |