[Mono-dev] Can not execute multiple SQL statements in single function call - ExecuteNonQuery()

[sivakumar.arumugam at wipro.com]

Hi
 
The following test case not working on Solaris 7 system.
 
Test Case  Name 
SqliteParameterUnitTests 
 
Test Result 
Failed
 
Error Message
       expected:<0>  but was:<1> 
 
      at
MonoTests.Mono.Data.SqliteClient.SqliteParameterUnitTests.InsertRandomVa
luesWithParameter () [0x00187]  
       in
/mono_sol7/mono-1.9/mcs/class/Mono.Data.SqliteClient/Test/SqliteParamete
rUnitTests.cs:70 
   
      at (wrapper managed-to-native)
System.Reflection.MonoMethod:InternalInvoke (object,object[])
   
      at System.Reflection.MonoMethod.Invoke (System.Object obj,
BindingFlags invokeAttr, System.Reflection.Binder binder,
System.Object[] parameters,          
      System.Globalization.CultureInfo culture) [0x0003f] in
/mono_sol7/mono-1.9/mcs/class/corlib/System.Reflection/MonoMethod.cs:149
 
Component
Mono.Data.SqliteClient 
 
Operating System/ Architecture  
Solaris 7  / Sparc  32 
 
My Analysis 
 
I think the command is not working as expected
SqliteCommand insertCmd = new SqliteCommand(DELETE FROM t1;"INSERT INTO
t1 (t, f, i, b) VALUES(:textP, :floatP, :int
egerP, :blobP)", _conn);
 
 Need your help to fix this issue. Thanks.
 
   Regards
  

 

Please do not print this email unless it is absolutely necessary. 

The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. 

WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. 

www.wipro.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ximian.com/pipermail/mono-devel-list/attachments/20080610/bc23e81f/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 4642 bytes
Desc: image002.jpg
Url : http://lists.ximian.com/pipermail/mono-devel-list/attachments/20080610/bc23e81f/attachment.jpe