Am 04.10.2012 01:27, David S. Crampton wrote:
Register1a is a table with field Trans-Date of type TIMESTAMP. Field
Trans-Date-Year is either TIMESTAMP or INTERGER. I have tried with both.
Update Register1a Set Register1a.Trans-Date-Year =
YEAR(Register1a.Trans-Date);
Looks like is should
-users] Re: Update SQL does nothing using Run SQL
directly button
To: users@global.libreoffice.org
Date: Monday, 8 October, 2012, 7:49
Am 04.10.2012 01:27, David S. Crampton wrote:
Register1a is a table with field Trans-Date of type TIMESTAMP. Field
Trans-Date-Year is either TIMESTAMP or INTERGER
Hi Jay,
On 6 October 2012 14:55, Jay Lozier jsloz...@gmail.com wrote:
This actually standard practice for writing queries. Another common
practice is to capitalize SQL key words, which you appear to also do.
I was aware that formatting a query was good practice - not so sure that it
is
On 10/07/2012 07:28 AM, Marion Noel Lodge wrote:
Hi Jay,
On 6 October 2012 14:55, Jay Lozier jsloz...@gmail.com wrote:
This actually standard practice for writing queries. Another common
practice is to capitalize SQL key words, which you appear to also do.
I was aware that formatting a
Jay Noel,
One other effect of the SQL button in Query Design appears to be that it
disables the GUI style design view. If one wants to use both the GUI table
(to get started with the basics) and then fine tune with written SQL, you
have to sacrifice the formatting of the SQL phrases. If you
John and the others who responded,
It took me a while to realize that the useful SQL menu is available only on
the main / opening window of the db. The SQL button in the Query Design view
still appears to do nothing.
I'm finally getting some traction. I acknowledge and appreciate the
stylistic
That button, according to the help file, toggles whether the SQL is passed
directly to the database engine or handled by Base first. I'm not quite
sure what that means in effect!
On 5 October 2012 18:12, David S. Crampton david_cramp...@ie2b.com wrote:
John and the others who responded,
It
I discovered one useful feature of the SQL Button. I like to format my SQL
queries by putting SELECT, FROM, WHERE etc. each on a separate line, plus I
use tabs to line up the various table names, again on their own line. I
find this makes complex queries much more readable.
If the SQL Button
On 10/05/2012 10:13 PM, Marion Noel Lodge wrote:
I discovered one useful feature of the SQL Button. I like to format my SQL
queries by putting SELECT, FROM, WHERE etc. each on a separate line, plus I
use tabs to line up the various table names, again on their own line. I
find this makes