Eclipse Community Forums: Eclipse Scout » Use of ListBox with a lookupcall

Help

Home

Home » Eclipse Projects » Eclipse Scout » Use of ListBox with a lookupcall

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

Use of ListBox with a lookupcall [message #1078082]

Fri, 02 August 2013 14:15

Ranto ANDRIANJAFY

Messages: 7
Registered: July 2013

Junior Member

Hi,

I use ListBox which is populate with a Lookupcall and I want to know how is the SQL script to use with it.

SELECT    P.IDPROD,
          P.NOMPROD
FROM      PROD P
WHERE     1 = 1
          AND (P.CAT_IDCAT = :master
          OR
          :master IS NULL)

I get the error:

java.sql.SQLException: Operand should contain 1 column(s)]]

[Updated on: Fri, 02 August 2013 14:21]

Report message to a moderator

Re: Use of ListBox with a lookupcall [message #1078184 is a reply to message #1078082]

Fri, 02 August 2013 16:41

Jeremie Bresson

Messages: 1252
Registered: October 2011

Senior Member

Without the context, it is difficult to answer. Your code seems correct. Let guess:

What is the type of your LookupCall#getMaster()? Are you sure you do not have a list or an array in this?

Have you access to the plain sql logs?

I have tried to google "Operand should contain 1 column(s)" there is a lot of topics with MySql. Are you using this engine?

Have you tried with just "AND P.CAT_IDCAT = :master" or just "AND :master IS NULL" to determine where the problem is located.

Report message to a moderator

Re: Use of ListBox with a lookupcall [message #1078214 is a reply to message #1078184]

Fri, 02 August 2013 17:36

Ranto ANDRIANJAFY

Messages: 7
Registered: July 2013

Junior Member

The type of LookupCall#getMaster() is Long[]. Yes I use MySQL. It is ok when I select one item, but when I make another selection, error!! My question is:
Is there any function to get the master value (like getMaster()) in a LookupService (server side)? If this function exists I can build the SQL script correctly.
Thanks.

Report message to a moderator

Re: Use of ListBox with a lookupcall [message #1079843 is a reply to message #1078214]

Mon, 05 August 2013 06:34

Jeremie Bresson

Messages: 1252
Registered: October 2011

Senior Member

Hi,

I think you are exactly in this case: Operand should contain 1 column(s)

Quote:

I think, the problem is the "WHEN (${CampType}) IS NOT NULL"
For this case, the value should not be a list.

Instead of "${CampType}" eclipse scout uses a syntax like this ":campType", but this is the same.

I do not know MySQL very well. I cannot tell what your solution could be.

Ranto ANDRIANJAFY wrote on Fri, 02 August 2013 19:36

My question is:
Is there any function to get the master value (like getMaster()) in a LookupService (server side)?

I am not sure what you want to do. Please notice that for your lookup service, you can extend AbstractSqlLookupService or AbstractLookupService.

1/
Extending AbstractLookupService is more generic. You implement:
* LookupRow[] getDataByKey(LookupCall call)
* LookupRow[] getDataByText(LookupCall call)
* LookupRow[] getDataByAll(LookupCall call)
* LookupRow[] getDataByRec(LookupCall call)

In this case you have access to call.getMaster().

2/
If you extend AbstractSqlLookupService, you get implementations for the four methods that are based on the SQL statement provided by getConfiguredSqlSelect(). The call object is provided as SQL bind. This means that you are limited to what you can do in the SQL statement.

If you need a more complex logic, you might need to use AbstractLookupService instaead of AbstractSqlLookupService. This way you can build the SQL script with more flexibility.

Report message to a moderator

Previous Topic:	Desktop aplication and web aplication.
Next Topic:	Unexpected update of my scout installation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 04:45:17 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter