Summary of Arcplan functions

Summary of commonly used functions:

1, REFERENCE ([OBJ1]; [ OBJ2]; [OBJ3]; [OBJ4]; [OBJ5])
[OBJ2] selected [OBJ1] column to [OBJ4] [OBJ3] line to [OBJ5]

Select the click part of a table
[OBJ31]: = REFERENCE ([OBJ30]; Currentcolumn (); CurrentRow ())
Gets the current column of the current table [OBJ32]: = Currentcolumn ()
Gets the current row of the current table [OBJ33]: = CurrentRow (

2. Cursor inside event: Cursor outside event: Cursor (2), which changes the pointer shape when the mouse is moved into the object, restores when the object is moved out
Curson (num): The style of the cursor

3 Value SETTING ([OBJ17])
4. Count the number of rows counted ([OBJ5])
5. Generate digital enumerate between 1 and 5 (1; 5)
6, [OBJ9] * EMPTY () produces a dynamic background.
7. Generate ScrollBar IsEmpty ([OBJ11]) * EMPTY ()
Both sides of the scroll bar isempty ([OBJ517; COLUMN2]) * COUNT ([OBJ519]) * EMPTY ()

8, Cancle used to control the validity of an object input when the input is not a number when the prompt statement and cancel this input
The On INPUT event IF (input () isnumerical); EMPTY (); MESSAGE ("Asdfads") CANCEL ())

9, isnumerical () judge is not a digital type of data
10. Verify the Judgment statement in the case in turn;
Case ([OBJ36] < 3; "Bad";
[OBJ36] > 16; "Good"; OTHERWISE; "Soso")
11, char (ASCLL code) converted to character type
12. The FACT (5) function provides the result of the multiplication of the numeric expression;
13, FILELIST ("e:\ Company Information \arcplan\basic Training odbc\documents"; "APD")
Obtain the name of the corresponding file according to the relevant path and the restriction condition;
14, FIND ([OBJ54]; [OBJ53])
Find the former position in the latter.
15, FontColor ([OBJ53]; 6) Change the font color in the object.
16, enumerate (3; 17) generate 3 to 17 records; enumerate (3; 17) * * can multiply;
17. The input () function is used to receive input information after the on input event
IF (isnumerical INPUT ()); MESSAGE ("is a number"); MESSAGE ("Not a number") CANCEL ())
18, Isinteger ([OBJ4]) Judgment object is not an integer ...
19, left ([OBJ1]; 3) Three characters from the beginning;
20, Length ([OBJ1]) takes a string.
21, like ([OBJ1]; "%1%") is similar to a fuzzy query in a database.
22, LOWER ([OBJ2]) uppercase string converted to lowercase string.
23, Max ([OBJ11]) produces the maximum value in the object.
24. MESSAGE ("not a number"; "Hint"; 0) 0 = warning; 1 = stop; 2 = information; 3 = no symbol
Interrupts the execution of a control function and pops a message dialog box to the user. If the user chooses OK, the control function is executed;
25, MOD (15; 4) The function of taking the remainder in the digital processing;
26, QUESTION ("Do you want to?"; "Hint"; 2)
The 0= dialog box contains the OK and cancel options. The 1= dialog box contains the Yes and no options. The 2= dialog box contains the Yes,no and cancel options.
The Uestion control function interrupts a control function to invoke a prompt dialog box. If the user chooses OK or the Yes,question field has a value of 1. If the user chooses the Cancel,question field, the value is 0.
IF (QUESTION ("Do-want to?"; "Hint"; 2) = 1; MESSAGE ("OK"); MESSAGE ("Cancle"))
27. Random number generation () * 100
28, Vertcombine (REFERENCE ([OBJ24]; 1; 1; 2; SETTING ([OBJ21])); [OBJ25])
Merge tables that form vertically ...
29, SORT ([OBJ15; COLUMN1]; Descending; [OBJ26]; [OBJ10]; [OBJ15])
30. Right ([OBJ40]; 4) intercept 4 characters from the left.
31, sign (-15): Judging the value of the positive and negative-1 for negative, 1 for positive, 0 for the value is 0.
32, SWITCH ([OBJ213]; SETTING ([OBJ213]) + 1)
In the on switch event, the position is synchronized with the switch ([OBJ219]; [OBJ218; SELECTION])
SWITCH ([OBJ218]; SETTING ([OBJ219; SELECTION]))
To ensure that the second parameter of switch is a number, the position can be synchronized directly, but only if the number needs to be converted by setting ().
No text: Position synchronization (must be a number, not a number to be converted to setting () number).
With text: Value synchronization

33, Replacestatement ("members"; "Children")
Remove all from a column

If or
34, IF (OR ([OBJ105; COLUMN3] = 0; ISEMPTY ([OBJ105; COLUMN3])); [images;obj117];
IF ([OBJ105; COLUMN3] > 0; [images;obj118]; [images;obj116])
)
35. Remove the null value from the value: Replacestatement ("select"; " Select NON EMPTY ")

36, FILTER ([OBJ532]; [OBJ530])

37, OpenLink ("http://news.baidu.com/"; NewWindow) Open a link page

38, Print (1) Display printing interface

39, Pdfprint () converted to PDF interface
Operator
The following objects are referenced:
+ (plus)
-(minus)
* (multiply)
/(except)
^ (second Party)
= (equals)
=,<,>,<>,<=,>= (comparative relationship)
: = (assigned value)

Top-down linkage: Take the value of the click
DELETE ([OBJ141])
DELETE ([OBJ139])

[OBJ139]: = REFERENCE ([OBJ105]; 1; CurrentRow ())

[OBJ141]: = REFERENCE ([OBJ105]; 2; CurrentRow ())

If the
IF (and (ISEMPTY ([OBJ139]); ISEMPTY ([OBJ141])); EMPTY ();
IF (ISEMPTY ([OBJ141]);

SWITCH ([OBJ154]; TEXT ([OBJ139])); SWITCH ([OBJ154]; TEXT ([OBJ141])))

The value of clicking on the histogram is taken from the background [OBJ133]: = REFERENCE ([OBJ116]; 1; CurrentRow ())

Replacement linkage
DELETE ([OBJ121])
Case (
SETTING ([OBJ120; SELECTION]) = 1; [OBJ121]: = "CYRC";
SETTING ([OBJ120; SELECTION]) = 2; [OBJ121]: = "Zyfy";
SETTING ([OBJ120; SELECTION]) = 3; [OBJ121]: = "ZYJCF")

SWITCH ([OBJ119]; TEXT ([OBJ121]))

EXECUTE ([Obj133;on Mouse click])

Change Color Menu
Click events:
DELETE ([OBJ366])
[OBJ366]: = REFERENCE ([OBJ365]; Currentcolumn (); 1)//The value of the forefront
[OBJ368]: = Currentcolumn ()//The value of the column
CANCEL ()

Load:
IF ([OBJ365] = [OBJ366]; 1; 0)

IF ([OBJ365] = [OBJ366]; [images;obj120]; EMPTY ())