Yes, you can use DrRacket to debug the file at
collects/db/private/sqlite3/connection.rkt. That one is likely the most
relevant one for you.
Alternatively, you could wait till Racket 6.10 is released which is very soon I
think. The bug fixes to the db library might reveal the correct error
For now I've just written a quick batch script that I execute via system
```
#!/bin/bash
for f in 'tmp/sql'/*.sql
do
echo "Filename: $f"
./sqlite3.exe output.sq3 < $f
echo ""
done
```
It works, but I'd still like to figure out exactly what's wrong. I'm relatively
new to
> OMG!!! Does the term "normalization" ring a bell?
Yes but these are encoded file outputs. I'm only using SQL as an alternative to
using a text editor.
> Have you tried removing the terminating semi-colon?
I just tried, same error
> I'm not sure what's causing your issue. What version of
I tried query-exec on those SQL strings you posted on gist on my local copy of
Racket 6.8 with an in-memory SQLite3 db and it worked fine.
I'm not sure what's causing your issue. What version of Racket and SQLite3 are
you running on your machine? Is it Windows, Linux, or Mac OSX?
>
On Wed, 26 Jul 2017 11:45:25 -0700 (PDT),
cmonbr...@gmail.com wrote:
>First the create table is called and afterwards I execute each insert
>statement. This is what displayln shows as output for sql-create:
>
On Wednesday, July 26, 2017 at 7:02:42 PM UTC+2, Alexander McLin wrote:
> One more thing for you to check, make sure there's no trailing whitespace
> after the end of your statement's terminating semi-colon, that will also
> trigger the `multiple statements given` error. That bug has been also
One more thing for you to check, make sure there's no trailing whitespace after
the end of your statement's terminating semi-colon, that will also trigger the
`multiple statements given` error. That bug has been also fixed in the current
repository.
--
You received this message because you
It appears you're giving to `query-exec` a string consisting of two statements;
the create table and insert into statements. `query-exec` only supports
executing one statement at a time.
If you break your two statements up into two strings and call `query-exec` on
each one, it should work.
--
I came across this post earlier. Does it possibly truncate the amount of
characters that was passed to it? My statements don't have syntax errors, I can
copy and paste them into the SQL console without a problem. Seeing as I'm
looking at somewhere close to around 80.000 records I'd rather
There's a problem with the sqlite interface where "multiple statements given"
error is reported for any syntax error. This was fixed only recently. See
previous discussion:
10 matches
Mail list logo