Re: [sqlite] sqlite3 question

If you look at shell.c in the code implementing sqlite3.exe, you will find a procedure named resolve_backslashes(char *z) which performs a substitution of '\'-escaped characters that is similar to the C/C++ interpretation of string literals. That is what has sucked up those backslashes. Getting

Re: [sqlite] read_uncommitted does not work ?

冶晶邓 wrote: > i'm using sqlite for a special mode: > 1.one process write > 2.other processes read > now i hope all read will not be blocked by write, because i'm sure the > writer won't update existing data, it only insert new data, so reader need > not wait for it. SQLite

[sqlite] sqlite3 question

I'm not sure if this is an sqlite3 question or WIndows. I am trying to use the .output command to send the output from a SELECT statement to a file on WIndows 7. The .output command looks like: .output C:\Users\Pete\AppData\Local\Temp\sqlite3out.txt When the SELECT statement is executed the

[sqlite] read_uncommitted does not work ?

i'm using sqlite for a special mode: 1.one process write 2.other processes read now i hope all read will not be blocked by write, because i'm sure the writer won't update existing data, it only insert new data, so reader need not wait for it. follow the docs, i run the SQL "PRAGMA read_uncommitted

Re: [sqlite] Is there any API for counting number of rows in a particular table.

OK, so how you open those then with SQLiteRoot? RBS On Mon, Jan 30, 2012 at 9:46 PM, Tim Streater wrote: > On 30 Jan 2012 at 16:37, Bart Smissaert wrote: > >> How do you make it open database files that have an extension other than >> .slt? >

Re: [sqlite] Is there any API for counting number of rows in a particular table.

On 30 Jan 2012 at 16:37, Bart Smissaert wrote: > How do you make it open database files that have an extension other than .slt? Eh? None of my SQLite databases has any extension at all. -- Cheers -- Tim ___ sqlite-users

Re: [sqlite] SQLite setup error - Rails/CentOS

On Mon, Jan 30, 2012 at 2:39 PM, Joshua Scott wrote: > Hello, > > I am new to SQLlite in setting it up I am getting the following error when > running the rake db:migrate command: > > usr/local/rvm/gems/ruby-1.9.3-p0/gems/sqlite3-1.3.5/lib/sqlite3/sqlite3_native.so: >

[sqlite] SQLite setup error - Rails/CentOS

Hello, I am new to SQLlite in setting it up I am getting the following error when running the rake db:migrate command: usr/local/rvm/gems/ruby-1.9.3-p0/gems/sqlite3-1.3.5/lib/sqlite3/sqlite3_native.so: undefined symbol: sqlite3_open_v2 Any help you can provide would be awesome. Thanks so

Re: [sqlite] VS2008 design support error

Simon Slavin wrote: > > You might want to ask this on a forum about VS2010. There's apparently > nothing wrong with the SQLite element. > The designer components are part of System.Data.SQLite and are currently supported by me. -- Joe Mistachkin ___

Re: [sqlite] VS2008 design support error

Levi Haskell wrote: > > Is there a log file I can look up somewhere on the disk where I can > get more specific error from? > Yes, logging can be enabled as described in: http://blogs.msdn.com/b/dr._ex/archive/2006/12/14/debugging-package-load-fai lures.aspx -- Joe Mistachkin

Re: [sqlite] VS2008 design support error

On 30 Jan 2012, at 6:04pm, Levi Haskell wrote: > Interestingly it works fine with VS2010 on the same machine. Is there a log > file I can look up somewhere on the disk where I can get more specific error > from? You might want to ask this on a forum about VS2010. There's apparently nothing

Re: [sqlite] VS2008 design support error

I tried it both ways, even tried putting SQLite.Designer.dll into GAC (which as I now understand is not required). Still the same result. Interestingly it works fine with VS2010 on the same machine. Is there a log file I can look up somewhere on the disk where I can get more specific error

Re: [sqlite] Incompatible versions of SQLite on same system

