For demonstration purposes, we use a Postgres database. You can use any supported database by modifying the example code (details are provided later).
For demonstration purposes, we use a database that already exists and which already contains a single record (it is possible to use Arcos to create a database, tables, columns and so on). The name of our database is "website". For simplicity, the user name and login password are also both "website". The database contains one table, named "tblfriends".
These are the fields in tblfriends:
Field name | Type | Size | Comment |
---|---|---|---|
friendid | Sequence | n/a | Each record has a unique identifier. This is the Primary Key in SQL terms. |
name | String | 80 | - |
tel | String | 20 | We may want characters such as "ext" in the phone number, hence the field is a string. |
String | 50 | - |
The table contains a single record.
To set up your database
Note. We suggest that you follow our example above, so you can use the code that is in the examples. For details of how to perform the various steps below, refer to the documentation for your database application. Keep a record of all names and passwords.
insert into tblfriends values ('1','mike','0114 221 1858','mike@kusala.com');