Gerevich Janos wrote:

> try{...
> int chk=st_check.executeUpdate(toinsert); //insert into check db, later
> into normal db
> if(st_normal.executeUpdate(toinsert)!=1) do all sorts of error messages
> and such
> ...}catch {error messages and such}

My 'quick' reaction would be - how do you know that BOTH
st_check and st_normal have been updated. From my
experience, it is quite possible that just occasionally the
'normal flow' has been interrupted, so that only the first
insert has completed - which is exactly what you are seeing.

I suspect that the 'problem' is actually the fact that you
ARE using two copies, and that scraping the 'check' would
actually fix the problem.

IF you need to know that records ARE missing, simply use a
generator, and look for missing numbers. ( 'Deleted' records
are simply retained and MARKED deleted ;) )

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services