Re: How to set a Default Value

My table definition (i change the deafult to 'N') :

CREATE TABLE pautaitem
(
  cdpautaitem serial NOT NULL,
  arquivo varchar(255),
  item varchar(255),
  cdpauta varchar(255),
  cditem varchar(11) NOT NULL DEFAULT 'N',
  CONSTRAINT pauta_arquivos_pkey PRIMARY KEY
(cdpautaitem)
)

My insert query:

INSERT INTO PautaItem (
         CdPauta,
         Item,
                 CdItem,
         Arquivo) VALUES (
         '"+this.sCdPauta',
         '"+this.sItem',
                 '"+this.sCdItem',
         '"+this.sArqImagem')

Ângelo Marcos Rigo
AMR Informática
(51) 3348 0870
Rua Pe. Alois Kades 400/210
Porto Alegre /RS/Brasil
http://amr.freezope.org
angelo_rigo@yahoo.com.br










_______________________________________________________
Yahoo! doce lar. Faça do Yahoo! sua homepage.
http://br.yahoo.com/homepageset.html