[Aubit4gl-discuss] Problem in index creation

[Carlos A. C. F. <cco...@li...>]

 Hi all,

The instrucction CREATE INDEX id1 ON table1 (field1,field2,field3)

The index is create only with first field.

Other question the Serial data type fails in creation the table.

The program is

DATABASE
 pos

MAIN
   CREATE TABLE client 
   (
   ctel integer not null,
   cext integer not null,
   dnom char(30) not null,
   tdoc char(1) not null,
   cnit decimal(12,0) not null,
   ncli serial not null,  /* THIS DATA TYPE GENERATED CORE DUMPED */
   nclc integer not null,
   ncua integer not null,
   snum smallint not null,
   siti char(5) not null,
   detd char(60) not null,
   ddir char(60) not null,
   codb smallint not null,
   nsuc char(15) not null,
   ctab decimal(15,0) not null,
   ttar char(1) not null,
   ntar decimal(15,0) not null,
   cseg smallint not null,
   vtar char(4) not null,
   fing date not null,
   fulp date not null,
   cdin integer not null,
   cdic integer not null,
   qven smallint not null,
   vacu integer not null,
   ctin integer not null,
   ctac integer not null
   )
  
   CREATE INDEX icli1 ON client (ctel,cext)/* The index only the column ctel)
   CREATE INDEX icli3 ON client (cnit)
   CREATE INDEX icli4 ON client (fulp)
   CREATE INDEX icli5 ON client (ncli)
   CREATE INDEX icli6 ON client (nclc)
 
END MAIN

In attach file all program and debug

Thank 

Carlos

-- 
______________________________________________
http://www.linuxmail.org/
Now with e-mail forwarding for only US$5.95/yr

Powered by Outblaze