edit-article

Article Description: FIX PRB #] # priority owner fields that have NULL values

Chapter ID/Name:

Status: Write Writing Written

Add Photo:

Owner ID:

Content: use HTML Edit Content <h1 style="text-align: center;"><strong>rev-008</strong></h1> <h2><strong>FIX&nbsp;PROBLEM #]&nbsp;EVENTS priority null values</strong></h2> <ol> <li><strong>x] FILES =&nbsp;1</strong></li> <ol> <li>x] (id=#) Tasks.cs&nbsp;-&nbsp;added property "priority"&nbsp;back&nbsp;to class, methods</li> <li>x] (id=#) set value of 538+ records from null to '-5' in db local</li> <li>x] (id=#) administer REMOTE dbs, ( db1 ... db5,global, sospep&nbsp;)</li> <ol> <li>x] ALTER TABLE tasks, priority field has default value, no nulls</li> <li>x] SET value of&nbsp;priority field WHERE currently&nbsp;= null to default(-5)</li> </ol> <li>x] (id=#) test local = pass</li> <li>x] checked local - items table -all priority fields&nbsp;have default value of -5</li> <li>x] checked local - people table - SET all priority field values to -5</li> <ol> <li>] people - alter table - change</li> </ol></ol> <li><strong>*] WHAT =</strong></li> <ol> <li>x] changed SET default value of -5 for priority field in tasks</li> </ol> <li><strong>x] REPLACES </strong></li> <ol> <li>x] none, revised</li> </ol> <li><strong>x] DATE=</strong></li> <ol> <li>x] 2012-07-11</li> </ol> <li><strong>x] TO: .com,&nbsp; </strong></li> <ol> <li>x] FILES=</li> <li>] BAL.start=?,-Files=#=Bal.new,</li> </ol> <li><strong>] TO: .org,</strong></li> <ol> <li>]</li> <li>] BAL.start=?,-Files=#=Bal.new,</li> </ol> <li><strong>] TEST.remote&nbsp;- .com</strong></li> <ol> <li>i] r= ?</li> </ol> <li><strong>] TEST.remote&nbsp;- .org</strong></li> <ol> <li>] r=&nbsp;&nbsp;?</li> </ol> <li><strong>*] seem to have the priority field now working, just db owner</strong></li> <li><strong>] (id=1463) OOP -&nbsp;Task.cs - FIX PRIORITY feild</strong></li> </ol>