Re: [sqlite] best way to use sqlite as application's format

[Richard Hipp]

On Wed, Feb 22, 2012 at 8:10 PM, Roger Binns  wrote:

>
> The second is to ensure you have an undo mechanism, as this will affect
> your schema and triggers.  One thing I worked on didn't even have a 'save'
> menu item.  Every action you did resulted in a database change.  You could
> easily undo these.  You could also see of the objects as they were at any
> prior point in time, being able to undo or redo any change.
>

Here  is a write-up from
2005 in which I describe a technique I used to implement unlimited-depth
undo/redo in a application that used SQLite as its file format.  There was
no "File/Save" button.  But you could undo as far back as you wanted - even
in to prior sessions.  That application was written in Tcl/Tk, but the idea
works the same in D or whatever language you want to use.

Another approach is to record historical versions of rows in the database
somehow.  In other words, design your schema as if it were a Version
Control System  that keeps a
permanent record of past images of the data.  Bonus points if you can make
it operate as a Distributed Version Control
System.
Note that Monotone  was a pioneer in the DVCS
space and their file format is an SQLite database.  Note also that SQLite
itself is maintained using
Fossilwhich
is another DVCS that uses an SQLite database for storage.  (Yes, the
source code for SQLite is stored in an SQLite database.  Recursion is a
wonderful thing.)

Or, you could do all your work inside a transaction and then implement a
File/Save button that does a COMMIT for you.  That approach is conceptually
simpler from the point of view of the programmer.  But it is less intuitive
to users.  And if your application crashes, you lose all of your work done
since the last File/Save.  If you do use this approach, please note that
SQLite does support nested
transactionwhich might be
useful to you.


-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] best way to use sqlite as application's format

[Roger Binns]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 22/02/12 13:35, Gour wrote:
> d) something else?

Just start using SQLite and see what happens.  You don't have to use an
ORM.  And if you don't use one, you'll eventually see if you need one and
what functionality it needs.

I do have two other recommendations.  The first is to ensure you have a
sensible way of testing.  A layer between your code and the database may
make that easier or harder - validate up front that it will be the former.

The second is to ensure you have an undo mechanism, as this will affect
your schema and triggers.  One thing I worked on didn't even have a 'save'
menu item.  Every action you did resulted in a database change.  You could
easily undo these.  You could also see of the objects as they were at any
prior point in time, being able to undo or redo any change.

Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (GNU/Linux)

iEYEARECAAYFAk9Fkg8ACgkQmOOfHg372QTxogCgk1lONsgDb3InMk+5JT90dsY9
Bj4AoK93XPTigLOMJwmSI9nGszryeuyk
=8d64
-END PGP SIGNATURE-
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLiteDataAdaptor Missing

[Joe Mistachkin]

Something is not quite right with that output.  You are running on 64-bit
Windows?

Are you able to add a new SQLite data connection from inside Visual Studio?

Do you see any messages about a package load failure?

For some reason, the installer tool believes it is running on 32-bit
Windows.

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] double_quote(text_field)

[Dave Watkinson]

Did you mean something like

SELECT '"'||text_field||'"' FROM table;

so that your column's data is quoted?


~~~
Dave Watkinson



On Wed, Feb 22, 2012 at 6:26 PM, Igor Tandetnik  wrote:

> On 2/22/2012 6:03 PM, Bill McCormick wrote:
>
>> What is the easiest way to return a text field with double (") quotes?
>>
>> SELECT quote(text_field) FROM table; is close, but I'd rather have a
>> SELECT double_quote(text_field) FROM table;
>>
>
> I'm not sure I understand the nature of the problem. What's wrong with
> simply
>
> SELECT text_field FROM myTtable;
>
> ? There's nothing special about text fields that happen to contain a
> double quote character.
> --
> Igor Tandetnik
>
>
> __**_
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] double_quote(text_field)

[Igor Tandetnik]

On 2/22/2012 6:03 PM, Bill McCormick wrote:

What is the easiest way to return a text field with double (") quotes?

SELECT quote(text_field) FROM table; is close, but I'd rather have a
SELECT double_quote(text_field) FROM table;


I'm not sure I understand the nature of the problem. What's wrong with 
simply


SELECT text_field FROM myTtable;

? There's nothing special about text fields that happen to contain a 
double quote character.

--
Igor Tandetnik

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] double_quote(text_field)

