Re: [sqlite] Help with SQLite and VB2010 Express

Hi, Simon I am a SQLite user. And before I can get to ask questions about SQLite Database, I must be able to use it with Visual Studio 2010. The tools from SQLite are not up to par. So I think all questions about SQLite and the environment it can be used are SQLite User Question. I will always a

Re: [sqlite] Propose minor incompatible API change

On Mon, Jan 10, 2011 at 9:00 PM, Igor Tandetnik wrote: ... They are stuck calling sqlite3_step - incorrectly - so the only remaining move is to modify the behavior of sqlite3_step itself, to allow them to muddle through. ... Understood and concurred. It makes sense to capitulate and have the c

Re: [sqlite] Propose minor incompatible API change

On 1/10/2011 8:52 PM, Chris Peachment wrote: > On Mon, 2011-01-10 at 19:54 -0500, Richard Hipp wrote: > > > >> This is, technically, a compatibility break. On the other hand, there >> appear to be vast numbers of smartphone applications that currently depend >> on undefined behavior and will sudd

Re: [sqlite] Propose minor incompatible API change

On Mon, Jan 10, 2011 at 8:52 PM, Chris Peachment wrote: > On Mon, 2011-01-10 at 19:54 -0500, Richard Hipp wrote: > > > > > This is, technically, a compatibility break. On the other hand, there > > appear to be vast numbers of smartphone applications that currently > depend > > on undefined beha

Re: [sqlite] Propose minor incompatible API change

On Mon, 2011-01-10 at 19:54 -0500, Richard Hipp wrote: > This is, technically, a compatibility break. On the other hand, there > appear to be vast numbers of smartphone applications that currently depend > on undefined behavior and will suddenly stop working if we don't make this > change. >

[sqlite] Propose minor incompatible API change

As you probably know, the sqlite3_step() interface is used to step through the results of an SQLite query. The sqlite3_step() function returns SQLITE_ROW for every row that is returned, then SQLITE_DONE when there are no more result rows. After SQLITE_DONE (or an error) is returned, one can use s

Re: [sqlite] fill blank fields

On 1/10/2011 5:04 PM, CDN Mark wrote: > using this exampleUPDATE Aircraft SET CN = '*' where (CN = '' or CN is null) > and MyPrimaryKey='xyz';can you substitute another column name iso MyPrimaryKey You can substitute any logical combination on any set of columns in Aircraft table. -- Igor Tande

Re: [sqlite] Help with SQLite and VB2010 Express

Hi, Simon I am a SQLite user. And before I can get to ask questions about SQLite Database, I must be able to use it with Visual Studio 2010. The tools from SQLite are not up to par. So I think all questions about SQLite and the environment it can be used are SQLite User Question. I will always a

Re: [sqlite] Help with SQLite and VB2010 Express

Thank you for the reply, it makes more sense now. I'll go to the forum on System.Data.SQLite. BobK --- On Mon, 1/10/11, Simon Slavin wrote: From: Simon Slavin Subject: Re: [sqlite] Help with SQLite and VB2010 Express To: "General Discussion of SQLite Database" Date: Monday, January 10, 2011,

Re: [sqlite] Help with SQLite and VB2010 Express

On 10 Jan 2011, at 9:34pm, Bob Keeland wrote: > Obviously I don't know what I'm doing with SQLite so I'll ask the question > that shows my ignorance. > What is the difference between what can or should be asked on this list and > what should be directed to the System.Data.SQLite forum? The eas

[sqlite] fill blank fields

using this exampleUPDATE Aircraft SET CN = '*' where (CN = '' or CN is null) and MyPrimaryKey='xyz';can you substitute another column name iso MyPrimaryKey if the column you wantedto reference to wasn't the primary key, for example the field in a column named AT,as in:UPDATE Aircraft SET CN = '*

Re: [sqlite] Help with SQLite and VB2010 Express

Hi, Bob I had problems to when i installed SQLite-1.0.66.0-setup specially with apps that I had created with SQLite-1.0.65.0-setup and also because of the framework 4.0, for that there is a work around to modify in the config file of the app. I will try to find the details and report back to y

Re: [sqlite] Help with SQLite and VB2010 Express

Obviously I don't know what I'm doing with SQLite so I'll ask the question that shows my ignorance. What is the difference between what can or should be asked on this list and what should be directed to the System.Data.SQLite forum? They seem to have duplicate purposes - helping people who are h

[sqlite] joining fts table with normal table

