Base will only run SELECT statements that way. If you want to use other
than SELECT the only way IIRC is to use Tools-SQL which opens "Execute SQL
statement" but can only handle typed stuff, not stored queries. It is
useful for one-off tasks such as merging two tables into one or doing a
field update as you describe.
On 4 October 2012 00:27, David S. Crampton <david_cramp...@ie2b.com> 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 be a very simple SQL statement. It does absolutely
> nothing.
>
> The statement won't run with the F5 key (the "run" button). It gives "The
> given command is not a SELECT statement".
>
> I'm trying to apply SQL learned elsewhere, mostly in MicroBloat Access, and
> I'm getting nowhere.
>
> Help will be appreciated.
>
> David
>
>
>
> -----
> --
> David S. Crampton
> --
> View this message in context:
> http://nabble.documentfoundation.org/Update-SQL-does-nothing-using-Run-SQL-directly-button-tp4010902.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
