https://bugzilla.novell.com/show_bug.cgi?id=364432


           Summary: ODBC: Parameter with DbType.Time and value DBNull.Value
                    produces invalid SQL statement
           Product: Mono: Class Libraries
           Version: 1.2.6
          Platform: i686
        OS/Version: Windows XP
            Status: NEW
          Severity: Major
          Priority: P5 - None
         Component: Sys.Data
        AssignedTo: [EMAIL PROTECTED]
        ReportedBy: [EMAIL PROTECTED]
         QAContact: [email protected]
          Found By: Customer


SQL Statements with parameters of type DbType.Time produces an invalid
statement.

1. Create an OdbcCommand with CommandTexdt set to "INSERT INTO tbl (col1)
VALUES (?)"
2. Add a parameter with type DbType.Time, set the value to DBNull.Valjue
3. Execute it (ExecuteNonQuery)

This seems to produce a statement like "INSERT INTO tbl (col1) VALUES ()" and
therefore fails.

I use Sybase SQL Anywhere 10 + all bug fixes.

Regards,
Mark


-- 
Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.
_______________________________________________
mono-bugs maillist  -  [email protected]
http://lists.ximian.com/mailman/listinfo/mono-bugs

Reply via email to