Re: problem with text column and indexes

2002-02-01 Thread Paul DuBois
At 13:05 -0500 2/1/02, Diego, Emil wrote: >I have a table that I created and i am trying to create an index that >contains a text field. I am having prblems with the syntax and keep >receiving errors whenever I try to create the table. > >Here is the SQL statement for the table: > >CREATE TABLE

problem with text column and indexes

2002-02-01 Thread Diego, Emil
I have a table that I created and i am trying to create an index that contains a text field. I am having prblems with the syntax and keep receiving errors whenever I try to create the table. Here is the SQL statement for the table: CREATE TABLE IF NOT EXISTS logInfo ( ID BIGINT UNSIGN