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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] +ReportedBy: [EMAIL PROTECTED] +QAContact: [EMAIL PROTECTED] +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.') _______________________________________________ mono-bugs maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-bugs