Hi, The documentation mentions the possibility of joining a fts table with a normal table via rowid. (e.g.   select sender, subject from email join email_text on email.rowid = email_text.rowid where body match 'jam';) Can this join only be done via the rowid field? I tried using an "id" field

Re: [sqlite] Help with SQLite and VB2010 Express

You really don't need to run the msi. You can download the binary package and added the dlls as references and start using the dataprovider. In the future, this sort of question should be asked in the System.Data.SQLite forum. On Mon, Jan 10, 2011 at 12:10 PM, Bob Keeland wrote: > I've been strug

[sqlite] Help with SQLite and VB2010 Express

I've been struggling with how to use SQLite with Visual Basic2010 Express. VB2010 Express does not work with Microsoft Access (which I've used in the past) and so I have to use SQL. I don't feel that I need the capabilities of Microsoft SQL Server and so I've been looking at SQLite and MySQL. I'

Re: [sqlite] R: R: Crypto lib for Sqlite - suggest required

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/10/2011 06:41 AM, Adam DeVita wrote: > The HASP envelope does prevent an executable from running with a > debugger open. Only in simple cases. Since the executable and the key are in the hands (and total control) of the adversary, they can do a

Re: [sqlite] How to use distinct in group_concat, together with specified separator

On 10 January 2011 15:18, smart sl wrote: > Thank you. It's an indirect way, and it works. Could it be the same > efficient as "select group_concat(distinct data separator '-') from tst" > like in mysql? I'm not quite understand the actual functionality inside, so > this is significant to me. I k

Re: [sqlite] How to use distinct in group_concat, together with specified separator

Thank you. It's an indirect way, and it works. Could it be the same efficient as "select group_concat(distinct data separator '-') from tst" like in mysql? I'm not quite understand the actual functionality inside, so this is significant to me. 2011/1/10 Simon Davies > On 10 January 2011 14:22, s

Re: [sqlite] How to use distinct in group_concat, together with specified separator

On 10 January 2011 14:22, smart sl wrote: > Is there any one can help? SQLite version 3.6.11 Enter ".help" for instructions sqlite> sqlite> create table tst( data integer ); sqlite> sqlite> insert into tst values( 1 ); sqlite> insert into tst values( 2 ); sqlite> insert into tst values( 3 ); sqli

Re: [sqlite] R: R: Crypto lib for Sqlite - suggest required

Just to add my $0.02 We use http://www.safenet-inc.com/ HASP HL Encryption. (We use HASP keys for end user products so it was 'free' to my internal product tracking system db.) This key allows the exe to get encrypted and optionally a data file as well. The encryption of the program provides us

Re: [sqlite] How to use distinct in group_concat, together with specified separator

Is there any one can help? 2011/1/7 smart sl > In "Aggregate Functions" of SQLite Docs, it's said that: > In any aggregate function that takes a single argument, that argument can > be preceded by the keyword DISTINCT. > > Then how about two arguments circumstance when I want to use distinct and

Re: [sqlite] NOT NULL

There are a few practices you can use depending on how you want things to work. The way I deal with things is that if there is any sort of user interaction, checks and balances should be done at the UI end. Which means that if you require something to be filled in, don't let the user continue on.

Re: [sqlite] Using Bulk Insert in SQLite

On 10 Jan 2011, at 1:10pm, Sunil Bhardwaj wrote: > We have large number of records in memory and we are using SQLite in-memory > using C++. > > How can we use Bulk Insert to speed up the record insertion process in SQLite > in one transaction. CREATE TABLE ... BEGIN TRANSACTION INSERT ... I

[sqlite] Using Bulk Insert in SQLite

Hi We have large number of records in memory and we are using SQLite in-memory using C++. How can we use Bulk Insert to speed up the record insertion process in SQLite in one transaction. Please suggest. Thanks Sunil Bhardwaj Ext. 1125 (0120-2567001) 9818868910 _

Re: [sqlite] Tcl interface to the int sqlite3_open_v2 funtion's SQLITE_OPEN_READONLY flag?

On 10 Jan 2011, at 1:01pm, Fredrik Karlsson wrote: > I notice that the int sqlite3_open_v2 C function has a > SQLITE_OPEN_READONLY which allows opening a database in read only > mode. > Would it be possible to have this possibility in the Tcl interface > too? Perhaps similar to the way the "open"

[sqlite] Tcl interface to the int sqlite3_open_v2 funtion's SQLITE_OPEN_READONLY flag?

