data in wrong file

[Guy Werry]

Bearing in mind that I have no VMS/RMS experience:

Do you have one of the following?
* User making a mistake?
* Are these two file definitions LOGICAL re-definitions of the same PHYSICAL
file?  
  Unless they are, it should be impossible to get the two confused.
* Pay attention to your FILE statements and the OPEN # options.  I've had, a
long time in the past, strange things happen where I was using ALIASs.  If
you're doing an ALIAS then you want to be very careful that you have
different OPEN numbers on the files.  You may even have to resort to using
the NOITEMS statement.  

Good luck,
	Guy.

-----Original Message-----
From: JOHAN Johan Koelewijn [mailto:j.koelewijn@thegreenery.com]
Sent: June 11, 2004 8:14 AM
To: powerh-l@lists.sowder.com
Subject: RE: Re: data in wrong file


Chris,

I'm sure it is Powerhouse and quite sure it is quick rather than qtp.
The problem comes up just for one or two records a week. In qtp this file is
mass updated so I don't think it's qtp.
No external procedures used. Some 3gl used, but not for these records.

To answer Bob:

I recompiled everything last week (I thought that may be the case too) but
that makes no difference. I even 'recovered' the dictionary with phdmaint,
but that didn't help either.

> 
> 
> 
> -----Oorspronkelijk bericht-----
> Van: POWERH-L-ADMIN@LISTS.SOWDER.COM
> Datum: 11-6-04, 14:57
> Aan: powerh-l@lists.sowder.com
> Onderwerp: RE: Re: data in wrong file
> 
> 
> JOHAN Johan Koelewijn wrote:
> > Sometimes we have the problem that the data of record A is written in
record B
> > Record B has a 1:n relation with record A but has a different layout
(other items).
> > 
> > In both records there is substructure defined including an item that
covers the 
> whore record. The names of these items are not the same. There is no
statement like :
> > let a-record of a = b-record of b
> > 
> > Any ideas how this can happen?
> 
> No - not a problem I've seen.
> Are you sure it's Powerhouse doing it ?
> Are you sure it's quick, rather than qtp (or quiz if you're talking of 
> subfiles) ?
> Any external procedures which could be trampling data ?
> 
> Likely a programmer error, I'm afraid - you could try to narrow it down 
> with some auditing, frequent backups to disk, etc.
> 
> Look out for use of accept, display, edit etc in procedures where you 
> shouldn't, such as input, edit etc (there's warnings and cautions in the 
> reference manuals which are best heeded) - you can trash the value of 
> fieldtext, and thereby transfer data between unrelated fields.
> 
> > Openvms 7.1
> > Powerhouse 7.10g
> > RMS file structure
> 
> Ditto.
> 
> Chris
> 
> 
> -----------------------------------------------------------------------
> 
> Any views expressed in this message are those of the sender and not
> necessarily those of CCA Group.  The unauthorized use, disclosure,
> copying or alteration of this message is forbidden.  The contents of
> this message may be confidential and/or privileged, copyright CCA Group
> and are intended solely for the use of the individual or entity to whom
> they are addressed.  Whilst this message has been scanned, CCA Group
> cannot guarantee that it is virus free or compatible with your systems
> and accepts no responsibility for any loss or damage arising from its
> use. The recipient is advised to run their own anti-virus software. If
> you receive this message in error please contact
> postmaster@ccagroup.co.uk immediately, destroy any copies and delete it
> from your computer systems.
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l@lists.sowder.com
> Subscribe: "subscribe" in message body to
powerh-l-request@lists.sowder.com
> Unsubscribe: "unsubscribe <password>" in message body to powerh-l-
> request@lists.sowder.com
> http://lists.sowder.com/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a subscriber.
> 

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.