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