id,summary,reporter,owner,description,type,status,priority,milestone,component,resolution,keywords,cc,planetversion,pltversion
162,Contracts not working or documentation incorrect,erast,jaymccarthy,"Either I'm systematically doing something wrong, the documentation is not up-to-date, or there is a bug somewhere. The following code yields an error:

#lang scheme
(require (prefix-in sqlite3: (planet jaymccarthy/sqlite:3))) 
(define (test)
  (define db (sqlite3:open (build-path ""test"")))
  (sqlite3:exec/ignore
   db
   ""CREATE TABLE ? (notesID INTEGER PRIMARY KEY, data TEXT, timeCreated DATE, timeModified DATE, misc BLOB);""
   ""test"")
  db)

(test)

==>  procedure exec/ignore: expects 2 arguments, given 3: #<db> ""CREATE TABLE ? (notesID INTEGER PRIMARY KEY, data TEXT, timeCreated DATE, timeM... ""test""

Worse, I can't get parameter to work at all. Sqlite always reports a syntax error near ""?"" for the following code:

#lang scheme
(require (prefix-in sqlite3: (planet jaymccarthy/sqlite:3))) 
(define (test)
  (define db (sqlite3:open (build-path ""test"")))
  (define stm (sqlite3:prepare db  ""CREATE TABLE ? (notesID INTEGER PRIMARY KEY, data TEXT, timeCreated DATE, timeModified DATE, misc BLOB);""))
  (sqlite3:load-params db stm ""name""))
(test)

==> SQLite Error: near ""?"": syntax error

Are these bugs or am I missing something obvious?",defect,closed,major,,jaymccarthy/sqlite.plt,,,erich@…,(4 1),4.1.5