Well now I've tried an insert but it freaks (got all the rest to work.)
It gives error "column "check_date" is of type date but expression is of type integer"
Now check_date is set as 'date'
The sql statement has:INSERT INTO revenue (id_company, id_owner, check_date, check_number, check_amount, post_date) VALUES (3434,5223,12/12/2015,3231,784.32,01/01/2015)
For some reason 12/12/2015 is a nogo. I have done lots of research and still cannot figure out why.
The table has check_date with data such as 4/7/2014 residing in it. All are in that order. Now I tried the key field, which is auto incremented, and have a number assigned but got the same error (and thus the fields are in sync.)