sqlite error another row available
kelvin 发布于 2024-12-28

最近用capacitor sqlite插件查询数据,返回了一个错误error code 100 another row available,查了返回代码,对应的是SQLITE_ROW (100)

Primary Result Code List

The 31 result codes are defined in sqlite3.h and are listed in alphabetical order below:

SQLITE_ABORT (4)

SQLITE_AUTH (23)

SQLITE_BUSY (5)

SQLITE_CANTOPEN (14)

SQLITE_CONSTRAINT (19)

SQLITE_CORRUPT (11)

SQLITE_DONE (101)

SQLITE_EMPTY (16)

SQLITE_ERROR (1)

SQLITE_FORMAT (24)

SQLITE_FULL (13)

SQLITE_INTERNAL (2)

SQLITE_INTERRUPT (9)

SQLITE_IOERR (10)

SQLITE_LOCKED (6)

SQLITE_MISMATCH (20)

SQLITE_MISUSE (21)

SQLITE_NOLFS (22)

SQLITE_NOMEM (7)

SQLITE_NOTADB (26)

SQLITE_NOTFOUND (12)

SQLITE_NOTICE (27)

SQLITE_OK (0)

SQLITE_PERM (3)

SQLITE_PROTOCOL (15)

SQLITE_RANGE (25)

SQLITE_READONLY (8)

SQLITE_ROW (100)

SQLITE_SCHEMA (17)

SQLITE_TOOBIG (18)

SQLITE_WARNING (28)

 

 

(100) SQLITE_ROW

The SQLITE_ROW result code returned by sqlite3_step() indicates that another row of output is available.

看这个还是不知道怎么解决,sql查询语句没有错误,后来发现我用的SQLiteDBConnection的run函数,如果改为query函数,就没再报这个错误了。

 

kelvin
关注 私信
文章
98
关注
0
粉丝
0