[libreoffice-users] Update SQL does nothing using "Run SQL directly" button

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+help@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