Skip to Content

Changes for page 01 Lua Functions

Last modified by Theodore Xu on 2023/10/26 10:51
From version 5.31
edited by Stone Wu
on 2022/07/12 10:45
Change comment: (Autosaved)
To version 5.35
edited by Stone Wu
on 2022/07/12 11:00
Change comment: (Autosaved)

Summary

Details

Page properties
Content
... ... @@ -1781,7 +1781,7 @@
1781 1781  end
1782 1782  {{/code}}
1783 1783  
1784 -= **11 Special function for V-NET** =
1784 += **10 Special function for V-NET** =
1785 1785  
1786 1786  == **normal_get_alldata()** ==
1787 1787  
... ... @@ -1826,10 +1826,84 @@
1826 1826  
1827 1827  **Parameter:**
1828 1828  
1829 -name: the name of mo
1829 +name: the name of monitoring point
1830 1830  
1831 +data: the data to be written
1832 +
1831 1831  **Return:**
1832 1832  
1833 -Succeed: calculated result
1835 +Succeed: string: The value of the monitor point before it is written
1834 1834  
1835 -Failed: multi, error code
1837 +Failed: mil
1838 +
1839 +== **normal_getdata_byname(string name)** ==
1840 +
1841 +
1842 +
1843 +
1844 +**Function:** Read the data of the monitoring point name
1845 +
1846 +**Parameter:**
1847 +
1848 +name: the name of monitoring point
1849 +
1850 +**Return:**
1851 +
1852 +Succeed: string
1853 +
1854 +Failed: mil
1855 +
1856 += **11 MySQL database operation** =
1857 +
1858 +== **luaMySql.init(string sourcename, string username, string password, string host, number port, string character)** ==
1859 +
1860 +**Function:** Configure database connection parameters
1861 +
1862 +**Parameter:**
1863 +
1864 +sourcename: the name of database
1865 +
1866 +username: the username of the connection
1867 +
1868 +password: the password of the connection
1869 +
1870 +host: the host name of the connection
1871 +
1872 +port: the host port of the connection
1873 +
1874 +character: the character set of the connection
1875 +
1876 +**Return:**
1877 +
1878 +Succeed: string
1879 +
1880 +Failed: multi
1881 +
1882 +== **luaMySql.exec(string statement)** ==
1883 +
1884 +**Function:** Execute the given SQL statement without returning the result set (add, delete, change)
1885 +
1886 +**Parameter:**
1887 +
1888 +statement: the given SQL statement
1889 +
1890 +**Return:**
1891 +
1892 +Succeed: status: returns the number of rows affected by SQL statement execution.
1893 +
1894 +Failed: mil, errorString
1895 +
1896 +== **luaMySql.execWithResult(string statement)** ==
1897 +
1898 +
1899 +**Function:** Execute the given SQL statement returning the result set (che)
1900 +
1901 +**Parameter:**
1902 +
1903 +statement: the given SQL statement
1904 +
1905 +**Return:**
1906 +
1907 +Succeed: status: returns the number of rows affected by SQL statement execution.
1908 +
1909 +Failed: mil, errorString