Article View: borland.public.cppbuilder.database.multi-tier
Article #1104Re: sql problem
From: Jeff Overcash (TeamB)
Date: Tue, 20 Jun 2000 00:00
Date: Tue, 20 Jun 2000 00:00
26 lines
2058 bytes
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-mailReferences:
<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