Article View: borland.public.cppbuilder.database.multi-tier
Article #1101Re: sql problem
From: Nuno Miguel da Silva Santos
Date: Mon, 19 Jun 2000 00:00
Date: Mon, 19 Jun 2000 00:00
27 lines
1891 bytes
1891 bytes
i do not put a value in idcliente because it is auto-increment in sql, so i do not want to put a value but i want that the value to appear automaticaly. i thinhk that the problem is that i use the dbnavigator, how can i use sql commands, bacause i want to click a button to confirm the insertion off a registry into the database. Jerry Bloomfield (TeamB) <JersWork@wwa.com> wrote in message news:ppoqksgrr5ibpmrksba13dvd0450mj5i1c@4ax.com... > On Sun, 18 Jun 2000 14:56:58 +0100, "Nuno Miguel da Silva Santos" > <inf02794@alunos.est.ipcb.pt> wrote: > > >i have a sql database. the primary key is auto-increment. > >in the builder aplication for this database, when i try to insert one > >registry it return the folowing error, the field IDCLIENTE must have a > >value, how can i solve this. > > When you post your insert into the database what value do you put into the > IDCLIENTE field? From the error message, I would guess that you do not > put a value, and the edit check sees that there is a null value in a > required field. > > Jerry Bloomfield (TeamB) > -- > http://www.teamb.com JersWork@wwa.com > Please do *NOT* send private e-mail without prior permission (my anti-spam > filters will probably just delete it anyway <g>)
Technical Details
Message-ID:
<394e9e31@dnews>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<394cd2d0@dnews> <ppoqksgrr5ibpmrksba13dvd0450mj5i1c@4ax.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: fcd2b,f78a0254ccdb6698 X-Google-Attributes: gidfcd2b,public From: "Nuno Miguel da Silva Santos" <inf02794@alunos.est.ipcb.pt> Subject: Re: sql problem Date: 2000/06/19 Message-ID: <394e9e31@dnews> X-Deja-AN: 636559188 References: <394cd2d0@dnews> <ppoqksgrr5ibpmrksba13dvd0450mj5i1c@4ax.com> X-Priority: 3 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 X-Trace: 19 Jun 2000 15:26:57 -0800, 212.55.157.5 Organization: Est X-MSMail-Priority: Normal Newsgroups: borland.public.cppbuilder.database.multi-tier