Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #3126

Re: Container Problem: File Cannot be Found

Show all headers | View raw

On 2018-04-14 18:59:56 +0000, Charles H. Sampson said:
> Helpful Harry <HelpfulHarry@BusyWorking.com> wrote:
>> On 2018-04-09 16:23:16 +0000, Charles H. Sampson said:
>>> Charles H. Sampson <csampson@inetworld.net> wrote:
>>>> 
>>>> I'm creating a largish database that contains pointers to music files
>>>> (.aif) in containers. The database has reached over 1000 records in the
>>>> that use the containers. I've just noticed that over 500 of them now
>>>> display the message "The file cannot be found". I got this message once
>>>> before when I changed the name of the disc the files are located on.
>>>> (They're all on the same disk.) I managed to fix it then, but I don't
>>>> remember how. In any case, there have been no new disk name changes.
>>>> 
>>>> Any ideas? In previous posts, the feeling was that containers are a
>>>> mess.
>>> 
>>> I've been working on this problem for a while and I've discovered a lot.
>>> My big conclusion is that containers are such a mess as to be unusable,
>>> so I'm giving up on this database and reverting to an organization of
>>> audio files that I control.
>>> 
>>> Now, some details. First and foremost, my problems were caused by
>>> changing the name of the disk (partition) that the files were on. Of
>>> course, I had put only a reference to the files into the containers.
>> 
>> The field store the filepath, so that includes the drive / volume name.
>> Changing the drive's name means FileMaker can no longer find a drive by
>> that name.
> 
> Sort of. And that's why my script worked up to a point. But suddenly,
> the "filepath" returned by GetAsText didn't return the full filepath.
> What it did return was so minimally usable that I abandoned my script.

A very quick play with GetAsText shows that it returns two file paths - 
a truncated one and the full one.

The Container Field functions don't have anything to obtain the 
filepath (just the actual filename), which kind of shows that Continaer 
Field file storage / reference hasn't really been fully thought through 
properly.

Helpful Harry  :o)

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Container Problem: File Cannot be Found csampson@inetworld.net (Charles H. Sampson) - 2018-04-02 17:41 -0700
  Re: Container Problem: File Cannot be Found Helpful Harry <HelpfulHarry@BusyWorking.com> - 2018-04-03 13:36 +1200
    Re: Container Problem: File Cannot be Found ursus.kirk@gmail.com - 2018-04-03 10:09 +0200
  Re: Container Problem: File Cannot be Found csampson@inetworld.net (Charles H. Sampson) - 2018-04-09 09:23 -0700
    Re: Container Problem: File Cannot be Found Helpful Harry <HelpfulHarry@BusyWorking.com> - 2018-04-10 09:40 +1200
      Re: Container Problem: File Cannot be Found csampson@inetworld.net (Charles H. Sampson) - 2018-04-14 11:59 -0700
        Re: Container Problem: File Cannot be Found Helpful Harry <HelpfulHarry@BusyWorking.com> - 2018-04-15 10:07 +1200
          Re: Container Problem: File Cannot be Found Erik Appeldoorn <ursus.kirk@gmail.com> - 2018-04-15 08:25 +0200
            Re: Container Problem: File Cannot be Found Helpful Harry <HelpfulHarry@BusyWorking.com> - 2018-04-15 19:24 +1200

csiph-web