SQLite: ask to display a non existent UNIQUE ID ?

Emile_Schwarz · March 5, 2020, 1:57pm

I had a crazy idea minutes ago:

in a current project, what happens if I ask for the next Record with a no more existant UNIQUE ID ?

With my actual code, since all Fields are Nil (but not the RecordSet), it only clears the previous window contents (if there was data).

But, this is disturbing when you are not awaiting that.

I tried to trap a Nil field, but it crash (If rs.Field("Issue_Number").StringValue = Nil Then).

The idea was to loop until the next valid ID in the case of missing(s) UNIQUE IDs.

MarkusR · March 5, 2020, 2:04pm

this make no sense

“” = Nil

Jean-Yves_Pochez · March 5, 2020, 2:16pm

If rs.Field("Issue_Number").Value.isNull Then

should work

Emile_Schwarz · March 5, 2020, 5:03pm

Check your data base in the Debugger: all fields (TEXT here) are noted Nil.

So, as a good (very old) boy, I checked against Nil

If it does not makes sense, it is Xojo who do not have sense

@Jean-Yves: I checked and GOOD ANSWER !

Thank you !