In this chapter, we will show how to create a data source for your business application.
Here's the diagram of relationship between basic components of a simple one table, one CRUD form, and one grid business application.
So, let's go ahead and create a table.
New Editor and then
SQL DDL Command for VCS.
Write your SQL query, tick
Run Local? and then press
-- Our DDL for this guideCREATE TABLE x_person(person_id integer NOT NULL, -- sequential primary keyname character varying(50) NOT NULL,surname character varying(50) NOT NULL,age integer,CONSTRAINT pk_person PRIMARY KEY (person_id) -- primary key definition);CREATE sequence seq_x_person;
Now we need to pull the table from database. Click on
DB Tables under
We will use JSONPlaceholder for this guide. See https://jsonplaceholder.typicode.com/ for more detail.
Next we will build user interface for our application.