Prevent backdate transation.

Ketan Mokariya

Hi,

I am developing desktop application which is based on offline database(say sqlite). where capture information from user and it will be store in table with currentdatetime stamp.

My offline data will later be updated to server using api based on internet connection available,mannually or through daily schedular .

Main chellange i am having that how i can prevent user to enter backdate data which will store in local DB. Let say internet connection on pc is not constant may be down for many day. Also user who will use application will be having rights in his pc to change his date.

Please help me out how i can prevent user to enter past date.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta8y ago
If there is no possibility to fetch datetime over the internet then you can check the current date should not be less than maximum date from the database. var query = "select max (date) from tablename"; // Execute something like above query and match with the current date and then proceed with insertion of your data.
+1
Laxmidhar Sahoo8y ago
sir
take a extra field in your table like uploaddata as bit
which rows u uploaded updatre that field to true which before false
means at the time of entry bydefault false;

here no neccessery to check date .Only check that uploaddata field
whether false
0