Oh ok..
Thanks a lot, I thought there was some way to do that..
I need to prepare the statement before to know the name of the table, but
I'll find an other way..
Thanks !
Martin Engelschalk wrote:
>
> Hi,
>
> you cannot bind the name of a table. Bind variables only work for Values
> in the database, like you used in the VALUES('1', ?) - clause.
> Names of tables, columns or other items of the schema must be written in
> the sql statement.
> You will have to build your statement (using sprintf() or similar)
> before preparig it.
>
> This is not uniqe to sqlite, but to SQL in general.
>
> Martin
>
> Am 19.05.2011 10:04, schrieb Dev_lex:
>> Hello,
>>
>> I've a little question about sqlite3_prepare_v2 :
>>
>> I would like to do this :
>>
>> const char *zSql = "INSERT INTO ?(ID, MyData) VALUES('1',?)";
>>
>> if(ppStmt)
>> {
>> sqlite3_bind_parameter_name(ppStmt, "atest");
>> sqlite3_bind_blob(ppStmt, 2,&blob, sizeof(blob),
>> SQLITE_TRANSIENT);
>> sqlite3_step(ppStmt);
>> sqlite3_finalize(ppStmt);
>> }
>>
>> So then I've just to bind values.. It works great for the second '?'
>> which
>> is a blob, so bind_blob(), but for the first one I don't really know what
>> to
>> use ?
>>
>> Maybe the '?' syntax is incorrect? I've not understood everything about
>> it..
>>
>> Regards
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
--
View this message in context:
http://old.nabble.com/Unknown-parameter-for-prepare_v2-tp31653746p31653969.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
