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 racket,
> 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
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 fi
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 automa
I'm working on converting a number of CSV files into SQLite3 tables. As of now
I export the SQL statements to a text file and import them afterwards.
```
(define (csv->sqlfiles)
(for-each
(λ (e)
(let* ([csv_filepath (string-append csv_dir (path->string e))]
[table_name (pat
5 matches
Mail list logo
