Re: [sqlite] Precompiled download of sqlite3 (v3.3.13) for Linux

2007-03-08 Thread G. Roderick Singleton
On Thu, 2007-03-08 at 12:14 -0500, Friedman, Eluzor wrote: > Hi, > > There is one for windows. Where is the one for Linux? > > Thanks > > PS I am a newbie. > Same page as for the windows versions, http://sqlite.org/download.html -- G. Roderick Singleton <[

Re: [sqlite] stupid man's manual to sqlite?

2007-03-08 Thread G. Roderick Singleton
ell very useful over the past 5 years. You might try http://safari.oreilly.com/0596004818 -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech smime.p7s Description: S/MIME cryptographic signature

Re: [sqlite] Abuse of the SQLite website

2007-01-30 Thread G. Roderick Singleton
gt; Richard, You might like to explore using mod_security with some custom rules to help eliminate problems like this. See http://www.modsecurity.org/ -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech smime.p7s Description: S/MIME cryptographic signature

Re: [sqlite] How to conditionally drop a table?

2007-01-25 Thread G. Roderick Singleton
On Thu, 2007-01-25 at 18:40 +, Martin Jenkins wrote: > G. Roderick Singleton wrote: > > On Thu, 2007-01-25 at 11:13 -0600, John Stanton wrote: > > > >> If you find a way to drop a table which dosn't exist. let us know how > >> you do it. > >>

Re: [sqlite] How to conditionally drop a table?

2007-01-25 Thread G. Roderick Singleton
On Thu, 2007-01-25 at 11:13 -0600, John Stanton wrote: > If you find a way to drop a table which dosn't exist. let us know how > you do it. > > G. Roderick Singleton wrote: > > On Thu, 2007-01-25 at 10:35 -0500, Anderson, James H (IT) wrote: > > > >>

Re: [sqlite] How to conditionally drop a table?

2007-01-25 Thread G. Roderick Singleton
On Thu, 2007-01-25 at 10:35 -0500, Anderson, James H (IT) wrote: > I need a way to drop a table only if that table exists. How would I do > that? > > Thanks, Are you asking if http://sqlite.org/lang_droptable.html works or have you had problems? -- G. Roderick Singleton <[EMAIL P

RE: [sqlite] date - SQL extraction from day, month and year

2006-12-26 Thread G. Roderick Singleton
please destroy and notify sender. Sender does > not intend to waive confidentiality or privilege. Use of this email is > prohibited when received in error. > > --------- > To unsubscribe, send email to [EMAIL PROTECTED] >

Re: [sqlite] INSERT Abilities?

2006-10-25 Thread G. Roderick Singleton
> For each columna in tabla.Fields > field_type = getSQLiteFieldType(columna, False) > If InStr(field_type, "-- error") = 1 Then > ts.writeline field_type > End If > Next > > Call exportDatabaseTable(db, tabla, ts) > End If > Next > > exportaReferencias db,ts > > ts.writeline "QUIT;" 'Si no, se queda > ts.close > > db.Close > wrkJet.Close > Exit Sub > > DB_Error: > MsgBox "Could not open database " & database_path & ". Check the path and > permissions." > > End Sub > > Public Sub Main(mdb_db) > > Dim outfile > 'keywords i took from sqlite/tokenizer.c > sql_keywords1 = Array( _ > "ABORT", "AFTER", "ALL", "AND", "AS", "ASC", "ATTACH", _ > "BEFORE", "BEGIN", "BETWEEN", "BY", "CASCADE", "CASE", _ > "CHECK", "CLUSTER", "COLLATE", "COMMIT", "CONFLICT", _ > "CONSTRAINT", "COPY", "CREATE", "CROSS", "DATABASE", _ > "DEFAULT", "DEFERRED", "DEFERRABLE", "DELETE", _ > "DELIMITERS", "DESC", "DETACH", "DISTINCT", "DROP", _ > "END", "EACH", "ELSE", "EXCEPT", "EXPLAIN", "FAIL", _ > "FOR", "FOREIGN", "FROM", "FULL", "GLOB", "GROUP" _ > ) > sql_keywords2 = Array( _ > "HAVING", "IGNORE", "IMMEDIATE", "IN", "INDEX", _ > "INITIALLY", "INNER", "INSERT", "INSTEAD", "INTERSECT", _ > "INTO", "IS", "ISNULL", "JOIN", "KEY", "LEFT", "LIKE", _ > "LIMIT", "MATCH", "NATURAL", "NOT", "NOTNULL", "NULL", _ > "OF", "OFFSET", "ON", "OR", "ORDER", "OUTER", "PRAGMA", _ > "PRIMARY", "RAISE", "REFERENCES", "REPLACE", "RESTRICT", _ > "RIGHT", "ROLLBACK", "ROW", _ > "SELECT", "SET", "STATEMENT", "TABLE", "TEMP", _ > "TEMPORARY", "THEN", "TRANSACTION", "TRIGGER", _ > "UNION", "UNIQUE", "UPDATE", "USING", "VACUUM", _ > "VALUES", "VIEW", "WHEN", "WHERE" _ > ) > > > If Right(mdb_db, 4) <> ".mdb" Then > outfile = mdb_db & ".sql" > Else > outfile = Replace(mdb_db, ".mdb", ".sql") > End If > > Call exportDatabase(mdb_db, "admin", "", outfile) > > End Sub > > main "lienzoSinSorolla.mdb" -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech smime.p7s Description: S/MIME cryptographic signature

