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

[Chris Hansen]

Steve,

I've seen 106 before, and like some of the other errors, it doesn't necessarily mean what it means :-p  So, some things to check:

1) Are permissions for that table you're editing set up for web access?

2) Is there a vertical scroll bar on the portal you're using on the layout that you're using? (not sure if FMS still cares about scroll bars, but worth a check...)

3) Is the name of the table occurrence spelled correctly?

4) Are you able to add a portal row to that table manually in FileMaker on that layout?

5) Have you tried doing just the record creation via FX? (just to be sure that everything is configured correctly...)

Those are the items that jump immediately to mind.  HTH

--Chris

On Mar 19, 2012, at 5:10 PM, Steve Winter wrote:

> Hi Tim
> 
> Thanks for the reply…
> 
>> Never tried that approach…
> 
> I've never had difficulties in the past, and have used this technique quite a bit because it saves on double-queries...
> 
>> Two things:
>> Are new records allowed to be created through the relationship? I assume yes, but worth checking
> 
> Good shout, but sadly, yes (sadly because that might have been the answer, and then it would work ;-)
> 
> <Screen Shot 2012-03-19 at 23.04.58.png>
> 
>> 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.
> 
> Thinking about it, I wonder if it only works when also creating the parent record at the same time… I know I can edit child records with this approach, and am sure I've created them this way too… 
> 
>> 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.
> 
> Oh I assure you this is just one of the many wonders of the business 'logic' which exists within this solution - me I'm just the guy building the web interface to conform to the rather unique way things have been built in FMP ;-)
> 
> Thanks for the thoughts…
> 
> 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