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

[Ness, David]

And even with file extensions, you can just leave those off entirely and not have to change them ever again!

There was no need to specify "Invoices.fp7". Just use "Invoices".



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 Bob Patin
Sent: Tuesday, May 21, 2013 1:26 PM
To: FX.php Discussion List
Subject: Re: [FX.php List] Debugging my move to FM v12

OOPS... I told you wrong.

You don't need to change it; you only need to change the extension on the database.

BP

Bob Patin
Longterm Solutions LLC
bob at longtermsolutions.com<mailto: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 12:24 PM, Bob Patin <bob at patin.com<mailto:bob at patin.com>> wrote:


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<mailto:bob at longtermsolutions.com>
615-333-6858
http://www.longtermsolutions.com<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<mailto: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> [mailto:fx.php_list-bounces at mail.iviking.org<mailto: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<mailto: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<mailto: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<mailto: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<mailto: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/f80cdf4c/attachment-0001.html