Re: [sqlite] High Ascii in path causes database load failures

2006-10-12 Thread G. Roderick Singleton
them to SQLite. I suspect this is a Windows problem rather than one with SQLite. The OpenOffice.org QA people have encountered and similar problem and isolated it to Windows. See http://www.openoffice.org/issues/show_bug.cgi?id=67649 -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech smime.p7s Description: S/MIME cryptographic signature

Re: [sqlite] Regarding removing create view and some other components in SQLite

2006-10-06 Thread G. Roderick Singleton
r the work to put this in, you want it gone :-) May I suggest you check out http://sqlite.org/support.html particularly the professional support section. All this assumes you do not have staff to do the programming. -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech smime.p7s Description: S/MIME cryptographic signature

[sqlite] Prepared statements and temp ffiles

2006-09-06 Thread G. Roderick Singleton
statements but need some pointers, please. -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech smime.p7s Description: S/MIME cryptographic signature

Re: [sqlite] Major projects using SQLite

2006-07-14 Thread G. Roderick Singleton
/20050405 > > Martin http://fedoraproject.org/wiki/Tools/yum -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech smime.p7s Description: S/MIME cryptographic signature

Re: [sqlite] How do you unsubscribe?

2006-06-01 Thread G. Roderick Singleton
On Thu, 2006-06-01 at 09:28 -0700, Richard Battagline wrote: > How do you unsubscribe? > Send an email to [EMAIL PROTECTED] which will return all the information about the list or check your sqlite mailbox for the welcome message. -- G. Roderick Singleton <[EMAIL PROTECTED]&g

Re: [sqlite] How to unsubscribe?

2006-01-13 Thread G. Roderick Singleton
; > Tom > This information is in the headers of every message. Look for List-Unsubscribe: <mailto:[EMAIL PROTECTED]> Remember to send it from the address with which you subscribed. -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech

Re: [sqlite] ANN: Sqlite3Explorer version 2.0 released

2005-10-03 Thread G. Roderick Singleton
t; the previous versions. > Report users : you will need to download an extra dll, it is bookmarked > in the above link. > > you can see the changes at a glance in > www.singular.gr/sqlite/changes.htm > > Interesting tool. Are sources available for porting to other OSes? I would

Re: [sqlite] Crash while creating a table

2005-10-01 Thread G. Roderick Singleton
ontact the application's support team for more information. > > I'm using SQLite 3.2.2 under Windows XP. > Does anyone see what could be wrong with that?? > > Thanks by advance for all the hints. > > D I would recommend an upgrade. See http://www.sqlite.org/changes.html -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech

Re: [sqlite] Survey: NULLs and GROUP BY

2005-09-01 Thread G. Roderick Singleton
On Thu, 2005-09-01 at 14:51 -0400, D. Richard Hipp wrote: > I'm rewriting the aggregate function processing in SQLite > (so that it runs faster and uses less memory) and I want to > make sure I get it right. In particular, I want to make > sure that SQLite handles NULLs in GROUP BY values the

Re: [sqlite] Survey: NULLs and GROUP BY

2005-09-01 Thread G. Roderick Singleton
On Thu, 2005-09-01 at 14:51 -0400, D. Richard Hipp wrote: > I'm rewriting the aggregate function processing in SQLite > (so that it runs faster and uses less memory) and I want to > make sure I get it right. In particular, I want to make > sure that SQLite handles NULLs in GROUP BY values the

