FbCommand Exception
-------------------
Key: DNET-107
URL: http://tracker.firebirdsql.org/browse/DNET-107
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 2.5.0
Environment: FB SS 2.0.1
Windows 2003 Server 32-bit
VStudio 2005
Reporter: Eduardo Gamboa
Assignee: Carlos Guzman Alvarez
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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider