Re: [sqlite] CREATE TABLE work arounds?

Thank You very much for all your responses and suggestions, they provided me with the information I needed to correct the issue. Cheers. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] CREATE TABLE work arounds?

On Thu, Jun 10, 2010 at 12:12:54PM -0500, Jay A. Kreibich scratched on the wall: > On Thu, Jun 10, 2010 at 07:02:02PM +0200, Jean-Christophe Deschamps scratched > on the wall: > > > >I am parsing fields on the fly and then creating tables, > > > Can you wrap every column name inside double

Re: [sqlite] CREATE TABLE work arounds?

On Thu, Jun 10, 2010 at 07:02:02PM +0200, Jean-Christophe Deschamps scratched on the wall: > >I am parsing fields on the fly and then creating tables, > Can you wrap every column name inside double quotes or square brackets? > "Order" If you're using identifiers (table or column names) from

Re: [sqlite] CREATE TABLE work arounds?

>I am parsing fields on the fly and then creating tables, unfortunately >one of the fields is "Order" and is a "special word" in SQL as is not >allowed. Is there a way around this instead of intercepting with perl >s'/Order/Orders/g' Can you wrap every column name inside double quotes or

[sqlite] CREATE TABLE work arounds?

I am parsing fields on the fly and then creating tables, unfortunately one of the fields is "Order" and is a "special word" in SQL as is not allowed. Is there a way around this instead of intercepting with perl s'/Order/Orders/g' thanks sqlite3 DB "CREATE TABLE META (channel_count TEXT ,

Re: [sqlite] BEFORE INSERT TRIGGER

___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users __ Information from ESET Smart Security, version of virus signature database 5186 (20100610) __ The message was checked by ESE

Re: [sqlite] BEFORE INSERT TRIGGER

> Like I said, I don't see anything wrong with it, and in fact it works for me. > I suspect the problem lies elsewhere, in a statement you didn't show. One > that actually contains a double quote in it, perhaps? In fact it's not double quote, it should be extra endline character I think.

Re: [sqlite] BEFORE INSERT TRIGGER

Tareq Khan wrote: > Thanks for the reply. Yes I am aware of that... I have just updated to the > latest version. However I would be grateful if someone could tell me what > was wrong with the trigger I was trying to create. Like I said, I don't see anything wrong with it,

Re: [sqlite] BEFORE INSERT TRIGGER

oreign keys? -- Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users __ Information from ESET Smart Security, version of virus signature database 518

Re: [sqlite] BEFORE INSERT TRIGGER

Tareq Khan wrote: > I have looked through the list with regards to my issue and there are > several entries that say that the following is correct for a BEFORE INSERT > trigger: > > > > CREATE TRIGGER AlbumSectionInsertTrigger > BEFORE INSERT > ON AlbumSection > FOR

[sqlite] BEFORE INSERT TRIGGER

Hi I have looked through the list with regards to my issue and there are several entries that say that the following is correct for a BEFORE INSERT trigger: CREATE TRIGGER AlbumSectionInsertTrigger BEFORE INSERT ON AlbumSection FOR EACH ROW BEGIN SELECT CASE WHEN

[sqlite] BUG: Build_Problem: 3.6.23.1 fails to build on Mac OS X < 10.6

Building the amalgamation of sqlite 3.6.23.1 fails during linking under Mac OS X releases prior to 10.6: == SNIP gcc -dynamiclib -o .libs/libsqlite3.0.8.6.dylib .libs/ sqlite3.o -install_name /opt/sqlite/3.6.23.1/lib/libsqlite3.0.dylib -compatibility_version 9

Re: [sqlite] sql api for ufs

On 7 June 2010 20:08, George Georgalis wrote: > On Mon 07 Jun 2010 at 05:07:43 PM +0200, Kees Nuyt wrote: >> >>That could be implemented as an appication with a set of >>virtual tables, backed by the readdir() and stat() system >>calls. >>I haven't heard of any implementation,

Re: [sqlite] Date format definition on bulk csv insert

Hi Albert, > in the csv; the field is defined like: > > 2010.03.31 16:01:24.284 For a datetime field. > > I would like to tell sqlite that this is in > .mm.dd hh:mm:ss.sss > > How can I define this in sqlite's program so it imports the datetime > correctly? > I have used the SQLite C

Re: [sqlite] how to install sqlite3 in windows+python2.5

thanks, it worked. -- From: "Martin Engelschalk" Sent: Thursday, June 10, 2010 2:07 PM To: "General Discussion of SQLite Database" Subject: Re: [sqlite] how to install sqlite3 in

Re: [sqlite] compiling in foreign key support

On Wednesday, June 09, 2010 9:27 PM, Jay A. Kreibich wrote: > On Wed, Jun 09, 2010 at 03:15:32PM -0400, Sam Carleton scratched on the > wall: >> From looking at the compile page (http://www.sqlite.org/compile.html), I >> am >> not seeing any compile options to turn on foreign key support. Was

Re: [sqlite] how to install sqlite3 in windows+python2.5

http://www.sqlite.org/sqlitedll-3_6_23_1.zip Am 10.06.2010 08:05, schrieb zeal: > Hi, > > i could not find the sqlite3.dll from http://www.sqlite.org/download.html > or would you please paste the linkage here? > thanks and best wish for you > > >

Re: [sqlite] how to install sqlite3 in windows+python2.5

Hi, i could not find the sqlite3.dll from http://www.sqlite.org/download.html or would you please paste the linkage here? thanks and best wish for you -- From: Sent: Thursday, June 10, 2010 1:59 PM To: