Mathematical logic for leap years.
Question: How can I create a mathematical logic for leap years? Solution: Leap years are years multiples of 4 but not of 100, unless they are multiples of 400. This…
Category: Elipse E3
KB-28174: PathName of an object in the remote domain.
Question: When using the PathName of an object in the remote domain (for example, RemoteDom:Data.Tag1), the complete path won’t return (in the example, only Data.Tag1 returns). Why does this happen,…
KB-26070: Monitoring a remote application’s status.
Question: How can I monitor the status of an XObject’s properties that are linked to tags in a remote application? Whenever the connection to the remote domain is lost, these…
Multi-language Elipse E3 application.
Question: How can I create a multi-language Elipse E3 application, that is, an application where all strings are automatically translated according to the language selected by the user? Solution: The…
Manipulating an SQL Database in E3.
Autor
Renato Souza
KB-64893: Report displaying values that exceed 24 hours.
Question: How can I format the report’s data field so it displays time values higher than 24 hours, since [h]:mm:ss format does not show any hour values? Solution: For versions…
SQL Server Express 2005: Frequently Asked Questions.
How can I set up an SQL Database? To do so, follow the procedures in SQL Server Express 2005 Tutorial: installation and settings. I forgot my “sa” password. What can…
KB-33563: Keeping negative values from being recorded in the database.
Question: How can I make a series of I/O tags display 0 whenever they return with a negative value (i.e., below zero), so as to make it possible their being…
KB-64290: Changing visibility in an E3Browser column.
Question: How can I change the visibility in an E3Browser column? Solution: To do so, change the Visible parameter of the desired column with a CheckBox: select its Change event…
KB-31974: Databases: comparing models.
ACCESS Pros: Microsoft Office Professional Fast for small databases Simple settings Stores data from both SQL and Oracle VBA (Visual Basic for Applications) language and SQL Import/export tools (Windows) Cons:…