Re: [sqlite] Altering views, keeping triggers

--- T <[EMAIL PROTECTED]> wrote: > As mentioned, all the associated triggers are deleted. IS there a way > to systematically locate and keep them? Such as: > > set viewDefinition to SQLExec( "select sql || ';' from sqlite_master > where type = 'view' and name = 'MyView';" ) > set

Re: [sqlite] Altering views, keeping triggers

Oops, sorry, that first paragraph should have read as below (I said "trigger" once where I meant "view"): Short version of question: I frequently want to alter view definitions, such as renaming them or changing the column definitions. The only way to do this is to drop the old view and

[sqlite] Altering views, keeping triggers

Hi all, Short version of question: I frequently want to alter view definitions, such as renaming them or changing the column definitions. The only way to do this is to drop the old trigger and create a new one (eg with the same name). The problem is that when I do this, any associated

Re: [sqlite] How to unsubscribe from his group?

mos wrote: Star Trek Epsiode 64, Season 3: The Tholian Web - The Real Unpublished Story When the problem gets fixed, I assume you will announce, "Ah, the renowned Tholian punctuality." Gerry - To unsubscribe, send

RE: [sqlite] Need To Export A Table From a SQLite Database as a TAB Character Delimited Text File

On Mon, 13 Aug 2007, Rich Shepard wrote: And does it work if you specify "\t" as the spacer? Lee, Better yet, try this from the command line: .m tabs .o myfilename.txt select * from mytable .m list .o stdout The .mode command allows you to specify tabs as the values separator, just

RE: [sqlite] Need To Export A Table From a SQLite Database as a TAB Character Delimited Text File

On Mon, 13 Aug 2007, Lee Crain wrote: I actually keyed a TAB character, not spaces. Lee, And does it work if you specify "\t" as the spacer? Rich -- Richard B. Shepard, Ph.D. |The Environmental Permitting Applied Ecosystem Services, Inc.|

Re: [sqlite] Need To Export A Table From a SQLite Database as a TAB Character Delimited Text File

I think .mode tabs does much the same as .separator "\t" but without the ambuguity of single vs double quotes. -Clark - Original Message From: "Griggs, Donald" <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Monday, August 13, 2007 2:37:06 PM Subject: RE: [sqlite] Need To

RE: [sqlite] Need To Export A Table From a SQLite Database as a TAB Character Delimited Text File

Rich, I actually keyed a TAB character, not spaces. Thanks for your response, Lee Crain ___ -Original Message- From: Rich Shepard [mailto:[EMAIL PROTECTED] Sent: Monday, August 13, 2007 4:22 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] Need To Export A

Re: [sqlite] Proposed incompatible change to SQLite

[EMAIL PROTECTED] wrote: sqlite3_soft_heap_limit(); sqlite3_enable_shared_cache(); sqlite3_release_memory(); As currently implemented (and documented), these routines only work across database connections in the same thread. We propose to modify this so that these routines work

Re: [sqlite] Object Oriented Question About Adding a vector inside the callback function

Thanks Igor I used your solution and it work. Char* was the problem. I'll use strings from now on . Stephen Igor Mironchick <[EMAIL PROTECTED]> wrote: I think problem is in use char * as parameter in push function. For that reason I use std::string always. Look, in callback2 SQLite

Re: [sqlite] Storing monetary values and calculations

If you store money as an integer with an "implied decimal point" (a familiar method for old-time COBOL programmers) it will work. We have added a DECIMAL type to Sqlite. This stores fixed point numbers in ASCII display format and performs accurate artithmetic and presents nicely from HTML.

RE: [sqlite] Need To Export A Table From a SQLite Database as a TAB Character Delimited Text File

On Mon, 13 Aug 2007, Lee Crain wrote: No, I'm on Windows XP. My condolences. I am running SQLite 3.3.17. And I did enter exactly: separator ''; where the gap between the single quotes is an actual T A B character. Maybe that's cheating. :^) Lee, Only yourself. The '\t' (or

Re: [sqlite] How to unsubscribe from his group?

Let me get this straight: there are no email filters on the Enterprise? They've figured out how to travel at Warp 9, but can't automatically delete messages sent from "sqlite-users@sqlite.org"? I'd say they got what they deserved. Jason On Aug 13, 2007, at 4:04 PM, mos wrote: Star Trek

RE: [sqlite] Need To Export A Table From a SQLite Database as a TAB Character Delimited Text File

No, I'm on Windows XP. ?? I am running SQLite 3.3.17. And I did enter exactly: separator ''; where the gap between the single quotes is an actual T A B character. Maybe that's cheating. :^) Lee Crain _ -Original Message- From: Griggs, Donald

[sqlite] Storing monetary values and calculations

Hi there, Currently I am using a SQLite 3.x database that stores and calculates currency values using the column type NUMERIC (which I believe has a FLOAT affinity). However this leads to errors in storing values values in floating point representation. I guess there is no planned support for

Re: [sqlite] How to unsubscribe from his group?

Star Trek Epsiode 64, Season 3: The Tholian Web - The Real Unpublished Story Kirk and the ship are trapped in a parallel universe by the weakening of the surrounding fabric of space, and the computer calculates that the next time of spatial interphase will occur in two hours. Meanwhile, the

RE: [sqlite] How to unsubscribe from his group?