[Simon Slavin]

On 22 Feb 2012, at 11:03pm, Bill McCormick  wrote:

> What is the easiest way to return a text field with double (") quotes?
> 
> SELECT quote(text_field) FROM table; is close, but I'd rather have a SELECT 
> double_quote(text_field) FROM table;

Does

SELECT quote(quote(text_field)) FROM table;

work ?

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] double_quote(text_field)

[Bill McCormick]

What is the easiest way to return a text field with double (") quotes?

SELECT quote(text_field) FROM table; is close, but I'd rather have a 
SELECT double_quote(text_field) FROM table;


Thanks!!
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Column names including spaces

[Petite Abeille]

On Feb 22, 2012, at 10:21 PM, Pete wrote:

> I try to access that column in any way, I get an error, no matter whether I
> specify the column name with no quotes, single quotes or double quotes

For the record:

http://www.sqlite.org/lang_keywords.html

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] best way to use sqlite as application's format

[Petite Abeille]

On Feb 22, 2012, at 10:35 PM, Gour wrote:

> Otoh, here we come to the well-known "object-relational impedance
> mismatch" problem and wonder how to resolve it, iow.:

Are you actually trying to solve a concrete problem? Or creating one out of 
thin air instead?

http://blogs.tedneward.com/2006/06/26/The+Vietnam+Of+Computer+Science.aspx
-- Ted Neward, The Vietnam of Computer Science, 2006


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Column names including spaces

[John Drescher]

>  For example if I "SELECT Col 1 FROM..." I get a "syntax error near 1"
> (which I'd expect).  If I try 'SELECT "CoL 1" FROM...", I get and error "no
> such column "Col1" - notice there is no space in the column name listed in
> the error message".
>

Are you escaping the quotes for whatever language / tool you are using
so they are passed to SQLITE?

John
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] best way to use sqlite as application's format

[Gour]

Hello!


We're considering what would be the optimal way way to resolve
"object-relational impedance mismatch" problem in our application which
we would like to write using D language.

Considering it's planned to be multi-platform desktop GUI app and have
extensive research capabilities available for learning & studying
purposes - it means to be able to put queries against the whole database
of available data - we are thinking that using embedded database -
sqlite3 -  as application's natural storage format would be a nice fit.
Sqlite3 offers robust format available for multiple platforms.

Moreover, having RDBMS could greatly simplify the code handling all
kinds of queries againsta the data which would be required to write
otherwise.

Otoh, here we come to the well-known "object-relational impedance
mismatch" problem and wonder how to resolve it, iow.:

a) we are not aware of any ORM available for D, so using relational data
model + D with its OOP paradigm, means to resolve the mismatch by hand
by writing required ORM

b) use relational model "as it is", leave OOP (in D) behind, but we
wonder whether such approach makes sense in the language which is
higher-level than C. (E.g. Fossil SCM written in C uses sqlite3 as
storage format.)

c) several papers/posts which we read before and recently (like
"Functional-Relational Impedance Match" Eric Meijer's The Confessions of
a Used Programming Language Salesman) tend to suggest that using
relational data model goes better with FP languages or that the latters
can overcome the above mismatch problem better, which would lead to
putting D's FP capabilites to extreme or

d) something else?


Sincerely,
Gour

-- 
The embodied soul may be restricted from sense enjoyment, 
though the taste for sense objects remains. But, ceasing 
such engagements by experiencing a higher taste, 
he is fixed in consciousness.

http://atmarama.net | Hlapicina (Croatia) | GPG: 52B5C810


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Column names including spaces

[Igor Tandetnik]

On 2/22/2012 4:21 PM, Pete wrote:

I seem to have stumbled upon what looks like a bug in SQLite.  I
accidentally created a column in a table that included a space in its
name,eg "Col 1".  The CREATE TABLE command accepted without an error but if
I try to access that column in any way, I get an error, no matter whether I
specify the column name with no quotes, single quotes or double quotes.
  For example if I "SELECT Col 1 FROM..." I get a "syntax error near 1"
