How to add records to tables?

Classic Servoy
1

Hallo,

Sorry for this stupd question.
I created three tables, to play with the data I would like to add 3 - 4 records per table.

Is there an easy way to do this in SERVOY?
In Foxpro we have an editmode to add new records in a quite fast way.

Thanks for help

Ralf Alkenbrecher

2

If you are using the Postgres DBMS then use the PGADMIN utility to view, edit data in your tables.
Other DBMS have their own utilities.

3

Hi Ralf,

Yes you are able to do this in Servoy in like 60 seconds.
I am assuming you are already have a connection defined in Servoy to your database.
Create a new solution (or use an existing one). Create a new form that is referencing your table. Place all fields on the form (you can select all fields in the field selection dialog).
After you have done this you launch your solution and navigate to your forms. Now you can use the toolbar buttons (or key combos) to add/delete records.
You can type in the data in the fields on the form, the moment you click out of the field it will be saved to the backend.

Hope this helps.

4

Thanks to both for tipps

Ralf