Hello.-
Is there any function that i can make event when a data change?
--
Ing. Hildemaro Carrasquel
Ingeniero de Proyectos
Cel.: 04164388917/04121832139
___
sqlite-users mailing list
sqlite-users@sqlite.org
"Hildemaro Carrasquel"
<[EMAIL PROTECTED]> wrote in
message
news:[EMAIL PROTECTED]
> Is there any function that i can make event when a data change?
See sqlite3_commit_hook, for changes that occur on the same connection.
If you hope to get a notification when some other process writes to the
--- On Wed, 6/4/08, Nicolas Williams <[EMAIL PROTECTED]> wrote:
> I'm told that Firefox expects the full version number in
> the sqlite3.pc
> file, not just "3.5".
>
> Is this true? If so, why does configure.ac strip out the
> micro number?
>
I don't know what the sqlite3.pc file is or what it
On Thu, Jun 5, 2008 at 11:08 AM, Richard Hipp <[EMAIL PROTECTED]> wrote:
> My understanding is that firefox uses the amalgamation, not
> anything generated from a configure script. The SQLite amalgamation
> is checked into their source tree. So I am thinking that FF does
> not care about the
look at teh trigger functions.
--- On Fri, 6/6/08, Hildemaro Carrasquel [EMAIL PROTECTED] wrote:
From: Hildemaro Carrasquel [EMAIL PROTECTED]
Subject: [sqlite] Interruption
To: sqlite-users@sqlite.org
Date: Friday, June 6, 2008, 2:17 AM
Hello.-
Is there any function that i can make event when
We see an error "database disk image is malformed" in our logs sometimes and
if we restart our application then it can continue fine--the db is not
corrupt. We can open the db in sqlite3.exe CLI and running "PRAGMA
integrity_check;" returns OK. What can cause this error if the db is
(thankfully)
On Jun 5, 2008, at 12:09 PM, Shawn Wilsher wrote:
> Hey all,
>
> We are getting reports that sqlite is not working for users of AFP
> (Apple Filing Protocol) in Bug 417037 [1]. I was wondering if this
> was a known issue, and what we could do to help get this resolved.
I think the solution
On Thu, Jun 5, 2008 at 4:04 PM, D. Richard Hipp <[EMAIL PROTECTED]> wrote:
> I think the solution might be as simple as compiling with -
> DSQLITE_ENABLE_LOCKING_STYLE=1. This option only works on a Mac. It
> enables some Apple-contributed code that does file locking that works
> on AFP as well
On Jun 5, 2008, at 1:32 PM, Shawn Wilsher wrote:
> On Thu, Jun 5, 2008 at 4:04 PM, D. Richard Hipp <[EMAIL PROTECTED]> wrote:
>> I think the solution might be as simple as compiling with -
>> DSQLITE_ENABLE_LOCKING_STYLE=1. This option only works on a Mac. It
>> enables some Apple-contributed
You can do your own custom functions using the C extentions. You should buy
the book.
"The Definitive Guide SQLite"
On Thu, Jun 5, 2008 at 6:55 PM, Scott Baker <[EMAIL PROTECTED]> wrote:
> I have a database with coordinates in it. I'd like to calculate distance at
> the SQL level, but the
> requires square root and I'm not sure if I can do this with sqlite.
> Something like:
>
> SELECT PlaceName, sqrt((PlaceX - 1)^2 - (PlaceY - 3)^2) AS
> DistFromHome
> FROM Table WHERE PlaceGroup = 3;
I was going to suggest using "^ 0.5" for square root, but now I see
that SQLite doesn't
On Thu, Jun 05, 2008 at 03:55:44PM -0700, Scott Baker scratched on the wall:
> I have a database with coordinates in it. I'd like to calculate distance at
> the SQL level, but the equation for calculating distance requires square
> root and I'm not sure if I can do this with sqlite. Something
On 6/5/08, BareFeet <[EMAIL PROTECTED]> wrote:
> > requires square root and I'm not sure if I can do this with sqlite.
> > Something like:
> >
> > SELECT PlaceName, sqrt((PlaceX - 1)^2 - (PlaceY - 3)^2) AS
> > DistFromHome
> > FROM Table WHERE PlaceGroup = 3;
>
>
> I was going to suggest
13 matches
Mail list logo