TOday an app that was working just kicked me ...

(Brett Mason) #1

TOday an app that was working just kicked me out at startup.

Error is:

Unable t o add/edit/delete row in table ‘rooms’. Value ‘NULL’ in field ‘TIMESTAMP’ cannot be converted to type ‘DateTime’.

This is

a SQL server hosted database.

I want all my variables empty, i.e. blank, so that the user can begin typing. My TEXT variables have ‘NULL’ showing, so the mobile user hits backspace four times.

They don’t like an app that works this way.

How do you recommend I deal with this new NULL problem that is showing up?

(Dinh Nguyen Nguyen) #2

@Brett_Mason1 Hi Brett, this problem occurred because the app attempted to write the value “NULL” into a DateTime column.

The main question is: if the column is indeed a DateTime column, the app should only allow the app user to pick valid date time values using a date time picker, so how did the app end up with the value “NULL”?

In order to investigate further, I will need the following information:

1/ The name of the app in question 2/ The names of all relevant columns and tables 3/ Was the app user trying to add or update rows? 4/ Have you made any changes to the column structure of the affected table/column recently? 5/ Any other relevant information?