🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.multi-tier
Article #1101

Re: sql problem

#1101
From: Nuno Miguel da Silva Santos
Date: Mon, 19 Jun 2000 00:00
27 lines
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-mail
References: <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