On Fri, 22 Sep 2017 10:54:21 +0100, John G
wrote:
>I know this is an older thread, but shouldn't that reference be on the ITEM
>table ? So ...
>
>CREATE TABLE ATTRIBUTES (
>ITEM_ID INTEGER REFERENCES ITEM(ID) ON DELETE CASCADE,
> KEY TEXT,
>VALUE TEXT,
>PRIMARY KEY (ITEM_ID,KEY)
I know this is an older thread, but shouldn't that reference be on the ITEM
table ? So ...
CREATE TABLE ATTRIBUTES (
ITEM_ID INTEGER REFERENCES ITEM(ID) ON DELETE CASCADE,
KEY TEXT,
VALUE TEXT,
PRIMARY KEY (ITEM_ID,KEY)
) WITHOUT ROWID;
John G
On 11 September 2017 at 13:11, K
On Mon, 11 Sep 2017 14:05:25 +0200, Kees Nuyt
wrote:
> CREATE TABLE ATTRIBUTES (
> ITEM_ID INTEGER REFERENCES ATTRIBUTES(ID) ON DELETE CASCADE,
> KEY TEXT,
> VALUE TEXT,
> PRIMARY KEY (ITEM_ID,KEY)
> ) WITHOUT ROWID;
> CREATE INDEX attr_item_id ON ATTRIBUTES(ITEM_ID);
Correction:
In thi
On Sun, 10 Sep 2017 20:35:16 -0700, Vikas Aditya
wrote:
> Hi All,
>
> I need some help in figuring our right query syntax for querying
> items from two tables. We have two tables. One of the table has
> list of items. And Second table has additional attributes.
Adding to the suggestions of Ryan
Correction:
On 2017/09/11 6:43 AM, R Smith wrote:
SELECT I.ID, ISNULL(A.VALUE,'[No Value]')
FROM ITEM AS I
LEFT JOIN ATTRIBUTES AS A ON A.ITEM_ID = I.ID
WHERE A.key='abc' OR A.key IS NULL
ORDER BY A.VALUE;
There is of course no such thing as SORT BY in SQL, it's ORDER BY.
(Forgive me,
On 2017/09/11 5:35 AM, Vikas Aditya wrote:
Hi All,
I need some help in figuring our right query syntax for querying items from two
tables. We have two tables. One of the table has list of items. And Second
table has additional attributes.
CREATE TABLE ITEM (
ID INTEGER,
FIELD0 TEXT
FIELD1 T
Hi All,
I need some help in figuring our right query syntax for querying items from two
tables. We have two tables. One of the table has list of items. And Second
table has additional attributes.
CREATE TABLE ITEM (
ID INTEGER,
FIELD0 TEXT
FIELD1 TEXT,
FIELD3 TEXT,
FIELD4 TEXT
);
CREATE TABLE
Richard. Further to your reply on Mar 31 2017, were those newly worked
code exemplars demonstrating non-trivial sqlite3_index_info from xBestIndex
interaction for a SQLite table backed vtable published?
I am sure there is still great interest for this information considering
the lack of even one
Some examples of these would be great, Dr. Hipp. Thanks.
On 2017-03-31 09:06, Richard Hipp wrote:
> On 3/31/17, aotto wrote:
>
>> I already have a working implementation with [a] close [to] empty
>> *xBestIndex and *xFilter.
>>
>> 6) I expect for a primitive WHERE clause like "rep=XXX" some
On 3/31/17, aotto wrote:
> I already have a working implementation with [a] close [to] empty
> *xBestIndex and *xFilter.
>
> 6) I expect for a primitive WHERE clause like "rep=XXX" some kind of access
>optimization…
Your xBestIndex and xFilter functions must implement the desired optimization
Hi…
I'm new to this mailing-list because I have a problem to define a
"VIRTUAL TABLE"
sqlite3 extension. I already have a working implementation with close empty
*xBestIndex and *xFilter.
1) My data is already in a sorted list with ONE or MORE primary index
columns
2) Currently the VTAB is al
mn."
-Original Message-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of Hick Gunter
Sent: Wednesday, January 11, 2017 11:29 AM
To: 'SQLite mailing list'
Subject: Re: [sqlite] Need help with System.Data.SQLite
What is the result if yo
nglists.sqlite.org] Im
Auftrag von Burtsev, Dmitriy
Gesendet: Mittwoch, 11. Jänner 2017 15:48
An: 'SQLite mailing list'
Betreff: Re: [sqlite] Need help with System.Data.SQLite
I didn't assign any value directly.
This is what I did:
1. On SQLite create source table.
CR
Message-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of GB
Sent: Wednesday, January 11, 2017 2:25 AM
To: SQLite mailing list
Subject: Re: [sqlite] Need help with System.Data.SQLite
SQLite does not really care about precision and scale. See
https://sq
017 2:08 AM
To: SQLite mailing list
Subject: Re: [sqlite] Need help with System.Data.SQLite
System.Data.SqlTypes.SqlDecimal is specific to the SQL Server provider and thus
the SQLite provider doesn't know how to handle it. Try using System.Decimal as
a more generic approach. If you need t
On
Behalf Of GB
Sent: Tuesday, January 10, 2017 2:08 AM
To: SQLite mailing list
Subject: Re: [sqlite] Need help with System.Data.SQLite
System.Data.SqlTypes.SqlDecimal is specific to the SQL Server provider and thus
the SQLite provider doesn't know how to handle it. Try using System.Decimal
System.Data.SqlTypes.SqlDecimal is specific to the SQL Server provider
and thus the SQLite provider doesn't know how to handle it. Try using
System.Decimal as a more generic approach. If you need to be portable
across providers, you will be better off using classes from
System.Data.Common anywa
> -Original Message-
> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
> Behalf Of Burtsev, Dmitriy
> Sent: Monday, January 09, 2017 10:10 AM
> To: 'SQLite mailing list'
> Subject: [sqlite] Need help with System.Data.SQLite
>
&
Is this a right mail group for System.Data.SQLite ?
-Original Message-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of Burtsev, Dmitriy
Sent: Thursday, January 05, 2017 9:08 AM
To: 'sqlite-users@mailinglists.sqlite.org'
Subject: [sqlite]
Hello
I got this error:
Exception calling "WriteToServer" with "1" argument(s): "The given value of
type SqlDecimal from the data source cannot be converted to type decimal of the
specified target column."
How to reproduce.
1. On SQLite execute this statements.
CREATE TABLE FromNum (
id
On Mon, Aug 11, 2014 at 9:19 PM, Nick Bao 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 ?*
--
--
--
n Facebook, 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
Try this:
SQLiteConnection connection = new SQLiteConnection(
"FullUri=file::memory:?cache=shared;");
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqli
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 case
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 some
o:sqlite-users-boun...@sqlite.org] On Behalf Of Kai Peters
Sent: Monday, January 14, 2013 11:50 PM
To: General Discussion of SQLite Database
Subject: [sqlite] Need help with query
Hi all,
given
CREATE TABLE masterlanguages (
ID integer primary key autoincrement,
Key1varchar not n
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 t1.descrip
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
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 (n
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 segmentatio
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/
h
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 fo
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
2011/8/4 Vinoth raj :
> 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 and send RDF or ot
On Thu, Aug 4, 2011 at 12:52 PM, Stephan Beal wrote:
> On Thu, Aug 4, 2011 at 7:50 PM, Stephan Beal wrote:
>
>> http://www.sqlite.org/whentouse.html
>>
>
> Specifically: 2nd section, 1st list item.
It may depend on the usage. After reading about the possible issues,
I have just implemented some
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 situ
On Thu, Aug 4, 2011 at 7:50 PM, Stephan Beal wrote:
> http://www.sqlite.org/whentouse.html
>
Specifically: 2nd section, 1st list item.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
On Thu, Aug 4, 2011 at 7:15 PM, Vinoth raj 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
http://wanderinghorse.net/home/stephan/
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 the
Black, Michael (IS) 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 12:15|2011-12-31 00:
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 date
11-12-31 00:15
Michael D. Black
Senior Scientist
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-us
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' '2011-12-3
don wish 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 (pres
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"
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 doct
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
Igor Tandetnik writes:
>
> Balasubramani Vivekkanandan 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
>
Igor Tandetnik writes:
>
> Balasubramani Vivekkanandan 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
>
Balasubramani Vivekkanandan 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 limit of 3 bytes is rea
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 del
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
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 generat
On Tue, Dec 7, 2010 at 3:49 AM, 곽현미 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 the sqli
Quoth Philip Graham Willoughby , 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 http://sqlite.org/lang_keywords.html:
| For resilience when c
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, sing
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 mail
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 wrote:
> >> From: oliver@web.de
> >> a little mistake - here
Igor Tandetnik 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 (t.TestId
Kristoffer Danielsson 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 DISTINCT Name FROM
ot;fail", which 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:
>
&g
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 - st
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)
>
NG(TestID) 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 0
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 +0000
> Subject: Re: [
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
___
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: [
Kristoffer Danielsson 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
;
Oliver
__
generating statistics will become a lot
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
> Sub
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)
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 INTEGER
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 System.
2010/1/19 Fabrice NA :
> 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 extrapol
helps,
Samuel
From: noel frankinet
To: General Discussion of SQLite Database
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,
In sqlite3_exec, you pass a function pointer
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
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 newbie.
Jörgen Hägglund
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 and CC as text.
> The
On Wed, Nov 11, 2009 at 09:36:41AM -0600, P Kishor scratched on the wall:
> 2009/11/11 Jörgen Hägglund :
> > 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
2009/11/11 Jörgen Hägglund :
> 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.
> Th
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 countr
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-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.
Rick Ratchford
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 string
>
..@sqlite.org
[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 su
#>> 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 + " & ((
#>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
Rick Ratchford
wrote:
> Unfortunately, I have to take the examples provided and convert them
> into
> STRINGS that Visual Basic 6 can use.
>
> Here is that string from your earlier example:
>
> sSQL = "SELECT Date, Month, Day, Open, High, Low, Close FROM [" &
> gsTableName & "] " & "WHERE ((Month
Rich Shepard 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
>> 100 - any number
atement jump out as the issue?
Thanks. :)
Rick
#>-Original Message-
#>From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
#>boun...@sqlite.org] On Behalf Of Igor Tandetnik
#>Sent: Monday, October 12, 2009 6:53 AM
#>To: sqlite-users@sqlite.org
#>Subjec
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.
Ig
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
>
#>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 T
Rick Ratchford wrote:
> Okay, I give.
>
> What do the 100 and 1300 values signify? I am completely baffled at
> how you
> arrived at these values and what they do.
I simply combine (month, day) pair into a single number - the same way you
combine two digits of a decimal number by multiplying th
Tandetnik
#>Sent: Friday, October 09, 2009 6:46 PM
#>To: sqlite-users@sqlite.org
#>Subject: Re: [sqlite] Need Help SQL
#>
#>Rick Ratchford
#>> Data Fields: ID, Date, Month, Day, Year, Price
#>>
#>> Problem: When provided the starting Month/Day numbers, and ending
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: [sql
Rick Ratchford
> 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):
>
> In other wor
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 data)
Thanks. Obviously it's going to take awhile to remember my C.
Jack
- Original Message -
From: "Dan Kennedy"
To: "General Discussion of SQLite Database"
Sent: Saturday, October 03, 2009 1:05 PM
Subject: Re: [sqlite] Need help To Get Started with SQLITE
>
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
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 confirmed the version number from
the command line.
It
1 - 100 of 148 matches
Mail list logo
