Hi all.
Have you ever seen this SQLight exception
This is a code where it's happens
I can't understand what is wrong here? This is only one user has this error. If I run this query against user's database in DB Browser it's doesn't show any errors.
Have you ever seen this SQLight exception
B4X:
ExecNonQuery error: not an errorThis is a code where it's happens
B4X:
Dim MySQL As String
MySQL="delete FROM tblUnscheduledShifts "
MySQL= MySQL & "where id in ( "
MySQL= MySQL & "Select us.ID "
MySQL= MySQL & "FROM tblUnscheduledShifts As US "
MySQL= MySQL & "left JOIN tblPlacementSchedule As PS "
MySQL= MySQL & "on ps.PlacementLocalID=us.PlacementLocalID "
MySQL= MySQL & "And ps.JobDate=us.JobDate "
MySQL= MySQL & "where ps.id Is Null "
MySQL= MySQL & "AND ps.SentFinish Is NOT Null"
MySQL= MySQL & ") "
Main.SQL1.ExecNonQuery(MySQL)I can't understand what is wrong here? This is only one user has this error. If I run this query against user's database in DB Browser it's doesn't show any errors.