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 long
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)
FROM
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 tmp_dspace_imp
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 the
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 report
> 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
Functions
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 seems
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 probl
9 matches
Mail list logo