[FX.php List] Getting Error 101 when using FMEdit()
dstrickler at mailwise.com
Sun May 15 09:20:07 MDT 2005
Funny - you and I use the same "|" constructs. ;-)
The idea of the calc field that contains the RecordID is a clever one.
I will use that one to verify things.
As far as running the latest version of FMU, I am running 5.0v3 - and I
can't seem to find if that's the latest patch on the Filemaker site. I
realize that 5.0 is *way* out of date. We have been avoiding the upgrade
to 7.0 as it would mean large costs in upgrade as well as a huge effort
to get everything converted over. Alas, I know it will be part of our
future sooner or later...
617 267-0044 x810
>>> chris at iViking.org 5/12/2005 4:59:13 PM >>>
Have you done an echo() of the data that you're sending as the RecordID
to make sure that it's what you expect? (I usually surround these
sorts of values with pipe -- '|' -- characters to both make them stand
out, and to avoid spaces, etc.) Make sure that you check the value
that is being sent to FileMaker (preferably just before the edit is
processed) and not just the value coming out of the find. You might
even consider adding a calc field that contains the RecordID to compare
against (if you haven't already.)
Also, in any version of FileMaker, it's important to make sure that
you're running the latest version possible of the Web Companion (for
5/6) or Server Advanced (for 7). Those little 'v2' or 'v3' updates
often fix some very interesting (read BIG) XML bugs. As I recall,
versions 5 and 5.5 were especially interesting, so make sure you have
the latest version of the Web Companion for 5.5. (Of course, this may
not be an issue for you, since you have working solutions.
creator of FX.php
"The best way from FileMaker to the Web."
On May 12, 2005, at 2:23 PM, Dave Strickler wrote:
> Yup, I am using it exactly as in your example below, and on the same
> FMU workstation is works on all databases fine except for one. It
> makes me think something on the database is not 'right'. And yes, I
> using the "-" in "-recid". I've even tried with without! ;-)
> I have done a Recover on the database, and it recovers without
> While there is rarely more than a few hundred records, I would rather
> not re-create the database by hand as it has a great deal of
> relational links with other databases.
> Is there any setting in a FileMaker 5.x database file that could
> this to happen?
> Dave Strickler
> MailWise LLC
> 617 267-0044 x810
> >>> fx at 9degrees.com 5/12/2005 3:25:38 PM >>>
> It might be something as simple as -recID case-sensitive. (which is
> the old CDML way, etc.) I know that with FM7SA, it only works with
> -recid (not -recID). BTW, you are using the required "-" (hyphen) to
> make it the "reserved" word, right?
> $result = $query->FMEdit();
> // this is for 6U and 7SA. Don't have 5.5 to test...
> On May 10, 2005, at 4:19 PM, Dave Strickler wrote:
>> I am attaching to a v5.5 Filemaker Unlimited (windows) workstation
>> that talks to a 5.x Filemaker server.
>> I have many databases that are loaded on the FMU workstation, and
>> have successfully queried them and updated them with fx.php. To
>> up development, and have written a wrapper class in PHP (that I am
>> happy to share).
>> The problem is that I have a single database that works just in
>> Filemaker just fine (multi-user, etc), and I can FMFind() from it
>> just fine. It pulls the data out, and I can view it on the screen.
>> However, when I use the 'recid' field to update any record in this
>> database, I get a "101" error, indicating the "Record is missing".
>> Now since I queried and found the record a few seconds ago, I know
>> the record is there, and I can repeat this sequence over and over.
>> Any ideas why other databases allow this, and yet this database
>> allow an update?
>> I have checked the privs (I am using the Web Server Privs) and the
>> user has all privs.
>> Dave Strickler
>> MailWise LLC
>> 617 267-0044 x810
>> This message has been certified virus-free by MailWise Filter - The
>> real-time, intelligent, e-mail firewall used to scan inbound and
>> outbound messages for SPAM, Viruses and Content. For more info
>> visit: http://www.mailwise.com
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
> This message has been certified virus-free by MailWise Filter - The
> real-time, intelligent, e-mail firewall used to scan inbound and
> outbound messages for SPAM, Viruses and Content. For more info visit:
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
FX.php_List mailing list
FX.php_List at mail.iviking.org
This message has been certified virus-free by MailWise Filter - The real-time, intelligent, e-mail firewall used to scan inbound and outbound messages for SPAM, Viruses and Content. For more info visit: http://www.mailwise.com
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the FX.php_List