Re: [sqlite] SQLite ODBC Driver - relative path

Hello. On 17/03/2010 04:16, Shen Nan wrote: > I used SQLite ODBC Driver to display data in Excel, and everything works > fine. > Except in the connection String, I have to enter an absolute path, which is > very troublesome every time I move the file. > I wonder is there any way to specify

Re: [sqlite] Strange File Import Error

Arr, let's count. Column 1: 117172 Column 2: Engineered Structures Inc. Column 3: Brockway Center Column 4: 10875 SW Herman Rd Column 5: Tualatin Column 6: 97062-8033 Column 7: Washington Column 8: NWR Column 9: 45.3834 Column 10: -122.7882 Column 11: 1542 Column 12: Nonresidential Construct NEC

Re: [sqlite] SQLite to Access

Well, Pighin, Ryan wrote: > Hi All - We have a new utility in our environment using SQLite and I was > wondering if there was a way to dump all the database into Access so we > can create reports on the databases? Why not attach the SQLite database into Access and create your reports? That way

Re: [sqlite] Resources for newbies.

Robert Simpson wrote: > Nothing stands out ... is your callback being called at all? What's it look > like? > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of David Nelson > Sent: Saturday, August 02, 2008 2:00 PM > To: General Discussion of SQLite

Re: [sqlite] SQLite website

[EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: "James Darpinian" <[EMAIL PROTECTED]> wrote: I decided to try turning the page into a pure CSS layout with no tables. The result is available at http://www.cs.hmc.edu/~jdarpini/sqlite.html I tested it in IE6; 3 hopefully unobtrusive hacks

Re: [sqlite] Trouble compiling with MSVC++ 6.0

Andreas Kupries wrote: Ticket #2457 reports difficulty building SQLite version 3.4.0 using MSVC++ 6.0. This appears to be a bug in MSVC++. See the comments on the ticket for details: http://www.sqlite.org/cvstrac/tktview?tn=2457 I do not own MSVC++ (and have no intention of acquiring a

Re: [sqlite] Locked database

Hello. At 13:37 2/25/2007 +, you wrote: Came across a situation where it was impossible to delete or rename a SQLite db file even after the application (Excel) that had locked the database was closed. It wasn't me, so I don't have very exact information, but there was a statement to create

RE: [sqlite] Still Excel crash when running sqlite_get_table

At 17:04 2/7/2007 +, you wrote: Not sure now the zip file has come through to this forum. I can see it, but I also got a message that it wasn't allowed. Didn't get through the first time, did get through the second time. I tried my version of the VBSqlite3 DLL and it works, although I

Re: [sqlite] Still Excel crash when running sqlite_get_table

Hmmm... At 13:38 2/7/2007 +, you wrote: Still having a problem when selecting data from one particular table with the VB wrapper dll SQLite3VB.dll. It is only a small table and I just can't see why there would be a problem. Would anybody be willing to have a look at this table? The zipped

RE: [sqlite] How do I know sqlite_get_table is finished

Hello. At 14:32 2/2/2007 +, you wrote: lReturnedRows is one of the function arguments, so that is fine. I have made some progress though and that is that this problem only occurs with this particular table, called SQL. It is a table that logs all the SQL statements that run in my app. When

RE: [sqlite] How do I know sqlite_get_table is finished

At 07:44 2/2/2007 +, you wrote: Sure, here it is: Looking at the C code published at http://www.tannertech.net/sqlite3vb/index.htm , it seems very risky - there are a lot of places it can fail to allocate memory (for example), and the use of some variables looks like it could randomly

RE: [sqlite] How do I know sqlite_get_table is finished

Well... At 23:17 2/1/2007 +, you wrote: Thanks, yes, I somehow didn't think my explanation made sense and in fact I just had another Excel crash, caused by the same call to sqlite_get_table. I just can't understand why this is happening. There is a valid connection, there is a valid SQL,

Re: [sqlite] VACUUM question

At 14:56 09/02/2005 -0500, Luc wrote: My application does a VACUUM everytime it is launched. This slows down the application a little (it's a plugin for Outlook so it freezes Outlook for a second or two at most, but users could find that annoying). So I was wondering if my app has a sqlite3*

Re: [sqlite] index not used?

Hi. At 15:41 12/12/2004 +0100, you wrote: I've a pretty big table (between 800.000 and 900.000 rows) with the following schema: create table relations (rel_id_from integer, rel_id_to integer, id_old integer, id_new integer, valid_from integer, valid_to integer); create index idx_relations_idx0 on

Re: [sqlite] FW: SQL error: no such column: State

At 12:51 03/12/2004 -0600, you wrote: When The Table is created in code with the following statements cmd.CommandText = "CREATE TABLE BillingNumbers(id int default 0 not null, " & _ "clecID int default 0 not null, " & _ "ilecID int default 0 not null, " & _ "BillingNumber varchar(20) default ""

Re: [sqlite] Extracting values from callback

Well... At 22:23 11/5/2004 +0100, you wrote: I've been trying at this for a good few hours now, I'm using sqlite3 and the quick start code at the website. By using a global "char *buffer[5][220];" and then doing buffer[i][counter]=argv[i]; I thought I would be able to extract the rows in my

Re: [sqlite] column def vs. constraint at end of create table stmt

At 18:57 11/2/2004 -0500, you wrote: if I have a column def statement for every field and specify unique and primary constraints in each column def, what is the reason the constraint that goes on the very end of the create table would be needed [, constraint]* column-def ::= name [type]

[sqlite] Building SQLite in MSVC 6

Hello. First I'd like to compliment you on a very nice product; I've been adding database support to an open source project and SQLite is of immense help to us. I've been building SQLite as a library and as a DLL for Windows using Visual C++ 6 from sources of version 3.0.8. I'd be happy to