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 relativ
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
C
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 c
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 D
[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 were
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 co
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 a
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 did
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 da
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
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
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, th
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* pointe
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 r
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 "" no
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 tabl
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] [[CO
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 publi
18 matches
Mail list logo