[plt-scheme] SQLite error

From: Jens Axel Søgaard (jensaxel at soegaard.net)
Date: Tue Jul 21 20:17:32 EDT 2009

Hi All,

A little sanity check. Does the program below run for you?

#lang scheme
(require (prefix-in sql: (planet jaymccarthy/sqlite:4:3/sqlite)))
(define db (sql:open (string->path "deleteme.db")))
(sql:select db "SELECT (*) FROM sqlite_master")

In DrScheme on OS 10.5 I keep getting this error:

Welcome to DrScheme, version [3m].
Language: Module; memory limit: 512 megabytes.
. . SQLite Error: You should only prepare one statement at a time!
"SELECT (*) FROM sqlite_master"

Jens Axel Søgaard

Posted on the users mailing list.