Hi Kees and John,
If you are getting data and storing it in an Sqlite database why not
store it in the appropriate format?
I will be storing it in the appropriate format. That's the objective
of this solution, to convert the data into the appropriate format. I
just want to do it within SQ
Thanks for the reminder. My ntp server seems to have died.
Daniel Önnerby wrote:
Sorry for this off topic comment:
John, about the dates, could you please fix your system clock, your
emails all appear at the top when sorting by date ;)
Again, sorry for the off topic. Hope I'm not intruding :
Sorry for this off topic comment:
John, about the dates, could you please fix your system clock, your
emails all appear at the top when sorting by date ;)
Again, sorry for the off topic. Hope I'm not intruding :)
Best regards
Daniel
John Stanton wrote:
Our business for many years was producin
Hi Darren,
On 11/3/07, Darren Duncan <[EMAIL PROTECTED]> wrote:
> At 9:42 AM -0400 11/2/07, Samuel R. Neff wrote:
> I think the real problem here is "virtual" is a broad enough term ...
I immediately think about MySQL when you use terms like "federated"
and "data engine". With the word "federated
Our business for many years was producing compilers and database
software to transport legacy software onto new platforms. We saw
literally thousands of custom application software implementations and
got to see the good, the bad and the ugly. As I said before dates were
a blind spot with mos
At 9:42 AM -0400 11/2/07, Samuel R. Neff wrote:
I like the term virtual 'cause that's exactly what they are.. a table that
does not really exist in the db and is provided by some other system. This
is not inconsistent with other DBMS's which use terms like "virtualized
view", both are tables tha
John,
There are an almost infinite number of applications and operations that a
person can think of regarding the use of dates and times.
My employer's applications on that particular server were specific and
well defined. I'm not going to go into all the details of the requirement;
there were m
I didn't mean to nitpick, but my experience has been that date and time
processing is a blind spot. Over the years we have come across the most
unholy kludges and nasty errors as people try to process dates without
using the core theory. The Y2K situation was just one of the side
effects in a
[Default] On Fri, 2 Nov 2007 19:52:21 +0530, "Babu, Lokesh"
<[EMAIL PROTECTED]> wrote:
>Hi all,
>
>Does anyone analysed the sqlite3 database output file by opening the file in
>some hex editor.
>Is it possible to create one such database file without using sqlite.i.e.,
>is it possible to write the
John,
None of the functionalities you mentioned were requirements on the project
I worked on.
Clumsy? My approach simplified everything on that server and is in
production worldwide, and unmodified, today.
Lee Crain
___
-Original Message-
From: John Stanton [mail
Lee Crain wrote:
Several years ago when I worked for a Fortune 70 company, we had a server
whose source code and database were complicated by timestamps. I say
complicated because there were different timestamp datatypes used for
different fields (inherited from the data sources), the data could
[Default] On Fri, 2 Nov 2007 17:29:23 +1100, T&B
<[EMAIL PROTECTED]> wrote:
>Hi all,
>
>How can I convert dates from the format d/m/yy to SQL style YYY-MM-DD?
>
>I have some imported data that includes a date column in the format d/
>m/yy, where:
>
>d = day as 1 or two digits
>m = month as 1 or
Several years ago when I worked for a Fortune 70 company, we had a server
whose source code and database were complicated by timestamps. I say
complicated because there were different timestamp datatypes used for
different fields (inherited from the data sources), the data could be
stored in differ
Trevor Talbot wrote:
It's a pre-commit hook, so it has the same problem as the triggers. I
haven't tried modifying the code to add a post-commit hook, but
sqlite3_commit_hook() is actually a good place to start: in main.c it
sets db->xCommitCallback, which is called by vdbeCommit() in
vdbeaux.c.
On 10/31/07, Bill Gatliff <[EMAIL PROTECTED]> wrote:
> Trevor Talbot wrote:
> > If your platform has a file modification notification mechanism, you
> > may be able to sleep on that instead. Of course the problem with this
> > approach is that it's only a coarse-grained "something changed"
> > no
Yes. this is all possible
Babu, Lokesh wrote:
Hi all,
Does anyone analysed the sqlite3 database output file by opening the file in
some hex editor.
Is it possible to create one such database file without using sqlite.i.e.,
is it possible to write the contents without using sqlite and later read
Terms like "foreign" and "federated" conjure up images of physical
tables that reside in external databases, which is not at all what
this feature is. It's simply an interface that looks like a table.
-
To unsubscribe, se
Hi all,
Does anyone analysed the sqlite3 database output file by opening the file in
some hex editor.
Is it possible to create one such database file without using sqlite.i.e.,
is it possible to write the contents without using sqlite and later read the
contents using sqlite.
or say if I have a t
To my mind "virtual" means something different. "Foreign" would be a
more intuitive name.
Samuel R. Neff wrote:
I like the term virtual 'cause that's exactly what they are.. a table that
does not really exist in the db and is provided by some other system. This
is not inconsistent with other
T&B wrote:
Hi John,
How can I convert dates from the format d/m/yy to SQL style YYY-MM- DD?
The data is from a bank, so I have no control over its production.
I couldn't find any suitable built in SQLite functions, which all
seem to operate in the other direction.
If you transform
I would like a virtual table cursor to distinguish read-only access
(SELECT statement/clause) from searched UPDATE/DELETE access.
For UPDATE / DELETE, I want to lock *my* rows in xNext cursor operation.
Is there a way to distinguish or is this a dumb question?
Many thanks
Mark
I have a highly threaded application that writes to a number of database
files. Each thread opens a database file, uses its own handle, and then
closes that handle when finished. As the threads come and go, some will
likely overlap with others using the same database, so it seems like the
process
Hi Gerry,
I would suggest either [scan] or [regexp] , with the former probably
being easier.
I'd love to use RegExp, but SQLite doesn't include it in its standard
functions (though I wish it did for so many reasons). I'm not familiar
with scan.
Tom
I like the term virtual 'cause that's exactly what they are.. a table that
does not really exist in the db and is provided by some other system. This
is not inconsistent with other DBMS's which use terms like "virtualized
view", both are tables that are not linked to underlying physical data. Th
Hi John,
How can I convert dates from the format d/m/yy to SQL style YYY-MM-
DD?
The data is from a bank, so I have no control over its production.
I couldn't find any suitable built in SQLite functions, which all
seem to operate in the other direction.
If you transform the date i
>But to do so seems likely to require an incompatible change to the
>virtual-table interface.
Could I kindly request an addition to the incompatible change to the
virtual-table interface?
I would very much appreciate a corresponding function to
function xRowID(
pCursor: psqlite3_vtab
T&B wrote:
Hi all,
How can I convert dates from the format d/m/yy to SQL style YYY-MM-DD?
I have some imported data that includes a date column in the format d/
m/yy, where:
d = day as 1 or two digits
m = month as 1 or two digits
yy = year as two digits
eg:
2/11/07 = today
2/8/68 = 2nd
T&B wrote:
Hi all,
How can I convert dates from the format d/m/yy to SQL style YYY-MM-DD?
I would suggest either [scan] or [regexp] , with the former probably
being easier.
Gerry
-
To unsubscribe, send email to [
I'm sorry if this is not the correct forum for this question, but does
anyone know if the digest mailing list is working? I have tried to
subscribe several times but it doesn't seem to work.
I assume that the digest will be one email each day containing all of
the posts to the regular mailing lis
29 matches
Mail list logo