[Mono-bugs] [Bug 82148][Wis] New - another NpgsqlParameter error

[bugzilla-daemon at bugzilla.ximian.com]

Please do not reply to this email- if you want to comment on the bug, go to the
URL shown below and enter your comments there.

Changed by miblogic at yahoo.com.

http://bugzilla.ximian.com/show_bug.cgi?id=82148

--- shadow/82148	2007-07-20 07:26:47.000000000 -0400
+++ shadow/82148.tmp.29984	2007-07-20 07:26:47.000000000 -0400
@@ -0,0 +1,99 @@
+Bug#: 82148
+Product: Mono: Runtime
+Version: 1.2
+OS: GNU/Linux [Other]
+OS Details: Ubuntu Feisty Fawn 64 bit
+Status: NEW   
+Resolution: 
+Severity: 
+Priority: Wishlist
+Component: io-layer
+AssignedTo: dick at ximian.com                            
+ReportedBy: miblogic at yahoo.com               
+QAContact: mono-bugs at ximian.com
+TargetMilestone: ---
+URL: 
+Cc: 
+Summary: another NpgsqlParameter error
+
+when the first parameter (insertDetail.Parameters.Add("p_ecmtp_rec_id")) is
+on first line, the first paramater always becomes '0', but when i moved
+command.parameters.add("p_ecmtp_rec_id") on last parameters statements,
+after of 'insertDetail.Parameters["p_remark"].SourceColumn = "remark";',
+then the dataadapter.update works.
+
+
+i can't sense why Npgsql on mono misbehaves this way, on windows it is just ok.
+
+anyway, i'll just re-arrange statements or find work-arounds rather than
+creating an extra O/R mapper.  
+
+but i hope this can be fixed by Francisco, because i really want to use
+Linux + Mono Remoting + Npgsql + PostgreSQL
+
+
+here's the code:
+
+
+NpgsqlCommand insertDetail = new NpgsqlCommand(
+	@"insert into ecmtp_parameter(ecmtp_rec_id, ecmtp_parameter_rec_id,
+color_code, parameter_code, unit, value_span_code, value, method, remark)
+	values( :p_ecmtp_rec_id , :p_ecmtp_parameter_rec_id, :p_color_code,
+:p_parameter_code, :p_unit, :p_value_span_code, :p_value, :p_method,
+:p_remark)", c);
+
+
+
+insertDetail.Parameters.Add("p_ecmtp_rec_id", NpgsqlDbType.Text);
+insertDetail.Parameters["p_ecmtp_rec_id"].Value = ecmtRecId;
+
+
+
+insertDetail.Parameters.Add("p_ecmtp_parameter_rec_id", NpgsqlDbType.Varchar);
+insertDetail.Parameters["p_ecmtp_parameter_rec_id"].SourceColumn =
+"ecmtp_parameter_rec_id";
+
+
+insertDetail.Parameters.Add("p_color_code", NpgsqlDbType.Varchar);
+insertDetail.Parameters["p_color_code"].SourceColumn = "color_code";
+
+
+Console.WriteLine("ecmt rec id: " + ecmtRecId);
+
+insertDetail.Parameters.Add("p_parameter_code", NpgsqlDbType.Varchar);
+insertDetail.Parameters["p_parameter_code"].SourceColumn = "parameter_code";
+
+
+
+insertDetail.Parameters.Add("p_unit", NpgsqlDbType.Varchar);
+insertDetail.Parameters["p_unit"].SourceColumn = "unit";
+
+
+insertDetail.Parameters.Add("p_value_span_code", NpgsqlDbType.Varchar);
+insertDetail.Parameters["p_value_span_code"].SourceColumn = "value_span_code";
+
+
+insertDetail.Parameters.Add("p_value", NpgsqlDbType.Numeric);
+insertDetail.Parameters["p_value"].SourceColumn = "value";
+
+insertDetail.Parameters.Add("p_method", NpgsqlDbType.Varchar);
+insertDetail.Parameters["p_method"].SourceColumn = "method";
+
+
+insertDetail.Parameters.Add("p_remark", NpgsqlDbType.Varchar);
+insertDetail.Parameters["p_remark"].SourceColumn = "remark";
+
+NpgsqlDataAdapter da = new NpgsqlDataAdapter();
+da.InsertCommand = insertDetail;
+da.Update(delta);
+
+
+
+
+postgresql log:
+
+
+insert into ecmtp_parameter(ecmtp_rec_id, ecmtp_parameter_rec_id,
+color_code, parameter_code, unit, value_span_code, value, method, remark)
+values( '0' , 'f021bcbb-0614-4723-bdc8-90520344b7be', 'B', 'ADD', '-', '>',
+4, 'DIN 54231-2005', 'n.n.')