lm
tkSQLite at
http://reddog.s35.xrea.com/wiki/TkSQLite.html
Tcl script as well as standalone executable binary versions for both Linux
and Microsoft Windows.
BSD license.
Updated frequently, current version wraps SQLite 3.5.7.
Robert Wishlaw
__
literal numeric values):
>
> "C-style escapes using the backslash character are not supported because
> they are not standard SQL."
>
If I understand correctly Igor Tandetnik's comment "A backslash is as
good as any.", in the above quote the phrase "they are
This is a Windows code page problem. Your output data to is being
displayed as CodePage 437 which displays an acute-a for OxA0. For
details see
http://en.wikipedia.org/wiki/Code_page_437
Postgresql also had this output problem but solved it with a patch
discussed around this thread node
http
Under the Precompiled binaries for Windows section of the downloads
page, the sqlite-3.5.5.zip, sqlitedll-3.5.5.zip and
tclsqlite-3.5.5.zip files contain 3.5.4 binaries from December 12,
2007.
Robert Wishlaw
-
To
On Jan 23, 2008 7:54 AM, Dennis Cote <[EMAIL PROTECTED]> wrote:
> Robert Wishlaw wrote:
> > When .import parses an empty field in the csv file, that is , a comma
> > immediately followed by another comma, is the cell, in the database,
> > that corresponds to
ned as well as the cells containing
temperatures over 0.
Robert Wishlaw
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
On 12/11/07, Robert Wishlaw <[EMAIL PROTECTED]> wrote:
> On 12/11/07, Joe Wilson <[EMAIL PROTECTED]> wrote:
> > --- [EMAIL PROTECTED] wrote:
> > > The current name resolution rules for SQLite are that it
> > > first tries to resolve names using just the t
expression starting with "B" specified in a SELECT clause, HAVING
clause, or ORDER BY clause is not specified in the GROUP BY clause or it is in
a SELECT clause, HAVING clause, or ORDER BY clause with a column function and
no GROUP BY clause is specified. SQLSTATE=42803
Robert Wishlaw
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
c
> ---+--
> 2 | -998
> 1 |3
>
>
> mysql> select * from t1;
> +--+---+--+
> | a| b | c|
> +--+---+--+
> |1 | 2 |4 |
> |2 | -1000 |5 |
> +--+---+--+
>
> mysql> select a,
On 12/8/07, Joe Wilson <[EMAIL PROTECTED]> wrote:
> --- Robert Wishlaw <[EMAIL PROTECTED]> wrote:
> > > >CREATE TABLE t1(a,b,c);
>
> > IBM DB2 9.5
> >
> > INSERT INTO t1 VALUES(1,2,4);
> > SELECT
; SQL Server returns a 3.
> ORACLE 9 returns a 3.
>
>
IBM DB2 9.5
INSERT INTO t1 VALUES(1,2,4);
SELECT a+b AS c FROM t1 WHERE c=4;
returns
C
3
3
3
3
4 record(s) selected
Robert Wishlaw
p and bottom of the page.
Robert Wishlaw
ies if you hadn't reminded me. It has been several
years since I last had this problem.
Robert Wishlaw
> --- Robert Wishlaw <[EMAIL PROTECTED]> wrote:
>
> > Using sqlite 3.5.2 on Windows XP, I have a textblob.csv file
> >
> > 192,C0,À0,À0
> > 193,C1,Á0,Á0
turns
192|C0
Any idea how to get the BLOB data? Or is the problem that the BLOB
data is not there because .import is filtering out invalid UTF-8?
Robert Wishlaw
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
14 matches
Mail list logo