Database

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.

Ibrahim.elh wrote:

what you proposed?

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]