Ubuntu
openoffice.org2 package

Calculated fields in ooBase queries

Asked by daeroncs

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:
Last reply:
Revision history for this message
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

Revision history for this message
Dave Meikle (dmk-uk) said : 		#2

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

Revision history for this message
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

Revision history for this message
Ubuntu User (anotherubuntuuser) said : 		#4

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

Revision history for this message
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.