Do not let any software impress you!

Only let it convince your intellect.
Slider img 1
Do not look for a business paradise!

It is a waste of time.
Slider img 2
Only yourself can push you uphill.

There is no easy road to prizes.
Slider img 3
Productivity is the name of the game.

And you have to conquer it.
Slider img 4
As long as you understand it,

you will start to build your know-how.
Slider img 5
We can help with that.

We have the tools and the method.
Slider img 6

Other Procedures




       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 the record - with id value - uvalue for the fields field1, field2, field3,.... and for the corresponding values val1, val2, val3, etc.

       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. The function LoadFromClipboard will retrieve it.

       DocumentEntry ( doc_id, tname, rid, reltype )


This procedure uploads the document to the server. But, we must have inserted it already into the AU_DOC table. Therefore, the arguments provided are the document id. Additionally, to relate the document with another table, we must provide the table name and record‘s unique value 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 )


In this procedure, repetitive calls can form a series of system commands. For example, the function call cmdexecute always follows the series of commands to execute the commands.
See the implementation of cmdexecute.

       OpenHTML ( kurl )


This procedure calls a specific HTM (HTML) document that we held in the resources directory of the Mykosmos server. The HTM can have embedded AutoScript 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“)



       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



       SetInfo ( obj, property, value )


We call this procedure 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