The Duck Song Poptrapica

An example to Create Data View

Source
1. GX 8.0 and SQL Server 7.0 Tene in mind that we use SQL Server 7.0
Steps to creating a Data View in GeneXus.
2. A Below are steps to follow to successfully create Data View in GeneXus.
4. In
DESIGN 1. Edit the model and create a Data Store (only going to allow placing the name of the Data Store)
5. 2. Create the Transaction which will then be connected to the Data View.
2.1. Is desirable but not necessary, that the names of the attributes of the Transaction are characteristic of GeneXus.

2.2. It is necessary that the Transaction is defined the same keys that have the source table.

3. From the definition of objects in order to create Data View.

3.1. Name the new object with a meaningful name.

3.2. In "Composition" add in the "Internal Name" attributes of the Transaction created in the previous section. In the column "External Name"

place same field names in the source table.

3.3. In "Platform" search and add "SQL Server" and property "Name"
1. put the name of the source table.
3.4. In "Index" to add an index to a meaningful name. Can not repeat the same index name for other Data View.
2. 3.4.1. In "Composition" to place the attributes of the transaction that will be key.
3.4.2. In "Platform" search and add "SQL Server" and property "Name"
3. place the name of the source table index.
4. Edit Properties Data View and "Associated table" look and put the name Transaction set (item 2) and "Data Store" search and place the Data Store created (step 1).

In PROTOTYPE 5. In reorganizing the transaction must say that it is associated with the Data View you created in step 2. Otherwise return to design and verify the steps above.

6. Edit the model and find the Data Store in the design created.

6.1. Put SQL Server. Edit the properties of the Data Store in "Access technology to set" select one of the options set (iSeries Native / JDBC / ODBC), in "Database name" put the name of the source database and "Server Name" origin server name.

6.2. If decicide in "Use trusted connection" seleccuinar not then "User ID" put the user name and "User password" for password.

6.3. Finally in "SQL Server version 7.0 select 7. Go to "Build" and select "Create Database".

7.1. Before reorganizing verify that the transaction is associated with the Data View. The Data View Generator I've used it and it works.
As I am a novice user of GX, I prefer to manually create the Data View to have more control.


H. Nelson Castillo
Analyst - Systems Integrator