insert creates 2 records (in exactly one case)
another strange observation with btrieve.
We observed in a single case (only *one* occurence), that a single
call of insert (code 2) creates two records.
The PSQL server engine has Version 8.70.14.000, local cache engine was
deactivatet on the workstation (the server allows local cach engine
connections: we will switch this off soon).
Our application runs in that special envrionment for more than 10
years with thousends of inserts a day: this never never occur: only in
that one singular case.
(Also in other environments still unsing PSQL 8.x this never happns
(same application running))
unfortunately in the logfiles (pvsw.log, system log of windows botzh
server an workstation) where nothing. As this happens, there where
only one user activ in the system. The database was not in continous
operation mode (this ends about 10 minutes befor the doubble record
Our application adds a additional record to a logfile upon *every*
update or insert operation to databasefiles. The add to this logfile
is made immediately after the update/insert.
In this logfile there is only one entry, but there are two (identical,
but with correct incremented autionc) records in the databasefile. I
mention this to illustrate, that the application definitely does not
call insert twice (because if so, there must be a second entry in the
In the logfile the statuscode of the last update/insert and the
autoinc-number is saved: therefor I know, that the insert-call that
procuced the 2 records, has returnd statuscode 0; the autoinc was that
from the first record. (There where no time beween the first and the
Does anybody know, what the reason for that strange thing may be?
Networkproblem? spillover effect of the COM(continous operation mode:
it was opened and closed with butil: which is done automatically twice
every day (for updates) without any problem in the last years)?
||3/18/2010 3:49:25 PM
(page loaded in 0.069 seconds)
insert creates 2 records (in exactly one case) 0 163 (3/18/2010 3:49:25 PM) Hi, another strange observation with btrieve. We observed in a single case (only *one ...
If the records does not exist, insert it - comp.databases ...
... ve got a table with 2 fields, an ID from the one side ... END IF; END; In this case, the update statement makes ... If the records does not exist, insert it - comp.databases ...
How to select 1 record from 1M records fast ? - comp.databases ...
... 11g R2 Standard One x64 on Linux I created a table with 1,000,000 records. ... tune it with creating indices. I need some advice on the case. ... It all depends exactly ...
Insert statements and foreign keys etc.. - comp.databases.mysql ...
... like it was at least in part created by a tool (PHPMyAdmin?), in which case I ... your host language API will make exactly ... have a relationship, you may insert into one ...
Return Values from INSERT - comp.databases.mysql
... wont have a matching entry in which case I want to create one. ... sub-clause where there were more than one such INSERT ... be nice to duplicate a set of child records when ...
Count repeat of value across all records - comp.databases ...
... global gName, then I make 2 loops one ... is what you want in both cases: A. Summary Field Create a ... repeat of value across all records - comp.databases ..... add ...
INSERT PICTURE INTO A CONTAINER FIELD DYNAMICALLY - comp.databases ...
... picture is displayed if one exists ... If the records does not exist, insert it - comp.databases ... ... image file names in a field and creating photo viewer - comp ... Insert ...
Counting number of records from a value list - comp.databases ...
... it, I want to see the total number of records that has one ... need a utility table for this where you create ... column or count the number of times records ... In this case ...
Relationship Question - comp.databases.filemaker
But, when you add col_2 to that ... the "update matching records" option? > > In either case ... in FM7, you have 2 key fields "A" and "B" - in FMP6, you create the one key ...
how to use a trigger to stop an insert/update? - comp.databases ...7/29/2012 10:51:52 PM
Once in a while someone manages to create records with ... One of the things > holding the conversion ... If the records does not exist, insert it - comp.databases ... how to ...