Database

<img src="data:image/png;base64,.........

this.Cursor = Cursors.WaitCursor;

// save the contact;
sql_connection = new MySqlConnection("my_connection");
sql_connection.Open();

sql_command = new MySqlCommand("sp_save_message", sql_connection);

sql_command.CommandType = CommandType.StoredProcedure;
sql_command.CommandTimeout = Convert.ToInt32(sql_command_timeout);
            
sql_command.Parameters.AddWithValue("param_message_id", message_id).MySqlDbType = MySqlDbType.Int32;
sql_command.Parameters.AddWithValue("param_message", txtMessage.HtmlText).MySqlDbType = MySqlDbType.LongText;

int result_rows = sql_command.ExecuteNonQuery();

this.DialogResult = System.Windows.Forms.DialogResult.OK;

Quote:

Packets larger than max_allowed_packet are not allowed.

[mysqld]
max_allowed_packet=1024M

"SELECT " & _
"  SUM(FSHIPQTY * FCOST) " & _
", SUM(FSHIPQTY * FPRICE) " & _
", SUM(FAMOUNT) " & _
", SUM(FSHIPQTY * FPRICE - FSHIPQTY * FCOST) " & _
" FROM " & _
"( " & _
" SELECT " & _
"     h.FSHIPQTY " & _
"   , h.FCOST " & _
"   , h.FPRICE " & _
"   , h.FAMOUNT " & _
" FROM ARTRS01H.dbf h " & _
" WHERE " & _
" h.FSHIPDATE >= @startDate AND h.FSHIPDATE <= @stopDate " & _
" AND " & _
" h.FITEMNO = @FITEMNO " & _
" UNION  ALL " & _
" SELECT " & _
"     v.FSHIPQTY " & _
"   , v.FCOST " & _
"   , v.FPRICE " & _
"   , v.FAMOUNT " & _
" FROM ARTRS01.dbf v " & _
" WHERE " & _
" v.FSHIPDATE >= @startDate AND v.FSHIPDATE <= @stopDate " & _
" AND " & _
" v.FITEMNO = @FITEMNO " & _
") "

var query = (from sub in db.myTable
                            where  (sub.Deleted == null || sub.Deleted == 0)
                            select new
                            {
                                sub.ID,
                                sub.UpdatedByAdmin,
                                sub.UpdatedBy,
                                sub.Deleted,
                                D1 = sub.UpdatedByAdmin.Equals(true ? sub.Date1 : sub.TimesForDate1),
                                D2 = sub.UpdatedByAdmin.Equals(true ? sub.Date2 : sub.TimesForDate2),
                                D3 = sub.UpdatedByAdmin.Equals(true ? sub.Date3 : sub.TimesForDate3)


                            }).ToList();

System.ArgumentException: DbComparisonExpression requires arguments with comparable types.

Dhyanga wrote:

I thought byte is equivalent to tinyInt.