(which I'd expect).  If I try 'SELECT "CoL 1" FROM...", I get and error "no
such column "Col1" - notice there is no space in the column name listed in
the error message".


Must be a problem with a tool or wrapper you use. Column names enclosed 
in double quotes do work in SQLite.

--
Igor Tandetnik

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Column names including spaces

[Stephan Beal]

On Wed, Feb 22, 2012 at 10:21 PM, Pete  wrote:

> I seem to have stumbled upon what looks like a bug in SQLite.  I
> accidentally created a column in a table that included a space in its
> name,eg "Col 1".  The CREATE TABLE command accepted without an error but if
> I try to access that column in any way, I get an error, no matter whether I
> specify the column name with no quotes, single quotes or double quotes.
> ...


stephan@tiny:~$ sqlite3
SQLite version 3.7.7 2011-06-23 19:49:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create table t([Col 1]);
sqlite> .h on
sqlite> insert into t values('a');
sqlite> select * from t;
Col 1
a
sqlite> select [Col 1] from t;
Col 1
a

Hope that helps,

-- 
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Column names including spaces

[Pete]

I seem to have stumbled upon what looks like a bug in SQLite.  I
accidentally created a column in a table that included a space in its
name,eg "Col 1".  The CREATE TABLE command accepted without an error but if
I try to access that column in any way, I get an error, no matter whether I
specify the column name with no quotes, single quotes or double quotes.
 For example if I "SELECT Col 1 FROM..." I get a "syntax error near 1"
(which I'd expect).  If I try 'SELECT "CoL 1" FROM...", I get and error "no
such column "Col1" - notice there is no space in the column name listed in
the error message".

I'm not unduly concerned since this column name should never have had a
space in it in the first place but perhaps CREATE TABLE should flag an
error in this situation if the column can't be accessed?


-- 
Pete
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to JOIN...

[Danilo Cicerone]

Thanks, your solution works better in case a student has subscribed a course
and has no card.
Just add the following SQL statement to the FILE:

INSERT INTO A VALUES(3,'Jack','Bridge');
INSERT INTO A2B VALUES(5,3,3);

to prove it.

2012/2/22 Igor Tandetnik :
> On 2/22/2012 1:05 PM, Danilo Cicerone wrote:
>>
>> two views. According to the following SQL statement(see below) I'm
>>
>> going to create a table
>> 'A' storing student's name, table 'B' storing courses and table D storing
>> cards.
>> Furthermore, it creates two pivot tables A2B and A2D to refer courses and
>> cards.
>> I'd like to query the DB to get that result:
>>
>> 1|John|Doe|Italian, Spanish|12345
>> 2|Paul|Smith|English, Italian|12345, 13579
>
>
> select A.*,
>  (select group_concat(b_course) from A2B join B on (a2b_ref_b = b_id) where
> a2b_ref_a=a_id),
>  (select group_concat(d_card) from A2D join D on (a2d_ref_d = d_id) where
> a2d_ref_a=a_id)
> from A;
>
> --
> Igor Tandetnik
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to JOIN...

[Danilo Cicerone]

Thanks!
Sigh, I need more research on JOINs
I need more research on JOINs,
I need more research on JOINs,
I need more research on JOINs,
I need more research on JOINs,
I need more research on JOINs,
I need more research on JOINs,
I need more research on JOINs,
I need more research on JOINs.

2012/2/22 Simon Davies :
> SELECT * FROM aTest NATURAL JOIN dTest;
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to JOIN...

[Igor Tandetnik]

On 2/22/2012 1:05 PM, Danilo Cicerone wrote:

two views. According to the following SQL statement(see below) I'm
going to create a table
'A' storing student's name, table 'B' storing courses and table D storing cards.
Furthermore, it creates two pivot tables A2B and A2D to refer courses and cards.
I'd like to query the DB to get that result:

1|John|Doe|Italian, Spanish|12345
2|Paul|Smith|English, Italian|12345, 13579


select A.*,
  (select group_concat(b_course) from A2B join B on (a2b_ref_b = b_id) 
where a2b_ref_a=a_id),
  (select group_concat(d_card) from A2D join D on (a2d_ref_d = d_id) 
where a2d_ref_a=a_id)

from A;

--
Igor Tandetnik

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to JOIN...

[Simon Davies]

On 22 February 2012 18:05, Danilo Cicerone  wrote:
> ...two views. According to the following SQL statement(see below) I'm
> going to create a table
> 'A' storing student's name, table 'B' storing courses and table D storing 
> cards.
> Furthermore, it creates two pivot tables A2B and A2D to refer courses and 
> cards.
> I'd like to query the DB to get that result:
>
> 1|John|Doe|Italian, Spanish|12345
> 2|Paul|Smith|English, Italian|12345, 13579
>
.
.
.
> so could you suggest an SQL solution?
>
> Thanks in advance, Danilo
>

SELECT * FROM aTest NATURAL JOIN dTest;

Regards,
Simon
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] How to JOIN...

[Danilo Cicerone]

...two views. According to the following SQL statement(see below) I'm
going to create a table
'A' storing student's name, table 'B' storing courses and table D storing cards.
Furthermore, it creates two pivot tables A2B and A2D to refer courses and cards.
I'd like to query the DB to get that result:

1|John|Doe|Italian, Spanish|12345
2|Paul|Smith|English, Italian|12345, 13579

using the views aTest and dTest it returns:

--aTest
1|John|Doe|Italian, Spanish
2|Paul|Smith|English, Italian

and

--dTest
1|John|Doe|12345
2|Paul|Smith|12345, 13579

but the vTest view doesn't return the right result:

1|John|Doe|Italian, Spanish|12345, 12345
2|Paul|Smith|English, English, Italian, Italian|12345, 13579, 12345, 13579

so could you suggest an SQL solution?

Thanks in advance, Danilo

-- START SQL FILE

CREATE TABLE A (
a_id INTEGER PRIMARY KEY NOT NULL,
a_name TEXT,
a_last TEXT);

CREATE TABLE A2B (
a2b_id INTEGER PRIMARY KEY NOT NULL,
a2b_ref_a INTEGER,
a2b_ref_b INTEGER);

CREATE TABLE B (
b_id INTEGER PRIMARY KEY NOT NULL,
b_course TEXT);

CREATE TABLE A2D (
a2d_id INTEGER PRIMARY KEY NOT NULL,
a2d_ref_a INTEGER,
a2d_ref_d INTEGER);

CREATE TABLE D (
d_id INTEGER PRIMARY KEY NOT NULL,
d_card TEXT);

INSERT INTO A VALUES(1,'John','Doe');
INSERT INTO A VALUES(2,'Paul','Smith');

INSERT INTO B VALUES(1,'English');
INSERT INTO B VALUES(2,'Italian');
INSERT INTO B VALUES(3,'Spanish');

INSERT INTO A2B VALUES(1,1,2);
INSERT INTO A2B VALUES(2,1,3);
INSERT INTO A2B VALUES(3,2,1);
INSERT INTO A2B VALUES(4,2,2);

INSERT INTO D VALUES(1,'12345');
INSERT INTO D VALUES(2,'67890');
INSERT INTO D VALUES(3,'13579');

INSERT INTO A2D VALUES(1,1,1);
INSERT INTO A2D VALUES(2,2,1);
INSERT INTO A2D VALUES(3,2,3);

CREATE VIEW aTest AS
SELECT
   A.*,
   group_concat(b_course, ', ')
FROM A
LEFT OUTER JOIN A2B ON a_id = a2b_ref_a
INNER JOIN B ON a2b_ref_b = b_id
GROUP BY a_id;

CREATE VIEW dTest AS
SELECT
   A.*,
   group_concat(d_card, ', ')
FROM A
LEFT OUTER JOIN A2D ON a_id = a2d_ref_a
INNER JOIN D ON a2d_ref_d = d_id
GROUP BY a_id;

CREATE VIEW vTest AS
SELECT
   A.*,
   group_concat(b_course, ', '),
   group_concat(d_card, ', ')
FROM A
LEFT OUTER JOIN A2B ON a_id = a2b_ref_a
INNER JOIN B ON a2b_ref_b = b_id
LEFT OUTER JOIN A2D ON a_id = a2d_ref_a
INNER JOIN D ON a2d_ref_d = d_id
GROUP BY a_id;

-- END
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] bug? Can't load file SQLiteConnection.cs under c:\dev\sqlite\dotnet\System.Data.SQLite.

