[sqlite] SQlite3.exe .dump doesn't do anything for me

bles in my database? Thank you very much. Rob Richardson - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] SQlite3.exe .dump doesn't do anything for me

I had an old version of sqlite3.exe. The latest worked fine. Rob -Original Message- From: Rob Richardson [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 06, 2007 1:21 PM To: sqlite-users@sqlite.org Subject: [sqlite] SQlite3.exe .dump doesn't do anything for me Greetings! I h

[sqlite] Is there a SQLiteSpy-like thing that will let me change data from a grid?

now about. Can somebody please point me to one or the other? Thank you very much. Rob Richardson - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] Is there a SQLiteSpy-like thing that will let me change data from a grid?

I can't get SQLiteExplorer to work with my databases. It always gives me an "unknown file format" error. I believe it's been quite a while since it was updated. RobR -Original Message- From: Griggs, Donald [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 06, 2007 3:14 PM To: sqlite

RE: [sqlite] Is there a SQLiteSpy-like thing that will let me change data from a grid?

For the life of me, I can't figure out how to open a database in DBManager. I looked at it before, tried for an hour, and erased it. I just tried again, with the same result. If I can't figure out how to do such an easy thing, I can't trust the program. RobR -Original Message- From:

[sqlite] How can I get my query to run as fast as SQLiteSpy?

I use the same trick? Also, my version of the sqlite library code only has an sqlite3_get_table() method that uses single-byte characters. Does the latest code have a Unicode version of this method? Thank you very much. Rob Richardson -Original Message- From: Will Leshner [mailto:[

[sqlite] Why does "SELECT julianday('some_date') AS dateNumber" get me a string via ODBC?

Greetings! I am trying to talk to a small SQLite database through ADO and an ODBC driver. I want to convert a date to a Julian day before using the date in a query of a table that could have over a million records. In SQliteSpy, the query "SELECT julianday('2007-06-05 12:34:56', 'localtime')

[sqlite] DSN-less connection string

r was specified. I downloaded and installed the ADO.Net provider, but I did not see anywhere anything telling me what provider name to use with it. I can't use a DSN because the database to be opened must be selected by the user at run time.

[sqlite] Why is there no sqlite3_exec16() method?

API that does have that method? Thank you very much. Rob Richardson - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] Re: Why is there no sqlite3_exec16() method?

hen clean up by calling sqlite_finalize? Rob Richardson - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] What happens when a table with an active statement is changed?

? Will the repeated sqlite3_step() calls on the first statement eventually get the new record? Or do I just need to be careful that I never have two active sqlite statements referencing the same table? Rob Richardson - To

RE: [sqlite] What happens when a table with an active statement is changed?

It seems this was discussed just a few days ago. A recent upgrade to SQLite allows inserts, updates and deletes on tables that are also open for selection. The changes may or may not appear as I call sqlite3_step(), but I can live with that. RobR

[sqlite] How can I convert from Julian time to a tm structure?

I'm going to do? Thank you very much. Rob Richardson - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] How can I convert from Julian time to a tm structure?

All right. Smack me upside the head again. I deserve it. SQLite is open source, so I just had to look in the source code. RobR - To unsubscribe, send email to [EMAIL PROTECTED] --

RE: [sqlite] How can I convert from Julian time to a tm structure?

error-prone to me. While I am quite confident that you and your collaborators checked this code carefully, I would like to see an explanation of this algorithm to understand it more fully. Maybe I'll see if I can get the book through an inter-library loan someplace. Rob

[sqlite] Sharing an in-memory database between applications

ever -- you get the idea) statements. Thank you very much. Rob Richardson RAD-CON INC. - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] Wrong column type being returned

column_text16(), I see that the data to the right of the decimal point is getting truncated when I read it. Can anyone tell me why SQLite suddenly thinks this column of floating-point data holds only integers? Thanks very much! Rob Richardson ___ sqlite

[sqlite] Major memory leak

Greetings! I must be doing something wrong. I've got a simple table with three columns, a key column, a value column and a timestamp column. There are 357,000 rows. The timestamps are stored as floating-point numbers (Julian dates), and the other two fields contain integers. I open the table,

[sqlite] Major memory leak

Greetings! I must be doing something wrong. I've got a simple table with three columns, a key column, a value column and a timestamp column. There are 357,000 rows. The timestamps are stored as floating-point numbers (Julian dates), and the other two fields contain integers. I open the table,

Re: [sqlite] Major memory leak

