, Twitter and LinkedIn!
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Joe Mistachkin
Sent: Saturday, August 09, 2014 9:54 AM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] Need help on SQLite In-Memory
On Mon, Aug 11, 2014 at 9:19 PM, Nick Bao hongfeng@avepoint.com wrote:
Thanks, Joe!
But it did not work for me.
Still got the error:
System.ArgumentException: Invalid ConnectionString format for parameter
FullUri
Are you using System.Data.SQLite version *1.0.81.0 ?*
--
--
Hi dear sqlite users,
I am using SQLite In-Memory Database in my application.
My application is written in C#.
I am trying to create an In-Memory Database that can be opened by multiple
connections as descripted in this link.
What it is the right format of connection string in this
Try this:
SQLiteConnection connection = new SQLiteConnection(
FullUri=file::memory:?cache=shared;);
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
Hi,
I am new to sqlite and my objective is to run the sqlite tests on build
where sqlite got integrated and have to use my own ZFS for my test.
I have downloaded the source where tests are available but need help on how
to take them and run against sqlite which is integrated in our code.
Can
Database
Subject: [sqlite] Need help with query
Hi all,
given
CREATE TABLE masterlanguages (
ID integer primary key autoincrement,
Key1varchar not null,
Key2varchar not null,
ISOCode varchar not null,
Description varchar not null,
MaxCharsinteger default 0
Hi all,
given
CREATE TABLE masterlanguages (
ID integer primary key autoincrement,
Key1varchar not null,
Key2varchar not null,
ISOCode varchar not null,
Description varchar not null,
MaxCharsinteger default 0
);
insert into masterlanguages values
like this?
sqlite SELECT t1.key1, t1.key2, t2.description FROM MASTERLANGUAGES as t1,
MASTERLANGUAGES as t2 WHERE t1.ISOCode = 'DEU' and t2.ISOCode = 'ENG' and
t1.key1 = t2.key1 and t1.key2 = t2.key2;
FORM1|SAVE_BUTTON|Save
FORM1|HELP_BUTTON|Help
Sorry if my try is wrong.
2013/1/15 Kai Peters
On Tue, 15 Jan 2013 14:57:42 +0900, Yongil Jang wrote:
SELECT t1.key1, t1.key2, t2.description FROM MASTERLANGUAGES as t1,
MASTERLANGUAGES as t2 WHERE
t1.ISOCode = 'DEU' and t2.ISOCode = 'ENG' and t1.key1 = t2.key1 and t1.key2 =
t2.key2;
that is very close - just needed to add
I am not sure if this is the correct mailing list to ask this question. If
not, please redirect me to the correct forum.
I am using Node js with node-sqlite extension. I tried to use the commented
out caode in node-sqlite to add an update callback. On running the code I am
getting a
http://www.sqlite.org/cvstrac/wiki?p=SqliteNetwork
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Please take a look at cubeSQL:
http://www.sqlabs.com/cubesql.php
--
Marco Bambini
http://www.sqlabs.com
On Aug 4, 2011, at 7:15 PM, Vinoth raj wrote:
Dear SQLite users,
I have been using SQlite database since three years. Suddenly I have a
requirement for client/server support for
I'm reading about:
http://www.atensoft.net/dev/sqlite3.php
http://www.sqliteconcepts.org/CS_index.html
http://www.sqlitening.com
http://www.codeproject.com/KB/database/SQLite_Server.aspx
http://www.realsoftware.com/realserver/
http://sqliteserver.xhost.ro/index.html
http://users.libero.it/irwin/
Dear SQLite users,
I have been using SQlite database since three years. Suddenly I have a
requirement for client/server support for my project.
So, the requirement is to save sqlite database on a server from a C++
application.
I explored the SQLite API with no success. Even numeours queries on
On Thu, Aug 4, 2011 at 7:15 PM, Vinoth raj vinoth@gmail.com wrote:
It would be a great help if you can shed some light on my problem. Is it
possible at all to save SQLite database on a server?
http://www.sqlite.org/whentouse.html
--
- stephan beal
On Thu, Aug 4, 2011 at 7:50 PM, Stephan Beal sgb...@googlemail.com wrote:
http://www.sqlite.org/whentouse.html
Specifically: 2nd section, 1st list item.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
On 4 Aug 2011, at 18:15, Vinoth raj wrote:
I have been using SQlite database since three years. Suddenly I have a
requirement for client/server support for my project.
So, the requirement is to save sqlite database on a server from a C++
application.
We use sqlite in a client/server
On Thu, Aug 4, 2011 at 12:52 PM, Stephan Beal sgb...@googlemail.com wrote:
On Thu, Aug 4, 2011 at 7:50 PM, Stephan Beal sgb...@googlemail.com wrote:
http://www.sqlite.org/whentouse.html
Specifically: 2nd section, 1st list item.
It may depend on the usage. After reading about the possible
2011/8/4 Vinoth raj vinoth@gmail.com:
So, the requirement is to save sqlite database on a server from a C++
application.
There are a lot of ways to copy file to server. SQLite database is single file.
And you can send SQL dump. And you can send diff of SQL dump.
And you can export your data
Hi,
i have a table which holds dates like
'2011-12-31 09:00' and i now want to write a query which gives me 2 columns.
First column holds the givin datetime from my table and the second column
should show the datetime from first row but 12 hours before. for example:
'2011-12-31 09:00'
NG Information Systems
Advanced Analytics Directorate
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of looki [looki1...@yahoo.com]
Sent: Friday, June 17, 2011 6:10 AM
To: sqlite-users@sqlite.org
Subject: EXT :[sqlite] need help
On 17/06/2011 12:10, looki wrote:
First column holds the givin datetime from my table and the second column
should show the datetime from first row but 12 hours before. for example:
'2011-12-31 09:00' '2011-12-30 21:00'
'2011-12-31 12:15' '2011-12-30 00:15'
...
looks simple but datetime
Black, Michael (IS) michael.bla...@ngc.com wrote:
sqlite create table t(d date);
sqlite insert into t values('2011-12-31 09:00');
sqlite insert into t values('2011-12-31 12:15');
sqlite select d,substr(datetime(d,'-12 hours'),1,16) from t;
2011-12-31 09:00|2011-12-30 21:00
2011-12-31
To start, I am not an SQLite user. i haven't used a database for
many years and have never used an SQL database.
I am on a MS Windows system. I have an application that uses SQLite as a
database for storing its information.
The name of the file containing the database is a.sqlite.
don wish don_u_w...@yahoo.com wrote:
Thus, if the Subject column does not contain the string last, I
want to replace the Value with an integer, say 5.
Also, if the Subject column contains the string current, I want
to replace the Value witn an integer, say 3.
What should happen in the
Hello.. I just joined today and can't seem to figure out how to start a
new thread... Can someone please enlighten me?
Regards,
Rolf
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On May 3, 2011, at 6:04 PM, Rolf Marsh wrote:
Hello.. I just joined today and can't seem to figure out how to start a
new thread... Can someone please enlighten me?
You just did.
Just post a question with the subject line indicating clearly what is bothering
you and take a seat. The
Hello,
I am very new database development and sqlite. I have a requirement
where I want to restrict the size of my integer primary key to 3 bytes.
In my database, entries will be added and removed very frequently. So If the
primary key limit of 3 bytes is reached, it should try to reuse the
Balasubramani Vivekkanandan bvivekkanan...@mvista.com wrote:
I am very new database development and sqlite. I have a requirement
where I want to restrict the size of my integer primary key to 3 bytes.
In my database, entries will be added and removed very frequently. So If the
primary key
Igor Tandetnik itandetnik@... writes:
Balasubramani Vivekkanandan bvivekkanandan@... wrote:
I am very new database development and sqlite. I have a requirement
where I want to restrict the size of my integer primary key to 3 bytes.
In my database, entries will be added and removed
Igor Tandetnik itandetnik@... writes:
Balasubramani Vivekkanandan bvivekkanandan@... wrote:
I am very new database development and sqlite. I have a requirement
where I want to restrict the size of my integer primary key to 3 bytes.
In my database, entries will be added and removed
Looking at the documentation for the latest version I think I understand that I
must define indexes for all foreign keys, manually, with UNIQUE as described in
the documentation. If I don't then the database will give me an immediate or
deferred error. These Foreign Key indexes are NOT
On 28 Feb 2011, at 9:41am, rf rf wrote:
Looking at the documentation for the latest version I think I understand that
I must define indexes for all foreign keys, manually, with UNIQUE as
described in the documentation. If I don't then the database will give me an
immediate or deferred
Anyone please give me an advise,
when i try the query below,
CREATE TABLE Test] (no INTEGER),
sqlite gives me the 'unrecognized token: ] ' result.
Is there a way to escape the ']' character in the identifier?
Thanks,
hyunmi.
___
sqlite-users mailing
On 7 Dec 2010, at 08:49, 곽현미 wrote:
Anyone please give me an advise,
when i try the query below,
CREATE TABLE Test] (no INTEGER),
sqlite gives me the 'unrecognized token: ] ' result.
Is there a way to escape the ']' character in the identifier?
Use the right quotes, single not
Quoth Philip Graham Willoughby phil.willoug...@strawberrycat.com, on
2010-12-07 10:57:45 +:
Use the right quotes, single not double; this works for me:
create table 'test]' (no integer);
Yagh! Please don't call those the 'right' quotes in this case.
Quoth
On Tue, Dec 7, 2010 at 3:49 AM, 곽현미 jinsoch...@gmail.com wrote:
Anyone please give me an advise,
when i try the query below,
CREATE TABLE Test] (no INTEGER),
sqlite gives me the 'unrecognized token: ] ' result.
It works when I try it. What version of SQLite are you using? Are you
using
Nice :)
To: sqlite-users@sqlite.org
From: itandet...@mvps.org
Date: Sat, 25 Sep 2010 10:21:18 -0400
Subject: Re: [sqlite] Need help with self-join (I think)
Kristoffer Danielsson kristoffer.daniels...@live.se wrote:
From: oliver@web.de
a little mistake - here's the correction
increases the chances of doing mistakes.
Date: Sat, 25 Sep 2010 02:47:05 +0200
From: oliver@web.de
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Need help with self-join (I think)
Am 25.09.2010 01:47, schrieb Kristoffer Danielsson:
[...]
Because, given a certain algorithm
Kristoffer Danielsson kristoffer.daniels...@live.se wrote:
From: oliver@web.de
a little mistake - here's the correction:
SELECT DISTINCT t.Year, b.Name,
(SELECT SomeValue FROM Test INNER JOIN Test2 WHERE Year = t.Year AND Name =
b.Name) AS SomeValue
FROM Test t
CROSS JOIN (SELECT
Igor Tandetnik itandet...@... writes:
[..]
See how you like this one:
select *
from (select distinct year from Test) as AllYears
join (select distinct name from Test) as AllNames
left join Test t on (t.year=AllYears.Year and t.name=AllNames.name)
left join Test2 t2 on
Hi,
I have an interesting SQL problem where I want certain rows to always be
represented. It feels like a self-join, but I'm not sure. Please help!
Create a database as follows:
CREATE TABLE Test (TestID
On Sat, Sep 25, 2010 at 01:01:36AM +0200, Kristoffer Danielsson wrote:
CREATE TABLE Test (TestID INTEGER PRIMARY KEY, Year INT NOT NULL, Name TEXT
NOT NULL);
INSERT INTO Test (Year, Name) VALUES (2007, 'A');
INSERT INTO Test (Year, Name) VALUES (2007, 'B');
INSERT INTO Test (Year, Name)
easier if each value combination is represented in the returned row set.
Perhaps a UNION is needed for this type of query?
Date: Fri, 24 Sep 2010 18:17:51 -0500
From: nicolas.willi...@oracle.com
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Need help with self-join (I think
Kristoffer Danielsson kristoffer.daniels...@... writes:
SELECT DISTINCT t.Year, b.Name,
CASE
WHEN (SELECT TestID FROM Test WHERE Year = t.Year AND Name = b.Name) IS NULL
THEN NULL
ELSE (SELECT SomeValue FROM Test2)
END AS SomeValue
FROM Test t
CROSS JOIN (SELECT DISTINCT Name FROM Test) b
;
Neat! Many thanks :)
Putting this logic together with my original query will be an interesting
challenge, hehe. Do you believe this is the best solution?
Chris
To: sqlite-users@sqlite.org
From: oliver@web.de
Date: Fri, 24 Sep 2010 23:47:59 +
Subject: Re: [sqlite] Need help
sry,
a little mistake - here's the correction:
SELECT DISTINCT t.Year, b.Name,
(SELECT SomeValue FROM Test INNER JOIN Test2 WHERE Year = t.Year AND Name =
b.Name) AS SomeValue
FROM Test t
CROSS JOIN (SELECT DISTINCT Name FROM Test) b
;
(results don't differ - in this case!)
Oliver
Ah, this one's easier to follow. What do you mean by in this case? What was
the condition that made it possible to remove the rest?
Again, thanks!
To: sqlite-users@sqlite.org
From: oliver@web.de
Date: Sat, 25 Sep 2010 00:05:11 +
Subject: Re: [sqlite] Need help with self-join (I
) WHERE Year = t.Year
AND Name =
b.Name) AS SomeValue
FROM Test t
CROSS JOIN (SELECT DISTINCT Name FROM Test) b
;
possible to remove the rest?
Again, thanks!
To: sqlite-us...@...
From: oliver@...
Date: Sat, 25 Sep 2010 00:05:11 +
Subject: Re: [sqlite] Need help with self-join
Yeah. USING is good to have :)
And yes, 123 might very well be a random number. I should have made that clear!
To: sqlite-users@sqlite.org
From: oliver@web.de
Date: Sat, 25 Sep 2010 00:19:44 +
Subject: Re: [sqlite] Need help with self-join (I think)
Kristoffer Danielsson
Am 25.09.2010 01:47, schrieb Kristoffer Danielsson:
[...]
Because, given a certain algorithm, generating statistics will become a lot
easier if each value combination is represented in the returned row set.
really? NULL means there are no values present or there are unknown
values -
Thanks all for your input.
Thanks to your feedback I have been able to advance quite a long way in my
studies... And yes my big problem is in fact understanding C++ (still in
learning phase).
4) I will check if this option is avaialable too on the express edition.
5) I did try to install
Hi all,
I am trying to understand Sqlite and to make thing worse I am also learning
C++. You will not be surprised that I find it really hard to understand the
C++ example on the web. Can someone guide me to digest this? If you can
explain please do so by extrapolating since I am a total
Fabrice NA a écrit :
Hi,
In sqlite3_exec, you pass a function pointer (callback).
Sqlite call that function with each row of data
Best wishes
Noël
Hi all,
I am trying to understand Sqlite and to make thing worse I am also learning
C++. You will not be surprised that I find it really hard
it helps,
Samuel
From: noel frankinet noel.franki...@skynet.be
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Sent: Tue, January 19, 2010 9:18:06 AM
Subject: Re: [sqlite] Need help understanding the basic of C++/sqlite
Fabrice NA a écrit :
Hi
2010/1/19 Fabrice NA pazou...@gmail.com:
Hi all,
I am trying to understand Sqlite and to make thing worse I am also learning
C++. You will not be surprised that I find it really hard to understand the
C++ example on the web. Can someone guide me to digest this? If you can
explain please do
Hi all!
I have three tables, one containing IP addresses as integers, lets call
it 'base'.
A second table containing IP ranges and the country code the range
belongs to. Lets call this 'IPtoCC' with the fields IPFrom and IPTo as
integers and CC as text.
Then a third, 'Exclude', containing
2009/11/11 Jörgen Hägglund jorgenhaggl...@netscape.net:
Hi all!
I have three tables, one containing IP addresses as integers, lets call
it 'base'.
A second table containing IP ranges and the country code the range
belongs to. Lets call this 'IPtoCC' with the fields IPFrom and IPTo as
On Wed, Nov 11, 2009 at 09:36:41AM -0600, P Kishor scratched on the wall:
2009/11/11 Jörgen Hägglund jorgenhaggl...@netscape.net:
Hi all!
I have three tables, one containing IP addresses as integers, lets call
it 'base'.
A second table containing IP ranges and the country code the range
Jörgen Hägglund
jorgenhaggl...@netscape.net wrote:
Hi all!
I have three tables, one containing IP addresses as integers, lets
call
it 'base'.
A second table containing IP ranges and the country code the range
belongs to. Lets call this 'IPtoCC' with the fields IPFrom and IPTo as
integers
Thanks!
Cheers!
#-Original Message-
#From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
#boun...@sqlite.org] On Behalf Of sub sk79
#Sent: Monday, October 12, 2009 9:35 PM
#To: General Discussion of SQLite Database
#Subject: Re: [sqlite] Need Help SQL
#
#Hi!,
#
#Here is a non
Rick Ratchford wrote:
#There is a slight complication with the case where endDate
startDate, #where you want to wrap around to next year. For that, I
simply need to #perform calculations modulo a large number - any
number greater than the #representation of 12/31 in my scheme. 1300
is one
On Sun, 11 Oct 2009, Igor Tandetnik wrote:
I simply combine (month, day) pair into a single number - the same way you
combine two digits of a decimal number by multiplying the first by 10 and
adding the second. The multiplier doesn't have to be 100 - any number
greater than 31 will do.
Igor,
Rich Shepard rshep...@appl-ecosys.com wrote:
On Sun, 11 Oct 2009, Igor Tandetnik wrote:
I simply combine (month, day) pair into a single number - the same
way you combine two digits of a decimal number by multiplying the
first by 10 and adding the second. The multiplier doesn't have to be
#Doesn't your VB SQLite binding support parameterized statements? If so,
#I'd suggest you dump it and find a better one.
#
#Igor Tandetnik
I'm not up on the terminology. I'm using Olaf Schmidt's VB SQLite binder.
He'd probably be better to answer this question than I.
:-)
Rick
# Here is that string from your earlier example:
#
# sSQL = SELECT Date, Month, Day, Open, High, Low, Close FROM [
# gsTableName ] WHERE ((Month - lngStartMth )*100 + (Day
# -
# lngStartDay ) + 1300) % 1300 = lngEndMth - lngStartMth *
# 100 + ((lngEndDay - lngStartDay) + 1300) Mod
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Rick Ratchford
Sent: 12 October 2009 20:16
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] Need Help SQL
#Doesn't your VB SQLite binding support parameterized statements? If so,
#I'd suggest you dump it and find a better one
Rick Ratchford r...@amazingaccuracy.com
wrote:
Your code:
((:EndMonth - :StartMonth) * 100 + (:EndDay - :StartDay) + 1300) %
1300
VB:
( lngEndMth - lngStartMth) ) * 100 + ((lngEndDay -
lngStartDay) + 1300) Mod 1300
In the VB version, I'm simply doing all the math outside the
Hi!,
Here is a non-math version using PL/SQL date operators and functions
available in StepSqlite (https://www.metatranz.com/stepsqlite/).
Hopefully this should be easier to follow.
You can compile the below code directly to a win32 dll on the
StepSqlite website and then use it in your VB code.
#Sent: Friday, October 09, 2009 6:46 PM
#To: sqlite-users@sqlite.org
#Subject: Re: [sqlite] Need Help SQL
#
#Rick Ratchford r...@amazingaccuracy.com
# Data Fields: ID, Date, Month, Day, Year, Price
#
# Problem: When provided the starting Month/Day numbers, and ending
# Month/Day numbers, what
#There is a slight complication with the case where endDate startDate,
#where you want to wrap around to next year. For that, I simply need to
#perform calculations modulo a large number - any number greater than the
#representation of 12/31 in my scheme. 1300 is one such number.
#
#Igor
I'm trying to correctly word an SQL statement.
Data Fields: ID, Date, Month, Day, Year, Price
Problem: When provided the starting Month/Day numbers, and ending Month/Day
numbers, what is the correct way to SQL the database so that the recordset
created returns as follows (assume 4 years of
Rick Ratchford r...@amazingaccuracy.com
Data Fields: ID, Date, Month, Day, Year, Price
Problem: When provided the starting Month/Day numbers, and ending
Month/Day numbers, what is the correct way to SQL the database so
that the recordset created returns as follows (assume 4 years of
data):
Thank you Igor. I will. :-)
Cheers!
Rick
#-Original Message-
#From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
#boun...@sqlite.org] On Behalf Of Igor Tandetnik
#Sent: Friday, October 09, 2009 6:46 PM
#To: sqlite-users@sqlite.org
#Subject: Re: [sqlite] Need Help SQL
#
#Rick
On Oct 4, 2009, at 12:01 AM, jack wrote:
I just setting out to learn how to use sqlite3 (3.6.18). Obviouly
I'm missing some very important points.
The very simple test app below is to open (and create) an sql
datbase then close it
Using windows XP. Using a precompiled .LIB. I
Thanks. Obviously it's going to take awhile to remember my C.
Jack
- Original Message -
From: Dan Kennedy danielk1...@gmail.com
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Sent: Saturday, October 03, 2009 1:05 PM
Subject: Re: [sqlite] Need help To Get Started
at first let me say: this doesn't run on my pc, but on a Popcorn-Hour A110
Mediaserver. That is a problem, because i can't predict the behaviour of
sqlite or php and i can't get real error message (Just one general Message
which occurs for all things).
i have a function that scans a folder which
To: sqlite-users@sqlite.org
Sent: Wednesday, April 15, 2009 9:17:09 PM
Subject: Re: [sqlite] Need help with the SQL statement.
Joanne Pham joannekp...@yahoo.com
wrote in message news:872428.4795...@web90308.mail.mud.yahoo.com
But the first row (20657220 1 2 101 -- this is 2009-04-11 00:00:00)
may
Joanne Pham joannekp...@yahoo.com
wrote in message news:348376.69121...@web90302.mail.mud.yahoo.com
20657220 is number of minutes in GMT time zone.
So we need to convert to second by 20657220 *60.
select datetime(20657220*60, 'unixepoch','localtime' );
will be 2009-04-11 00:00:00
In this
Thanks a ton Igor!
It worked. Your help is greatly appreciated.
Thanks,
JP
From: Igor Tandetnik itandet...@mvps.org
To: sqlite-users@sqlite.org
Sent: Thursday, April 16, 2009 4:52:28 AM
Subject: Re: [sqlite] Need help with the SQL statement.
Joanne Pham
Hi All,
I have the following table(dailyDataTable) as defined below
startTime INTEGER : number of minutes in GMT time
appId INTEGER : application Id
remoteId INTEGER : server id
proxyCount INTEGER
This table can have up to 24 hours as below: (this table
Joanne Pham joannekp...@yahoo.com
wrote in message news:594788.4966...@web90305.mail.mud.yahoo.com
Hi All,
I have the following table(dailyDataTable) as defined below
startTime INTEGER : number of minutes in GMT time
appId INTEGER : application Id
remoteId INTEGER : server id
proxyCount
To: sqlite-users@sqlite.org
Sent: Wednesday, April 15, 2009 7:44:48 PM
Subject: Re: [sqlite] Need help with the SQL statement.
Joanne Pham joannekp...@yahoo.com
wrote in message news:594788.4966...@web90305.mail.mud.yahoo.com
Hi All,
I have the following table(dailyDataTable) as defined below
startTime
Joanne Pham joannekp...@yahoo.com
wrote in message news:872428.4795...@web90308.mail.mud.yahoo.com
But the first row (20657220 1 2 101 -- this is 2009-04-11 00:00:00)
may not be there in the dailyDataTable so min(startTime) won't work
in this case. Any idea Igor?
I don't quite see how 20657220
On 16/04/2009 2:17 PM, Igor Tandetnik wrote:
Joanne Pham joannekp...@yahoo.com
wrote in message news:872428.4795...@web90308.mail.mud.yahoo.com
But the first row (20657220 1 2 101 -- this is 2009-04-11 00:00:00)
may not be there in the dailyDataTable so min(startTime) won't work
in this case.
venkat karri venkat9...@gmail.com
wrote in message
news:265032e50901291849h68ff004ay642ba7357a701...@mail.gmail.com
I have a database where date is stored in the integer format ( eg:
1125426109) I want the output in mm/dd/ format. can any one tell
me the syntax to convert the date.
select
Thanks dude, that works !
On 1/29/09, Igor Tandetnik itandet...@mvps.org wrote:
venkat karri venkat9...@gmail.com
wrote in message
news:265032e50901291849h68ff004ay642ba7357a701...@mail.gmail.comnews%3a265032e50901291849h68ff004ay642ba7357a701...@mail.gmail.com
I have a
Dear All,
I need help in sqlite3. i want to test the sqlite 3 database . any test tool
is there to test database??
pls help me
Thanks in Advance.
--
View this message in context:
http://www.nabble.com/Need-help-in-sqlite3-tp14685105p14685105.html
Sent from the SQLite mailing list
like what I've implemented, I
suggest that you will most likely have to write it yourself.
Lee Crain
-Original Message-
From: ssridhar07 [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 08, 2008 2:18 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] Need help
Richard Klein [EMAIL PROTECTED] wrote:
The previous statement is actually more general: SQLite
version 3.x.y can read and write any database created by
any prior version of SQLite.
Even SQLite 2.w.z ?
No. Any prior 3.x.x version of SQLite.
The previous statement is actually more general: SQLite
version 3.x.y can read and write any database created by
any prior version of SQLite.
Even SQLite 2.w.z ?
-
To unsubscribe, send email to [EMAIL PROTECTED]
Michael Dupuis [EMAIL PROTECTED] wrote:
Greetings,
I have an application that uses SQLite 3.3.2 right now, and I'm
looking to move to 3.5.2. The problem I have right now is that 3.5.2
can't open the 3.3.2 formatted database files. I know that the file
format changed, and then changed back,
SQLite version 3.5.2 can read and write database files created
by every prior version of SQLite. No exceptions.
Which is what I would expect. But still, I get the error that the
latest build can't read my older format. Is there anything that CAN
cause this error? My version 3.3.2 was built on
Michael Dupuis [EMAIL PROTECTED] wrote:
SQLite version 3.5.2 can read and write database files created
by every prior version of SQLite. No exceptions.
Which is what I would expect. But still, I get the error that the
latest build can't read my older format. Is there anything that CAN
I was able to open and run PRAGMA integrity_check on the
database file you sent me (off-list) on both Linux and
MacOSX x86 using SQLite version 3.4.1 and 3.5.2. No errors.
I have no idea what is causing your problem.
Ok, since it was confirmed here that there SHOULDN'T be a problem, I
went
Greetings,
I have an application that uses SQLite 3.3.2 right now, and I'm
looking to move to 3.5.2. The problem I have right now is that 3.5.2
can't open the 3.3.2 formatted database files. I know that the file
format changed, and then changed back, but I thought there was still a
way to get
John Elrick-2 wrote:
I've been using the Delphi ASGSqlite components with static linking for
some time with version 3.3.13. I'd like to move on up to 3.4.0,
however, no one seems to have documented how to do this yet.
I tried compiling the Amalgamation with Borland C++ 5.0 and it
John Elrick wrote:
I've been using the Delphi ASGSqlite components with static linking
for some time with version 3.3.13. I'd like to move on up to 3.4.0,
however, no one seems to have documented how to do this yet.
I tried compiling the Amalgamation with Borland C++ 5.0 and it
generates
I've been using the Delphi ASGSqlite components with static linking for
some time with version 3.3.13. I'd like to move on up to 3.4.0,
however, no one seems to have documented how to do this yet.
I tried compiling the Amalgamation with Borland C++ 5.0 and it generates
the obj file nicely.
I have a file with the columns: StockSymbol, OptionSymbol, StockPrice,
StrikePrice, ExpiryDate
For each StockSymbol, ExpiryDate, I would like to list just 4 of the
records where the StrikePrice is lower than the StockPrice.
The following is close to what I want except it gives me all the
1 - 100 of 116 matches
Mail list logo