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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/cpmueller%40mac.com
This email sent to [email protected]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
