| View previous topic :: View next topic |
| Author |
Message |
jobzesage
Newbie
Joined: 12 Jan 2009
Posts: 2
|
 Posted: Mon Jan 12, 2009 12:46 am Post subject: Concatenation problem |
 |
|
Hi everyone,
I've been using NeoOffice for a while, but I'm new to OpenOffice Mac, and especially to Base. I've been developping databases for a couple of year, and would love to find a free alternative to MS Access.
Anyway, my first challenge is the following, I'm trying to use OO Base for my wedding guestlist. I've imported datas from my address book, but it's a bit messy, I need to change the structure of the table. My goal is to create a Query that is the clean version of my table. I would need to concatenate the fields First name and Last name. But it does not work...
The following SQL applied to the orignial table (linked on my system address book) gives me empty tuples (the right amount).
| Code: | | SELECT "First" + "Last" AS "name" FROM "Wedding guestlist" AS "Wedding guestlist" |
But the following works
| Code: | | SELECT "First" FROM "Wedding guestlist" AS "Wedding guestlist" |
Does anyone has had similar issues with concatenation ?
Interesting point, when I copy the data in a new database (a suspect the link with addressbook to be a part of the problem) and execute the following query
| Code: | | SELECT "First" + "Last" FROM "guestlistAddressbook" AS "guestlistAddressbook" |
Then I only get the First name ?!?
That behavior is so strange... I would also need to add a space character in between, but I'm not yet there...
Any idea ? |
|
| Back to top |
|
 |
RPG
Super User
Joined: 24 Apr 2008
Posts: 2696
Location: Apeldoorn, Netherland
|
| Posted: Mon Jan 12, 2009 3:32 am Post subject: |
|
|
Hello
OOo does not support the function in the way you want. I think it is better to use the label functions who are part of writer.
If you you try using writer and label you still can use the query for making a selection.
For good understanding, If you use a real database engine and not an address book as I assume you can use those functions in the way you want, if your database engine support it.
Search on this forum for label and JohnV
http://sheepdogguides.com/fdb/fdb1addrlab.htm
http://www.oooforum.org/forum/viewtopic.phtml?t=78260&highlight=label+john
I hope this helps you
Romke |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|
