FrontBase Error "Datatypes are not comparable or don't match"
FrontBase Error "Datatypes are not comparable or don't match"
- Subject: FrontBase Error "Datatypes are not comparable or don't match"
- From: Paul Stringer <email@hidden>
- Date: Mon, 07 Sep 2009 21:23:45 +0100
I'm switching an eomodel to use FrontBase instead of Oracle. I'm using
ERPrototypes and generating the SQL no problem. However when I come to
access the database I'm getting the following error.
Semantic error 217. Datatypes are not comparable or don't match.
Semantic error 485. Near: '1'.
The SQL reveals that the select statements have qouted integers
converting them to strings e.g. ID='1' instead of ID=1. The eomodel
external types for these attributes are correctly set to INTEGER. I'm
using the latest Wonder FrontBasePlugin version 5.0, with WebObjects
5.4.3. Any ideas where I'm going wrong?. I've been happily using Id's
Integers & FrontBase in various other projects under the same setup.
Paul
_______________________________________________
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