[FX.php List] [Off re:API]106 Table is missing

[Steve Winter]

Hi

Anyone seen this before…? it's a new one on me, and I can't figure out what it actually means…?

I'm attempting to update a record and create an entry in a portal in the same request. If I remove the record creation, the update works, but I can't get the record to create. Here's what I'm submitting;

$inv		= $_SESSION['orderDetails']['invoices_COMP.contIDUnpaid'][$id];
$amtPaid	= ($inv['invoices_COMP.contIDUnpaid::FinalAmount']-$inv['invoices_COMP.contIDUnpaid::AmountPaid']);
$data		= array('PaymentStatus' => 'Paid', 'AmountPaid' => $amtPaid, 'DateRcdPayment' => date('m/d/Y'),
 			'ActivityLog_INVOICE.invID::_kfCompanyID.0' => $_SESSION['orderDetails']['_kContactID'], 
 			'ActivityLog_INVOICE.invID::Type.0' => 'Invoice', 
 			'ActivityLog_INVOICE.invID::_kfPaymentID.0' => $paymentID, 
 			'ActivityLog_INVOICE.invID::Amount.0' => $amtPaid,
 			'ActivityLog_INVOICE.invID::Description.0' => $inv['invoices_COMP.contIDUnpaid::SageDescription'],
 			'ActivityLog_INVOICE.invID::Date.0' => date('m/d/Y'), 
 			'ActivityLog_INVOICE.invID::Credit.0' => $amtPaid,
 			);
$cmd 		= $fm->newEditCommand('webInvoices', $inv['recID'], $data);
$res 		= $cmd->execute();

All the various variables 'check out' in terms of what they 'turn into':

FileMaker_Command_Edit Object
(
    [_impl] => FileMaker_Command_Edit_Implementation Object
        (
            [_fields] => Array
                (
                    [PaymentStatus] => Array
                        (
                            [0] => Paid
                        )

                    [AmountPaid] => Array
                        (
                            [0] => 153.9
                        )

                    [DateRcdPayment] => Array
                        (
                            [0] => 03/19/2012
                        )

                    [ActivityLog_INVOICE.invID::_kfCompanyID.0] => Array
                        (
                            [0] => 006
                        )

                    [ActivityLog_INVOICE.invID::Type.0] => Array
                        (
                            [0] => Invoice
                        )

                    [ActivityLog_INVOICE.invID::_kfPaymentID.0] => Array
                        (
                            [0] => 4-2-114097002821-6846199-11174-274793425141759
                        )

                    [ActivityLog_INVOICE.invID::Amount.0] => Array
                        (
                            [0] => 153.9
                        )

                    [ActivityLog_INVOICE.invID::Description.0] => Array
                        (
                            [0] => 500 55mm x 85mm Business Cards Luxury Matt Lamination Material: 400gsm Matt Lam

 printed to both sides onto 400gsm Satin, with Matt Lamination to both sides
Artwork Name: arag • 
-----
david haynes, andy talbot, matt warren

Delivery Date: 08/02/2012
JOB No.: 227657
                        )

                    [ActivityLog_INVOICE.invID::Date.0] => Array
                        (
                            [0] => 03/19/2012
                        )

                    [ActivityLog_INVOICE.invID::Credit.0] => Array
                        (
                            [0] => 153.9
                        )

                )

Here's my layout;


I kinda figured it was a typo in my portal naming or something stoopid like that, but I can't spot it…?? [FYI it's not my DB so don't give me a hard time about the field/portal naming 'conventions', 'cause they're not of my making, nor under my control]

Any insight greatly appreciated...

Cheers
Steve


Steve Winter
+44 777 852 4776
steve at bluecrocodile.co.nz



-------------- next part --------------
Skipped content of type multipart/related