On Sep 27, 2010, at 23:20, Richard Hipp wrote:
> See http://www.sqlite.org/c3ref/complete.html
Thank you very much. That was exactly what I need. Sorry to have
overlooked that.
--
Dustin Sallings
___
sqlite-users mailing list
sqlite-use
On Tue, Sep 28, 2010 at 2:01 AM, wrote:
> Hi,
> Has anyone tried (successfully or unsuccessfully) anything along the line
> of using just the B-tree APIs of sqlite as disk-based b+ tree library ?
> Looking at the source code it looks like B-tree APIs are not really
> exported
> but could be, wit
On Tue, Sep 28, 2010 at 2:07 AM, Dustin Sallings wrote:
>
>I've got a program that uses SQLite and has a couple of callouts to
> do pre and post initialization (setting pragmas mostly).
>
>Originally, I was just parsing for ';' characters and sending each
> through with execute.
I've got a program that uses SQLite and has a couple of callouts to do
pre and post initialization (setting pragmas mostly).
Originally, I was just parsing for ';' characters and sending each
through with execute. Recently, I wanted to set up a couple of temporary
triggers (wh
Hi,
Has anyone tried (successfully or unsuccessfully) anything along the line
of using just the B-tree APIs of sqlite as disk-based b+ tree library ?
Looking at the source code it looks like B-tree APIs are not really exported
but could be, with little bit of a hacking. Please share your experien
Dustin Sallings wrote:
> On Sep 27, 2010, at 5:43, Simon Slavin wrote:
>
>> I think this differs for different platforms. For instance:
>>
>> http://www.manpagez.com/man/3/usleep/
>>
>> makes no mention of that fault.
>
> It kind of does indirectly. It says it's built on nanosleep(), and
I will try it tomorrow morning. I do not have access right now.
Hemant Shah
E-mail: hj...@yahoo.com
--- On Mon, 9/27/10, Igor Tandetnik wrote:
> From: Igor Tandetnik
> Subject: Re: [sqlite] sqlite cannot find the row
> To: sqlite-users@sqlite.org
> Date: Monday, September 27, 2010, 10:14 PM
Hemant Shah wrote:
> The MD5Sum column is char[33], the sum is 32 characters long, the C datatype
> is also char[33] (i.e. one extra character for NULL
> termination).
This is largely irrelevant to the issue at hand.
> I thought the bind text column function stopped at the first NULL character
On 28 Sep 2010, at 3:13am, Hemant Shah wrote:
> The MD5Sum column is char[33], the sum is 32 characters long, the C datatype
> is also char[33] (i.e. one extra character for NULL termination).
Please note that SQLite completely ignores any character length restrictions
you may have specified.
The MD5Sum column is char[33], the sum is 32 characters long, the C datatype is
also char[33] (i.e. one extra character for NULL termination).
I thought the bind text column function stopped at the first NULL character so
the column should not have NULL character.
Timestamp column is also bigge
Here is the schema:
create table find_retransmissions(InsTimeStamp int NOT NULL, SrcIp char[16] NOT
NULL, DstIp char[16] NOT NULL, TimeStamp char[50] NOT NULL, SrcPort int NOT
NULL, DstPort int NOT NULL, SeqNum int NOT NULL, MD5Sum char[33] NOT NULL)
Hemant Shah
E-mail: hj...@yahoo.com
---
On Sep 27, 2010, at 5:43, Simon Slavin wrote:
> I think this differs for different platforms. For instance:
>
> http://www.manpagez.com/man/3/usleep/
>
> makes no mention of that fault.
It kind of does indirectly. It says it's built on nanosleep(), and
links to that doc which says t
Quoth Simon Slavin , on 2010-09-27 13:43:20 +0100:
> I think this differs for different platforms.
What about POSIX:2001?
>From http://www.opengroup.org/onlinepubs/95399/functions/usleep.html:
| The usleep() function may fail if:
|
| [EINVAL]
| The time interval specified one millio
Without seeing the original schema and more information on what you changed, no
idea.
** Sent from my mobile device with the tiny keys **
Timothy A. Sawyer, CISSP
Managing Director
MBD Consulting, LLC
55 Madison Av., Suite 400
Morristown, NJ 07960
Phone: (973) 285-3261 | Fax: (973) 538-0503
Web
Hemant Shah wrote:
> I ran .dump command to dump the data to a file, and ran .read command to read
> it into a different database. Now, I could do a
> select based upon MD5Sum column.
>
> Next I edited the output file and changed the table name. I ran .read and
> loaded the data into new table
Sorry,
I keep replying to my own posts, but I keep trying different things to figure
out the problem.
I ran select for all other columns in the table and I was able to get data, but
when I run select for MD5Sum column I do not get anything.
I ran .dump command to dump the data to a file, and
What does the table schema look like?
** Sent from my mobile device with the tiny keys **
Timothy A. Sawyer, CISSP
Managing Director
MBD Consulting, LLC
55 Madison Av., Suite 400
Morristown, NJ 07960
Phone: (973) 285-3261 | Fax: (973) 538-0503
Web: http://www.mybowlingdiary.com
Email: tsaw...@my
Instead of in-memory database, I created database in a file and tried to do
select with same results.
1285625918|10.208.54.32|239.90.91.101|2010-09-27
17.18.37.521968|10101|10101|4801345|fd5cb2d226b48d5dd4645d4fe7ca12cf
1285625918|10.208.54.32|239.90.91.101|2010-09-27
17.18.37.522843|10101|10
Sorry about that. No I do not have single quotes around ?.
strcpy(SqlString, "INSERT INTO find_retransmissions(InsTimeStamp, SrcIp, DstIp,
TimeStamp, SrcP ort, DstPort, SeqNum, MD5Sum) VALUES (?,?,?,?,?,?,?,?)");
sprintf(SqlString, "SELECT SrcIp, DstIp, TimeStamp, SrcPort, DstPort, SeqNum
FROM
Your code is chopped off and I suspect the problem is on the remainder of this
line:
sprintf(SqlString, "SELECT SrcIp, DstIp, TimeStamp, SrcPort, DstPort, SeqNum
For example, did you put single quotes around the ? parameter?
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
N
Here is the snippet of code:
int GetMessageFromDB(char *MD5Sum, struct ReceiveNode *FromDb)
{
int ReturnCode;
sqlite3_stmt *SelectStmtHandle;
sprintf(SqlString, "SELECT SrcIp, DstIp, TimeStamp, SrcPort, DstPort, SeqNum
ReturnCode = sqlite3_prepare(DbHandle, SqlString, -1, &SelectStmtH
You need to add "-ldl" to LIBS resolve the dynmic linking library calls.
It's possible these calls could be in your -lrt which should be moved to the
END of your LIBS.
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Northrop Grumman Information Systems
___
Good afternoon all,
This is the first time I've posted online seeking help and hope I
haven't missed anything out. I am trying to use SQLite on an embedded
system with an ARM9, running a closed proprietary Linux Real Time
Operating System (based on the 2.6 Linux kernel). At the time of
writi
> Since the time for sleeping is an integer number of seconds it's probably
> simplest just to replace this call with one to sleep(10). sleep() is defined
> in POSIX.1 so I believe it should be available in a library for every
> platform SQLite is expected to run on.
Windows has no sleep() - b
On 27 Sep 2010, at 10:03am, Dustin Sallings wrote:
> I happened to notice this code in the output of a git grep somewhere:
>
> usleep(1000); /* wait 10 sec and try the lock again */
>
> usleep is documented to fail with EINVAL if its argument is greater
> than 1,
The following code is intended to change text values 'UND' into NULL values.
However, I see that string values different from 'UND' get corrupted. In the
example below the value 'ENG' is corrupted and the new value is a string of
three non-printable characters (ascii values 0x03 0x17 0x13) in
I happened to notice this code in the output of a git grep somewhere:
usleep(1000); /* wait 10 sec and try the lock again */
usleep is documented to fail with EINVAL if its argument is greater
than 1,000,000. I'm not sure if that takes effect on all platfor
27 matches
Mail list logo