My SQLite library is built from the single translation unit sqlite.c/sqlite.h. That file contains the version number 3.3.17. I do not have valgrind, but circumstantial evidence that this is a SQLite problem is strong. When stepping through my code, I see that my application's memory jumps by ove

Re: [sqlite] Major memory leak

at is a leak, by my definition. RobR On 3/23/08, Christian Smith <[EMAIL PROTECTED]> wrote: > On Fri, Mar 21, 2008 at 10:41:10AM -0400, Rob Richardson wrote: > > My SQLite library is built from the single translation unit > > sqlite.c/sqlite.h. That file contains the version

[sqlite] sqlite3_interrupt() and threads

n the sqlite3_step() that I want to interrupt, or is there some other mechanism I can use, or is there no way to do this? Thanks very much! Rob Richardson Rad-Con, Inc.

RE: [sqlite] sqlite3_interrupt() and threads

be used for? OK, three questions: Is there a way to run sqlite3 queries asynchronously? Thanks again! Rob Richardson Rad-Con, Inc.

RE: [sqlite] sqlite3_interrupt() and threads

Great! That looks like exactly what I need. Thanks very much! Rob Richardson RAD-CON INC. -Original Message- From: Michael Scharf [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 10:45 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] sqlite3_interrupt() and threads Hi

RE: [sqlite] sqlite3_interrupt() and threads

Michael, I notice in the documentation that the sqlite3_progress_handler() method is marked "experimental". Is that significant? Rob

[sqlite] Reading the same table from two threads

in the previous 24 hours. The second thread is probably started only a few milliseconds after the first one. I am getting an access violation inside sqlite3.dll when the second thread calls sqlite3_prepare(). Am I trying to do something I shouldn't? Thanks very much! Rob Richardson

RE: [sqlite] Reading the same table from two threads

: Re: [sqlite] Reading the same table from two threads On 7/26/06, Rob Richardson <[EMAIL PROTECTED]> wrote: > few milliseconds after the first one. I am getting an access violation > inside sqlite3.dll when the second thread calls sqlite3_prepare(). Am I > trying to do someth

RE: [sqlite] Reading the same table from two threads

I found the spot where I was telling the two threads to use the same database pointer instead of running on separate ones. Once I fixed that, it works. Thanks for your help. Rob Richardson Rad-Con, Inc. -Original Message- From: Jay Sprenkle [mailto:[EMAIL PROTECTED] Sent: Wednesday

[sqlite] Can I use internal variables in SQL scripts?

much! Rob Richardson RAD-CON, Incv.

RE: [sqlite] Can I use internal variables in SQL scripts?

Christian, Thank you for your reply. I will be happy to develop stored procedure capability for SQLite in my copious spare time. :-) Don't hold your breath. RobR -Original Message- From: Christian Smith [mailto:[EMAIL PROTECTED] Sent: Friday, July 28, 2006 10:10 AM To: sqlite-users@

[sqlite] The meaning of times in julianday()

d to be UTC time, and it is converted to local time before the comparison is made. Are those conclusions correct? And I presume the datetime() method operates the same way? Thanks again! Rob Richardson RAD-CON INC.

RE: [sqlite] starting with unicode

No, you don't need sqlite3_reset() inside the loop. The pseudocode should be: open prepare loop while not at end of file step read repeat finalize close For the "read" portion, use the sqlite_column_xxx() methods. And wrap every single string in your co

[sqlite] How can I tell what version of SQLite a database was created with?

Greetings! I have an SqLite database file that cannot be opened in my application or with SQLiteExplorer. Both of them report "Unsupported file format". However, it can be opened with SQLiteSpy. If I open it in Visual Studio's hex editor, I see that the first few bytes of the database file ident

[sqlite] sqlite3_interrupt()

I have a thread that executes a query that takes about 30 seconds on my test setup. In the field, the query could take several minutes. The user needs to be able to stop this query if it was started by accident. I have a pointer to the sqlite3 object that is running the query inside my thread. I

RE: [sqlite] sqlite3_interrupt()

Dr. Hipp, Thanks for your reply. The question of which version I'm using is up in the air right now. I threw a call to sqlite3_libversion() into my application, and it returned "3.2.1". I asked our lead developer (who's in Indiana while the rest of us are just west of Cleveland, OH) what versio

RE: [sqlite] sqlite3_interrupt()

ta() finished at Thu Aug 24 16:05:07 2006 Rob Richardson RAD-CON INC. - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] sqlite3_interrupt()

