[Firebird-net-provider] Using FBCommandBuilder with a table that has a trigger to update a column

[Tony R. <Ton...@jf...>]

How do you stop FBCommandBuilder from using "ID" in the insert command.
The ID will be created by a trigger in the database.

=20

Insert: INSERT INTO "JFMTEMP" ("ID", "TEST_STRING", "TEST_DATE",
"TEST_BOOLEAN", "TEST_NUMERIC", "TEST_TEXT", "TEST_INTEGER") VALUES (?,
?, ?, ?, ?, ?, ?)

=20

Update: UPDATE "JFMTEMP" SET "ID" =3D ?, "TEST_STRING" =3D ?, "TEST_DATE" =
=3D
?, "TEST_BOOLEAN" =3D ?, "TEST_NUMERIC" =3D ?, "TEST_TEXT" =3D ?,
"TEST_INTEGER" =3D ? WHERE ( ("ID" =3D ?) AND (("TEST_STRING" IS NULL) OR
("TEST_STRING" =3D ?)) AND (("TEST_DATE" IS NULL) OR ("TEST_DATE" =3D ?))
AND (("TEST_BOOLEAN" IS NULL) OR ("TEST_BOOLEAN" =3D ?)) AND
(("TEST_NUMERIC" IS NULL) OR ("TEST_NUMERIC" =3D ?)) AND (("TEST_INTEGER"
IS NULL) OR ("TEST_INTEGER" =3D ?)) )

=20

Delete: DELETE FROM "JFMTEMP" WHERE ( ("ID" =3D ?) AND (("TEST_STRING" IS
NULL) OR ("TEST_STRING" =3D ?)) AND (("TEST_DATE" IS NULL) OR ("TEST_DATE"
=3D ?)) AND (("TEST_BOOLEAN" IS NULL) OR ("TEST_BOOLEAN" =3D ?)) AND
(("TEST_NUMERIC" IS NULL) OR ("TEST_NUMERIC" =3D ?)) AND (("TEST_INTEGER"
IS NULL) OR ("TEST_INTEGER" =3D ?)) )

=20

=20



This message has been scanned for viruses by MailControl - www.mailcontrol.=
com