Jeff - from you desc. Below when you mentioned: "...only thing that I found that is unusual is that the order table was indexed on every field..." - makes it sound to me like you have a System you now support - but, that you didn't build. Am I right?
Also - I'm curious about something. You mentioned the problem started last June - and you now have 100 users. Was there a bust in Co. growth last year - prior to that June creation of Blank orders??? I suspect that this MAY be the case - and that Increase of Users MAY have initiated the problem - users fighting over records. Its as though there is a problem with your system in adding the new orders - that one user adds a blank record - but, then maybe the system tries to lock it - and can't - since maybe another user conflicted on the lock. Something strange like that. My suggestion - KILL that Append/Gather - and replace that code with an SQL Insert! Its what I have done in the past in some problem areas of systems - and its done Wonders!!! HTH, -K- -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Jeff Johnson Sent: Friday, February 22, 2013 9:21 AM To: [email protected] Subject: Weird Problem Adding Records to a Table I have a very strange problem. It is an application that uses append and gather. June of last year their system started creating orders with blank information in them. Mainly dispatcher. They call them phantom orders. There is no rhyme or reason for them to appear, but 40% of their overall orders since then. They wrote a routine to zero out the numbers and delete them but it is annoying because they show up and then the purge routine removes them and the users see this. There are about 100 users. The only thing that I found that is unusual is that the order table was indexed on every field with the invoice field descending. Could this cause problems when adding new records? Thanks in advance, -- Jeff --------------- Jeff Johnson [email protected] (623) 582-0323 www.san-dc.com www.arelationshipmanager.com [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/287D5124A35343DD88D0C76A48CDD481@Programming2 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