et the correct sqlite3 object to use in the interrupt call, I'll let you know how it works. Rob Richardson RAD-CON INC. - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] sqlite3_interrupt() works

Greetings! After installing SQLite 3.3.7 and making sure I was passing the correct pointer to sqlite3_interrupt(), I got it to work. Rob Richardson RAD-CON INC.

[sqlite] "Invalid or corrupt file" when building .lib file for version 3.3.7 dll

Greetings! I am using MS Visual Studio 6 under the Windows XP pro operating system. I downloaded the dll for version 3.3.7. I tried to run Lib to build the .lib file for the dll. Here's the command line: lib /machine:i386 sqlite3.def This was run with the folder containing sqlite3

RE: [sqlite] "Invalid or corrupt file" when building .lib file for version 3.3.7 dll

Thanks, Martin. That worked. Rob Richardson RAD-CON INC. -Original Message- From: Martin Jenkins [mailto:[EMAIL PROTECTED] Sent: Friday, August 25, 2006 5:21 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] "Invalid or corrupt file" when building .lib file for version

[sqlite] Stripping a newline character

. It has no effect. How should I do this? Thanks very much! Rob Richardson RAD-CON INC.

RE: [sqlite] Stripping a newline character

Please forgive my idiocy. I was more tired than I thought. First, I posted this message to the wrong mailing list (I wanted a Python list), and second, I made a dumb, silly assumption about how the method worked. RobR -

RE: [sqlite] Bug in SQlite ?

What assertion failure are you seeing? What is the exact message? Can you use a debugger to step into the code where the assertion failure happens? RobR - To unsubscribe, send email to [EMAIL PROTECTED]

[sqlite] Can primary key columns be altered to use autoincrement?

s not possible to alter a column at all. There's no ALTER COLUMN clause available for the ALTER TABLE statement. Is that correct? Thank you. Rob Richardson RAD-CON INC. - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] Creating a database from inside a program

his won't work from a DOS prompt, I'm sure it won't work from my program. So, what is the recommended way to create a new database and its schema from inside a program? In case it matters, I'll be using Visual C# 2005 and the SQLite.net.dll file from SourceForge. Thank y

Re: [sqlite] [SQLITE]select from a table and use its data to select from another one

The use of single quotes instead of double quotes in database queries is not limited to SQLite. That's part of the SQL standard. RobR On Fri, Sep 14, 2018 at 2:05 PM David Raymond wrote: > Small typo: > > SELECT * FROM table2 JOIN table1 > ON table1.rowid = table2.rowid > WHERE table1.

Re: [sqlite] [SQLITE]select from a table and use its data to select from another one

ars to have some specific meaning inside SQL (or at least, inside PostgreSQL). So, although the query SELECT * FROM cycle works, we should probably use SELECT * FROM "cycle" to avoid any possible ambiguity. RobR On Fri, Sep 14, 2018 at 2:12 PM Rob Richardson wrote: > The use of sin

Re: [sqlite] Unique Constraint Failed

Dumb question: are you sure you're only inserting one record at a time? Is it possible you're inserting records so fast that the timestamp is the same for two of them? On Fri, Sep 14, 2018 at 3:30 PM Andrew Stewart wrote: > Hi, > I am having problems with a database reporting U

Re: [sqlite] Using SQLite in C# without System.Data.SQLite

Why don't you want to use System.Data.SQLite? On Thu, Oct 18, 2018 at 11:04 AM Jordy Deweer wrote: > Dear all > > I am new to this group and this is my first question here. > > My question is as follows: > > Is there a way to use a SQLite database in a C# project, without > installing / configur

Re: [sqlite] Using SQLite in C# without System.Data.SQLite

What target platforms have you found on which it is unreliable? I haven't had problems on Win7, but I haven't used it all that much. RobR On Thu, Oct 18, 2018 at 2:57 PM Jordy Deweer wrote: > Larry Brasfield wrote: "Jordy Deweer asks: “Is there a way to use a > SQLite database in a C# project,

Re: [sqlite] How to round to an Integer

I don't think the cast rounds, though. It just truncates. Am I wrong? RobR On Thu, Oct 18, 2018 at 4:13 PM Richard Hipp wrote: > On 10/18/18, John Harney wrote: > > Recently figured this out. Seems to work fine > > > > trim(trim(round(1.111,0),'0'),'.') = 1 > > > > CAST(1.111 AS integer)

