[ic] IC_TEST_CREATE table

[Chad Leigh, Shire.Net LLC]

--==========1474446717==========
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi mike

The question is, why doesn't it go away again?  The program can reely =
create and drop tables but it doesn't seem to be dropping this so the next =
time around it is still there.  I understand why it is there.  I want to =
understand how to make it work the way you intended.

Thansk
Chad

--On Tuesday, May 08, 2001 9:43 AM -0400 Mike Heins <mikeh@minivend.com> =
wrote:

> Quoting Chad Leigh, Shire.Net LLC (chad@shire.net):
>> Hi
>>
>> In the configuration of a new catalog (using SQL database, in my case
>> trying to use FrontBase), it apperas to create a table called
>> IC_TEST_CREATE with the columns of the real table it wants to create.
>> It then appears to try and create the real table.  My problem is that
>> the IC_TEST_CREATE from the table creation before hand is still in my
>> database when it tries to go through the cycle again for the next table.
>>
>> I have tried using Oracle and Postgres as my "databases" with actually
>> being logged into FrontBase, after changing the appropriate table column
>> definition files.
>>
>> What is the actual work going on behind he scenes with this
>> IC_TEST_CREATE table?
>>
>
> It is designed to see if the table is failing because we are unable
> to create/drop tables. If we don't do this, the error is inscrutable.
>
> A workaround is to create a valid SQL creation statement and put it
> in the parameter CREATE_SQL:
>
> Database  country  CREATE_SQL   <<EOF
>     CREATE TABLE country (
>       code char(3) NOT NULL default '',
>       sorder char(128) default NULL,
>       region char(128) default NULL,
>       selector char(3) default NULL,
>       shipmodes char(64) default NULL,
>       name char(32) NOT NULL default '',
>       iso char(3) NOT NULL default '',
>       isonum char(3) NOT NULL default '',
>       PRIMARY KEY  (code),
>       KEY name (name),
>       KEY country_code (code)
>     )
> EOF
>
> --
> Red Hat, Inc., 131 Willow Lane, Floor 2, Oxford, OH  45056
> phone +1.513.523.7621 fax 7501 <mheins@redhat.com>
>
> People who want to share their religious views with you
> almost never want you to share yours with them. -- Dave Barry
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@lists.akopia.com
> http://lists.akopia.com/mailman/listinfo/interchange-users
>




--==========1474446717==========
Content-Type: application/pgp-signature
Content-Transfer-Encoding: 7bit

-----BEGIN PGP SIGNATURE-----
Version: Mulberry PGP Plugin v2.0
Comment: processed by Mulberry PGP Plugin

iQA/AwUBOvf/a5Tz5Jfdw0hKEQK3OQCbBFKy1yjxMTcHmxW37B519uytOqwAoP1S
ntFJJFgUnBSRbEOQtEAQTDCB
=ZDfj
-----END PGP SIGNATURE-----

--==========1474446717==========--