Simon Slavin-3 wrote:
>
>
> On 19 May 2011, at 9:35am, Dev_lex wrote:
>
>> I need to prepare the statement before to know the name of the table, but
>> I'll find an other way..
>>>
>>>>
>>>> I would like to do this :
>>>>
>>>> const char *zSql = "INSERT INTO ?(ID, MyData) VALUES('1',?)";
>
> Instead of using a const, use a C string, or select one of a few different
> consts.
>
> But what your problem is really telling you is that those tables are
> actually all one big table. The thing you think of as a table name is
> really just another column.
>
> Simon.
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
Yeah, thanks, I've found another way to solve my problem.. this wasn't too
hard ^^..
But now I've got a new problem, again with this function..
I've create a structure in a header file (called init_handle) that contains
the informations like sqlite3 *db // sqlite3_stmt *Stmt // ...
And in a .c file I've made a function that prepare a command, but I obtain
an error..
Here is the line :
if( sqlite3_prepare_v2(init_handle.db, zSql_stmt[i][j],
strlen(zSql_stmt[i][j])+1, &init_handle.Stmt[i][j], init_handle.pzTail) !=
SQLITE_OK )
{
fprintf(stderr, "Can't prepare : %s\n",
sqlite3_errmsg(init_handle.db));
sqlite3_close(init_handle.db);
exit(1);
}
And the error says :
Can't create table : table DHSS already exists
Can't prepare : near "create": syntax error
Do I have made a syntax error?
--
View this message in context:
http://old.nabble.com/Unknown-parameter-for-prepare_v2-tp31653746p31662252.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
