Contents Appendices..........................................................................................................................................................................415 Using ODBC Databases...............................................................................................................................................415 Using Microsoft SQL Server.........................................................................................................................................416 Using ORACLE Databases..........................................................................................................................................
417 Using Microsoft Access Databases..............................................................................................................................419 Using SQL Server CE.................................................................................................................................................. 420 Using Sybase...............................................................................................................................................................
422 Using Microsoft Excel...................................................................................................................................................422 Using MySQL............................................................................................................................................................... 425 TROUBLESHOOTING...............................................................................................................................................................
427 General Troubleshooting..................................................................................................................................................... 428 Frequently Asked Questions............................................................................................................................................... 430 Help Menu...........................................................................................................................................................................
437 Technical Reference.....................................................................................................................................................437 License Agreement...................................................................................................................................................... 437 Release Notes..............................................................................................................................................................437 Home Page..................................................................................................................................................................
437 Communication Drivers................................................................................................................................................438 Support Information......................................................................................................................................................438 About............................................................................................................................................................................ 439 APPENDIX:
BUILT-IN SCRIPTING LANGUAGE......................................................................................................................440 Logic and arithmetic operators............................................................................................................................................ 441 How to read function descriptions.......................................................................................................................................
443 Log Message functions........................................................................................................................................................445 Trace............................................................................................................................................................................ 445 Arithmetic functions.............................................................................................................................................................
446 Abs............................................................................................................................................................................... 446 Div................................................................................................................................................................................ 446 Format..........................................................................................................................................................................
447 GetBit........................................................................................................................................................................... 449 Mod.............................................................................................................................................................................. 450 Pow..............................................................................................................................................................................
450 ResetBit........................................................................................................................................................................451 Round...........................................................................................................................................................................451 SetBit............................................................................................................................................................................452 Sqrt...............................................................................................................................................................................452 Swap16........................................................................................................................................................................
453 Swap32........................................................................................................................................................................ 453 Trunc............................................................................................................................................................................
454 Statistical functions..............................................................................................................................................................455 Avg...............................................................................................................................................................................
455 Max...............................................................................................................................................................................455 Min................................................................................................................................................................................456 Rand.............................................................................................................................................................................457 Logarithmic functions...........................................................................................................................................................458 Exp...............................................................................................................................................................................
458 Log............................................................................................................................................................................... 458 Log10...........................................................................................................................................................................
458 Logical functions..................................................................................................................................................................460 False.............................................................................................................................................................................460 If...................................................................................................................................................................................
460 Toggle...........................................................................................................................................................................461 True.............................................................................................................................................................................. 461 InduSoft Web Studio Page 5