[ic] changing column name really changes things (trying to get frontbase t work)

[Ed LaFrance]

At 04:11 PM 05/07/2001 -0400, you wrote:
>Hi All
>
>I am new to this tool and am trying to get interchange to work with 
>FrontBase (www.frontbase.com).
>
>I have set up a demo construct catalog.
>
>I have set the DSN appropriately and it does log in to my database.
>
>I get the following error because "name" is a reserved sql92 identifier:
>

[del]




>So I go into dbconf/pgsql/ and find country.pgsql:
>


[del]


>I modify the
>Database  country  COLUMN_DEF   "name=CHAR(32) NOT NULL"
>line to be
>Database  country  COLUMN_DEF   "cname=CHAR(32) NOT NULL"
>
>So now when I try and restart (to finish config) I get:
>
>--------------------------
>Do you want me to start it as 'interch' now? [y]
>Killing Interchange server 53179 with TERM.
>Low traffic settings.
>Calling UI....
>...UI is loaded....
>Interchange V4.6.5
>Configuring catalog construct...Using PostgreSQL, 
>DSN=dbi:FB:dbname=construct+goShire2001;host=myhost.mycom.com.
>dbname = construct+pwd/frogmorton.shire.net
>perl in free(): warning: modified (chunk-) pointer.
>bad table creation statement:
>create table country (
>code CHAR(3) NOT NULL PRIMARY KEY,
>selector CHAR(3) NOT NULL,
>shipmodes CHAR(64),
>name char(128)
>)
>


[del]

>my "cname" got morphed into "name=char(128)"
>notice it is still "name" and the CHAR(32) is now char(128) and the NOT 
>NULL is missing.
>
>What did I do wrong and how do I go about changing the column name definition?
>

You must also change the column header 'name' to 'cname' in country.txt.

- Ed L.



===============================================================
New Media E.M.S.               Software Solutions for Business
463 Main St., Suite D          eCommerce | Consulting | Hosting
Placerville, CA  95667         edl@newmediaems.com
(530) 622-9421                 http://www.newmediaems.com
(866) 519-4680 Toll-Free       (530) 622-9426 Fax
===============================================================