How to add records to tables?

Find out how to get things done with Servoy. Post how YOU get things done with Servoy

How to add records to tables?

Postby Ralf » Sun Nov 21, 2010 1:39 am

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
Ralf
 
Posts: 4
Joined: Thu Nov 11, 2010 10:24 pm

Re: How to add records to tables?

Postby Thomas Parry » Sun Nov 21, 2010 3:02 am

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.
Tom Parry
Prospect IT
Java/C++/Servoy/Jasper Reports/Simulation/Service Applications
http://www.prospect-saas.biz
Thomas Parry
 
Posts: 498
Joined: Thu Jan 10, 2008 8:48 pm
Location: Ottawa, Canada

Re: How to add records to tables?

Postby ROCLASI » Sun Nov 21, 2010 11:42 am

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.
Robert Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Re: How to add records to tables?

Postby Ralf » Sun Nov 21, 2010 7:28 pm

Thanks to both for tipps

Ralf
Ralf
 
Posts: 4
Joined: Thu Nov 11, 2010 10:24 pm


Return to How To

Who is online

Users browsing this forum: No registered users and 11 guests

cron