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

Malcolm Fitzgerald malcolm at notyourhomework.net
Sat Jan 24 20:49:50 MST 2015


Maybe? I'll play around and see what I get.

Malcolm

On 25/01/2015 4:32 pm, Beverly 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



More information about the FX.php_List mailing list