[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 4.2.0.6-svn15jul2009 [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.