Locks and ESQL/C question (long)
Posted in 1994
> > When we use wait locks for a specific amount of time or no waiting at all > we have to go through the entire application programming checks for locks > after each fetch ! ( and the application is big >100.000 lines ! ) > So we tried: $whenever sqlerror call err_sql > In err_sql we check if a record is locked and display a message informing > the user what is going on. The problem is that we couldn't find a way to > tell Informix to try the fetch again from within the err_sql function. > In 4gl we use a trick: WHENEVER ERROR CONTINUE WHENEVER ERROR CALL syserr The effect is that after syserr has been invoked the program picks up where it left off. j. _____________________________________________________________________________ Jack Parker | Hewlett Packard, BSMC Boise, Idaho, USA| If you put all of the lawyers in jparker@hpbs3645.boi.hp.com | this country end to end, (208) 396-5388 (W) (208) 384-1623 (H) | it would be a good thing. _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________