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

Reply via email to