Re: [libreoffice-users] Update SQL does nothing using Run SQL directly button
And, as a stylistic suggestion, don't use a separate field for transaction year, calculate it from transaction date. The reason is that you've created a new classs of issue for yourself by doing this, keeping two fields in step. In general it's best to store basic data and calculate subsidiary data from it, don't store subsidiary data. Regards Mark Stanton One small step for mankind... -- 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
Re: [libreoffice-users] Update SQL does nothing using Run SQL directly button
On 10/04/2012 06:29 AM, Mark Stanton wrote: And, as a stylistic suggestion, don't use a separate field for transaction year, calculate it from transaction date. The reason is that you've created a new classs of issue for yourself by doing this, keeping two fields in step. In general it's best to store basic data and calculate subsidiary data from it, don't store subsidiary data. Regards Mark Stanton One small step for mankind... The function is Year(name) = year. For best results store the date in -mm-dd format, Typical use is Selectcolumn list From table list WhereYear(column) = AND month = mm There are other date/time functions available. -- Jay Lozier jsloz...@gmail.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
[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+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
Re: [libreoffice-users] Update SQL does nothing using Run SQL directly button
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