Xcode X Switt X SQLite

Question

Hi, Has anyone developing an app for Mac, Xcode 14.3 and using SQLite ever had the errors below? Detail: the application compiles and runs without errors!!

Captura de Tela 2023-05-28 às 19.50.25.png

Tks.

Swift

281

Posted by

agostinhoScz

Reply

Add a Comment

Answer 1

Should this...:

fmResultSet = ...

...be:

let fmResultSet = ...

..instead? And apparently:

while fmResultSet!.next() == true

Is not the valid way since next() returns the next result object, not a boolean value true or false. So perhaps you need to replace that with:

while fmResultSet!.next() != nil

Later you use the isEmpty property, and that is either true or false but you compare that to nil instead.

Posted by

AndyJJ

Add a Comment

Answer 2

Should this...:

fmResultSet = ...

...be:

let fmResultSet = ...

..instead? And apparently:

while fmResultSet!.next() == true

Is not the valid way since next() returns the next result object, not a boolean value true or false. So perhaps you need to replace that with:

while fmResultSet!.next() != nil

Later you use the isEmpty property, and that is either true or false but you compare that to nil instead.

Posted by

AndyJJ

Add a Comment

Answer 3

Hi AndyJJ, Thanks for the tips, after corrections the error messages disappeared. However, the command

while fmResultSet!.next() != nil

It always returns True, so the loop ends up giving an error when finding one of the columns of the ResultSet where I check if it is different from nil. To work around, I now check if the PkLivro field is equal to zero then I break the loop.

Thanks.

Posted by

agostinhoScz

Add a Comment

Xcode X Switt X SQLite

Accepted Reply

Replies