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

[Ness, David]

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<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

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