Eclipse Community Forums: scout » CodeType with codes from the database

Help

Home

Home » Eclipse Projects » scout » CodeType with codes from the database(CodeType with codes from the database)

Show: Today's Messages :: Show Polls :: Message Navigator

CodeType with codes from the database [message #787448]

Tue, 31 January 2012 10:43

Bertin Kiekebosch
Messages: 223
Registered: August 2011

Senior Member

Is there an example on how to use codeTypes when the codes should be loaded from the database.

My database has a table Status that is used for Appointments. On my planning form i need these statusus. A status has an id (which is in the Appoinment)a name, a code, and a color. So the idea is to load all this information into a AppointmentStatusCodeType.

When an appointment is presented I want to use the AppointmentStatusCodeType for the persentation and make it possible to use change the status of an appointment.

Regards Bertin

Report message to a moderator

Re: CodeType with codes from the database [message #787515 is a reply to message #787448]

Tue, 31 January 2012 12:10

Jeremie Bresson
Messages: 259
Registered: October 2011

Senior Member

Overide execLoadCodes() in your CodeTypeClass.
This functions need to return an array of CodeRow.
Have a look at the different CodeRow constructor and/or setter that are available.

You can do a DB Call as usual with SQL.select(..) or SQL.selectInto(..)

Report message to a moderator

Re: CodeType with codes from the database [message #787532 is a reply to message #787515]

Tue, 31 January 2012 12:24

Bertin Kiekebosch
Messages: 223
Registered: August 2011

Senior Member

How can I use the codes when I implemented the method execLoadCodes(). How to get the codeType and how can I get the individual codes then. I expected some static method getCodeById.

So when I have a Calendar, an appointment only has aStatus id. I then have to get the rest of the info through the codeType.

Report message to a moderator

Re: CodeType with codes from the database [message #787643 is a reply to message #787532]

Tue, 31 January 2012 15:43

Jeremie Bresson
Messages: 108
Registered: November 2010

Senior Member

Having a dynamic CodeType (loaded from execLoadCodes()) or a static CodeType (with Codes as inner-class of the code Type - YesOrNoCodeType for example) do not change how you use the code type.

Under Using a CodeType of the CodeType page you will find some examples.

You can access the CodeType instance with:

StatusCodeType statuses = CODES.getCodeType(StatusCodeType.class);

After that if you want to access a code, with its id.

ICode code = statuses.getCode(id);

Do not forget to check if code is not null...

CodeType are often used with SmartField (or smart columns). In a such case the value of the field (or of the column for a row) is the id.

Report message to a moderator

Re: CodeType with codes from the database [message #789632 is a reply to message #787643]

Fri, 03 February 2012 03:03

Bertin Kiekebosch
Messages: 223
Registered: August 2011

Senior Member

I did not know this one : "StatusCodeType statuses = CODES.getCodeType(StatusCodeType.class);"

Thanks, it works now

Report message to a moderator

Previous Topic:	Start application with parameters
Next Topic:	Filter calendar items

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 20 10:53:23 EDT 2013