Is there anyone knows the code for time in and time out in Visual Basic please let me know

Answer 1

Will Google help?

Answer 2

But what you mean by time in and time out?

Answer 3

Its like monitoring system when the ID tap the scanner it will appear the time in and time out in the database in Visual basic

Answer 4

Try

dr.Close()

Dim ups As New MySqlCommand("UPDATE " & Table_Name4 & "SET TimeOut=curtime() WHERE StudID='" & LabelStudID.Text.Substring(5, LabelStudID.Text.Length - 5) & "'", Conn)
ups.ExecuteNonQuery()
TimeOutLog.Text = "TIME OUT : " & Now.ToString

Catch ex As Exception

End Try

Answer 5

Theres a logical error there

Answer 6

Varchar

Answer 7

Because the system is RFID Base

Answer 8

There is no error message sir

Answer 9

Maybe the placing of the columns

Answer 10

Or maybe it cant find the column to select for update

Answer 11

Okay thankyou sir that was very helpful 😊

Answer 12

Jane Cruz it looks like the query needs a space inserted before "SET...", unless Table_Name4 already has a space appended at its end.

Side note: I noticed that it is recording potentially two different timestamps between the database record and the log file. The query takes its timestamp from the SQL engine, and the log file timestamp comes from the local computer. If the SQL engine is on a separate server (and worse, in a different time zone) the timestamps will surely be different. This makes log analysis difficult to reconcile with database timestamps. You should use a consistent time source and be certain the log matches the database times exactly by retrieving the time once and using the same result in both places. Alternatively, you could retrieve the timestamp from the record after the update and use that timestamp in the log file.

Answer 13

By anychance do u know the code for that? Can u help me sir

Answer 14

Not sure what logical problem is
Maybe you can build the query as a string and show it in a MessageBox for a closer observation (for SQL syntax error).

What are the data type for 'Timeout', and 'StudID' column?

Answer 15

Tell me more about your suspicion for logical error ...
What got you thinking it is happening? any error message?

Check validity and correctness for quotes in the query may (or not) help.

Answer 16

Placement of columns matters for INSERT not UPDATE.

Your query will fail with error if you try to update a non existing column

So strike those two cause you said there was no error message.

Answer 17

Keep me posted for updates ...

Answer 18

Hiii