RE: [sqlite] Problem creating extension for use with load_extension

oes anyone have a working extension in Windows form that I could try just to make sure I am using this properly? Thanks, Bob Dankert - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] Problem creating extension for use with load_extension

t cannot find anything on this error. I am running this with Windows Vista 32-bit in a command prompt run as administrator. Thanks for any help, let me know if I need to post a link to the source/my project for this.

[sqlite] Question on SQL query optimization with joins

d an index on both table1id and the name columns from table2? I am more or less looking at the theory behind these optimizations in SQL and not a specific case for SQLite - just trying to understand how all this stuff works so I can write better queries. Thanks! Bob Dankert

RE: [sqlite] unsuscribe

Especially considering they are all spelling the word wrong with the same mis-spelling. -Original Message- From: John Newby [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 31, 2006 1:25 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] unsuscribe whats with all these unsubscribe

RE: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

I have to agree as well - Quite frequently I am just too busy to read the list, other times I get a wealth of information from the list. I would hate to get unsubscribed because I was too busy to reply to a message. Plus, I archive all of my messages in the list so I can search for previous

RE: [sqlite] Cannot load sqlite3.dll

You can not use it directly in .Net as it is not a .Net module - you need to reference it's API using PInvoke (platform invoke). You can look at some of the .Net wrappers in the wiki at http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers Bob Bob -Original Message- From: Paul Hunnisett

RE: [sqlite] Windows SQLITE3 SUPER SLOW

Hi Sly, Can't really help without the query that you are using and more information about the database. Are you using indexes? How many records are in the tables? Bob Envision Information Technologies Associate [EMAIL PROTECTED] v. 608.256.5680 f. 608.256.3780 -Original Message-

RE: [sqlite] SUM and NULL values

I would think that if you are looking to know the total of something (which is what SUM provides), and there is nothing to total, the total should be 0. If you want to know if any sales were made, it seems you should be using COUNT and not SUM. Just my opinion, of course. Bob Envision

RE: [sqlite] Survey: NULLs and GROUP BY

MySQL 4.1.1-NT +--+--++ | a| b| sum(c) | +--+--++ |1 |2 | 2 | | NULL |2 | 4 | |1 | NULL | 8 | | NULL | NULL | 16 | +--+--++ Bob Envision Information Technologies Associate [EMAIL PROTECTED] v.

RE: [sqlite] Unlucky number for the ROUND function

256.5680 f. 608.256.3780 -Original Message- From: D. Richard Hipp [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 30, 2005 1:08 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] Unlucky number for the ROUND function On Tue, 2005-08-30 at 12:46 -0500, Bob Dankert wrote: > According to th

RE: [sqlite] Unlucky number for the ROUND function

y, August 30, 2005 12:18 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Unlucky number for the ROUND function Interesting... Bankers' Rounding http://blogs.msdn.com/ericlippert/archive/2003/09/26/53107.aspx Brass Tilde wrote: >>From: "Bob Dankert" > > >>Using

RE: [sqlite] Unlucky number for the ROUND function

Using the downloaded command-line tool for 3.2.5, I get the same :.0 result. Using an older version which I compiled, I get 9.9, though it seems it should round up to 10.0? Bob Envision Information Technologies Associate [EMAIL PROTECTED] v. 608.256.5680 f. 608.256.3780 -Original

[sqlite] How to update wiki? date/time page misprint

I'm not sure if it is possible for myself to update the SQLite wiki, but on the Date and Time Functions page, http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions, the text for the format of strftime is incorrect for the %j format. I believe this should specify 001-366 instead of 000-366.

RE: [sqlite] sqlite 3.x and Win Server 2003 SP1 not working

there are a couple of entries that point outside itself. This seems to point to a gcc bug to me, but who knows. If the vc build still has the same problem they are going to take a look at it for me :) I assume you are running under SP1? Everything works fine? ~derek -Original Message- From: Bob

RE: [sqlite] sqlite 3.x and Win Server 2003 SP1 not working

I followed these instructions for VS 2003 http://www.sqlite.org/cvstrac/wiki?p=HowToCompileWithVsNet Bob Envision Information Technologies Associate [EMAIL PROTECTED] v. 608.256.5680 f. 608.256.3780 -Original Message- From: Derek Shaw [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 12,

RE: [sqlite] SQL functions - documentation?

