[FX.php List] Getting Error 101 when using FMEdit()

[Dave Strickler]

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 am using the
"-" in "-recid". I've even tried with without! ;-)
 
I have done a Recover on the database, and it recovers without errors.
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 cause
this to happen?
 
Dave Strickler
MailWise LLC
617 267-0044 x810 
www.mailwise.com


>>> 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?
        $query->AddDBParam('comments',$_POST['comments']);    
        $query->AddDBParam('-recid',$_POST['recid']);    
        $result = $query->FMEdit();

        // this is for 6U and 7SA.  Don't have 5.5 to test...

HTH,

Michael

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 speed 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 won't
allow an update?
 
I have checked the privs (I am using the Web Server Privs) and the user
has all privs.
 
TIA,
 
 
Dave Strickler
MailWise LLC
617 267-0044 x810 
www.mailwise.com

 


----------------------------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
http://www.iviking.org/mailman/listinfo/fx.php_list






----------------------------
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...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20050512/2647e547/attachment.html