Please I am having similar issue. I actually designed an application GUI, the GUI has a form with different input variables (textfield ). There's also a textfield for date and the date gets inputted automatically.
After all the data have been entered in their textfields of the form, I submit the record and they get saved in SQL database.
The database column for dateRecorded has data type of varchar(500).
So when application form is submitted, every column record gets saved in their respective columns in the database table.
I have no issue inserting and retrieving record. It's just about 3hours ago I discovered I'm unable to delete any record from the table. It comes up with an SQL error message that conversion failed when converting date and/or time.
I am so confused. I was wondering why a deletion process would have anything to do with conversion. I am about deleting the record, not making any transaction with it. Why is it giving me this error please?
I am attaching a photo showing a record with the stored dateRecord.
Meanwhile I've been deleting records from this same table before. I'm surprised it no longer works as it used it.
How do I resolve this please?