[sqlite] How can I lock a database?

I have a program reads data from 17 PLCs and writes it into SQLite databases every minutes. Every midnight, it deletes old data and vacuums the databases. It's behaving strangely after that. I think the problem begins because the vacuum operation is still going on at 12:01, when the next read

[sqlite] Unable to run SQLite programs: error 0xC000007b

sure. What do I need to do to get this little test program to run? Thank you very much. Rob Richardson ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Why isn't my time formatting working?

Hello! I have a table with times stored as strings. I massaged them into a form that strftime() should be able to work with, but it's not working. Here's a little query using the string as it is currently formatted: select strftime('%d/%m/%Y %H:%M:%S', '03/07/2017 13:06:03') This query retur

Re: [sqlite] Why isn't my time formatting working?

ssage- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Richard Hipp Sent: Wednesday, March 08, 2017 2:28 PM To: SQLite mailing list Subject: Re: [sqlite] Why isn't my time formatting working? On 3/8/17, Rob Richardson wrote: > Hello! > > I have

Re: [sqlite] Why isn't my time formatting working?

Thank you. The https://www.sqlite.org/lang_datefunc.html page doesn't seem to make it clear what strftime() returns. The specification it gives for strftime() is: strftime(format, timestring, modifier, modifier, ...) Given the lack of an indication of the return type, it seemed to me to be re

[sqlite] Where is the official document for System.Data.SQLite?

Where is the official document for System.Data.SQLite? And is there a better list than this one to ask questions about System.Data.SQlite? Specifically, I'm looking for the correct way to use the SQLiteCommand class and parameterized queries. Do parameters have to be named? Thank you.

Re: [sqlite] Where is the official document for System.Data.SQLite?

Of Donald Griggs Sent: Monday, March 13, 2017 1:57 PM To: SQLite mailing list Subject: Re: [sqlite] Where is the official document for System.Data.SQLite? On Mon, Mar 13, 2017 at 1:44 PM, Rob Richardson wrote: > Where is the official document for System.Data.SQLite? And is there a > bette

[sqlite] Help file has no information

The help file that is linked from the System.Data.SQLite home page appears to have a table of contents but no information. No matter what page I select, the page does not appear. RobR ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

[sqlite] How to use parameterized queries in SQLite.Net

Hello again. Since my attempt to find the official answer for myself has hit a snag, I'll just ask here. The examples I've seen for parameterized queries used with the SQLiteCommand class have shown named parameters, and the names usually begin with an "@" character. Is that character require

Re: [sqlite] Help file has no information

ham Sent from my Samsung Galaxy S7 - powered by Three Original message ----From: Rob Richardson Date: 13/03/2017 18:14 (GMT+00:00) To: "General Discussion of SQLite Database (sqlite-users@mailinglists.sqlite.org)" Subject: [sqlite] Help file has no information Th

Re: [sqlite] How to use parameterized queries in SQLite.Net

users-boun...@mailinglists.sqlite.org] On Behalf Of Rob Richardson Sent: Monday, March 13, 2017 2:23 PM To: General Discussion of SQLite Database (sqlite-users@mailinglists.sqlite.org) Subject: [sqlite] How to use parameterized queries in SQLite.Net Hello again. Since my attempt to find the official answer for

[sqlite] Difference between localtime and utc is 8 hours, but should be 4

Hello! I'm in the Eastern US time zone, in daylight savings time. I am four hours earlier than UTC time. I have a column that stores UTC times as Julian times (floating-point numbers). The latest data point in the table was stored at about 8:41 this morning (4/21). I am getting strange re

Re: [sqlite] Difference between localtime and utc is 8 hours, but should be 4

e and adjusts that string to be in UTC. If the prior string is not in localtime, then the result of "utc" is undefined. On Fri, Apr 21, 2017 at 4:24 PM, Stephen Chrzanowski wrote: > Because you're converting your UTC time to UTC. > > On Fri, Apr 21, 2017 at 4:03 PM, Rob

Re: [sqlite] Bug in division?

I don't know if it's in the SQL standard or not, but the C, C++ and C# languages all act this way. The result of mathematical operations on integers is always an integer. If you want the result to be a floating-point number, you have to force at least one of the operands to be a floating-point

Re: [sqlite] how to write this commands?

Igor, It took me a bit of looking, but I think I understand your query. One question remains: why did you use the max() function? Thanks! RobR -Original Message- update adla1 set PFLOPF=( select case count(*)=1 then max(adl.pflopf) else adla1.pflopf end from adl where adla1.re

Re: [sqlite] Sqlite querie delete bug

This doesn't sound like an SQLite problem to me. Instead it sounds like a problem with whatever visualization tool you are using. What tool are you using? If you can find a user's group for that tool, you may get more helpful answers there. RobR -Original Message- From: sqlite-users

Re: [sqlite] Simple SQLite-based spreadsheet?

There's several GUI-based SQLite tools available now. Maestro was already mentioned. My favorite is SQLiteSpy because it's fast, even though you can't insert or update data in its grid view (you have to write insert or update queries to do that, which I admit is a pain, but most of the time I'

Re: [sqlite] Mapping Sqlite INTEGER field to C# Nullable

Seems like a strange thing for VS Designer to do. NULL is not 0. RobR -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Quanren Xiong Sent: Thursday, January 03, 2013 12:30 PM To: General Discussion of SQLite Database Subject:

Re: [sqlite] looking up records with terms in a table

I think you need wildcards: SELECT Sentences FROM T1 JOIN T2 ON T1.Sentences LIKE %T2.Terms% RobR, not guaranteeing correct syntax -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Gert Van Assche Sent: Tuesday, March 26, 2013

Re: [sqlite] (no subject)

First idea: include a subject line. I'm not 100% clear on your message. You said: " For those entries in table1 where there is a null in t2..." I'm guessing you wanted to say: " For those entries in table1 where there is a null in t1..." Is that right? RobR _

Re: [sqlite] SQLite NULL or 0-Length

Simon, Is there a danger here if firstname is NULL and the LENGTH() function is called first? RobR -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: Thursday, May 23, 2013 2:54 PM To: General Discussion o

Re: [sqlite] GUI for SQLite

Not all of us. Thanks for the list. RobR, SQLiteSpy user and about to find Navicat. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] updating using a value from another table

Your query looks good to me, which probably means I'm missing the same thing you are. What happens when you run this query? RobR -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of dean gwilliam Sent: Monday, October 07, 2013 7

Re: [sqlite] updating using a value from another table

Thank you. Now, can you show us sample data from your tables before this query is run? RobR -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of dean gwilliam Sent: Monday, October 07, 2013 10:45 AM To: sqlite-users@sqlite.org S

[sqlite] Colons (was: RE: Groups and members)

In Igor's post below, what is the meaning of the colon in front of mypid? RobR -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: Wednesday, November 06, 2013 8:45 AM To: sqlite-users@sqlite.org Subject: Re:

[sqlite] A faster way to insert into a keyless table?

Greetings! I am working on updating an application that has been around for years, originally written by someone who knew SQLite exists but had very little idea of how to use it. The application monitors OPC information for 124 bases, with 7-10 tags per base. (Don't worry about what a base is

Re: [sqlite] A faster way to insert into a keyless table?

PM To: General Discussion of SQLite Database Subject: Re: [sqlite] A faster way to insert into a keyless table? On Feb 14, 2012, at 8:01 PM, Rob Richardson wrote: > What would be the best way to speed this up? wrap all your inserts in one transaction. commit at the

Re: [sqlite] SQLiteDataAdaptor Missing

In another library, I had to specify "x86" processor because it wasn't designed for 64-bit machines. Might you need to do that? RobR -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Electric Eddy Sent: Monday, February 20, 2

Re: [sqlite] accessing multiple databases

IIRC, there's a connection string option that will choose between creating an empty database and throwing an exception if you try opening a database that doesn't exist. Perhaps if that option is set to throw an exception, then the ATTACH command would fail. Or not. RobR

Re: [sqlite] Views and Performance

What kind of JOIN is used when it a type (INNER, OUTER, etc.) is not specified? RobR -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Duquette, William H (318K) Sent: Friday, March 02, 2012 11:23 AM To: Discussion of SQLite

[sqlite] What do people think of SQLite Root?

Our company typically uses SQLite Spy for managing SQLite databases. I keep hoping to find something better, because SQLite Spy does not offer the ability to edit a table inside a grid. The only way to update data is to use an SQL UPDATE statement. But nothing else offers the speed of display

Re: [sqlite] What do people think of SQLite Root?

e.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Ralf Junker Sent: Monday, March 05, 2012 9:48 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] What do people think of SQLite Root? On 05.03.2012 14:50, Rob Richardson wrote: > I keep hoping to find something better,

Re: [sqlite] What do people think of SQLite Root?

qlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Ralf Junker Sent: Monday, March 05, 2012 10:37 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] What do people think of SQLite Root? On 05.03.2012 16:11, Rob Richardson wrote: > With the latest version,

[sqlite] Best LINQ provider for SQLite?

Greetings! What is the best LINQ provider for SQLite? I'm sorry for posting a question that must have been asked several times in the past, but the archives of this group do not appear to be searchable. If there is a way to search the archives, could someone please show me? RobR _

[sqlite] No error message generated by sqlite_exec()

Hello! I am sending a badly formed query string to sqlite_exec(). It is giving me error 21 (misuse of library), but it is not giving me an error message. The value of the pointer sent as the fifth argument of sqlite_exec() is not changed. Is this expected behavior? Is there something I have

Re: [sqlite] No error message generated by sqlite_exec()

t: Re: [sqlite] No error message generated by sqlite_exec() On Tue, Mar 13, 2012 at 6:43 PM, Rob Richardson wrote: > Hello! > > I am sending a badly formed query string to sqlite_exec(). It is > giving me error 21 (misuse of library), but it is not giving me an error > message.

Re: [sqlite] No error message generated by sqlite_exec()

Thank you, Dr. Hipp. I understand. RobR -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Richard Hipp Sent: Tuesday, March 13, 2012 7:07 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] No error message gene

Re: [sqlite] Sqlite error message

You may want to add "FailIfMissing=true" to your connection string. It always surprises me when I successfully connect to a database and then an attempt to read from a table that I know durn well is there fails. RobR -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqli

Re: [sqlite] Visual Studio 2008 Express and sqlite3.c

This leads me to agree with the person who suggested that a #define someplace is telling the precompiler to change "not" to something else. There is a compiler setting that will generate a file with an extension of ".i" that is the output of the precompiler. You could try doing that and seeing

Re: [sqlite] table names

In SQLite Expert, I created table "12-345" with no problem, but I noted that when the new table was displayed, its name was wrapped in square brackets: "[12-345]". Perhaps you could wrap numeric names in brackets similarly. Good luck! RobR ___ sqlite

Re: [sqlite] Integer Truncation Issue

Disclaimer: I am not in any way an expert! As I understand things, in SQLite, any value can be stored in any column, regardless of type. But in C#, the System.Data.SQLite library isn't that flexible. If the table definition says the column contains integers, then all data in the table is pro

Re: [sqlite] auto-incrementing integer in composite primary key

If you deleted record on New Year's Day, you want a query for data on New Year's Eve to find the record but you don't want a query for data on January 2nd to find it. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Pavel Iv

Re: [sqlite] Details on New Features

Gabor Grothendieck mentioned a new feature of SQLite in 3.7.11: Queries of the form: "SELECT max(x), y FROM table" returns the value of y on the same row that contains the maximum x value. Is that standard SQL behavior? I'd have expected that to return one row for every row in the table

Re: [sqlite] How do you access a specific row of a resultset?

The other thing you are not thinking about is that you never know the order of data in a set. You may think that you want the 5th record that was ever inserted into the table, but you have no guarantee that a select statement will return records in the order in which they were inserted. The 5t

Re: [sqlite] ADO.NET Provider, targeting any cpu

-Original Message- The System.Data.SQLite managed-only assembly, when the native library pre-loading code is enabled (which it is by default starting with release 1.0.80.0), will now attempt to detect the processor architecture of the process it is being loaded into and then it will att

Re: [sqlite] cann't work

Does SQLite care about the use of double quotes instead of single quotes? RobR -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Davies Sent: Wednesday, July 11, 2012 5:10 AM To: General Discussion of SQLite Database Subj

Re: [sqlite] Syatem.Data.SQLite Exception/Error handling viaTry...Catch

I have some vague memory that exception handling is screwy inside constructors, and it's better to create a naked object and then fill it in in an Init() method. But I have no idea where I read that, if it's correct, or even which language it applies to. Good luck! RobR __

Re: [sqlite] MIN() for a timedelta?

See below. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: Thursday, July 26, 2012 8:47 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] MIN() for a timedelta? On 27 Jul 2012, at 12:04am,

Re: [sqlite] no such function problem

This is a C question, not an SQLite question. But I'll answer it anyway. You included the function call in your quoted string, so your compiler thinks it's just random text. You need: sprint(sql, "insert into student select 3, %s, 22;", ldll("bb")); RobR __

  1   2   >