Mercurial > hg > dbutils / changeset

--- a/dbutils/sqlite.c	Thu Feb 27 20:53:55 2025 +0100
+++ b/dbutils/sqlite.c	Thu May 29 15:59:17 2025 +0200
@@ -118,32 +118,32 @@
 
 int dbuSQLiteQuerySetParamString(DBUQuery *q, int index, cxstring str) {
     DBUSQLiteQuery *query = (DBUSQLiteQuery*)q;
-    return sqlite3_bind_text(query->stmt, index, str.ptr, str.length, NULL);
+    return sqlite3_bind_text(query->stmt, index+1, str.ptr, str.length, NULL);
 }
 
 int dbuSQLiteQuerySetParamInt(DBUQuery *q, int index, int i) {
     DBUSQLiteQuery *query = (DBUSQLiteQuery*)q;
-    return sqlite3_bind_int(query->stmt, index, i);
+    return sqlite3_bind_int(query->stmt, index+1, i);
 }
 
 int dbuSQLiteQuerySetParamInt64(DBUQuery *q, int index, int64_t i) {
     DBUSQLiteQuery *query = (DBUSQLiteQuery*)q;
-    return sqlite3_bind_int64(query->stmt, index, i);
+    return sqlite3_bind_int64(query->stmt, index+1, i);
 }
 
 int dbuSQLiteQuerySetParamDouble(DBUQuery *q, int index, double d) {
     DBUSQLiteQuery *query = (DBUSQLiteQuery*)q;
-    return sqlite3_bind_double(query->stmt, index, d);
+    return sqlite3_bind_double(query->stmt, index+1, d);
 }
 
 int dbuSQLiteQuerySetParamNull(DBUQuery *q, int index) {
     DBUSQLiteQuery *query = (DBUSQLiteQuery*)q;
-    return sqlite3_bind_null(query->stmt, index);
+    return sqlite3_bind_null(query->stmt, index+1);
 }
 
 int dbuSQLiteQuerySetParamBytes(DBUQuery *q, int index, void *bytes, int len) {
     DBUSQLiteQuery *query = (DBUSQLiteQuery*)q;
-    return sqlite3_bind_blob(query->stmt, index, bytes, len, NULL);
+    return sqlite3_bind_blob(query->stmt, index+1, bytes, len, NULL);
 }
 
 int dbuSQLiteQueryExec(DBUQuery *q) {