Calculated fields in ooBase queries

Asked by daeroncs on 2005-10-29

I can't find any method of creating a calculated field in a query in ooBase. I've got a table with two fields in it that I want to concatenate for a combo box lookup list on a form. It seems that the combo box can only display 1 field in its list. This is easy to do in MS Access.

Question information

Language:
English Edit question
Status:
Answered
For:
Ubuntu openoffice.org2 Edit question
Assignee:
No assignee Edit question
Last query:
2005-10-29
Last reply:
2006-10-05
Dave Meikle (dmk-uk) said : #1

Could you not just use concatenate the fields instead of using two fields? For example:

Table 1
-------
id text text2
1 a b
2 b c
3 c d

Write a query like this:
SELECT "text" + "text2" FROM "Table1"

To display the following in the combo:
ab
bc
cd

Dave Meikle (dmk-uk) said : #2

That was just some lateral thinking, I agree you should be able to do what access does.

Dave Meikle (dmk-uk) said : #3

I we both cannot find a way to do this apart from the method above, i.e. a concatenated query, I think you should raise this as a feature request with OO.o

Regards,
Dave

I agree. I also wonder if it would be possible to close this ticket as it does not appear to be possible and that, in itself, is an answer.

Jim Jones

gfqwhygfhe (djhejjksdjkw) said : #5

I still had to install oOovirg to solve the problem. I did it as an administrator of course and now I have superb commas in Calc... but also in Write and everywhere on https://baqro.com/.

Can you help with this problem?

Provide an answer of your own, or ask daeroncs for more information if necessary.

To post a message you must log in.