Re: Invisible rows

> >I have been puzzling over a mysterious problem with an Informix 4GL >application. It is a simple timecard application which is used in-house. >Everyone tracks the hours spent on different projects. > >I started noticing several weeks ago that some people began showing up >on late reports who steadfastly assured me that they had entered their >time for the week. I ran an isql query from my terminal and it showed >that they had no data for the week. They ran the same isql query from >their terminal and the data showed up. I experimented for quite some >time and could detect no pattern. Now my data is missing but it can be >viewed by someone else running a query. > >I have dba permission as do the few others who run the queries. The >.dat and .idx files have 666 permissions. There are update, >delete, and alter permissions for everyone at this time. > >There is no pattern regarding access method since they do not appear for >me using 4GL report programs or isql queries. Yet the data is there. > >Has anyone else had this occur? Is this some kind of bug in the database >or in my code? The application has been running nearly a year without >major problems. This seemed to start about 3 weeks ago. > I assume you have checked the obvious, namely that when your application is run by you and your users you are looking at the same database. i.e. the DBPATH is identical. (Differences in order may cause strange results like you describe if the "same" form appears in different DBPATH places.) Also that you both are running the "same" application version. One thing you might try is to do a dbexport as you and as a user who has this problem and compare the results. If they are the same then it is some wierdness in your application, if different then different databases. Nigel Brickenden brick@agate.bellcore.com (908) 758-5551