RE: dbdiff2 1.2

} John Brown wrote: } > } > Jack, } > } > I like the changes, but there seems to be a slight problem with the -u } > switch. If used without the -a switch you get the following error:- } > } > Program stopped at "dbdiff.4gl", line number 987. } > SQL statement error number -206. } > The specified table (o_sysusers) is not in the database. } > SYSTEM error number -111. } > ISAM error: no record found. } > } > Works fine when the -a switch is included. I don't know why anyone would } > want to run one without the other anyway. } > } > John } } Ooops, guess how I tested it. You're right, the sysusers table depends on } the -a switch. Easy fix, you can change that switch check } where it unloads the tables. I'll fix and re-send. } Insert at line 183 (right after unloading syscolauth): END IF IF USER_SW THEN On second thought I'm going to wait a bit and see if anyone else has problems before I re-wrap and send. Don't want to overwhelm Walt with 32 sendings. cheers j. _____________________________________________________________________________ Jack Parker | Hewlett Packard, BSMC Boise, Idaho, USA| Someday you'll go far, jparker@hpbs3645.boi.hp.com | if you catch the right train. (208) 396-5388 (W) (208) 384-1623 (H) | _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________