[FX.php List] PHP API

[Matthew White]

We can't use php's odbc handlers because they don't work with fm's driver,
i.e. Odbc_prepare etc.  We have to send raw sql commmands.

We believe we have actually been able to hang the odbc interface in FMS and
crash FMS by sending too many simultaneous odbc calls. (using a threaded
python app)

The sql is a little squirely as far as syntax goes with fm.  If you have a
field name that start with a _ you are hosed.  I could go on.

Overall, I have not been overwhelmed with odbc in FMS but I have not found a
lot of arena's to discuss the issues with other developers.

matt




On 7/19/06 10:38 AM, "Steve Hannah" <shannah at sfu.ca> wrote:

> Hi Matt,
> 
> Just curious what limitations you have run into with odbc.  I haven't
> done any odbc with filemaker yet but the manual makes it look like it
> will handle most SQL.   Interested to hear first-hand observations.
> 
> Best regards
> 
> Steve
> On 19-Jul-06, at 7:27 AM, Matthew White wrote:
> 
>> Has FM announced this officially yet?  I heard rumblings it would
>> happen
>> Monday, but haven't seen anything.  We are really struggling with
>> limitations in the current api's both xml and odbc and are really
>> interested
>> in whatever this may be.
>> 
>> matt
>> 
>> 
>> On 7/18/06 5:03 PM, "John Gillespie" <John_Gillespie at JGCworks.com>
>> wrote:
>> 
>>> How will the inclusion of a PHP API in the next release of FileMaker
>>> effect FX.php?
>>> _______________________________________________
>>> FX.php_List mailing list
>>> FX.php_List at mail.iviking.org
>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>> 
>> -- 
>> Matthew White
>> VP of Development
>> Epiphany Cardiology Products
>> 919-680-0883
>> mattwhite at epiphanycardio.com
>> 
>> 
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>> 
> 
> 
> 
> ----------------------------------------
> Steve Hannah
> Web Services Developer
> 
> Faculty of Applied Sciences
> Simon Fraser University
> shannah at sfu.ca
> 604-268-7228
> Homepage: http://www.sjhannah.com
> ----
> Creator of Dataface: "Put a face on your database" : http://
> fas.sfu.ca/dataface
> 
> 
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list

-- 
Matthew White
VP of Development
Epiphany Cardiology Products
919-680-0883
mattwhite at epiphanycardio.com