Re: [sqlite] Please test prior to version 3.1.5. Was: Delete crashes with Version 3.2.4 in Windows XP

2005-08-24 Thread G. Roderick Singleton
t; What is your environment? The build scripts have hardly changed > since 3.2.2 so it is hard to imagine what might have broken... > I recall that running make test as root gives very strange results. -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech

Re: [sqlite] unit tests

2005-05-22 Thread G. Roderick Singleton
On Sun, 2005-05-22 at 14:01 -0500, Kurt Welgehausen wrote: > > How do I run the unit tests in Linux? > > make test Running make test as root can give odd results. Use a user account. -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech

Re: [sqlite] sqlite 3.2.1 lock-2.8 test hangs

2005-04-27 Thread G. Roderick Singleton
> concerned about? > > thanks, > > - jolan Thanks. -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech

Re: [sqlite] Windows question

2005-04-27 Thread G. Roderick Singleton
On Wed, 2005-04-27 at 16:57 -0400, D. Richard Hipp wrote: > On Wed, 2005-04-27 at 16:47 -0400, G. Roderick Singleton wrote: > > I ask because I have been building my own Linux releases from source > > and > > now have a need for a windows version I can send to a friend. &

[sqlite] Windows question

2005-04-27 Thread G. Roderick Singleton
the windowless guy with some basic directions like: you only need to get this binary or that binary. I believe I can figure out where to stuff the binary when I get it but even a hint or two in that direction wouldn't go amiss. TIA -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech

Re: [sqlite] 50MB Size Limit?

2005-04-11 Thread G. Roderick Singleton
ly 51,200,000 bytes. I'm stumped too. quotas? -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech

Re: [sqlite] Problem with compiling 3.2.1

2005-04-01 Thread G. Roderick Singleton
On Fri, 2005-04-01 at 15:11 -0500, G. Roderick Singleton wrote: > On Fri, 2005-04-01 at 14:37 -0500, D. Richard Hipp wrote: > > On Fri, 2005-04-01 at 09:06 -0500, G. Roderick Singleton wrote: > > > Running make test as a normal user, make test halts in wait() at the &g

Re: [sqlite] Problem with compiling 3.2.1

2005-04-01 Thread G. Roderick Singleton
On Fri, 2005-04-01 at 14:37 -0500, D. Richard Hipp wrote: > On Fri, 2005-04-01 at 09:06 -0500, G. Roderick Singleton wrote: > > Running make test as a normal user, make test halts in wait() at the > > following test: > > > > lock-2.1... Ok > > lock-2.2... Ok &g

[sqlite] Problem with compiling 3.2.1

2005-04-01 Thread G. Roderick Singleton
. Now ... Do prior releases need to be removed from the system before building the new? -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech

Re: [sqlite] Does sqlite has isnull function?

2005-03-06 Thread G. Roderick Singleton
//www.metrokc.gov/gis/kb/Content/SQLTipNull.htm it is. -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech

Re: [sqlite] Ticket 1153: make test on 3.1.3 throws 11 errors

2005-03-02 Thread G. Roderick Singleton
On Tue, 2005-03-01 at 12:59 -0500, G. Roderick Singleton wrote: > On Tue, 2005-03-01 at 12:37 -0500, D. Richard Hipp wrote: > > On Tue, 2005-03-01 at 11:36 -0500, G. Roderick Singleton wrote: > > > I tried posting via gmane and was unsuccessful as this mailing list > > &

Re: [sqlite] Ticket 1153: make test on 3.1.3 throws 11 errors

2005-03-01 Thread G. Roderick Singleton
On Tue, 2005-03-01 at 12:37 -0500, D. Richard Hipp wrote: > On Tue, 2005-03-01 at 11:36 -0500, G. Roderick Singleton wrote: > > I tried posting via gmane and was unsuccessful as this mailing list > > rejected the posting. I subsequently entered this ticket for evaluation. >

[sqlite] Ticket 1153: make test on 3.1.3 throws 11 errors

2005-03-01 Thread G. Roderick Singleton
. -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech

[sqlite] Gname support is poor

2005-03-01 Thread G. Roderick Singleton
The mailing gateway from gmane is not allowing postings. Is this intentional because the newsgroup is superior to this list. -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech