Table full of records. I'm looking for duplicate values but I don't
see any. Should I back it up an try re-creating, adding the primary
key then pumping in the records?

Jim

--- In ib-support@y..., "Martijn Tonies" <m.tonies@u...> wrote:
> Ay records in the table?
>
> Martijn Tonies
> InterBase Workbench - the developer tool for InterBase and Firebird
> http://www.interbaseworkbench.com
>
> Upscene Productions
> http://www.upscene.com
>
> "This is an object-oriented system.
> If we change anything, the users object."
>
>
>
> > Table DDL is:
> >
> > CREATE TABLE INVOICES
> > (
> > INVOICE_NO INTEGER NOT NULL,
> > DATE_DEL DATE,
> > ACC_NUM INTEGER NOT NULL,
> > ROUTE CHAR( 5) CHARACTER SET NONE
COLLATE
> > NONE,
> > REF_NO CHAR( 5) CHARACTER SET NONE
COLLATE
> > NONE,
> > SUB_TOTAL NUMERIC( 4, 2),
> > TAX_SALES NUMERIC( 4, 2),
> > TAX_COUNTY NUMERIC( 4, 2),
> > DRUMS_DEL SMALLINT,
> > DRUMS_RET SMALLINT,
> > DRUM_DEP NUMERIC( 4, 2),
> > R_F_CHRG NUMERIC( 4, 2),
> > REC_BY CHAR( 20) CHARACTER SET NONE
COLLATE
> > NONE,
> > DEL_BY CHAR( 20) CHARACTER SET NONE
COLLATE
> > NONE,
> > PAID NUMERIC( 4, 2),
> > CHECK_NO CHAR( 5) CHARACTER SET NONE
COLLATE
> > NONE,
> > CHRG_ACC NUMERIC( 4, 2),
> > REMARKS CHAR( 5) CHARACTER SET NONE
COLLATE
> > NONE,
> > AMT_PD_INV NUMERIC( 4, 2),
> > AMT_PD_ACC NUMERIC( 4, 2),
> > PO_NUM CHAR( 15) CHARACTER SET NONE
COLLATE
> > NONE,
> > TERR CHAR( 2) CHARACTER SET NONE
COLLATE
> > NONE,
> > SP_TAX NUMERIC( 4, 2),
> > POSTED CHAR( 1) CHARACTER SET NONE
COLLATE
> > NONE,
> > APPLIED CHAR( 1) CHARACTER SET NONE
COLLATE
> > NONE,
> > TOTAL NUMERIC( 2, 2) NOT NULL
> > )
> >
> > I want the INVOICE_NO column to be the primary key
> >
> > Jim
> >
> >
> >
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@e...
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
> >