RE: [sqlite] RE: Problem executing sqlite3_prepare command

2006-07-12 Thread Shields, Daniel
> Never mind. I just realized (from rereading a previous newsgroup > posting) that the wildcards can only be used to replace values within > expressions (and not the table or column names). > > I use printf for these cases before preparing: sprintf(buf, "INSERT INTO %s VALUES (?,

[sqlite] RE: Problem executing sqlite3_prepare command

2006-07-11 Thread Vitali Lovich
Never mind. I just realized (from rereading a previous newsgroup posting) that the wildcards can only be used to replace values within expressions (and not the table or column names).

[sqlite] Re: Problem executing sqlite3_prepare command

2006-07-11 Thread Igor Tandetnik
Vitali Lovich <[EMAIL PROTECTED]> wrote: I'm trying to call the sqlite3_prepare command with the string 'CREATE TABLE $table ( $columns );'. You cannot parameterize on table name, nor on columns list. A parameter can only appear where an expression would be syntactically valid. Igor