[FX.php List] Debugging my move to FM v12

[Bob Patin]

Interesting that it worked in 11... I would've guessed that it wouldn't.

Change $dataSourceType to 'FMP12'; it's the only thing you have to change.

BP

Bob Patin
Longterm Solutions LLC
bob at longtermsolutions.com
615-333-6858
http://www.longtermsolutions.com
FileMaker 9, 10 & 11 Certified Developer
Member of FileMaker Business Alliance and FileMaker TechNet
--
Twitter: bobpatin
AIM: longterm1954
iChat: bobpatin
--
Expert FileMaker Consulting 
FileMaker Hosting for all versions of FileMaker

On May 21, 2013, at 11:38 AM, "Ness, David" <dness at bondedbuilders.com> wrote:

> I can verify that using ‘-recid’ with FX v4.5.1 on a FMSA v11 worked when using FMFind(), and when connected to FMSA v12 it does not. This even though ‘-recid’ isn’t a field name, using it just like you would when performing a FMEdit() or a FMDelete().
>  
> Obviously, I can change all of my instances where I used ‘-recid’ when performing a FMFind(). I’m not certain why I started using that, but it’s always worked, so I never thought anything more about it, until FMS v12. I’m glad I was able to find the problem.
>  
> Can somebody confirm that I should change my $dataSourceType from ‘FMPro7’ to  'fmalt' for use with FMS v12? I hadn’t seen that mentioned before, but like I said, I’ve been off-list for some time.
>  
>  
>  
>  
> David Ness
> FileMaker & Web Applications Developer
>  
> Bonded Builders Warranty Group
> 800-749-0381 x3123
>  
>  
> From: fx.php_list-bounces at mail.iviking.org [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Nick
> Sent: Tuesday, May 21, 2013 11:20 AM
> To: FX.php Discussion List
> Subject: Re: [FX.php List] Debugging my move to FM v12
>  
> I don't think you can do a find by -recid? but I've never done it, so maybe??
>  
> Make sure you are using the "fmalt" type instead of FMPro7 for v12.
>  
> 
> On Mon, May 20, 2013 at 12:16 PM, Ness, David <dness at bondedbuilders.com> wrote:
> Hi everyone! Looking forward to seeing everyone at DevCon this year. I've been off-list for a while, but still doing my fx.php thing.
> 
> I am late to the FM v12 party, but I'd like to make the transition before DevCon but I'm running into a problem that I can seem to figure out. I'm sorry if this has been covered in previous threads.
> 
> Everything here works great when using a FMSA v11, but when using v12, when I perform a FMFind, some values in the return array appear to be missing.
> 
> After much experimentation, I discovered that when I replace:
> 
> $applicationdata->AddDBParam('-recid', $_SESSION['application_recid'], "eq" );
> 
> with:
> 
> $applicationdata->AddDBParam('recordid', $_SESSION['application_recid'], "eq" );
> 
> Everything now appears to work.
> 
> 'recordid' is a field I added to my FileMaker table that simply is a calc field = Get ( RecordID )
> 
> >>> Q: Is there something about using '-recid' that has changed when using FMSA v12?
> 
> FX_VERSION = 4.5.1
> 
> Thanks!
> David Ness
> FileMaker & Web Applications Developer
> 
> _______________________________________________
> 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

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