Changing the text returned by a query.
Question: How can I change the type of text being displayed in an E3Browser or Report (for example, to have it display True or False instead of 0 or 1)?…
Category: DataBases
NULL values not allowed in SQL fields.
Question: Why does a table generated inside SQL by E3 not allow writing NULL values in their fields, unlike Oracle? Solution: First, you need to understand each database’s behavior when…
KB-60839: Setting up an Oracle Client to work with Elipse E3.
Question: How can I set up an Oracle Client to work properly with Elipse E3? Solution: For communication purposes between an Oracle Database and Elipse Software’s systems, you will need…
KB-47758: Exporting data from SQL Server to Excel.
Question: How can a table be exported from SQL Server to Excel? Solution: To do so, follow these procedures: 1. Create a spreadsheet whose first row works as a column…
List of procedures for *.e3i and *.e3o file.
The goal of this file is to help Elipse E3 users with *.e3i and *.e3o files by describing all the possible outcomes of these files being generated but not downloaded…
*.e3i and *.e3o files – Frequently Asked Questions (FAQ).
1) What are *.e3i and *.e3o files? These files (.e3i and .e3o) are basically intermediate files, working as buffers between E3 and the Database, where all the information to be…
KB-57024: Loading into a combo box all values from a Database column.
Question: How can all the values from a Database column be loaded into a combo box? Solution: To perform this command, you must use GetADORecordset method in one of your…
KB-31799: Generating *.e3i and *.e3o files.
Question: What are *.e3i and *.e3o files, and how are they generated? Solution: These files (.e3i and .e3o) are basically intermediate files, working as buffers between E3 and the Database,…
KB-51359: Recording data with CSV extension in a database.
Autor
Pedro Rossi
KB-49924: Tutorial for installing Microsoft® SQL Server® 2008 R2 – Express Edition.
This article shows the procedures for installing and setting up Microsoft SQL Server 2008 R2 Express, the free version of Microsoft’s database, thus making it possible to use it as…