Andrew,
I don't need multi-user access to the files. I am the only one
using the files. I have to convert large ASCII text files, or Excel
files, into a specified, space delimited, text format for our Business
software. I started using Excel then moved to Access so I didn't have
to split the files into pieces. Now I would like to switch off of
Microsoft. That is why I was exploring OOo Base. Every other
component of OOo I have found easy to switch to but this one, because of
this problem. I will explore Base and MySQL and see what works best.
Thank you all for your advice.
Shane
Andrew Jensen wrote:
Well, that changes a lot. Remember that Base is a front end to many
backends, and what you can do in that front end also changes - though
not dramatically - based on the particular backend. In the case of MS
Access (Jet) there is appears to be IMO a lot of shortcomings (due I
would guess in no short reson to Jets querky SQL syntax) , in the case
of MySQL there are quite a few less and you could for example enter
your concatination directly in the GUI builder using the concat function.
The same holds true if you migrated your data from the MDB to a Base
ODB file itself. The big question there would be whether you need
concurent multi-user support?
Shane Johnson wrote:
Thank you, all of you, for you replys. One more question on this
then. With having to do all the formulations in the query in SQL,
how much of a benefit does the Base GUI offer? Would I be better off
just using MySQL?
Thanks
Shane
Andrew Jensen wrote:
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]
---------------------------------------------------------------------
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]
