FbCommand Exception [DNET107]

[firebird-automations]

Submitted by: Eduardo Gamboa (bestrafender)

Please disregard. It was my mistake.

Sorry.

[firebird-automations]

Modified by: Eduardo Gamboa (bestrafender)

priority: Blocker [ 1 ]

description: Having two tables with identical structure and executing the following statement:
INSERT INTO TABLE1 SELECT * FROM TABLE2
everything works fine, but executing
INSERT INTO TABLE1 (FIELD1, FIELD2, FIELD3) SELECT (FIELD1, NULL, FIELD3) FROM TABLE2
or
INSERT INTO TABLE1 (FIELD1, FIELD2, FIELD3) SELECT (FIELD1, @p1, FIELD3) FROM TABLE2
throws the execption.

Dynamic SQL Error
SQL error code = -104
No message for error code 335544851 found.

The statement
INSERT INTO TABLE1 (FIELD1, FIELD2, FIELD3) SELECT (FIELD1, NULL, FIELD3) FROM TABLE2
works fine within isql or IBExpert SQL Editor.

=>

Please disregard. It was my mistake.

Sorry.

[firebird-automations]

Modified by: @cincuranet

assignee: Carlos Guzman Alvarez [ carlosga_fb ] => Jiri Cincura [ cincura_net ]

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Won't Fix [ 2 ]

[firebird-automations]

Modified by: @cincuranet

status: Resolved [ 5 ] => Closed [ 6 ]