iOS Question SQLight error

[Alex_197]

Hi all.

Have you ever seen this SQLight exception

ExecNonQuery error: not an error

This is a code where it's happens

    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.

 

[Erel]

1. [B4X] Smart String Literal -

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.

2. Not sure that I understand. Does this query (in B4i) sometimes work and sometimes doesn't?

 

[Alex_197]

1. [B4X] Smart String Literal -


2. Not sure that I understand. Does this query (in B4i) sometimes work and sometimes doesn't?

1. [B4X] Smart String Literal -


2. Not sure that I understand. Does this query (in B4i) sometimes work and sometimes doesn't?

Looks like this.

About 20 users have this app installed on their iPhone and only 2 so far report this issue. I'm receiving emails whwn it happens. I don't even understand this exception message.

 

[Computersmith64]

Try getting rid of the trailing space in:

MySQL= MySQL & ") "

I've seen reports of this "not an error" error coming up randomly for queries that have trailing spaces &/or lines.

For the 2 who report the issue, does it happen consistently or is it intermittent?

- Colin.

 

[Alex_197]

Try getting rid of the trailing space in:

MySQL= MySQL & ") "

I've seen reports of this "not an error" error coming up randomly for queries that have trailing spaces &/or lines.

For the 2 who report the issue, does it happen consistently or is it intermittent?

- Colin.

It's just happened, for the last 2 days.

 

[aeric]

If I am not remember wrongly, this may due to Null data.