Hi, I notice that the int sqlite3_open_v2 C function has a SQLITE_OPEN_READONLY which allows opening a database in read only mode. Would it be possible to have this possibility in the Tcl interface too? Perhaps similar to the way the "open" command of Tcl specifies flags. This feature would be ve

Re: [sqlite] max length of integer?

On 10-01-11 13:09, Simon Slavin wrote: > On 10 Jan 2011, at 10:05am, KimTaein wrote: > >> What is the largest number that I can store in integer data type in sqlite? >> I was not able to find it on sqlite website. > You're right. It's not in the obvious place. You can, however, find it here: > >

Re: [sqlite] max length of integer?

On Mon, Jan 10, 2011 at 12:09:02PM +, Simon Slavin scratched on the wall: > > On 10 Jan 2011, at 10:05am, KimTaein wrote: > > > What is the largest number that I can store in integer data type in sqlite? Integers are 64-bit signed values, so the range is -2^63 to (2^63 - 1). > > I was not

Re: [sqlite] max length of integer?

On 10 Jan 2011, at 10:05am, KimTaein wrote: > What is the largest number that I can store in integer data type in sqlite? > I was not able to find it on sqlite website. You're right. It's not in the obvious place. You can, however, find it here:

[sqlite] max length of integer?

What is the largest number that I can store in integer data type in sqlite? I was not able to find it on sqlite website. Thanks ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mai

[sqlite] SQLITE_DEFAULT_FILE_PERMISSIONS

I have a linux application with daemons running under several uids. I wish them all to be able to access and modify an SQLite database. I am using the Perl DBI SQLite interface on a debian system. However, regardless of how permissively I set the umask in my code, the sqlite code will not create a

Re: [sqlite] Using Bulk Insert in SQLite

*here are summary code :inserting 100k in 5-7 sec* * * //Reading text file 1 in yarray2= filetext.Split(Environment.NewLine) //Reading text file 1 in yarray1 = filetext1.Split(Environment.NewLine) insert: Dim tx = cons.BeginTransaction() For y = j To x Dim strva

Re: [sqlite] Using Bulk Insert in SQLite

Sunil, Google is your friend: http://www.google.com/search?client=safari&rls=en&q=bulk+insert+sqlite&ie=UTF-8&oe=UTF-8 Regards, -- Tito On Jan 10, 2011, at 11:25 AM, Sunil Bhardwaj wrote: > Hi > > Please suggest, how can we implement Bulk Insert in SQLite. > > Thanks > Sunil Bhardwaj > Ext.

[sqlite] Using Bulk Insert in SQLite

Hi Please suggest, how can we implement Bulk Insert in SQLite. Thanks Sunil Bhardwaj Ext. 1125 (0120-2567001) 9818868910 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Advice on breaking trigger recursion?

On Fri, Jan 07, 2011 at 09:54:07PM -0600, Nicolas Williams wrote: > On Sat, Jan 08, 2011 at 01:29:23AM +, Simon Slavin wrote: > > On 8 Jan 2011, at 1:12am, Nicolas Williams wrote: > > > I need to use recursive triggers. In some cases I want to "normalize" > > > values of some columns of NEW be

Re: [sqlite] calculate difference of two times and show the result as double value

As you are using Acccess maybe you are using Olaf Schmidt's VB wrapper dhRichclient3 and in that case you do things like this: select (cast(left$('16:30:00', 2) as integer) + cast(mid$('16:30:00', 4, 2) as real) / 60) - (cast(left$('08:00:00', 2) as integer) + cast(mid$('08:00:00', 4, 2) as real)

Re: [sqlite] Using local variables through sqlite

Thanks Igor, I coded in the second syntax previously, but the first syntax looks good for me. I will use that one for my project. Thanks for helping me out guys. Cheers Venkat From: Igor Tandetnik To: sqlite-users@sqlite.org Sent: Sat, January 8, 2011 3:3

Re: [sqlite] calculate difference of two times and show the result as double value

On 10-01-11 08:42, Sven wrote: > Dear SQLite users, > > I've created a Microsoft Access 2003 database with three complex queries > written in pure SQL language. The function of the database is to > document and calculate the daily work-time. > > Today I want to convert this database to SQLite b

Re: [sqlite] calculate difference of two times and show the result as double value

On 10 January 2011 07:42, Sven wrote: > Dear SQLite users, > > I've created a Microsoft Access 2003 database with three complex queries > written in pure SQL language. The function of the database is to > document and calculate the daily work-time. . . . > and returns the following data '8.5'. Whi