[FX.php List] FX.php with FM12

[Robert Fox]

Thank you for the suggestions.  I think the problem is related to submitting blank find requests.  In this particular application, I want to perform a find based on a default name. When I use my FM7 database, I can leave the default name blank and perform "FMFind", and it will act the same as a "FMFindAll".  When I use the FM12, it comes back with no results.  I will rewrite my code to test for empty defaults, which I think will fix my issue.

Robert Charles Fox
Developer
Inner File Software

http://innerfile.com


On Apr 29, 2013, at 1:30 PM, John Funk wrote:

Yes I have two installations, They have been working for 9 months now. Here are two lines in your server.php file to check:
$dataSourceType = 'FMPro12';
$fmdb='<filename>.fmp12';

 The problem I have read about had to do with getting data from Portals if I remember right.
John


From: Robert Fox <rfox at innerfile.com<mailto:rfox at innerfile.com>>
Reply-To: "FX.php Discussion List" <fx.php_list at mail.iviking.org<mailto:fx.php_list at mail.iviking.org>>
Date: Monday, April 29, 2013 12:07 PM
To: "FX.php Discussion List" <fx.php_list at mail.iviking.org<mailto:fx.php_list at mail.iviking.org>>
Subject: [FX.php List] FX.php with FM12

Has anyone successfully used FX.php to perform queries on a .fmp12 file?  I am able to retrieve field and layout names, but get any empty found set whenever I perform a query.  I have no problem performing queries on .fp7 files.

As an experiment, I made a small .fp7 database and used FX.php to successfully perform queries.  I then converted that file to .fmp12 and used FX.php to query and connect in the exact same way (except the change to the file extension and FM version).   I was able to retrieve layout and fields names, but any query for records results in an empty found set.

I have searched through this list's archive and found a lot of people discussing problems with FX and FM12, but I can't find anyone who reached a solution.

Thanks,

Robert Charles Fox
Developer
Inner File Software

http://innerfile.com<http://innerfile.com/>


_______________________________________________ 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
<ATT00001.c>

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