[LouOttawa]

Well...I didn't compile the SQLite binaries. I don't have the SQLite source
code, so Sharpdevelop could not have compiled it. So the folder path must
have been set there by whoever/whatever compiled the SQLite binaries. I
certainly have no folder path that resembles that one.
I guess I see this as a SQLite bug in that someone wrote code that caused
the error to occur when it fact it should not have occurred.
Unless... is it possible that I'm using the wrong DLL file?
Lou.


Joe Mistachkin-3 wrote:
> 
> 
> LouOttawa wrote:
>> 
>> You explained that: "The path you are seeing is from the machine used to
>> build the released binaries." I understand your explanation, but is this
> not
>> then a bug in SQLite? Doesn't "someone" build the binaries on the "SQLite
>> machine" so to speak? 
>> 
> 
> No, it's not a bug.  The compiler automatically embeds the original source
> location in the PDBs.
> 
>> 
>> I mean - its not a SharpDevelop problem, is it?
>> 
> 
> Not really.  It's probably just reading the PDB and assuming that the
> source
> code should be available locally in the same location as when it was
> built.
> That assumption is invalid in this case; however, in the more general case
> of
> projects being developed with SharpDevelop, that might be OK.
> 
> --
> Joe Mistachkin
> 
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> 
> 

-- 
View this message in context: 
http://old.nabble.com/bug--Can%27t-load-file-SQLiteConnection.cs-under-c%3A%5Cdev%5Csqlite%5Cdotnet%5CSystem.Data.SQLite.-tp33353617p33372245.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Reference error