I don't think Dr. Hipp has a tech support center ;). Be patent. In my experience, he reads these emails and will fix whatever needs fixing on his end. Shawn M. Downey MPR Associates 10 Maxwell Drive, Suite 204 Clifton Park, New York 12065 518-831-7544 (work) 860-508-5015 (cell)

RE: [sqlite] Need To Export A Table From a SQLite Database as a TAB Character Delimited Text File

Regarding .separator "\t" Vs .separator '\t' Cool. BTW, It seems to require double quotes for me, running Windoze XP, sqlite3.exe version 3.4.0, else the separator becomes literally a backslash followed by the letter t. I'm guessing you're using *NIX and guessing it requires single

Re: [sqlite] How to unsubscribe from his group?

Oh Great! Now, you're stuck too? I hate to tell ya, but it seems like we've become victims of a technical support black hole.* You see, there appears to be a "bug" in the unsubscribe function. Their response *may* be to fix the software, or start using different software. But I envision -

RE: [sqlite] Need To Export A Table From a SQLite Database as a TAB Character Delimited Text File

Donald, After a small change ("" to '') for the .separator command, everything worked very well. Thanks for taking the time to respond, Lee Crain __ -Original Message- From: Griggs, Donald [mailto:[EMAIL PROTECTED] Sent: Monday,

RE: [sqlite] Need To Export A Table From a SQLite Database as a TAB Character Delimited Text File

Hi Lee, Regarding: ...I need to export a table from a SQLite database as a TAB character delimited text file. Try the following .separator "\t" .output ExportFile.txt select * from MyTable; .output stdout - To

[sqlite] Need To Export A Table From a SQLite Database as a TAB Character Delimited Text File

I need to export a table from a SQLite database as a TAB character delimited text file. After reading the SQLite documentation, and specifically, the command line interface, I haven't found anything appropriate. Is there a way to do this from the command line interface? If so how? Thanks, Lee

[sqlite] How to unsubscribe from his group?

I've sent half a dozen emails to this address "[EMAIL PROTECTED]" over the past few days and I'm still getting email. Is there a trick to it? Mike - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] any way to find out how many current connections to db?

On 8/13/07, Chase <[EMAIL PROTECTED]> wrote: > > is there any way (in c/c++) to find out how many current connections > there are to a database that i am connected to? > > i'd like to do some housekeeping on the database every so often, but > only if there's no one else connected to it at the

[sqlite] Re: Re: Auto Increment of Integer Primary Key

chetana bhargav wrote: I think if it would have been unsigned we could have got more range, as anyways negative numbers doesn't make sense as PK's, of course reaching the 2^63-1 is remote (or probably impossible) You can interpret it as unsigned if you need to. Just cast the value to

Re: [sqlite] any way to find out how many current connections to db?

Rather than count the number of connections which would be prone to failure due to race conditions, you should do this instead: BEGIN EXCLUSIVE; -- run whatever SQL statements you want here, -- or copy the database file. COMMIT; Just schedule this job off-hours when people are not likely

[sqlite] any way to find out how many current connections to db?

is there any way (in c/c++) to find out how many current connections there are to a database that i am connected to? i'd like to do some housekeeping on the database every so often, but only if there's no one else connected to it at the time. any ideas? thanks. - chase

Re: [sqlite] Problem loading extension in Delphi (FTS2)

Might be a typo, but your declaration defines the calling convention as 'stdcall' (instead of 'cdecl'), was your sqlite3.dll custom built with this calling convention? I don't think much of sqlite would work with stdcall. On 13/08/07, Andre du Plessis <[EMAIL PROTECTED]> wrote: > >

Re: [sqlite] Re: Auto Increment of Integer Primary Key

I think if it would have been unsigned we could have got more range, as anyways negative numbers doesn't make sense as PK's, of course reaching the 2^63-1 is remote (or probably impossible) -x- Chetana - Original Message From: Igor Tandetnik <[EMAIL PROTECTED]> To: SQLite

[sqlite] Re: Auto Increment of Integer Primary Key

Sreedhar.a wrote: "create table Test(id integer primary key,player char);" "insert into Test(id,player) values(2,'surya');" "insert into Test(id,player) values(9223372036854775807,'sree');" "insert into Test(id,player) values(9223372036854775808,'sree1');" "select * from Test;" The result is

[sqlite] Auto Increment of Integer Primary Key

Hi, I am working with sqlite 3.3.6 version. I have defined the macro SQLITE_OMIT_FLOATING_POINT. 1. this is my test program "create table Test(id integer primary key,player char);" "insert into Test(id,player) values(2,'surya');" "insert into Test(id,player)

RE: [sqlite] Problem loading extension in Delphi (FTS2)

sqlite3_enable_load_extension : function (sqlite3_value: Pointer; AOnOff: Integer): Integer; cdecl; sqlite3_load_extension : function (sqlite3_value: Pointer; AFileName, AProcedure : PChar; var AErrorMsg : PChar): Integer; cdecl; var Error : Pchar; ConnectionHandle : Pointer; // Handle

[sqlite] datetime type

Hi everybody, I have a database with a datatype datetime where default value is not set. And then I have a java program that will insert some entries in this database but in the column of the datetime type the value will be entered false. I am reading some information from a file and there i get