Does anyone know why this cannot be done through the gui?
Ross Johnson wrote:
There was a similar question recently where the backend was PostgreSQL
and it's syntax was slightly different. Translating Andrew's SELECT,
would become:
SELECT `FirstName` || ' ' || `LastName` AS 'Name' FROM `Customers`
There was a suspicion that this was standard SQL syntax, but nobody was
sure. But the 'Run SQL Direct' was the key.
On Thu, 2006-02-09 at 16:58 -0700, Shane Johnson wrote:
Thank you Drew. I will give that a try. Will have have to build the
whole query with SQL or can I just do the column I need to modify?
Thanks
Shane
Andrew Jensen wrote:
Hi shane,
Using OO 2.0.1 on WinXp and connecting to a MS Access database I can
perform a cancatination such as this:
SELECT `FirstName` & ' ' & `LastName` AS 'Name' FROM `Customers`
`Customers`
You must run this query as 'Run SQL Direct', which in the Query
builder is the button with a green check mark over the letters SQL.
HTH
Drew
Shane Johnson wrote:
Good Afternoon. I was referred here from the OOo users group.
The following is a paste of the message I sent to that list. If
anyone can help me I would appreciate it.
Thank you
Shane
I am converting from Access to Openoffice and was trying to run a
query
against a ODBC source. In Access I could do something like the
following
fieldname: [table:Data1] + [table:Data2}
and have it spit out a concatenated result. I tried this in Base
and it
will not let me do this. Did I miss something or is there a different
way to do this.
I am running 2.0.1 on Win2K.(Let me know if you need more info)
I went through the how-to on Base and it didn't really help. If there
is some other resource you could point me to that I couldn't find,
that
would be appreciated as well.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
|
