Thanks for alternative ideas.
In my app, user need Exclusive mode occassionally. But when uses Exclusive
mode, user may enter/import some data or may change permissions for other
users, or some report generation. User may use Exclusive mode for few
minutes to may be 1-2 hours. That time no other
Hello Michael,
Thanks.
Best regards,
Kervin
--- Michael Ruck <[EMAIL PROTECTED]> wrote:
> Use the function sqlite3_expired to determine, when
> you need to
> recompile a prepared statement. That's the approach
> I use.
>
> Mike
>
> Am 24.09.2006 um 20:48 schrieb Kervin L. Pierre:
>
> >
Hello Igor,
Thanks for the info.
Best regards,
Kervin
--- Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> Kervin L. Pierre
>
> wrote:
> > The problem is, I don't know what
> > 'invalidates' a prepared statement. In
> > other words, when can I expect to have to
> > 're-'prepare a statement?
> >
On 9/23/06, Martin Alfredsson <[EMAIL PROTECTED]> wrote:
Hi !
Tried to solve a problem and what I did was to open the
database over the net and then physically disconnect
the machine.
I can still SELECT !
It's probably cached on your local machine.
Funny huh? :)
On 9/23/06, Martin Alfredsson <[EMAIL PROTECTED]> wrote:
>
> Windows XP, SQLite 3.3.4.
>
> /Martin
> ma1999ATjmaDOTse
Martin, did anyone mention virus scanners can lock your database file?
Do you have any other processes that might be reading the database file?
Michael Ruck
wrote:
I have the tables of the following style:
CREATE TABLE Objects (ObjectID TEXT PRIMARY KEY, Class TEXT)
And I'm executing the following statement in the sqlite3 shell:
SELECT * FROM Objects WHERE ObjectID =
'{08021C17-46DD-4d83-A6FE-DDF0F7EC0AAE}'
In the shell this query
--- Slava Tutushkin <[EMAIL PROTECTED]> wrote:
>
> MJ> -4713-11-24 GC, which is -4712-01-01 JC" so datetime(0) does correctly
> MJ> convert Julian Day 0 to a (proleptic) Gregorian date but not to a Julian
> MJ> Date as (I think) I thought. That'll teach me to post follow-ups when
>
> I see no
Hello,
I have a few queries that are executed very
often. I would like to keep them around as
much as possible.
The problem is, I don't know what
'invalidates' a prepared statement. In
other words, when can I expect to have to
're-'prepare a statement?
How long can I keep a prepared
MJ> -4713-11-24 GC, which is -4712-01-01 JC" so datetime(0) does correctly
MJ> convert Julian Day 0 to a (proleptic) Gregorian date but not to a Julian
MJ> Date as (I think) I thought. That'll teach me to post follow-ups when
I see no problem here while, because it does not matters, what day
Martin Jenkins wrote:
Looks like I'm getting more confused than I thought I was. :(
According to http://www.hermetic.ch/cal_stud/jdn.htm a Julian Date can
be a date in the Julian calendar *or* a Julian Day Number.
Section 9 of that page states that "Julian day number 0 corresponds to
On Sun, 24 Sep 2006 04:41:55 -0700 (PDT), you wrote:
>User (Client App) connects to middle-tier application-server and then user
>may access any one company in normal or exclusive mode. Only
>application-server communicates with database. If user wants exclusive
>access, Application-Server needs
Hi,
I have the tables of the following style:
CREATE TABLE Objects (ObjectID TEXT PRIMARY KEY, Class TEXT)
And I'm executing the following statement in the sqlite3 shell:
SELECT * FROM Objects WHERE ObjectID =
'{08021C17-46DD-4d83-A6FE-DDF0F7EC0AAE}'
In the shell this query succeeds. However
Slava Tutushkin wrote:
I think, I found a bug in the strftime function.
When I executed the next query: select strftime('%Y-%m-%d %H:%M:%f',
julianday('2006-09-24T10:50:26.047')); it returned 2006-09-24
10:50:26.046
At the same time, I can clearly see, that julianday for that time for
.046 and
use your chosen OS's reader/writer locks per user.
Some additional info
User (Client App) connects to middle-tier application-server and then user
may access any one company in normal or exclusive mode. Only
application-server communicates with database. If user wants exclusive
access,
Hi SQLite experts/users
In my multi-user app (Win32, SQLite3.3.4), one database file for each
company (accounts). User can access company accounts in two modes, normal
mode and exclusive mode. In exclusive mode, only one user will have access,
no other user should be able to access that company
I think, I found a bug in the strftime function.
When I executed the next query:
select strftime('%Y-%m-%d %H:%M:%f', julianday('2006-09-24T10:50:26.047'));
it returned 2006-09-24 10:50:26.046
At the same time, I can clearly see, that julianday for that time for .046 and
.047 points is
On Sep 21, 2006, at 7:18 AM, Narendran wrote:
as far as my knowledge SQLITE allows me to declare the column types
suppoted by the programming languare or say i am using blob . My
requirement
is i wish to store a structure in the SQLite column.
Instead of storing the structure in a single
17 matches
Mail list logo