Joe, Thanks for the idea, but after a quick look at the ILDASM tool, I think it's beyond what I want to do to fix this problem (unlike the Dependency Walker tool, which I gave a spin). I guess I'll just have to wait for the HP and/or Intuit developers to solve the problem of incompatible

Re: [sqlite] Is there any API for counting number of rows in a particular table.

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 30/01/12 04:45, bhaskarReddy wrote: > Is there any API that will return number of rows (records) present in a > particular table. I want to access the table using its database name > and corresponding table. > > If possible give one example. You

Re: [sqlite] VS2008 design support error

Levi Haskell wrote: > > When I open VS2008 -> go to Server Explorer -> Add Connection -> Select > 'System...SQLite ... provider' I get the > following error: > Without more details it's tough to guess what the precise problem is (as package load failures are fairly generic and can be caused by a

[sqlite] VS2008 design support error

Just installed .NET3.5 32bit bundle v1.0.79.0 (on a 64bit Win7 machine). When I open VS2008 -> go to Server Explorer -> Add Connection -> Select 'System...SQLite ... provider' I get the following error: --- Microsoft Visual Studio --- Package

Re: [sqlite] Is there any API for counting number of rows in a particular table.

How do you make it open database files that have an extension other than .slt? RBS On 1/30/12, Fabio Spadaro wrote: > Hi > > 2012/1/30 bhaskarReddy > >> >> Its working with only table name. >> >> >> Regards, >> Bhaskar. > > > You could use a GUI to

Re: [sqlite] unresolved references when linking sqlite 3.7.9

On 2012-01-30 16:07, Richard Hipp wrote: > On Mon, Jan 30, 2012 at 9:46 AM, Marcel Stumpel wrote: > >> Hi, I am getting undefined references (see below) linking sqlite 3.7.9 for an ARM based target. I am using the arago toolsuite with glibc. Can anyone tell me what

Re: [sqlite] unresolved references when linking sqlite 3.7.9

On Mon, Jan 30, 2012 at 9:46 AM, Marcel Stumpel wrote: > > > Hi, > > I am getting undefined references (see below) linking sqlite > 3.7.9 for an ARM based target. > I am using the arago toolsuite with > glibc. > Can anyone tell me what I am doing wrong? > >

[sqlite] unresolved references when linking sqlite 3.7.9

