Re: [sqlite] How can I know whether the fields in the table by sql statement?

On Tue, Feb 02, 2010 at 10:35:22AM +0800, hongbin.gao scratched on the wall: > Usually, in SQL-server 2000, when I update fields of the table, I can use > such sql statement: > > > > if not EXISTS(select T.[name],F.[name] from sysobjects T left join > syscolumns F on T.[id]=F.[id] where T.[name

[sqlite] How can I know whether the fields in the table by sql statement?

Usually, in SQL-server 2000, when I update fields of the table, I can use such sql statement: if not EXISTS(select T.[name],F.[name] from sysobjects T left join syscolumns F on T.[id]=F.[id] where T.[name]='table_A' and F.[name]='field_A') alter table table_A add field_A varchar(20) not null d

Re: [sqlite] Searching for a LIKE '[0-9]%' equivalence in sqlite

On Tue, Feb 02, 2010 at 12:55:34AM +0100, Oliver Peters scratched on the wall: > Am Montag, den 01.02.2010, 22:55 +0100 schrieb Jean-Christophe > Deschamps: > > [...] > > > > Try this: > > > > SELECT * FROM mytable WHERE myfield glob '[0-9]*' > > thank you for opening my eyes - it seems that I

Re: [sqlite] Searching for a LIKE '[0-9]%' equivalence in sqlite

uses the Unix file globbing *** syntax *** It is the SYNTAX that it uses, not the UNIX FILE GLOBBING =) On 2/1/10, Oliver Peters wrote: > Am Montag, den 01.02.2010, 22:55 +0100 schrieb Jean-Christophe > Deschamps: > > [...] >> >> Try this: >> >> SELECT * FROM mytable WHERE myfield glob '[0-9]*'

Re: [sqlite] Searching for a LIKE '[0-9]%' equivalence in sqlite

Am Montag, den 01.02.2010, 22:55 +0100 schrieb Jean-Christophe Deschamps: [...] > > Try this: > > SELECT * FROM mytable WHERE myfield glob '[0-9]*' > thank you for opening my eyes - it seems that I never read http://www.sqlite.org/lang_expr.html#glob with total awareness. "The GLOB operator

Re: [sqlite] Searching for a LIKE '[0-9]%' equivalence in sqlite

On 1 Feb 2010, at 9:49pm, flakpit wrote: > To to get columns that begin with a number range or any number, I would use > in SQL server: > > SELECT * FROM mytable WHERE myfield LIKE '[0-9]%' > > This obviously doesn't work in sqlite and I have been searching for an > equivalence. SELECT * FROM

Re: [sqlite] Searching for a LIKE '[0-9]%' equivalence in sqlite

flakpit wrote: > > To to get columns that begin with a number range or any number, I would > use in SQL server: > > SELECT * FROM mytable WHERE myfield LIKE '[0-9]%' > > This obviously doesn't work in sqlite and I have been searching for an > equivalence. > Thank you for your kind assistanc

Re: [sqlite] Searching for a LIKE '[0-9]%' equivalence in sqlite

On Mon, Feb 01, 2010 at 01:49:59PM -0800, flakpit scratched on the wall: > > To to get columns that begin with a number range or any number, I would use > in SQL server: > > SELECT * FROM mytable WHERE myfield LIKE '[0-9]%' Use "...WHERE myfield GLOB '[0-9]*' " -j -- Jay A. Kreibich <

Re: [sqlite] Searching for a LIKE '[0-9]%' equivalence in sqlite

>To to get columns that begin with a number range or any number, I >would use >in SQL server: > >SELECT * FROM mytable WHERE myfield LIKE '[0-9]%' > >This obviously doesn't work in sqlite and I have been searching for an >equivalence. Try this: SELECT * FROM mytable WHERE myfield glob '[0-9]*'

[sqlite] Searching for a LIKE '[0-9]%' equivalence in sqlite

To to get columns that begin with a number range or any number, I would use in SQL server: SELECT * FROM mytable WHERE myfield LIKE '[0-9]%' This obviously doesn't work in sqlite and I have been searching for an equivalence. -- View this message in context: http://old.nabble.com/Searching-for-

Re: [sqlite] Getting an error "table insert failed for eventLog" any idea what is the reason

On 1 Feb 2010, at 4:37pm, Vasanta wrote: > Here the issue is comes when it imports configuration, the script throws an > error, since this is users group, I thought some esprts who can figure out > the issue from script, DON'T YOU? Sorry, but you are using scripts someone else produced and repor

Re: [sqlite] Update/Delete problem

Are you sure that Spiceworks or SQLLite Database Browser commit your changes? What happens if you close those applications and restart it - will they see their own changes? If they will and they still won't see other application's changes then you can be sure that you're looking at different databa

[sqlite] Update/Delete problem

Hi, I'm completely new to SQLLite, and I'm very sorry if I ask a trivial question. I'm using Spiceworks which again uses SQLLite as backend database. I've made some updates and deletions to the records using the freeware SQLLite Database Browser application. If I the open Spiceworks application

Re: [sqlite] Getting an error "table insert failed for eventLog" any idea what is the reason

No, we don't. We can help sometimes when script contains about 5 short lines of code, but not with some big complicated scripts. For help with those scripts you should go to script authors. This group is for problems with using SQLite - when you see that SQLite behaves not in a way you expect or r

Re: [sqlite] poor execution time with select queries

By the way these queries execute very fast in MySQL, and one point I noticed is that a query is slow if tries to join two of the same tables, i.e. pte_atm r1, pte_atm r2, pte_drug r3 may this be the problem? _alenD alenD wrote: > > Hi all, > I wrote a small C code to execute a number of select

Re: [sqlite] Getting an error "table insert failed for eventLog" any idea what is the reason

Here the issue is comes when it imports configuration, the script throws an error, since this is users group, I thought some esprts who can figure out the issue from script, DON'T YOU? On Sat, Jan 30, 2010 at 11:42 AM, Simon Slavin wrote: > > On 30 Jan 2010, at 4:00pm, Vasanta wrote: > > >

Re: [sqlite] parallelizing an update

On Sat, Jan 30, 2010 at 10:36:56AM +0100, Sylvain Pointeau wrote: > echo "begin transaction" >> update.sql > > sqlite3 -separator $'\t' sample.db 'select rowid, item from foo;' | > while read rowid item ; do > status=$(long_running_process "${item}" ) > echo "update foo set status=${status} wher

Re: [sqlite] poor execution time with select queries

On Mon, Feb 01, 2010 at 07:49:50AM -0800, alenD scratched on the wall: > > Hi all, > I wrote a small C code to execute a number of select queries. If you're doing a number of similar queries, look at the prepare/bind/step interface. It is generally better than the exec() interface. > SELE

[sqlite] poor execution time with select queries

Hi all, I wrote a small C code to execute a number of select queries. Select execution code is rc = sqlite3_exec(db, "BEGIN;", callback, 0, &zErr); for(eQ = 0; eQ < queries.size(); eQ++){ cout << "Executing " << eQ << "/" << queries.size() << "\t" << queries[eQ].q

Re: [sqlite] system.data.sqlite & encryption

I think you should probably ask this question on the System.data.sqlite support forums at http://sqlite.phxsoftware.com/forums I'm not familiar with enough with their ADO .NET implementation to answer your question. -Shane On Sun, Jan 31, 2010 at 11:54 AM, Sylvain Pointeau < sylvain.point...@g

Re: [sqlite] overwritten iphone contacts

On 1 Feb 2010, at 9:42am, Jean-Denis Muys wrote: > On 1/30/10 19:21 , "Roger Binns" wrote: > >> ishak kalkavan wrote: >>> file I could see phone numbers and contact names but in a very complex way. >>> I couldnt find any way to match those data. >> >> The file format is documented at http://ww

Re: [sqlite] overwritten iphone contacts

On 1/30/10 19:21 , "Roger Binns" wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > ishak kalkavan wrote: >> file I could see phone numbers and contact names but in a very complex way. >> I couldnt find any way to match those data. > > The file format is documented at http://www.sqli