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 exten
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, although fossil
>>ht
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 -current_vers
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 (
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 EACH ROW
>
> BEGIN
>S
ment of foreign 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 5186 (201006
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, and in fact it works f
> 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.
Pavel
___
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 ESET Smart Securit
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 ,
>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 squar
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
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 quot
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
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlit
14 matches
Mail list logo