Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » Eclipse Scout » Fill table with data in form
Fill table with data in form [message #1414807] Mon, 01 September 2014 10:39 Go to next message
Flash Man is currently offline Flash ManFriend
Messages: 17
Registered: August 2014
Junior Member
Hello, I have user form, with user fields (name,surname...) and bellow table that needs to show all user roles.

How can I fill data in that table with user roles? I created service that returns object[][] of all user roles..but probles how to show them in database

thanks!

[Updated on: Mon, 01 September 2014 10:39]

Report message to a moderator

Re: Fill table with data in form [message #1414828 is a reply to message #1414807] Mon, 01 September 2014 11:31 Go to previous message
Jeremie Bresson is currently offline Jeremie BressonFriend
Messages: 1252
Registered: October 2011
Senior Member
You can use SQL.selectInto():
    SQL.selectInto(
        "select      actor_id, " +
            "        first_name, " +
            "        last_name " +
            " from   actor " +
            " where  1 = 1 " +
            " and    actor_id in (select actor_id from film_actor where film_id = :id) " +
            " into   :ActorId, " +
            "        :FirstName," +
            "        :LastName ",
            formData.getMetadataBox(),
            formData.getActorsTable()
        );


The MatadataBox provides the id bind [something like formData.getMetadataBox().getId().getValue()]

The ActorsTable contains columns for:
* ActorId
* FirstName
* LastName

Source: FilmProcessService#load()

Additional Input from Ivan:
Ivan Motsch wrote on Mon, 19 March 2012 08:35
The javadoc of ISqlService describes all possibilities of binding.

For output batch filling, use :{ActorId} instead of :ActorId


I hope this helps.

.
Previous Topic:Multiple scout client applications accessing the same scout server?
Next Topic:Dependency Injection + Eclipse Scout?
Goto Forum:
  


Current Time: Fri May 03 21:02:47 GMT 2024

Powered by FUDForum. Page generated in 0.02695 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top