Hi Helen,

What version of Interbase are you running, and by which vendor?

Regards,
Dion.


-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: 04 January 2001 06:02
To: IBObjects@egroups.com
Subject: Re: [IBO] Where is the diference


At 11:32 PM 03-01-01 -0400, you wrote:

>When I am at delphi and run the app and try post a record with no ID
>I got the exception, but when I execute from Windows Explorer or from a
>shortcut any
>thing happen.

It looks as though your database table has a BEFORE INSERT trigger to
populate the ID field when the database receives NULL for it. Could you
look at the table using IB_WISQL's Browser, and inspect its Triggers page?

If delphi is not giving you an exception on an ID field that you know is
NOT NULL, then have a look at the ID column's REQUIRED attribute in the
Fields Editor. If it is checked off, then your app is allowing the trigger
to do the work.

Helen


All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________