Other Procedures
RepLinkField
SetDriverTb
ChangeUserPwd
ChangeUserLogin
TSQLType
FreeLst
PutNotes
PutRecordNotes
AssignQuery
LoadEditFields
ReLoadEditFields1
OpenCodeDialog
OpenCameraForm
TopFormAsImage
CopyFileNamesToDataSet
FullClientResourceUpdate
SmartClientResourceUpdate
PutShortcut
DropShortcut
WriteRegistry
DeleteRegistry
SelectAndOpenFile
OpenOmrTemplate
MenuExec
TOpenEdit
TOpenDelete
TOpenAppend
TFreeConnection
CloseConnTable
CloseClientTable
LoadRows ( dg )
This procedure refreshes the DataGroup (dg) by reloading data from the database
UpdateField( tname, uvalue, field1, val1, field2, val2, ... )
This procedure updates the table named tname in record - with id value - uvalue for the fields field1, field2, field3,.... and for the coresponding values val1, val2, val3,...
RefreshActiveRow( form_id, pname, uvalue )
This procedure refreshes the current row of the form (form_id) and with DataGroup with the name (pname) and for the current rows unique value (uvalue)
SaveToClipboard ( str )
This procedure saves the (str) to the system clipboard. It will be retrieved by the function LoadFromClipboard.
DocumentEntry ( doc_id, tname, rid, reltype )
This procedure uploads the document to the server. The document must be already inserted into the AU_DOC table. The arguments provided are the document id. Additionally in order to relate the document with another table, the table name and record unique value must be provided and the reltype as a comment for the relation.
For the exact usage of this procedure see the code of the document attachment form.
cmdline ( str )
This procedure repetitive calls can form a series of system commands. Always the series of commands is followed by the function call cmdexecute, in order the commands be executed.
See the implementation of cmdexecute.
OpenHTML ( kurl )
This procedure calls a specific HTM (HTML) document that is held in the resources directory of Mykosmos server. The HTM can have embedded AutoScript in order to be dynamic.
The calling is given as bellow:
call OpenHTML("AU_NEWSLETTER_1.HTM?param1=1¶m2=2¶m3=20¶m4=20¶m5=20¶m6=20")
or
call OpenHTML("AU_NEWSLETTER_2.HTM")
ChangeView
BrowseEditDelete
BrowseDragDrop
CreateHelp
HelpForm
ShowHelp
ShowHelpExe
CreateChart
CreateSheet
SaveExcelSheetTbl
InitializeExSheets
CreatePivotTable
PivotFieldProp
CreateRepSheet
TSaveToFile
SetFetchRowCount
ShowQuery
UpdateLogouts
Terminate
SysDataToSchema
UpgradeTables
UpgradeIndexes
SetMainMenu
DateTimePicker
OpenSpForm
LoadSpForm
ShowImages
SelectImages
SelectFormPerm
SelectUser
SelectWorkDB
PromptCommand
ShowError
PictureViewer
Documentor
QueryBuilder
message_cap
SetDrawCell
Repaint
MainMenuSet
PopupMenuSet
Popup
PopupMenuMerge
SetPictBitmap
SetLabelCap
SetLabelCap1
LabVisible
SetEditBox ( id, option_vals )
Given the edit box id is possible to give values to the edit box properties. For example:
call SetEditBox ( id, "LEFT=10;TOP=10;V=1;CP=HELLO")
where LEFT, TOP for positioning.
VAL for value
V (1, 0) for visibility
CP for caption
EN (1, 0) for enabling
RQ (1, 0) for required
TO for tab order
LQ for the lookup sql
TYP (edit, combo, check, memo) for edit type
SL for lookup list
SetControl ( id, option_vals )
Given the control id is possible to give values to the control properties. For example:
call SetControl ( id, "LEFT=10;TOP=10;V=1;CP=PUSH ME!")
where LEFT, TOP for positioning.
V (1, 0) for visibility
CP for caption
EN (1, 0) for enabling
FirstFocus
Beep
ProgMemoClear
ProgMemoAdd
ProgMemoWrite
ProgMemoWriteLast
setvar
SetEdit0
SetEdit
RefreshAllBrowsers
DesignQuery
AssignVars
SendVarToCode
GetVarFromCode
LoadVarsTableF
SaveVarsTableF
LoadVarsTableG
SaveVarsTableG
LoadVarsForm
SaveVarsForm
LoadVarsFormPrev
SaveVarsFormPrev
CbLoadDataFields
CbLoadFromTBL
LLoad
LUnLoad
CopyRecord
PasteRecord
PrintVarRecord
PrintVarFields
SendToExcel
ShowSelectedForm
ToggleToolbars
Cascade
RunDataProc
SendFile
raise_exception
Browser
ExecuteExternal
ExecuteQuery
DistillDirectory
Ellipse
DrawText
Line
SetInfo ( obj, property, value )
We call this procedure in order to place values into properties.
For Example:
proc Form_Close ( FORM )
call SetInfo ( FORM, "DoNotFocusParent", 1) {...in order not to focus on the parent form}
end
or
proc Form_Start ( FORM )
call SetInfo ( FORM, "UseBrowserThemes", 1) {...in order to use the Bowser Themes (fonts) in a report form}
end
Trace
Sleep
SetTimer
SetRefreshTimer
ClearFlexVars
ExplainFlex
SetFlexVar
OpenAgentLanguage
SendVarToCallerAgent
SendPopupMessage
OpenAgentForm
sms_send
ExportCObjChilds
InitCObjCount
MoveCObjObject
DeleteCObjObject
AddChildCObj
AddVariableCObj