EOModeler, INTEGER and Frontbase

Simon <[email protected]>
Newsgroups gmane.comp.web.webobjects.devel
Message-ID <[email protected]>
Hi All - Raw sql is not my usual territory so please forgive me if  
this is a basic question, but here goes...

We have been using a commerical reporting tool to generate reports  
based on a Frontbase database. The reporting tool is receiving an  
exception from Frontbase when it tries to call this:

SELECT COUNT(POSITION) FROM URLMAP;

I believe the reason is because the POSITION data type in Frontbase  
is INT.

However, the SQL being used to generate the table is:

CREATE TABLE URLMAP(ACTUALDIR VARCHAR(100) NOT NULL,WEBPATH VARCHAR 
(100),POSITION INTEGER);

Why is Frontbase assigning the data type as "INT" and not "INTEGER" ?

Any help appreciated.

Thanks, Simon
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.