[David Horne]

Here's the result of running gacutil:

Microsoft (R) .NET Global Assembly Cache Utility.  Version 4.0.30319.1
Copyright (c) Microsoft Corporation.  All rights reserved.

The Global Assembly Cache contains the following assemblies:
  System.Data.SQLite, Version=1.0.79.0, Culture=neutral,
PublicKeyToken=db937bc2d44ff139,

processorArchitecture=AMD64

Number of items = 1

I ran this after uninstalling and reinstalling to make sure that the
assemblies were installed in the GAC.

I've also changed the code slightly to avoid opening the db in the form
load - but, apart from the form loading, there's no difference. Here's the
revised (and still simple) code:

Imports System.Data.SQLite

Public Class Form1

Private dbConn As SQLiteConnection

Private Sub Button1_Click(sender As System.Object, e As
System.EventArgs) Handles Button1.Click

'configure & open data connection
dbConn = New SQLiteConnection("Data
Source=C:\Users\David\testJnl;Version=3;")

Try
dbConn.Open()
MessageBox.Show("Conn open", "TestLocaldb",
MessageBoxButtons.OK, MessageBoxIcon.Information)
Catch ex As Exception
MessageBox.Show(ex.ToString())
Finally
If (dbConn.State = ConnectionState.Open) Then
dbConn.Close()
End If
End Try

End Sub

End Class

Out of ideas and moving to MySQL - unless you have any further suggestions.

Thanks for your help, Joe.

David Horne


On 21 February 2012 22:10, Joe Mistachkin  wrote:

>
> David Horne wrote:
> >
> > The only thing I haven't checked is the contents of the GAC for the
> > possible stray that you mention. Can you tell me how to do this?
> >
>
> Open a Visual Studio 2010 Command Prompt and type:
>
>gacutil /l System.Data.SQLite
>
> --
> Joe Mistachkin
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Site/Login Confusion

[Igor Tandetnik]

LouOttawa  wrote:
> I can loggin under Nabble without a problem. But the SQLite web site at
> "http://www.sqlite.org/src/login; seems to be quite separate in its
> credentials, although it lists bug reports that I entered in Nabble. What is
> that website for?

Nabble is a mailing list aggregator. It's completely independent from and 
unrelated to SQLite, except that it happens to aggregate sqlite-users mailing 
list, among thousands of others. SQLite.org doesn't know nor care about your 
Nabble login credentials.

For more information about SQLite mailing lists, see 
http://sqlite.org/support.html . For more information about Nabble, see 
http://www.nabble.com/help/Answer.jtp?id=1
-- 
Igor Tandetnik

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problem with LIKE and greek characters

[Igor Tandetnik]

Robert Gdula  wrote:
> Thank you for the fast response, Mayby someone know any implementation of
> LIKE, ICU function for UNICODE ?

http://www.sqlite.org/src/artifact?ci=trunk=ext/icu/README.txt

-- 
Igor Tandetnik

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLiteDataAdaptor Missing

[Electric Eddy]

After copying the compiled files into c:\Program Files
(x86)\System.Data.SQLite\2008\bin> and running the command:
Installer.exe -install true -wow64 true -installFlags All -tracePriority
Lowest -verbose true -noCompact true -noNetFx40 true -noVs2008 true
-noVs2010 true -whatIf false -confirm true

I get the output below but still no sign of the SQLiteDataAdapter as an
option under Toolbox\Choose Items...

Start of output:
---
C:\Program Files (x86)\System.Data.SQLite\2008\bin>Installer.exe -install
true -
wow64 true -installFlags All -tracePriority Lowest -verbose true -noCompact
true
 -noNetFx40 true -noVs2008 true -noVs2010 true -whatIf false -confirm true
Installer.exe: #1 @ 2012.02.21T20:49:44.8310261: Assembly: "Installer,
Version=1
.0.80.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139"
Installer.exe: #2 @ 2012.02.21T20:49:44.8320261: LogFileName:
"C:\Users\Administ
rator\AppData\Local\Temp\2\Installer.exe.trace.tmp28CC.log"
Installer.exe: #3 @ 2012.02.21T20:49:44.8320261: Directory: "C:\Program
Files (x
86)\System.Data.SQLite\2008\bin"
Installer.exe: #4 @ 2012.02.21T20:49:44.8320261: CoreFileName: "C:\Program
Files
 (x86)\System.Data.SQLite\2008\bin\System.Data.SQLite.dll"
Installer.exe: #5 @ 2012.02.21T20:49:44.8330262: LinqFileName: "C:\Program
Files
 (x86)\System.Data.SQLite\2008\bin\System.Data.SQLite.Linq.dll"
Installer.exe: #6 @ 2012.02.21T20:49:44.8330262: DesignerFileName:
"C:\Program F
iles (x86)\System.Data.SQLite\2008\bin\SQLite.Designer.dll"
Installer.exe: #7 @ 2012.02.21T20:49:44.8330262: DebugFormat: "#{0} @ {1}:
{2}"
Installer.exe: #8 @ 2012.02.21T20:49:44.8340262: TraceFormat: "#{0} @ {1}:
{2}"
Installer.exe: #9 @ 2012.02.21T20:49:44.8340262: InstallFlags: Default
Installer.exe: #10 @ 2012.02.21T20:49:44.8340262: DebugPriority: Default
Installer.exe: #11 @ 2012.02.21T20:49:44.8340262: TracePriority: Lowest
Installer.exe: #12 @ 2012.02.21T20:49:44.8340262: Install: True
Installer.exe: #13 @ 2012.02.21T20:49:44.8340262: Wow64: True
Installer.exe: #14 @ 2012.02.21T20:49:44.8350263: NoRuntimeVersion: False
Installer.exe: #15 @ 2012.02.21T20:49:44.8350263: NoDesktop: False
Installer.exe: #16 @ 2012.02.21T20:49:44.8350263: NoCompact: True
Installer.exe: #17 @ 2012.02.21T20:49:44.8350263: NoNetFx20: False
Installer.exe: #18 @ 2012.02.21T20:49:44.8350263: NoNetFx40: True
Installer.exe: #19 @ 2012.02.21T20:49:44.8360263: NoVs2005: False
Installer.exe: #20 @ 2012.02.21T20:49:44.8360263: NoVs2008: True
Installer.exe: #21 @ 2012.02.21T20:49:44.8360263: NoVs2010: True
Installer.exe: #22 @ 2012.02.21T20:49:44.8370264: NoTrace: False
Installer.exe: #23 @ 2012.02.21T20:49:44.8370264: NoConsole: False
Installer.exe: #24 @ 2012.02.21T20:49:44.8370264: NoLog: False
Installer.exe: #25 @ 2012.02.21T20:49:44.8370264: ThrowOnMissing: True
Installer.exe: #26 @ 2012.02.21T20:49:44.8380265: WhatIf: False
Installer.exe: #27 @ 2012.02.21T20:49:44.8380265: Debug: False
Installer.exe: #28 @ 2012.02.21T20:49:44.8380265: Verbose: True
Installer.exe: #29 @ 2012.02.21T20:49:44.8380265: Confirm: True
Installer.exe: #30 @ 2012.02.21T20:49:44.8390265: AssemblyTitle:
"System.Data.SQ
Lite Designer Installer"
Installer.exe: #31 @ 2012.02.21T20:49:44.8390265: AssemblyConfiguration:
"Debug"

Installer.exe: #32 @ 2012.02.21T20:49:44.8400266: Configuration.Process:
Running
 executable is: "C:\Program Files
(x86)\System.Data.SQLite\2008\bin\Installer.ex
e"
Installer.exe: #33 @ 2012.02.21T20:49:44.8410266: Configuration.Process:
Origina
l command line is: Installer.exe  -install true -wow64 true -installFlags
All -t
racePriority Lowest -verbose true -noCompact true -noNetFx40 true -noVs2008
true
 -noVs2010 true -whatIf false -confirm true
Installer.exe: #34 @ 2012.02.21T20:49:44.8420267: Configuration.Process:
Running
 process is 32-bit.
Installer.exe: #35 @ 2012.02.21T20:49:44.8440268:
Configuration.CheckRuntimeVers
ion: Assembly is compiled for the .NET Framework v2.0.50727, support for
.NET Fr
amework v4.0.30319 is now disabled.
Installer.exe: #36 @ 2012.02.21T20:49:44.9210312: Installer.Main:
GacInstall: as
semblyPath = "C:\Program Files
(x86)\System.Data.SQLite\2008\bin\System.Data.SQL
ite.dll"
Installer.exe: #37 @ 2012.02.21T20:49:44.9710341: Installer.Main:
GacInstall: as
semblyPath = "C:\Program Files
(x86)\System.Data.SQLite\2008\bin\System.Data.SQL
ite.Linq.dll"
Installer.exe: #38 @ 2012.02.21T20:49:44.9740342:
Installer.ForEachFrameworkRegi
stry: frameworkName = ".NETFramework", frameworkVersion = v2.0.50727,
platformNa
me = 
Installer.exe: #39 @ 2012.02.21T20:49:44.9750343:
RegistryHelper.OpenSubKey: roo
tKey = "HKEY_LOCAL_MACHINE", subKeyName =
"Software\Microsoft\.NETFramework\v2.0
.50727", writable = False
Installer.exe: #40 @ 2012.02.21T20:49:44.9770344:
RegistryHelper.OpenSubKey: roo
tKey = "HKEY_LOCAL_MACHINE", subKeyName =
"Software\Microsoft\.NETFramework", wr
itable = False
Installer.exe: #41 @ 

Re: [sqlite] Problem with LIKE and greek characters

[Robert Gdula]

Thank you for the fast response, Mayby someone know any implementation of
LIKE, ICU function for UNICODE ?

W dniu 22 lutego 2012 10:15 użytkownik Dan Kennedy
napisał:

> On 02/22/2012 03:53 PM, Robert Gdula wrote:
>
>> Hi,
>>
>> I've problem with greek characters when I'm using SQLite, it's no working,
>> but for English charaters is ok, problem it is only for LIKE, when I use
>> WHERE for greek characters it's working ok, how to resolve this problem ?
>>
>
> SQLite's built-in LIKE operator only understands upper and lower case
> equivalence for the 26 letters used in English.
>
> If you need it to understand the upper/lower case relationships between
> any other characters, either use the ICU extension or create your own
> implementation of LIKE:
>
>  
> http://www.sqlite.org/lang_**corefunc.html#like
>
> Dan.
> __**_
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problem with LIKE and greek characters

[Dan Kennedy]

On 02/22/2012 03:53 PM, Robert Gdula wrote:

Hi,

I've problem with greek characters when I'm using SQLite, it's no working,
but for English charaters is ok, problem it is only for LIKE, when I use
WHERE for greek characters it's working ok, how to resolve this problem ?


SQLite's built-in LIKE operator only understands upper and lower case
equivalence for the 26 letters used in English.

If you need it to understand the upper/lower case relationships between
any other characters, either use the ICU extension or create your own
implementation of LIKE:

  http://www.sqlite.org/lang_corefunc.html#like

Dan.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Problem with LIKE and greek characters

[Robert Gdula]

Hi,

I've problem with greek characters when I'm using SQLite, it's no working,
but for English charaters is ok, problem it is only for LIKE, when I use
WHERE for greek characters it's working ok, how to resolve this problem ?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users