Re: Entity Modeler and Filemaker
Re: Entity Modeler and Filemaker
- Subject: Re: Entity Modeler and Filemaker
- From: Clark Mueller <email@hidden>
- Date: Wed, 24 Jun 2009 18:38:32 -0700
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 being created from the FileMaker UI. This
was acceptable in the environment where I needed to do it. If you want
the sequence to be the same, you would probably need to find some way
to pretend to have a "sequence" in FileMaker and tell your FileMaker
database and EOF to generate their primary keys accordingly.
Clark
On Jun 24, 2009, at 1:11 PM, Andrew Lindesay wrote:
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. From memory; unfortunately the JDBC/ODBC bridge from FM
is not possible or difficult to wrap into an EO adaptor because it
cannot generate primary keys ahead of actually creating the FM
records (or some such problem). The JDBC/ODBC FM system works
well. To use spaces in field names, I just wrapped the field name
in double quotes (").
cheers.
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 else out there that uses Filemaker with WO?
___
Andrew Lindesay
www.lindesay.co.nz
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden