Description
Returns the average value of array variable
Syntax
ret = avg(array)
Parameters
| array | : | Array to determine the average |
Return Value
| real number | : | Result | |
| 0 | : | Error or result | |
System Return Value
Example
//[result example]
//
// Average is 11.000000
//
exit Run()
function Run()
local arr[3] = {18, 9, 6}
local avg_arr
avg_arr = avg(arr)
print('Average is ${avg_arr}', stdout)
endfunction
Description
Open a file in append mode
Read / Write
r
Type
number
initial value
1
See Also
Description
Returns character code in decimal
Syntax
ret = asc(string)
Parameters
| string | : | length 1 of character string |
Return Value
| number | : | Character code | |
| 0 | : | Error | |
System Return Value
Example
//[result example]
//
// 1:83
// 2:83
//
run()
exit
function run()
print(asc('S'))
print(asc('SQeeL'))
endfunction
Description
Pseudo function
Each element in the virtual array can access by using colname like a table.
Each array is considered as column, and each element is considered as row.
Syntax
ret = array(colname,arr,colname, arr, { … })
Parameters
| colname | : | column name |
| arr | : | array |
| colname, arr, { … } | : | |
Return Value
System Return Value
Example
//[result example]
//
// 01/01/2004 Thursday is New Year's Day
// 02/14/2004 Saturday is St. Valentain's Day
// 04/01/2004 Thursday is April Fool's Day
// 10/31/2004 Sunday is Helloween
// 12/25/2004 Saturday is Christmas
//
run()
exit
function run()
local data1 = { '01/01/2004', '02/14/2004', '04/01/2004', '10/31/2004', '12/25/2004' }
local data2 = { 'Thursday', 'Saturday', 'Thursday', 'Sunday ', 'Saturday' }
local data3 = { 'New Year\'s Day', 'St. Valentain\'s Day', 'April Fool\'s Day', 'Helloween', 'Christmas' }
local tab,i
xsql select val1, val2, val3 from array('val1', data1, 'val2', data2, 'val3', data3);
tab = xfetch(0)
xclose()
loop i=0;i<count(tab); i++
print('${tab[i]["val1"]} ${tab[i]["val2"]} is ${tab[i]["val3"]}', stdout)
endloop
endfunction
Topへ