Sorry, for the tack on post, but the point I meant to make with this is:
You are moving your front end from Access so, you should be able to use
the Access GUI query builder to generate your queries. Access offers you
a SQL view of the query. You should be able to copy this, and paste into
a Base SQL view query object, since this SQL view in Access is really
the Jet engine dialect.
Andrew Jensen wrote:
Yes, and kind of no. You can start with GUI functions and select your
fields and handle your joins. But then you must turn the designer off
and finish the part with the concatination by hand. Just so you know
it also means that you can enter it as more standard Accesseeze also,
this statement would be just as valid with SQL direct turned on
SELECT [FirstName]+ ' ' + [LastName] AS [Name] FROM [Customers]
By the way, the above select staetment is what is actually generated
by the MS Access query builder when you enter
Name: [Firstname] + ' ' +[LastName]
in the field area of the designer and sent to the Jet engine.
Because Base is a loosely coupled front end [i](My terminology
there)[/i] to any number of backends it is the syntax that is accepted
by the MS Jet engine that you need to enter, not the syntax you enter
in the MS Access GUI, since MS Access itself is just a front end to
the Jet engine, albeit a very tightly coupled front end.
This also means that once your make the final changes you can not turn
the designer back on, it will report a syntax error.
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]
