Apologies in advance for a terrible subject line -- I didn't know quite how to
phrase it better.
I have the following two tables (with sample data)
CREATE TABLE geo (
id INTEGER PRIMARY KEY,
max_age TEXT,
min_age TEXT
);
geo table: 39K rows
id max_age min_ag
https://discussions.apple.com/message/15712311#15712311
--
Marco Bambini
http://www.sqlabs.com
On Sep 5, 2011, at 10:46 PM, Lani Gonzales wrote:
> Dear Technical Support:
>
> Please help me remove this error message:
>
> The procedure entry point sqlite3_wal_checkpoint could not be locat
Dear Technical Support:
Please help me remove this error message:
The procedure entry point sqlite3_wal_checkpoint could not be located in the
dynamic link library SQlite3.dll
Please kindly send instructions on how to resolve this problem.
Thank you,
Lani Gonzales
_
> Is it possible to create Storedprocedure or Functions in Sqlite. ?
No.
> Since i am new to Sqlite. Can u suggest some best sites or links to learn
> Sqlite (ofcourse i saw Sqlite.org site)
Other than sqlite.org you can look at google.com. It is usually very
good at finding answers on SQLite-re
Hi,
I am new to Sqlite.
I need to develop a Desktop windows application C# with Sqlite.
Is it possible to create Storedprocedure or Functions in Sqlite. ?
If so, can you send me an example for both.
Since i am new to Sqlite. Can u suggest some best sites or links to learn
Sqlite (ofcou
On Tue, Jul 05, 2011 at 00:30:31 +0200, Wolfgang Enzinger wrote:
> Am Mon, 4 Jul 2011 14:45:07 -0700 (PDT) schrieb ceekayCK:
> > unfortunately send me a .doc file
>
> You're at a loss there. Your friend could as well print this file and send
> you the printer output, essentially that would make no
collection is in tables called "tracks"
So what sqlite command i must write that sqlite would automatically compare
and put imported csv data with all collection to "playlist1"?
--
View this message in context:
http://old.nabble.com/Sqlite-help-tp31992826p31993464.html
Sent
Am Mon, 4 Jul 2011 16:10:10 -0700 (PDT) schrieb ceekayCK:
> It was quite easy to export to csv (using excel) :)
> Now i have in one column Artist , and in second column Title
Fine. :-)
> Ok So i use sqlite Manager in Firefox
Unfortunately, I'm not too familiar with SQLite Manager.
> What shou
in second column Title
Ok So i use sqlite Manager in Firefox
In my database i have one Table called "tracks" Structure is Column ID,
Name, Type,
Name are Artist Type Text
Title Text
What should I do next?
Wolfgang will u help me?
--
View this message in context:
http://old.nabble.
Am Mon, 4 Jul 2011 15:39:30 -0700 (PDT) schrieb ceekayCK:
> If i changed .doc file to .txt or csv, will this help?
> Or put all data from .doc to excel, and then split Artist and title to
> separate columns and export to csv?
*If* you can manage a reasonable export to .csv (using Excel, if neede
nd title to
separate columns and export to csv?
--
View this message in context:
http://old.nabble.com/Sqlite-help-tp31992826p31993160.html
Sent from the SQLite mailing list archive at Nabble.com.
___
sqlite-users mailing list
sqlite-users@sqlite.
Am Mon, 4 Jul 2011 14:45:07 -0700 (PDT) schrieb ceekayCK:
> unfortunately send me a .doc file
You're at a loss there. Your friend could as well print this file and send
you the printer output, essentially that would make no difference.
A .doc file is basically a load of printer instructions, but
command in sqlite that will help me to choose automatically
with a whole database identified 800 songs?
If so, what commands should I use?
Please please help :)
--
View this message in context:
http://old.nabble.com/Sqlite-help-tp31992826p31992826.html
Sent from the SQLite mailing list archive at
Just FYI:
James told me in private mail
"
SQLiteDatabase is not working
for sqlite3, I changed the open script to:
$dbh = new PDO('sqlite:yourdatabase.db');
Now it is working.
"
On Sun, 03 Jul 2011 16:08:24 +0200, Kees Nuyt
wrote:
>On Sun, 3 Jul 2011 06:47:26 -0700 (PDT), James_21th
> wr
On Sun, 3 Jul 2011 06:47:26 -0700 (PDT), James_21th
wrote:
>Dear experts,
>
>I was quite excited when I see such a nice portable database---SQLite, which
>can be installed locally.
>
>However, when I tried to open the SQLite DB with PHP, just a simple open
>script
>will cause "HTTP 500 Intern
On 3 Jul 2011, at 2:47pm, James_21th wrote:
> 20110703:054052 WARN: function 'pcntl_fork' not available
> 20110703:054052 WARN: function 'posix_setuid' not available
These functions aren't available under Windows. I'm guessing from the context
that the SQLite API you're using depends on them.
Dear experts,
I was quite excited when I see such a nice portable database---SQLite, which
can be installed locally.
However, when I tried to open the SQLite DB with PHP, just a simple open script
will cause "HTTP 500 Internl server error", my web server is running fine with
normal php code.
On Tue, Jun 28, 2011 at 8:18 PM, Jan Hudec wrote:
> > name TEXT
> >
> > DATA
> > file_id INTEGER REFERENCES files(resource_id) ON DELETE CASCADE,
> > data_type TEXT,
>
> If nothing else, you want to define integer identifiers for the data types
> and use integer here. That will save you some spac
On 29 Jun 2011, at 2:26am, Lazarus 101 wrote:
> the select statement is
> SELECT * from files left join data on files.file_id=data.file_id;
So you read all the records for the correct file_id, and deal with each one as
you find it, ignoring those you don't want. Hmm. I don't see why your ap
the select statement is
SELECT * from files left join data on files.file_id=data.file_id;
to test the performance i'm only doing
long t1 = System.currentTimeMillis();
Cursor cursor = db.rawQuery(...);
while (cursor.moveToNext()) {
}
android.util.Log.e(TAG, "loaded in: " + (System.currentTime
On 28 Jun 2011, at 9:58pm, Lazarus 101 wrote:
>> You should make an index on the columns 'file_id' and 'data_type' from the
>> 'DATA' table. This will allow it to be searched far more quickly. Your
>> command will be something like
>>
>> CREATE UNIQUE INDEX dfd ON data (file_id,data_type)
>>
On Tue, Jun 28, 2011 at 8:18 PM, Jan Hudec wrote:
> On Tue, Jun 28, 2011 at 17:33:23 +0300, Lazarus 101 wrote:
> > Hi guys, i'm working on an Android app and using sqlite to store some
> data
> > and i need some help with a query.
> >
> > I have the following table structure:
> >
> > FILES
> > fi
On Tue, Jun 28, 2011 at 5:48 PM, Simon Slavin wrote:
>
> On 28 Jun 2011, at 3:33pm, Lazarus 101 wrote:
>
> > FILES
> > file_id INTEGER NOT NULL,
> > name TEXT
>
> I assume that SQLite has identified 'file_id' as its own 'rowid' column and
> made in INDEX for it.
>
it's also marked as primary key
On Tue, Jun 28, 2011 at 17:33:23 +0300, Lazarus 101 wrote:
> Hi guys, i'm working on an Android app and using sqlite to store some data
> and i need some help with a query.
>
> I have the following table structure:
>
> FILES
> file_id INTEGER NOT NULL,
Do file_ids repea
On 28 Jun 2011, at 3:33pm, Lazarus 101 wrote:
> FILES
> file_id INTEGER NOT NULL,
> name TEXT
I assume that SQLite has identified 'file_id' as its own 'rowid' column and
made in INDEX for it.
> DATA
> file_id INTEGER REFERENCES files(resource_id) ON DELETE CASCADE,
> data_type TEXT,
> value TE
> This has to run as fast as possible. A left join between these tables is too
> slow, for 10.000 entries it takes around 15 seconds just to navigate through
> the cursor, if I add a where clause selecting only one kind of data then it
> reduces to less than 5 seconds which is acceptable.
What kin
Hi guys, i'm working on an Android app and using sqlite to store some data
and i need some help with a query.
I have the following table structure:
FILES
file_id INTEGER NOT NULL,
name TEXT
DATA
file_id INTEGER REFERENCES files(resource_id) ON DELETE CASCADE,
data_type TEXT,
value TEXT
data_typ
-boun...@sqlite.org] on
behalf of Singh, Manpreet [manpreet.sing...@ca.com]
Sent: Tuesday, June 21, 2011 2:55 AM
To: sqlite-...@sqlite.org; sqlite-users@sqlite.org
Subject: EXT :Re: [sqlite] Help sqlite database corruption
Anyone with clues to the problem "malformed disk image"?
Anyone with clues to the problem "malformed disk image"?
From: Singh, Manpreet
Sent: Tuesday, May 24, 2011 3:10 PM
To: sqlite-...@sqlite.org; d...@hwaci.com; sqlite-users@sqlite.org
Cc: Singh, Abhijeet; Singh, Satbeer; Prasanth, Neelapalem
Subject: RE: Help sqlite database corruption
Hello
"Mr. Puneet Kishor" wrote...
>
> On Jun 19, 2011, at 10:04 PM, jose isaias cabrera wrote:
>
>> "Mr. Puneet Kishor" wrote...
>>>
>>> On Jun 19, 2011, at 5:12 PM, jose isaias cabrera wrote:
>>>
"Nico Williams" wrote...
> On Fri, Jun 17, 2011 at 5:05 PM, Mr. Puneet Kishor
>
On Jun 19, 2011, at 10:04 PM, jose isaias cabrera wrote:
> "Mr. Puneet Kishor" wrote...
>>
>> On Jun 19, 2011, at 5:12 PM, jose isaias cabrera wrote:
>>
>>>
>>> "Nico Williams" wrote...
>>>
On Fri, Jun 17, 2011 at 5:05 PM, Mr. Puneet Kishor
wrote:
> The above is not SQL. You ca
"Mr. Puneet Kishor" wrote...
>
> On Jun 19, 2011, at 5:12 PM, jose isaias cabrera wrote:
>
>>
>> "Nico Williams" wrote...
>>
>>> On Fri, Jun 17, 2011 at 5:05 PM, Mr. Puneet Kishor
>>> wrote:
The above is not SQL. You can't have a SQL statement begin with CASE.
SQL
statements can on
On Jun 19, 2011, at 5:12 PM, jose isaias cabrera wrote:
>
> "Nico Williams" wrote...
>
>> On Fri, Jun 17, 2011 at 5:05 PM, Mr. Puneet Kishor
>> wrote:
>>> The above is not SQL. You can't have a SQL statement begin with CASE. SQL
>>> statements can only begin with either SELECT or UPDATE or C
"Nico Williams" wrote...
> On Fri, Jun 17, 2011 at 5:05 PM, Mr. Puneet Kishor
> wrote:
>> The above is not SQL. You can't have a SQL statement begin with CASE. SQL
>> statements can only begin with either SELECT or UPDATE or CREATE or
>> DELETE or ALTER, etc. CASE is an expression, and has to
On Jun 19, 2011, at 12:06 PM, looki wrote:
> and a table 'foods' which also holds a 'time' column and i now want to know
> all entries in foods which time is between one of the times in t.
for example:
select foods.id
fromfoods
where exists (select 1 from symptoms where foods.time between
Hi, i have a select stamement which holds two dates, something like:
2011-12-31 09:002011-12-30 21:00
2011-12-31 18:002011-12-31 06:00
...
let me call this t.
and a table 'foods' which also holds a 'time' column and i now want to know
all entries in foods which t
On Fri, Jun 17, 2011 at 5:05 PM, Mr. Puneet Kishor wrote:
> The above is not SQL. You can't have a SQL statement begin with CASE. SQL
> statements can only begin with either SELECT or UPDATE or CREATE or DELETE or
> ALTER, etc. CASE is an expression, and has to be a replacement for a column.
>
On Jun 17, 2011, at 4:56 PM, jose isaias cabrera wrote:
> CASE (SELECT round(sum(Xtra8),2) FROM LSOpenJobs
> WHERE subProjID = 9144 AND lang = 'ES-LA'
> AND PSubClass != 'Portal-Fee')
>
> WHEN < 5000 THEN
>UPDATE LSOpenJobs SET ProjFund = (SELECT round(sum(ProjFund)
Greetings.
I have used CASE before, but for simple codes and it works. However, I am
trying to break down some calculations and it-s not working. I am getting,
...>
...> END;
Error: near "CASE": syntax error
sqlite> COMMIT TRANSACTION;
Error: cannot commit - no transaction is active
sql
I've only used the xerial driver recently and haven't checked for the
error code on exception. It does come with source, so you may be able
to walk into the code to see how the value is set/retrieved.
___
sqlite-users mailing list
sqlite-users@sqlite.o
Any one with java/JDBC experience please have a look at the snippet and
let me know why I am not able to get the exact errorCode.
Thanks
Sridhar
On 08-06-2011 21:23, Martin.Engelschalk wrote:
> Hi,
>
> The important information is that you seem to use a JDBC driver.
> Maybe someone with Java/JDBC
I am on windows 7 and this is my test code
try
{
Statement stat = mconn.createStatement();
stat.execute(sql);
resultSet = stat.getResultSet();
mconn.close();
break;
}
catch (SQLException e)
{
Hello Sridhar,
please tell us more: what interface are you using? what OS?
SQLException is not a part of the sqlite library, so obviously you use
an additional layer.
Martin
Am 08.06.2011 16:44, schrieb Sridhar Polavarapu:
> Appreciate if anyone can help me.
>
> Thanks
> Sridhar
>
> On 08-06-20
Appreciate if anyone can help me.
Thanks
Sridhar
On 08-06-2011 16:16, Sridhar Polavarapu wrote:
> Hi
>
> I am using getErrorCode() of SQLException to see if the exception is
> due to any database lock. I all the time get Errorcode to be 0 even
> though the getMessage is returning different mess
Hi
I am using getErrorCode() of SQLException to see if the exception is due
to any database lock. I all the time get Errorcode to be 0 even though
the getMessage is returning different messages. Can anyone let me know
if there is some thing that i need to do to get the error codes correctly ?
Changing the driver helped in improving the performance drastically.
Sridhar
On 03-06-2011 20:05, Sridhar Polavarapu wrote:
> This is not any update or insert statement. This is just a select
> statement. Will that help if i change the driver ? I am currently
> using sqlitejdbc-v056.jar
>
> Tha
Thanks Pavel for your replies. The reason looks to be the driver I am
using to connect sqlite. I have changed it to use the driver from xerial
and it is working fine now.
Sridhar
On 03-06-2011 12:00, Sridhar Polavarapu wrote:
> Here is the code of my TestStatusDate
>
> public static void main(S
This is not any update or insert statement. This is just a select
statement. Will that help if i change the driver ? I am currently using
sqlitejdbc-v056.jar
Thanks
Sridhar
On 03-06-2011 18:59, Sridhar Polavarapu wrote:
> Hi
>
> One of my sqlite query executes faster in sqlite manager( firefox
Here is the code of my TestStatusDate
public static void main(String[] args) throws Exception
{
String jobQuery = "SELECT j.jobId, c.channelName ,
datetime(j.jobCreateDate, 'localtime'), j.jobStatus, j.jobQuality,
j.jobCompleteDate FROM Job j, Channel c where c.channelId =
j.jobCh
And your TestStatusDate code is?
I'd bet now that the problem is in the way you get that time from
jdbc. It can convert the time back to utc for you, although it looks a
little strange that it converts one date and doesn't convert other
one...
Pavel
On Thu, Jun 2, 2011 at 11:52 AM, Sridhar Pol
I am on Windows 7 64 bit; I have tested the program as you mentioned,
the good point here was the issue still appears please find logs . Let
me know if you infer anything from below.
C:\development\SignalCoreClient\test\com\Rimage\Starfish\AutomatedTests>java
TestStatusDate
Today's Locale is en
> I have verified my locale and default time zone in the same program.The
> values are correct and it is not UTC timezone. Any help appreciated.
How did you do that? What OS are you running it on?
Can you extract the code accessing SQLite database from your program
and create a mini-program that d
I have verified my locale and default time zone in the same program.The
values are correct and it is not UTC timezone. Any help appreciated.
Sridhar
On 02-06-2011 19:34, Sridhar Polavarapu wrote:
> The returned value is displayed to the user. We are not storing back
> the returned column.
>
> S
The returned value is displayed to the user. We are not storing back the
returned column.
Sridhar
On 02-06-2011 19:28, Pavel Ivanov wrote:
>> but is returning the value stored in the database when executed
>> as a part of a java program. Can anyone help me if I am missing
>> something here ?
>
> but is returning the value stored in the database when executed
> as a part of a java program. Can anyone help me if I am missing
> something here ?
Looks like your java program runs with a different locale than SQLite
Manager. I'm not sure why it thinks that you are in a UTC timezone.
Maybe th
Hi
I am preparing a string sql query as follows
String jobQuery = "SELECT j.jobId, c.channelName ,
datetime(j.jobCreateDate,'localtime') as jobCreateDate, j.jobStatus,
CASE WHEN j.jobQuality='md' THEN 'Medium' WHEN j.jobQuality='hi' THEN
'High' WHEN j.jobQuality='lo' THEN 'Low' ELSE 'Unsp
On Tue, May 24, 2011 at 5:39 AM, Singh, Manpreet wrote:
> Hello,
>
>
>
> Resending with some more finding any help would be appreciated. One of
> the tables in the database is getting corrupted.
>
http://www.sqlite.org/howtocorrupt.html
http://www.sqlite.org/lockingv3.html#how_to_corrupt
http://w
Hello,
Resending with some more finding any help would be appreciated. One of
the tables in the database is getting corrupted.
1. Sqlite>select count(*) from $table_name
..
7981508|35001|284
7981509|35002|284
7981510|35003|284
7981511|35004|284
SQL error: database disk image is malfo
Hi!!
I'm studying databases in my college and I'd like to implement an algorithm
to SQLite... since I'm not familiar with C, could you guys help me a little?
For now, I just need to, every time the VDBE enters in OP_COLUMN, get the
column value and put it to a string variable, that's all !
Thank
> drh on Tue Apr 12 22:23:38
>
>Set your breakpoint on the function winAccess if you want to try to debug
>this.
Which I cannot do since attaching debugger masks the problem.
Now I am really confused. I have modified winAccess to simply return the
result of GetFileAttributesExW() if th
>drh Tue Apr 12 22:23:38 GMT 2011
>
>Set your breakpoint on the function winAccess if you want to try to debug
>this.
If only it were that easy. Its intermittent and attaching a debugger seems to
mask the problem. It's never been seen with only a single process and occurs
more when there are
On Tue, Apr 12, 2011 at 6:06 PM, jeff archer wrote:
> I have a process which analyzes an image then writes results to database.
> (sqlite 3.7.4)
> When I run multiple of these in parallel, each on its own image but all on
> the
> same database, and all on same machine (Windows 7) I get an error f
I have a process which analyzes an image then writes results to database.
(sqlite 3.7.4)
When I run multiple of these in parallel, each on its own image but all on the
same database, and all on same machine (Windows 7) I get an error from
sqlite3_step() when attempting to execute "BEGIN IMMEDIA
On 5 Apr 2011, at 8:47pm, Guilherme Batista wrote:
> Yes it's true.
> But I'm not trying to improve the SQLite performance. I'm just studying the
> query optimization of databases in general, and a better way to optimize if
> the tables do not have indexes and if the query is complex and deals wi
On 5 Apr 2011, at 6:54pm, Guilherme Batista wrote:
> let's say I get the number of rows from the first table scan of the
> execution. I would compare it with the number of rows defined for the table
> in sqlite_stat1 (I ran the analyze once, and there are no index in my
> tables). If the differen
On 4 Apr 2011, at 11:53am, thilo wrote:
> On 4/4/2011 2:05 AM, Guilherme Bamepe wrote:
>> Hi!
>>
>> I'm new in SQLite, and I'm studying it to do a work in my college,
>> and would be helpful if I get the SQLite to print, while executing
>> the sql, after each table scan or join, the name of the
On 4/4/2011 2:05 AM, Guilherme Bamepe wrote:
> Hi!
>
> I'm new in SQLite, and I'm studying it to do a work in my college,
> and would be helpful if I get the SQLite to print, while executing
> the sql, after each table scan or join, the name of the table and
> number of rows that are going to the n
Hi!
I'm new in SQLite, and I'm studying it to do a work in my college, and would be
helpful if I get the SQLite to print, while executing the sql, after each table
scan or join, the name of the table and number of rows that are going to the
next operator...
for example.. the following sql:
sele
On 21 Mar 2011, at 5:46pm, Enrico Thierbach wrote:
> On 21.03.2011, at 06:34, Simon Slavin wrote:
>
>> Suppose you have a TABLE employees with ten thousand rows and no indexes,
>> and you execute
>>
>> SELECT id,firstname,surname FROM employees WHERE firstname='Guilherme' AND
>> age=46
>>
>>
Hi Simon,
I just stumbled about this post.
>
On 21.03.2011, at 06:34, Simon Slavin wrote:
>
> Suppose you have a TABLE employees with ten thousand rows and no indexes, and
> you execute
>
> SELECT id,firstname,surname FROM employees WHERE firstname='Guilherme' AND
> age=46
>
> The quer
On 21 Mar 2011, at 2:17pm, Guilherme Batista wrote:
> So, in general, the the ANALYZE is not advantageous only if I have just 1
> index in my table, in that case the sqlite never use the ANALYZE...
If you have exactly one INDEX which looks helpful for the query, SQLite will
just use that. It w
On Mon, Mar 21, 2011 at 9:48 AM, Simon Slavin wrote:
>
> Note that if you provide good INDEXes as you should, then the results of
> ANALYZE will never be used at all because the query finder will find it has
> an excellent INDEX before it even starts trying to guess how to access the
> data by a
On 21 Mar 2011, at 12:12pm, Guilherme Batista wrote:
> 1) So if I run ANALYZE, it will gather statistics about all columns in all
> tables from the database?
You can add parameters to the end of the command:
http://www.sqlite.org/lang_analyze.html
but without them it will analyze everything, j
Thanks for the big and helpful explanation Simon! My changes in my study,
theoretically, would improve the performance just of big and complex
queries, so it's not my intention improve the sqlite, I want just study the
effects..
Just a few more questions if anyone can help me
1) So if I run ANALY
On 21 Mar 2011, at 3:33am, Guilherme Batista wrote:
> I'll implement some changes in the sqlite query optimization for study
> purpose... before I start studying the code please help me understand the
> basic idea...
>
> 1) The basic idea of optimization is to optmize and then execute. Where in
Hi!!
I'll implement some changes in the sqlite query optimization for study
purpose... before I start studying the code please help me understand the
basic idea...
1) The basic idea of optimization is to optmize and then execute. Where in
the code the plan is built and where it is executed?
2) I
Thanks a lot Simon and Robert.
--
Marco Bambini
http://www.sqlabs.com
On Mar 4, 2011, at 11:50 AM, Robert Hairgrove wrote:
> On Fri, 2011-03-04 at 11:10 +0100, Marco Bambini wrote:
>> Hello,
>> I have a table defined as:
>> CREATE TABLE MKProperties (id INTEGER PRIMARY KEY AUTOINCREMENT, obj
On Fri, 2011-03-04 at 11:10 +0100, Marco Bambini wrote:
> Hello,
> I have a table defined as:
> CREATE TABLE MKProperties (id INTEGER PRIMARY KEY AUTOINCREMENT, obj_id
> INTEGER, prop_key TEXT, prop_value TEXT, UNIQUE(obj_id, prop_key))
>
> In that table there some rows like:
> obj_idprop
On 4 March 2011 10:10, Marco Bambini wrote:
> Hello,
> I have a table defined as:
> CREATE TABLE MKProperties (id INTEGER PRIMARY KEY AUTOINCREMENT, obj_id
> INTEGER, prop_key TEXT, prop_value TEXT, UNIQUE(obj_id, prop_key))
>
> In that table there some rows like:
> obj_id prop_key prop_v
Hello,
I have a table defined as:
CREATE TABLE MKProperties (id INTEGER PRIMARY KEY AUTOINCREMENT, obj_id
INTEGER, prop_key TEXT, prop_value TEXT, UNIQUE(obj_id, prop_key))
In that table there some rows like:
obj_id prop_keyprop_value
1 PARENTID0
1 RESOURCE_ORDER 0
2
>> for example, i insert String filled with gbk bytes and set the String
>> charset 'UTF-8'
>
>What do you mean, "set String charset"? Set how and where?
>--
>Igor Tandetnik
Hi
The String on java side is ok.
> for example, i insert String filled with gbk bytes and set the String charset
> 'UTF-
On 3/1/2011 9:49 PM, 陈强 wrote:
> How did the sqlite.exe work if insert data through it?
> insert gbk string?
Most likely. I wouldn't be surprised if these strings came out wrong on
Java side, though.
> can I insert data like it ?
Probably, but I don't think you really want to. It'll be a strugg
>Try running this command before starting sqlite.exe, but I'm not sure
>this will help:
>
>mode con cp select=65001
Hi
I tried to change the charset of console to utf-8 before, but it didn't work
correctly.
Because the app will besent to custom, so i want to make sqlite.exe display
correctly.
On 3/1/2011 8:52 PM, 陈强 wrote:
> But if i want to make the gbk console show String correctly, what should i do?
Try running this command before starting sqlite.exe, but I'm not sure
this will help:
mode con cp select=65001
There also exists a number of nice graphical tools for working with
SQ
At 2011-03-02 09:17:48,"Igor Tandetnik" wrote:
>On 3/1/2011 8:05 PM, 陈强 wrote:
>> At 2011-03-01 20:56:49,"Igor Tandetnik" wrote:
>>
>>> 陈强 wrote:
Why is the Chinese i Selected from SQLIte.exe and jdbc is not different.
The Chinese from JDBC(rs.getString(index)) is normal but
th
On 3/1/2011 8:05 PM, 陈强 wrote:
> At 2011-03-01 20:56:49,"Igor Tandetnik" wrote:
>
>> 陈强 wrote:
>>> Why is the Chinese i Selected from SQLIte.exe and jdbc is not different.
>>> The Chinese from JDBC(rs.getString(index)) is normal but
>>> the Chinese from Sqlite.exe (Select data) is Garbled, my en
At 2011-03-01 20:56:49,"Igor Tandetnik" wrote:
>陈强 wrote:
>> Why is the Chinese i Selected from SQLIte.exe and jdbc is not different. The
>> Chinese from JDBC(rs.getString(index)) is normal but
>> the Chinese from Sqlite.exe (Select data) is Garbled, my environment as
>> list:
>
>Console wind
陈强 wrote:
> Why is the Chinese i Selected from SQLIte.exe and jdbc is not different. The
> Chinese from JDBC(rs.getString(index)) is normal but
> the Chinese from Sqlite.exe (Select data) is Garbled, my environment as list:
Console window doesn't know UTF-8. The strings are fine, but the consol
Dear All:
I have a problem toDisturb your.
Why is the Chinese i Selected from SQLIte.exe and jdbc is not different. The
Chinese from JDBC(rs.getString(index)) is normal but the Chinese from
Sqlite.exe (Select data) is Garbled, my environment as list:
Server os: 2003 Simple Chinese
Server o
>Date: Fri, 18 Feb 2011 07:34:06 -0800
>From: Jim Morris
>
>A correlated sub-query might work for you.
>
>SELECT
>[Analyzers].[AnalyzerID]
>, [Analyzers].[Name] AS [Analyzer]
>, [Analysis].[AnalysisID]
>, [Analysis].[ScanID]
>, [Analysis].[Timestamp]
>, [Analysis].[EndTime]
A correlated sub-query might work for you.
SELECT
[Analyzers].[AnalyzerID]
, [Analyzers].[Name] AS [Analyzer]
, [Analysis].[AnalysisID]
, [Analysis].[ScanID]
, [Analysis].[Timestamp]
, [Analysis].[EndTime]
, (SELECT COUNT(*) AS NumDefects FRO
Here is my existing schema. I would like to change this and remove the
"NumDefects" from the [Analysis] table.
To do this I need to update the [vwAnalysis] view to determine the number of
defects from the [Defects] table by the AnalysisID.
I can't seem to get the right select for the new version
Hi,
I am using an in-memory dbase in a multi-threaded application and have
the following two questions:
I create dbase connections by each thread using the API:
{
Sqlite3 *db = NULL;
Sqlite3_open(":memory:", &db);
When I try to use sqlite3_exec( ) I get segmentation faults.
>
> From: sqlite-users-boun...@sqlite.org on behalf of Marcus Grimm
> Sent: Mon 1/17/2011 11:18 AM
> To: General Discussion of SQLite Database
> Subject: EXTERNAL:Re: [sqlite] Help on DELETE FROM...
>
>
>
>
> On 17.01.2011 17:26, Black, Michael (IS) wrote:
>> I ca
f SQLite Database
Subject: EXTERNAL:Re: [sqlite] Help on DELETE FROM...
On 17.01.2011 17:26, Black, Michael (IS) wrote:
> I came up with the logical opposite which I think does what you want
>
> select a.id from thi as a where a.id in (select thi.id from thi where
> a.userid=thi.userid order
...> (select thi.id from thi where a.userid=thi.userid
> ...> order by timestamp limit 100 offset 10);
> 10|20|10|0
> 11|21|10|0
> 12|22|10|0
> 23|31|20|0
> 24|32|20|0
> 25|33|20|0
>
>
> Michael D. Black
> Senior Scientist
> Advanced Analytics Dire
Igor Tandetnik wrote:
> delete from THI where ID not in (
>select ID from THI t2 where t2.UserID = UserId
>order by t2.TimeStamp desc limit 10);
Correction:
delete from THI where ID not in (
select t2.ID from THI t2 where t2.UserID = THI.UserId
order by t2.TimeStamp desc limit 10
Black, Michael (IS) wrote:
> The "NOT IN" approach doesn't work..here's sample data using select rather
> than delete to show the result.
>
> sqlite> select * from THI where ID not in (
>...> select ID from THI t2 where t2.UserID = UserId
>...> order by t2.TimeStamp desc limit 10);
This
torate
> Northrop Grumman Information Systems
>
>
>
>
> From: sqlite-users-boun...@sqlite.org on behalf of Marcus Grimm
> Sent: Mon 1/17/2011 10:24 AM
> To: General Discussion of SQLite Database
> Subject: EXTERNAL:Re: [sqlite] Help on DELETE FROM
|0
23|31|20|0
24|32|20|0
25|33|20|0
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Northrop Grumman Information Systems
From: sqlite-users-boun...@sqlite.org on behalf of Igor Tandetnik
Sent: Mon 1/17/2011 10:57 AM
To: sqlite-users@sqlite.org
S
401 - 500 of 880 matches
Mail list logo