Re: Entity Modeler and Filemaker

I'm also going to be looking to do some work with a department here where a FileMaker 6 database has been serving them for a long time. More in-line with Chuck's response, I am looking at replacing their data store with a SQL92 db and then having a more "late model" version of FileMaker bec

Re: Entity Modeler and Filemaker

The (non-WooF) trick with that is that FileMaker doesn't even have a concept of specifying a primary key, just a unique key that auto- populates as a number. My solution was to generate a PK with EO_PK_TABLE and then prefix that value with some value so that there is no overlap with records

Re: Entity Modeler and Filemaker

Didn't Java on OS X can only use Type IV (eg native drivers) JDBC drivers? If it's now possible to use a ODBC/JDBC bridge, might be useful to connect to MS Access (yes, I know) datasources too. Hello Sherry; I have also worked with FM in a "legacy database" situation. I started off with

Re: Entity Modeler and Filemaker

Hello Sherry; I have also worked with FM in a "legacy database" situation. I started off with WOOF (with FM advanced server) which worked well, but is somewhat slow and has some considerable restrictions in regard to how fetching can occur. I then moved to use the ODBC/JDBC FM system.

Re: Entity Modeler and Filemaker

I definitely understand the legacy FileMaker problem. To elaborate a bit... I have used FileMaker with WO on two projects, sans WooF. I don't recall the reason for not using WooF in my application - it was certainly around at the time, but it was still commercial. My use of FileMaker was al

Re: Entity Modeler and Filemaker

I really don't have a choice. I have to connect to an existing Filemaker database that is actively being used. I do currently use WOOF with Filemaker 6 which works well, but the database is being upgraded to Filemaker 10. I couldn't get any information saying that WOOF supported 10. I was

Re: Entity Modeler and Filemaker

Hi Sherry, There is also an opensource framework that will allow you to connect WebObjects to Filemaker. I don't know how well it works, but it used to be a commercial product. If you could tell us which option you choose and how successful it is, that would b

Re: Entity Modeler and Filemaker

Hi Sherry, From Oracle to FileMaker. You sure do run the gamut of tools there! :-) If you just need to work with a snapshot, FrontBase has a FileMaker to FrontBase migration tool. That would give you a real SQL92 database to work with. Chuck On Jun 24, 2009, at 11:06 AM, Clark Mue

Re: Entity Modeler and Filemaker

You'd be happier if you went CamelCase, but I recommend against FileMaker + WO. There are lots of gotchas; the FileMaker JDBC driver is pretty weak. Clark On 2009-06-24, at 10:59 AM, Sherry Tirko wrote: Hello, I have to interface with a Filemaker database which has spaces in a majority

Entity Modeler and Filemaker

Hello, I have to interface with a Filemaker database which has spaces in a majority of the attribute names. Entity Modeler does not like this. My thought is to replace the spaces with underscores. Does anyone have any recommendations/suggestions or know if this will work? Is there anyone