[FX.php List] Workaround for Portal Bug in Recent Versions of FMS

[Dale Bengston]

Me too.

-Dale

> On Jan 24, 2015, at 9:32 PM, Beverly <beverlyvoth at gmail.com> wrote:
> 
> I didn't say multiple connections I said multiple queries. Does that help?
> This is the same method I use to SQL dbs. 
> 
> -- sent from myPhone --
> Beverly Voth
> --
> 
>> On Jan 24, 2015, at 6:54 PM, Malcolm Fitzgerald <malcolm at notyourhomework.net> wrote:
>> 
>> Beverly,
>> 
>> Don't you find that the need to make multiple connections imposes time penalties?
>> 
>> I began doing all the work, ie, query parent, query related tables, but I'm now putting portals onto layouts and getting better performance. Admittedly, this is done on small related record sets.
>> 
>> Malcolm
>> 
>>> On 25/01/2015 12:41 pm, Beverly wrote:
>>> Yes. Query and display the parent. Query and display as many "portals" as needed by taking the parent primary key to match the child foreign key.
>>> 
>>> -- sent from myPhone --
>>> Beverly Voth
>>> --
>>> 
>>>> On Jan 24, 2015, at 2:10 PM, Philip Lamb <phil at eden.net.nz> wrote:
>>>> 
>>>> Beverly,
>>>> 
>>>> Can you explain a little more about this technique? I used portal fields as a convenient way to query multiple tables with a single query. Do you make multiple requests using the foreign key technqiue?
>>>> 
>>>> Regards,
>>>> Phil.
>>>> 
>>>>> On 24/01/2015, at 5:47 AM, BEVERLY VOTH <beverlyvoth at gmail.com> wrote:
>>>>> 
>>>>> I tend to skip portals altogether on the web and just get the data using the foreign key. Which is another option for those who hate the portal-bug. :)
>>>> _______________________________________________
>>>> FX.php_List mailing list
>>>> FX.php_List at mail.iviking.org
>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>> _______________________________________________
>>> FX.php_List mailing list
>>> FX.php_List at mail.iviking.org
>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>> 
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list