Hi, I am getting undefined references (see below) linking sqlite 3.7.9 for an ARM based target. I am using the arago toolsuite with glibc. Can anyone tell me what I am doing wrong? ../lib/libsqlite.so: undefined reference to `fcntl64' ../lib/libsqlite.so: undefined reference to

Re: [sqlite] Problem with sqlite and codeblocks (mingw)

Am 28.01.2012 17:07, schrieb Robert Gdula: No becuase, I need encryption and it is not supported bu wxslite3, Not true. wxSQLite3 supports encryption using the official SQLite API. wxSQLite3 even provides it's own SQLite encryption extension implementation (supporting 128 bit and 256 bit AES

Re: [sqlite] joint two table

Pawl wrote: > I use TIMESTAMP datatype, disply format is according to local cuture setting > ex: 27.1.2012 13:50:32. > all compare type is same. There is no TIMESTAMP datatype in SQLite. Your dates are stored as strings, and are being compared using regular alphabetical

Re: [sqlite] joint two table

Pawl wrote: > > I need to joint two table > > This table show change set up limts value. > > ++---+---+ >> edittime | lim_lower | lim_upper | > ++---+---+ >> 01.01.2011 | 0.8 | 12.1 | >

Re: [sqlite] Is there any API for counting number of rows in a particular table.

Hi 2012/1/30 bhaskarReddy > > Its working with only table name. > > > Regards, > Bhaskar. You could use a GUI to facilitate these requests, and your this regard we propose to test my application it is freeware: www.sqliteroot.com -- Fabio

Re: [sqlite] Is there any API for counting number of rows in a particular table.

Its working with only table name. Regards, Bhaskar. Igor Tandetnik wrote: > > bhaskarReddy wrote: >> I am getting an error as, >> >> sqlite> select count (*) from LR6000.ONTtable; >> Error: no such table: LR6000.ONTtable > > Just do "select count (*) from ONTtable;" >

Re: [sqlite] Is there any API for counting number of rows in a particular table.

bhaskarReddy wrote: > I am getting an error as, > > sqlite> select count (*) from LR6000.ONTtable; > Error: no such table: LR6000.ONTtable Just do "select count (*) from ONTtable;" -- Igor Tandetnik ___ sqlite-users mailing list

Re: [sqlite] Is there any API for counting number of rows in a particular table.

I am getting an error as, sqlite> select count (*) from LR6000.ONTtable; Error: no such table: LR6000.ONTtable Regards, Bhaskar. Simon Slavin-3 wrote: > > > On 30 Jan 2012, at 12:45pm, bhaskarReddy wrote: > >> Is there any API that will return number of rows (records) >> present

Re: [sqlite] Is there any API for counting number of rows in a particular table.

On 30 Jan 2012, at 12:45pm, bhaskarReddy wrote: > Is there any API that will return number of rows (records) > present in a particular table. I want to access the table using its database > name and corresponding table. Nope. It's quite difficult doing that in SQLite because of how

Re: [sqlite] joint two table

I use TIMESTAMP datatype, disply format is according to local cuture setting ex: 27.1.2012 13:50:32. all compare type is same. Pavel Simon Slavin-3 wrote: > > > On 30 Jan 2012, at 11:16am, Pawl wrote: > >> | 05.01.2011 | 7.7 | 01.05.2011| 0.7 | 12.1 | >>

Re: [sqlite] Delete data base.

Tank you very much simon. Regards, Bhaskar Reddy. Simon Slavin-3 wrote: > > > On 30 Jan 2012, at 11:42am, bhaskarReddy wrote: > >> Can any one tell me how to delete entire database with its name, >> using sqlite3 API. > > You can't. But unless you have the database open using

[sqlite] Is there any API for counting number of rows in a particular table.

Hi Friends, Is there any API that will return number of rows (records) present in a particular table. I want to access the table using its database name and corresponding table. If possible give one example. Regards, Bhaskar Reddy. -- View this message in context:

Re: [sqlite] Delete data base.

On 30 Jan 2012, at 11:42am, bhaskarReddy wrote: > Can any one tell me how to delete entire database with its name, > using sqlite3 API. You can't. But unless you have the database open using SQLite the entire database just one file. Use whatever language feature you have for deleting

Re: [sqlite] joint two table

On 30 Jan 2012, at 11:16am, Pawl wrote: > | 05.01.2011 | 7.7 | 01.05.2011| 0.7 | 12.1 | > ++---+---+--+---+ > ... > > I tried to use cmd JOIN in this content, but didn't work it. > > SELECT JX.*,JX_lim.* FROM JX JOIN JX_lim ON

Re: [sqlite] How do I contribute a port?

On Mon, Jan 30, 2012 at 5:51 AM, David Henry wrote: > I've just managed to port SQLite to an 50MHz ARM with 256KB ROM and 96KB > RAM. > > It was an interesting exercise, not too painful and quite successful. I > have > tables of 1 rows, foreign keys, indices etc.

[sqlite] Delete data base.

Hi Friends, Can any one tell me how to delete entire database with its name, using sqlite3 API. Regards, Bhaskar Reddy. -- View this message in context: http://old.nabble.com/Delete-data-base.-tp33228500p33228500.html Sent from the SQLite mailing list archive at Nabble.com.

[sqlite] joint two table

Hi, I need to joint two table This table show change set up limts value. ++---+---+ | edittime | lim_lower | lim_upper | ++---+---+ | 01.01.2011 | 0.8 | 12.1 | ++---+---+ | 05.01.2011 | 0.7

[sqlite] How do I contribute a port?

I've just managed to port SQLite to an 50MHz ARM with 256KB ROM and 96KB RAM. It was an interesting exercise, not too painful and quite successful. I have tables of 1 rows, foreign keys, indices etc. Performance is reasonable and it seems to be stable. At this stage I'd like to contribute