Pedro

Sorry, missed the bit about no gap so corruption is not the issue here.  Don't think disk failure is too likely as the issue would be much greater - eg. no db at all.

So.  Are there other copies of the db that might have been written to?  Is the db on FMServer?

Stephen

----------

"How wonderful that we have met with a paradox. Now we have some hope of making progress." - Niels Bohr 

On Jul 26, 2010, at 9:22 AM, Pedro Perdomo-Miteff wrote:

> Thanks Stephen for your prompt and kind response.
> 
> I moved through the data as you suggested but can't find any trace of the
> records. As I said before, there's not "gap" in record number.
> 
> Do you think that a disk failure would the culprit?
> 
> Best
> 
> 
> 
> 
> --------------------------------------------
> Pedro Perdomo-Miteff, MD, MSc
> Assistant Professor
> Faculty of Medicine
> Hospital Universitario de Caracas
> Universidad Central de Venezuela
> [log in to unmask]
> [log in to unmask]
> 
> 
> 
> 
> 
> On 26/07/10 10:02, "Stephen Wonfor" <[log in to unmask]> wrote:
> 
>> Pedro
>> 
>> The possibility exists that you may have corrupted indexes on those records.
>> Typically they show up as "?" in all the fields.  If you move through the data
>> in order of record creation you may run across them - you can't (as far as I
>> know) actually search for them using FMP finds but you can stumble across them
>> by going through the data manually.
>> 
>> If you do find them see http://fmdiff.com/fm/recordindex.html for help in
>> sorting them out.
>> 
>> Stephen
>> 
>> ----
>> 
>> BELT  SANDER:  An electric sanding tool commonly used to convert minor
>> touch-up jobs into major refinishing  jobs.  (---Attributed to the list at
>> http://techtalk.parts-express.com/; Also claimed by others...)
>> 
>> On Jul 26, 2010, at 8:18 AM, Pedro Perdomo-Miteff wrote:
>> 
>>> Dear friends,
>>> 
>>> Looking at my DB last night I realize, WITH ORROR that 3 records created
>>> this month was missed. Is a not very complex DB running without trouble for
>>> the last couple of years.
>>> 
>>> Each record has creation date, incremental record number and client data.
>>> 
>>> There is not a “gap” on creation dates. I can’t find the records searching
>>> for date, record number or client name, as if the records were not ever
>>> created. I’m sure that the records was created because I had printed a
>>> recipe for each client.
>>> 
>>> I’m working on FM 10.0v3, OS X 10.5.8.
>>> 
>>> 
>>> I would appreciate your comments and help. Please excuse me for my bad
>>> English.
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> --------------------------------------------
>>> Pedro Perdomo-Miteff, MD, MSc
>>> Assistant Professor
>>> Faculty of Medicine
>>> Hospital Universitario de Caracas
>>> Universidad Central de Venezuela
>>> [log in to unmask]
>>> [log in to unmask]
>>> 
>>> 
>>> 
>>>