|
Log in | ||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|
Thread Tools | Display Modes |
|
|
|
#1
25th March 2005, 12:54 PM
|
|||
|
|||
How set multiple fields to null
I'm new to SQL but understand rudimentary stuff like:
UPDATE accounts SET balance = NULL (which works, but I don't want to have to go through the whole table one field at a time) this instance is a COA and I want to keep all the descriptions , account details, etc. Just change any amounts that are showing in the table. My feeble brain tried something like: UPDATE accounts SET balance,startdr,startcr, <... etc> = NULL but the parser doesn't like me :-) so, over to the gurus...... Malcolm |
|
#2
25th March 2005, 01:27 PM
|
|||
|
|||
|
Re: How set multiple fields to null
> UPDATE accounts
> SET balance,startdr,startcr, <... etc> = NULL > > but the parser doesn't like me :-) > > so, over to the gurus...... V1: http://www.nexusdb.com/downloads/V10...7%20Manual.zip V2: http://www.nexusdb.com/onlinemanualv...nce/index.html -- Hannes Danzl [NexusDB Developer] Newsgroup archive at http://www.tamaracka.com/search.htm |
|
#3
25th March 2005, 02:50 PM
|
|||
|
|||
|
Re: How set multiple fields to null
Thanks Hannes
This means even more proof reading ;-) and hope some of it 'sticks'. Malcolm "Hannes Danzl[NDD]" <hannes@nexusdb.dbnexus.com> wrote in message news:xn0e068vkcfe3np00b@news.nexusdb.com... >> UPDATE accounts >> SET balance,startdr,startcr, <... etc> = NULL >> >> but the parser doesn't like me :-) >> >> so, over to the gurus...... > > V1: > http://www.nexusdb.com/downloads/V10...7%20Manual.zip > > V2: > http://www.nexusdb.com/onlinemanualv...nce/index.html > > -- > Hannes Danzl [NexusDB Developer] > Newsgroup archive at http://www.tamaracka.com/search.htm |
|
#4
25th March 2005, 02:54 PM
|
|||
|
|||
|
Re: How set multiple fields to null
Oh, WOW !!!
What a wealth of information. This is going to keep me out of mischief for a few days (weeks). ;-) Malcolm "Malcolm Cheyne" <malcolm@XXXXsbca.com.au> wrote in message news:42437e73@wic040d.... > Thanks Hannes > > This means even more proof reading ;-) and hope some of it > 'sticks'. > > Malcolm > > > "Hannes Danzl[NDD]" <hannes@nexusdb.dbnexus.com> wrote in > message news:xn0e068vkcfe3np00b@news.nexusdb.com... >>> UPDATE accounts >>> SET balance,startdr,startcr, <... etc> = NULL >>> >>> but the parser doesn't like me :-) >>> >>> so, over to the gurus...... >> >> V1: >> http://www.nexusdb.com/downloads/V10...7%20Manual.zip >> >> V2: >> http://www.nexusdb.com/onlinemanualv...nce/index.html >> >> -- >> Hannes Danzl [NexusDB Developer] >> Newsgroup archive at http://www.tamaracka.com/search.htm > > |
|
#5
25th March 2005, 03:05 PM
|
|||
|
|||
|
Re: How set multiple fields to null
Malcolm Cheyne wrote:
> Oh, WOW !!! > > What a wealth of information. This is going to keep me out > of mischief for a few days (weeks). ;-)  )-- Hannes Danzl [NexusDB Developer] Newsgroup archive at http://www.tamaracka.com/search.htm |
«
Previous Thread
|
Next Thread
»
| Thread Tools | |
| Display Modes | |
Hybrid Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Multiple uploads | Charalampos Michael | nexusdb.public.support.portal | 19 | 20th October 2009 11:49 AM |
| Sum, Coalesce and Null fields | Brenton Wildman | nexusdb.public.support.adoprovider | 1 | 19th January 2006 08:51 AM |
| Multiple SQL Statement Blocks | Michael Wandrey | nexusdb.public.support.sql | 15 | 12th June 2004 12:46 PM |
| Re: Multiple changes, one transaction, with SQL | Eivind Bakkestuen [NDD] | nexusdb.public.support.sql | 1 | 14th April 2004 06:02 AM |
| Re: Multiple changes, one transaction, with SQL | Hugo Galindo | nexusdb.public.support.sql | 2 | 7th April 2004 12:05 PM |
All times are GMT +11. The time now is 04:19 AM.