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

[Tim 'Webko' Booth]

Dear Steve,

Never tried that approach...

Two things:
Are new records allowed to be created through the relationship? I  
assume yes, but worth checking

And instinctively, I question whether a new (child) record can be  
created with an Edit command - I always use two queries to do  
something like this. And for invoicing, I tend to use FM calculations  
to determine if it the invoice is *really* paid (as most of my systems  
allow part payment), so I'd actually only add the child payment record  
and then check the parent record for the status.

Cheers

Webko

> 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

Tim 'Webko' Booth

Niche IT Pty Ltd
PO Box 255 . Oatley . NSW . 2223
[m] 0418 993 306
http://www.nicheit.com.au

FileMaker Training Partner for Australia and New Zealand
FileMaker Business Alliance Member





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