I.T. Discussion Community!
-Collapse +Expand
DBA
Search DBA Group:

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE

Prestwood eMagazine

September Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyDBA, Databases, & Data BoardInterbase Topic   Print This     

Cannot insert into triggered interbase field.

Cannot insert into triggered interbase field. in Interbase topic (part of our DBA, Databases, & Data group).

Quick Search: triggered   interbase   Cannot insert   Cannot insert into   triggered interbase   field   
PANTLORD
 (Inactive)
-- USA
Hi there,

I'm having trouble inserting a value into one of my interbase tables. The table in question has 5 fields, the primary key Operator_ID has a trigger set on it to autoincrement. It is a NOT NULL field as it is the primary key, so I don't enter a value via my Delphi front end. I have also set the required property for this field in Delphi to false.

I consistently am getting the message 'Field XXX requires a value however'.

Should interbase not handle this itself the trigger type is BEFORE INSERT. Within delphi I am using a DataModule with a an IBdatabase/IBTransaction/IBTable and a standard datasource as components and am attempting o do the insert via a navigation component and dbgrid.

Any suggestions this thing is driving me crazy slowly but surely.

Thanks in advance
PL
 Posted 17 years ago (Thread Starter)
Comment Quote
About PANTLORD -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #5123, 1 replies
Thread Started 2/3/2002 10:22:00 AM
View Counter=3341
Last Reply Posted 2/7/2002 11:31:00 PM)
Location=-- USA 
Joined=17 years ago   MB Posts=5  
Most Recent Post
Simon Wood
 (Inactive)
UK
I use this technique all over the place in my apps and don't see the problem that you have. I am using ObjectPAL and pass-through SQL.

Have you tried inserting a record using an INSERT statement in Windows iSQL ? If this fails then you have an InterBase problem otherwise it is something in your Delphi App

Have you tried doing a simple hard-coded insert using a TQuery component under a button in your Delphi App ?
 Posted 17 years ago
Comment Quote
About Simon Wood -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #5201 (Level 1.1)  Reply to 5123
Thread Started 2/7/2002 11:31:00 PM
View Counter=2
Location=UK  
Joined=17 years ago   MB Posts=10  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1173A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #5123 Counter
3341
Since 4/2/2008

Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech