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

[Joel Shapiro]

Nope, never seen a 106 error

Hey Steve

Few random thoughts:

Ditto Webko re allow-creation

Are you sure the missing table isn't  invoices_COMP.contIDUnpaid?

Can you create a new child record if you do individual setFields instead of using the array?  (at least on the related fields?)

Can you create a new child record if you just set one of the fields?

I assume _kfCompanyID isn't a key field for ActivityLog_INVOICE.invID, right?

Have you tried testing another DB with a dot/period in a TO name and adding a child via the .0 syntax?

Does the portal have/need a vertical scroll bar?

umm…  Any chance your moon is in Taurus this week?

-Joel


On Mar 19, 2012, at 3:46 PM, Steve Winter wrote:

> 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;
> 
> <Screen Shot 2012-03-19 at 22.40.30.png>
> 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
> 
> 
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20120319/b028d8ed/attachment.html