English 中文(简体)
C++ sqlite3_ prepare : “ SQL 逻辑错误或缺少数据库 ”
原标题:C++ sqlite3_prepare: "SQL logic error or missing database"

这是我要在我的 SQLite3 DB 上运行的 SQL 代码 :

INSTERT 进入 tbl_ type valluess (?,????????????????)

但无论我玩多少 ? ? 我都会得到相同的 “SQL逻辑错误或缺少数据库” 错误,而只是用自定义任意值取代 ? ? 错误,在我的表格中运行并获得记录,因此我推断出我的语法有问题。

解药是什么?

最佳回答

我不得不道歉,因为我发现问题 部分由Googling 和部分野蛮的武力:

  1. I was supplying a default 0 argument for an auto increment field, which I replaced with NULL, this I found on the web.
  2. I was binding my values starting from 0, while the doc says The leftmost SQL parameter has an index of 1 and I was confusing it with the similar clause I read at column page.

感谢您花时间反正;-)

问题回答

我也有同样的错误,但后来我注意到我拼错了一个参数名称。





相关问题
Undefined reference

I m getting this linker error. I know a way around it, but it s bugging me because another part of the project s linking fine and it s designed almost identically. First, I have namespace LCD. Then I ...

C++ Equivalent of Tidy

Is there an equivalent to tidy for HTML code for C++? I have searched on the internet, but I find nothing but C++ wrappers for tidy, etc... I think the keyword tidy is what has me hung up. I am ...

Template Classes in C++ ... a required skill set?

I m new to C++ and am wondering how much time I should invest in learning how to implement template classes. Are they widely used in industry, or is this something I should move through quickly?

Print possible strings created from a Number

Given a 10 digit Telephone Number, we have to print all possible strings created from that. The mapping of the numbers is the one as exactly on a phone s keypad. i.e. for 1,0-> No Letter for 2->...

typedef ing STL wstring

Why is it when i do the following i get errors when relating to with wchar_t? namespace Foo { typedef std::wstring String; } Now i declare all my strings as Foo::String through out the program, ...

C# Marshal / Pinvoke CBitmap?

I cannot figure out how to marshal a C++ CBitmap to a C# Bitmap or Image class. My import looks like this: [DllImport(@"test.dll", CharSet = CharSet.Unicode)] public static extern IntPtr ...

Window iconification status via Xlib

Is it possible to check with the means of pure X11/Xlib only whether the given window is iconified/minimized, and, if it is, how?

热门标签