LiveCode Forums.

Mysql max integer value

Hi!

Here is part of my code:
(it's on desktop app, button action)

dim rs as RecordSet
dim i, fim as integer

rs=app.g_db.SQLSelect("select max(id) id from zendesk")
fim=rs.field("id").IntegerValue+1
here is the "debug of fim"

fim = -14163
and, of course, this is the ...