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]
>>>
>>>
>>>
>>>
|
