KB-32129: Syntax for creating variables in E3Query.
Question: What is the syntax for creating variables in E3Query? Solution: To create a variable, just inform any name between these symbols: for a numeric value. ‘‘ for a…
Categoria: En
KB-32112: Connection with SQL Server working only locally.
Question: Why can I only establish connection with a SQL Server Express database locally, and not in a computer other than the one where this DB is running? Solution: In…
KB-32098: Divinding a tag’s value.
Question: How can I display an I/O tag’s value divided by 10? Solution: To do so, there are two possibilities: Enable the I/O tag’s scale to dividide its value by…
KB-32089: Returning FolderSelectWindow() function.
Question: How can I tell whether the user has pressed Cancel key while FolderSelectWindow() function is being executed? Solution: Whenever Cancel option is pressed, this function returns an empty string…
KB-32047: Inserting a table in a formatted report.
Question: Can I insert a table in a formatted report? Solution: Yes, but the table must be drawn manually. It will also remain fixed, that is, it will not increase…
KB-24635: Checking wheter Value property is already linked, at runtime.
Question: How can I check, at runtime, whether an object’s Value property is already linked? Solution: To do so, use a script that is similar to the one in the…
KB-27707: Synchronizing PLC’s and computer’s date/time (BIOS).
Question: How can I synchronize the PLC’s date/time with the computer’s date/time (BIOS)? Solution: To do so, use this script: dim oShellSet oShell = CreateObject(“WSCript.shell”)oShell.run “cmd /K DATE “& Application.GetObject(“Dados.Data”).Value,0…
KB-28518: Opening a pop-up window from another pop-up window.
Question: How can I open a pop-up window from another pop-up window, closing the first window in the process? Solution: To close the first pop-up window, follow these procedures: Create…
KB-28479: Retrieving a string’s size.
Question: How can I retrieve the number of characters in a string? Solution: To do so, use VBScript’s Len function. Sample script to be executed at a button’s Click event:…
KB-28475: Converting integers into strings.
Question: How can I convert an integer into a string? Solution: To do so, use VBSscript’s CStr command. For example: CStr(15).