in my app ;-)
Is the database bigger than 2Gb?
If so, have you got large file support in samba (lfs in the mount options)?
--
Nikki Locke, Trumphurst Ltd. PC & Unix consultancy & programming
http://www.trumphurst.com/
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
for dates (surrounded with # and
in mm/dd/ format, I think). However, I have a feeling it will accept
Ansi standard date format in a quoted string ('2004-02-06' for a date or
'2004-02-06T12:02:02' for s date with time (the T is important).
--
Nikki Locke, Trumphurst Ltd. PC & Unix consu
date_notes_timeStamp AFTER UPDATE ON notes
BEGIN
UPDATE notes SET timeStamp = strftime('%Y-%m-%d %H:%M:%f', 'now')
WHERE rowid = new.rowid;
END;
Notice I used strftime to create the timestamp - TIME('now') does not return
the fractional seconds, so you could conceivably get two updates with the
s in them which
are
NOT nulls. Indeed, I have some databases where NULL and '' are supposed to be
distinct values, with different meanings.
--
Nikki Locke, Trumphurst Ltd. PC & Unix consultancy & programming
http://w
the first users
> changes are lost.
I usually use a timestamp for this. I believe recent versions of SQLite support
auto-updating timestamps (which record the time the record was last updated).
--
Nikki Locke, Trumphurst Ltd. PC & Unix consultancy &
ome implementations of NFS.
Hope this explanation is clear and correct (I'm just an SQLite user who gets
most of his knowledge from reading this list).
--
Nikki Locke, Trumphurst Ltd. PC & Unix consultancy & programming
http://www.trumphurst.com/
--
Martin Jenkins wrote:
> Nikki Locke wrote:
> > Martin Jenkins wrote:
> > Using [] is a Microsoft thing. More portable to use double quotes...
>
> Thanks, I didn't know that. I avoid spaces in column names so I haven't
> actually use it in anger.
>
> JOO
carefully. The middle term is of length 4 - it will pick up "-mm-"
from the middle of the original string.
--
Nikki Locke, Trumphurst Ltd. PC & Unix consultancy & programming
http://www.trumphurst.com/
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
on. So far I
have only used SQLite from C#, so I don't get involved in all that stuff.
--
Nikki Locke, Trumphurst Ltd. PC & Unix consultancy & programming
http://www.trumphurst.com/
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
sqlite3_reset(pStmt); // Not sure if this is needed
}
if (nRetVal != SQLITE_ROW)
break; // No more rows, or an error
// How do I get the information out of this returned record?
sqlite3_reset(pStmt); // Ready f
y wait until the first attempt to update the
database.
--
Nikki Locke, Trumphurst Ltd. PC & Unix consultancy & programming
http://www.trumphurst.com/
> CREATE INDEX index1 ON ITM (IDC);
..
> Select count(*) from itm, HVH where itm .IDC = HVH.IDC
2) Your original schema is always going to be slow, because you have not
defined
a suitable index on HVH(IDC).
--
Nikki Locke, Trumphurst Ltd. PC & Unix consultancy & programming
http://www.trumphurst.com/
alues (1, "one");
sqlite> insert into test values (2, "two");
sqlite> insert into test values (3, "three");
sqlite> select * from test;
1|one
2|two
3|three
sqlite>.q
C:\TEMP>
Works fine. Works on Linux too. Try it on your machine - does it work?
--
Nikki Locke, Trumphurst Ltd. PC & Unix consultancy & programming
http://www.trumphurst.com/
safe to do stuff that requires locks from any thread. Which solves your
objection.
--
Nikki Locke, Trumphurst Ltd. PC & Unix consultancy & programming
http://www.trumphurst.com/
at sqlite.org.
Given that I am using SQLite.Net, if I execute this pragma as the first command
passed over the connection, before creating any tables, will it work? Or do I
really have to execute it "before creating the database"?
--
Nikki Locke, Trumphurst Ltd.
eproducing the problem, and reporting it through the usual channels.
--
Nikki Locke, Trumphurst Ltd. PC & Unix consultancy & programming
http://www.trumphurst.com/
16 matches
Mail list logo
