hi everyone

Could some one help me please I can not seem to get this bit of SQL code to work on a SQLite Database


Code:
SQLCommand = vbNullString
SQLCommand += "insert into tenders ("
SQLCommand += "pos, "
SQLCommand += "cash, "
SQLCommand += "cheque, "
SQLCommand += "card, "
SQLCommand += "giftvoucher, "
SQLCommand += "giftcard, "
SQLCommand += "coupon) "
SQLCommand += "values('"
SQLCommand += Format(Val(PoSNumber), "000") & "','"
SQLCommand += Tender_CashValue & "','"
SQLCommand += Tender_ChequeValue & "','"
SQLCommand += Tender_CardValue & "','"
SQLCommand += Tender_GiftVoucherValue & "','"
SQLCommand += Tender_GiftCardValue & "','"
SQLCommand += Tender_CouponsValue & "') "
SQLCommand += "on duplicate key update"
SQLCommand += "cash = cash + '" & Tender_CashValue & "','"
SQLCommand += "cheque = cheque + '" & Tender_ChequeValue & "','"
SQLCommand += "card = card + '" & Tender_CardValue & "','"
SQLCommand += "giftvoucher = giftvoucher + '" & Tender_GiftVoucherValue & "','"
SQLCommand += "giftcard = giftcard + '" & Tender_GiftCardValue & "','"
SQLCommand += "coupon = coupon + '" & Tender_CouponsValue & "');"
what am i doing wong it works fine on my MySQL Server database