Adam, Most of the functions (except date/time functions) are covered on this page: http://www.sqlite.org/lang_expr.html Many functions are intentionally left out of SQLite but can be easily added. Bob Envision Information Technologies Associate [EMAIL PROTECTED] v. 608.256.5680 f.

RE: [sqlite] Is this possible in SQLite?

Unfortunately, as the syntax on the website points out, this is not supported. As you pointed out previously, it is doable with a few extra commands. Bob Envision Information Technologies Associate [EMAIL PROTECTED] v. 608.256.5680 f. 608.256.3780 -Original Message- From: John

[sqlite] User functions

Is there a good example somewhere of how to implement user-defined functions? Thanks Bob Envision Information Technologies Associate [EMAIL PROTECTED] v. 608.256.5680 f. 608.256.3780

RE: [sqlite] basic sql question: Is there a way of entering multiple rows in a table?

I would use attach database, and then use an insert select.. Ie. Attach database db2; Insert into table1 select * from db2.table2; Hope this helps... Bob Envision Information Technologies Associate [EMAIL PROTECTED] v. 608.256.5680 f. 608.256.3780

[sqlite] how to use multiple tables in an update or delete?

Is there any way to use multiple tables in an update or a delete? Most databases support doing something like: Update table1 join table2 on table1.index = table2.index set table1.column = value The only way I know around it is to use a subselect in the filter for the update/delete, but

RE: [sqlite] How to unite query results from two databases

I havent worked with multiple databases before, but I would think you could just union two queries together if nothing else. Eg: select ... union select ... order by col Bob Envision Information Technologies Associate [EMAIL PROTECTED] v. 608.256.5680 f. 608.279.3780 -Original

RE: [sqlite] download db - security question

My tip and advice would be to stop sending the same message over and over. Bob -Original Message- From: Ramon [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 12:55 AM To: sqlite-users@sqlite.org Subject: [sqlite] download db - security question I was wondering if someone can

RE: [sqlite] Union queries with sub-select tables with limits returns no results

queries with sub-select tables with limits returns no results Bob Dankert wrote: > I am trying to union two queries with each query having a sub-select > defining the table, but I consistenly get no results if I try to limit > the sub-query. Here is my query, assuming the table a

[sqlite] Union queries with sub-select tables with limits returns no results

b-selects for the tables and limit these. Does anyone have any suggestions as to what I can do for this? Thanks, Bob Dankert -Original Message- From: George Ionescu [mailto:[EMAIL PROTECTED] Sent: Thursday, December 16, 2004 1:00 AM To: SQLite Forum Subject: Re: [sqlite] db admin tool Hello s

RE: [sqlite] Documentation help

I believe if you take a look in the wiki, you will find the date and time functions. Otherwise, look through the syntax section and the wiki section of the web site. Bob Dankert -Original Message- From: John Mistler [mailto:[EMAIL PROTECTED] Sent: Thursday, October 14, 2004 4:47 PM

[sqlite] Get a listing of tables

Is there any way through a sql call to get a listing of tables in sqlite? I tried '.tables' as would be used at the console application, but this is not supported. Thanks! Bob Dankert

[sqlite] string concatenation

function is supported. Bob Dankert

RE: [sqlite] Encryption?

http://www.hwaci.com/sw/sqlite/prosupport.html#crypto I would also recommend going through the mailing list archives as I know there have been a couple conversations per this topic in the last few weeks. Bob -Original Message- From: Bryan Ashby [mailto:[EMAIL PROTECTED] Sent:

[sqlite] Default column value as current date

Is there any way to make the default column value as the current datetime? Thanks! Bob

RE: [sqlite] Encrypting data stored in database

Joey, You are going to have to excuse my ignorance of c++, but I am a bit confused as far as the ppdbuffersize and ppdbuffer. Is there additional code I would need to add elsewhere for these variables, and if so, would you mind including those as well?? I'm very sorry if this is really stupid,

RE: [sqlite] Encrypting data stored in database

Joey, Would you mind sharing the modifications you made to the os_win.c file? I would be interested in using such a modification, unfortunately, c++ isn't my strongest language. Thanks! Bob -Original Message- From: Joey Blankenship [mailto:[EMAIL PROTECTED] Sent: Friday, September 10,

[sqlite] Encrypt or somehow protect database?

I am wondering if there is some way that a SQLite database file can be encrypted or password protected, or something similar to this? I would like to prevent any mischievous users from digging through the database if they figure it out to be a sqlite file. Thanks! Bob