🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: sql problem

#1104
From: Jeff Overcash (TeamB)
Date: Tue, 20 Jun 2000 00:00
26 lines
2058 bytes
Like I said in my other post, you need to set the Required property for the
TField for that column to false.  This stops the client side validation for that
field.  The problem is not in the DBNavigator.  The problem is that when TQuery
reads the properties for each field your DB backend returns that IDCLIENTE is a
required field, so a validation error will result before anything is even sent
to the DB if the field is NULL, turning off Required for that field will stop
the client side check and let the server fill it out for you.

Nuno Miguel da Silva Santos wrote:
> 
> 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.
> 


-- 
Jeff Overcash (TeamB)   
  (Please do not email me directly unless asked.  Thank You)     
A spider wanders aimlessly within the warmth of a shadow, not the regal creature
of border caves, but the poor, misguided, directionless familiar of some obscure
Scottish poet.  The mist crawls from the canal like some primordial phantom of
romance To curl, under the cascade of neon pollen.  While I sit tied to the
phone like some expectant father, your carnation will rot in a vase.  (Fish)
Technical Details
Message-ID: <394F7550.6993D363@onramp.net>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <394cd2d0@dnews> <ppoqksgrr5ibpmrksba13dvd0450mj5i1c@4ax.com> <394e9e31@dnews>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,f78a0254ccdb6698
X-Google-Attributes: gidfcd2b,public
From: "Jeff Overcash (TeamB)" <overcash@onramp.net>
Subject: Re: sql problem
Date: 2000/06/20
Message-ID: <394F7550.6993D363@onramp.net>
X-Deja-AN: 636800771
Content-Transfer-Encoding: 7bit
References: <394cd2d0@dnews> <ppoqksgrr5ibpmrksba13dvd0450mj5i1c@4ax.com> <394e9e31@dnews>
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
X-Trace: 20 Jun 2000 06:37:26 -0800, 127.0.0.1
Organization: TeamB
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.multi-tier