iOS Question Attempt to insert nil object from objects[2] error

[Alex_197]

I have a code that reads a row from a table in the database.
Let's say we have 2 fields with timestamps Start, Finish.

In some cases Finish doesn't have a timestamp and this field has NULL as a value.

My code

dim MySQL as String
dim Start as string,Finish as String,Schedule as String
dim rs as ResultSet

MySQL="SELECT Start,Finish from tblSchedule where id=?"
rs=SQL1.ExecuteQuery2(MySQL,Array as String(1))

Do While rs.NextRow

   Start=rs.getstring("Start")
   Finish=rs.getstring("Finish")
  
Loop

rs.close

'I'm creating a parameters string that will be sent to the server with HttpJob
Schedule="Start=" & Start
Schedule=Schedule & "&Finish=" & Finish ' Here is problem string - line 19

Line 19 has a problerm. As I said in some cases Finish has a value NULL in the database and when I read it string Finish gets value <nil> so when I try to add it to the string Schedule it crashes with the error message -[__NSPlaceholderArray initWithObjects:count:]: attempt to insert nil object from objects[2].

But if I put a breakpoint to line 19 or to any lines before and run the same code with the same values it doesn't crash. I tried 5 times - the same result.

Is it a bug? I'm using version 7.80.

Thanks

 

[Erel]

Nulls and strings don't play well together. Best to get rid of the null as soon as possible.

Something like:

MySQL="SELECT Start, IFNull(Finish, '') from tblSchedule where id=?"

SQLite IFNULL

The SQLite IFNULL function accepts two arguments and returns the first non-NULL argument. If both arguments are NULL, the IFNULL function returns NULL. Syntax The following illustrates the syntax of the IFNULL function. Arguments The IFNULL function has exactly two arguments. The IFNULL function...

www.sqlitetutorial.net