can i query fm using sql?

[demiurgen]

can i query fm using sql?

if i install an odbc driver can i then use sql to get data out of and into fm?

i want to use php file and simply do a: ODBC_connect(dbname, user, password)

and then do a:

ODBC_query("select * from staff where id = '001';")

is this possible?

can it be that simple??

[brian rich]

If you have Filemaker 7 or 8 server advanced you can manage data in Filemaker tables via ODBC. You will need the Data Direct Technologies ODBC drivers and will need to enable the ODBC extended permissions on the Filemaker files you want to access via ODBC. There is a ODBC manual which ships with the Server Advanced archive which is useful.

There are some limitations to how many records you can read or update at once, and you need to be aware of record locking issues if both Filemaker and ODBC are manipulating the same data tables. We have a prototype application in development so that Filemaker and our content management system (both Windows based) can interact, and it seems pretty solid so far.

Brian Rich

ruralnet|uk

www.ruralnet.org.uk

[demiurgen]

resolved!

i used this code:

<?php

$dsn = 'filemaker_client';

$uid = 'prepress';

$pwd = 'prepress';

// Connect to server

$conn = odbc_pconnect($dsn, $uid, $pwd);

$sql = 'SELECT * FROM Companies WHERE clientnumber=10100';

$rs = odbc_exec($conn, $sql);

$row = odbc_fetch_array($rs);

print_r($row);

?>