Matthew Halliday wrote:
> Unfortunately is comlains after "SET diff_used," and I get "near ",":
> syntax error: "
Then your SQLite is too old; row values require 3.15 or later.
> it won't diferentiate between servers and drives.
Oops!
> However this does appear to have worked! Seems a bit
However this does appear to have worked! Seems a bit long-winded to me but
it worked. I think - going to compare to the same thing in Excel and just
check the data before I do a happy-dance.
UPDATE tmp_dspace_import
SET diff_used = (SELECT tmp_dspace_import.used_mb - ifnull(prev.used_mb, 0)
Hi Clemens, thanks for that.
Unfortunately is comlains after "SET diff_used," and I get "near ",":
syntax error: "
If I seperate it out into stand-alone statemeonts like this:
UPDATE tmp_dspace_import
SET diff_used = (SELECT tmp_dspace_import.used_mb - ifnull(prev.used_mb, 0)
FROM
Matthew Halliday wrote:
> I used the SQLite Studio to create the table so used the DATETIME data type
> for that, and although I used -mm-dd hh:mm:ss in the script
That is correct.
> it seems to have reverted it to dd/mm/yy hh:mm:ss.
That would not be usable.
Check the actual format with
Hi Chris,
I used SharpDevelop years ago, forgot abot that. I'd like to do it via the
script or in-DB because I want a set-and-forget solution I can run on a
scheduler. I have stacks of other jobs to do - some actually similar to
this, but if I can just leave it to run and generate a daily
> I prefer using the PortableApps SQLite browser for other things as you
can have tabbed SQL queries but it doesn't have the DATETIME data type
Date and Time *Datatype*. *SQLite* does not have a storage *class* set
aside for storing dates and/or times. Instead, the built-in Date And Time
Hi Clemens - thanks for the reply.
I'm trying to keep them a regular 4 or 6 hours - I'll see what works
best. The script runs as a scheduled task.
I used the SQLite Studio to create the table so used the DATETIME data type
for that, and although I used -mm-dd hh:mm:ss in the script it
Matthew Halliday wrote:
> I have a simple import table: id, servername, drive, capacity, used_mb,
> free_mb, free_pc (%) and a date_time field.
What is the format of the values in the date_time field?
Is there always a constant offset between two consecutive timestamps?
Regards,
Clemens
Good morning all
Sorry for the long email. I'm back to using SQLite after some years away
from it and from databases in general, so a bit rusty. I'be been trying to
figure this out for almost a week now but can't quite get my head around it
although I think I understand the principles.
My
9 matches
Mail list logo