HOW TO UPDATE THE HARDWARE DATABASE FOR MANY BOARDS (eg new finder design)
---------------------------------------------------------------------------

This way is much faster than the CardEditor if you have to change some
parameter to the same value for all boards. Examples are a new L1 pipeline
depth or offset, a new linker VME chip version or a different finder miss
design.   Use the CardEditor (described in single board how-to) if you need to
look up what the names of the database fields are. 

6 easy steps - just remember the semicolon!  

1. setup oracle  (on b0dap30) 

2. sqlplus thomsone@cdfonprd 

3. SQL> select distinct pipelinedepth from cards where card_type='XFTFINDER'; 
Type this at SQL> prompt to show the current value of pipelinedepth

4. SQL> update cards set pipelinedepth=143 where card_type='XFTFINDER';
This updates the value of pipelinedepth to 143.  A message like "48 rows
updated" will be printed out - useful to make sure  you've changed the right
number of boards!

5. SQL> commit;  
This will commit your change!  (rollback; would reverse it) 

6. SQL> exit;


Examples of steps 3 and 4 when changing flashram label names  for finder SL13
and finder SL24 boards.

FOR SL13 FINDERS
================
3. SQL> select distinct FLASHRAMLABEL1 from cards where bt_boardtype='050'; 
This prints out the flashram label for the SL1 chip on SL13 finders:

		FLASHRAMLABEL1
		-----------------------------------------------------------
		fn3sl1_4v4.hex

4. SQL> update cards set FLASHRAMLABEL1='fn1sl1_4v5.hex' where bt_boardtype='050';
This updates the flashram label for the SL1 chip on SL13 finders


FOR SL24 FINDERS
================
3. SQL> select distinct FLASHRAMLABEL1 from cards where bt_boardtype='051'; 
This prints out the flashram label for the SL2 chip on SL24 finders:

		FLASHRAMLABEL1
		-----------------------------------------------------------
		fn3sl2_3v4.hex

4. SQL> update cards set FLASHRAMLABEL1='fn1sl2_3v5.hex' where bt_boardtype='051';
This updates the flashram label for the SL2 chip on SL24 finders