In SQLite type guid does not exist. Look at this documentation:
https://www.sqlite.org/datatype3.html
Affinity for guid would be BLOB but in trigger you store TEXT.
I do not use .NET but I think you should use different parameter
type. I would use TEXT type.
Regards R.A.
On 14.02.2020 15:09,
Can you explain why workaround is fast. Why one version is fast and
other slow. I'm talking about this change in where:
"and R.ID_ARHDAJ is not null"
to
"and ifnull(R.ID_ARHDAJ,0) <> 0"
For me analyze is no improvement because data is loaded from RDBMS
and would have to run always after load.
D_ARHDAJ is not null" to "and
ifnull(R.ID_ARHDAJ,0) <> 0".
So sqlite goes through large table but should go through small table and
search record in
large for every record.
Best Regards
Radovan Antloga
___
sqlite-us
This is FireDAC error message not SQLite specific. I cannot reproduce it
when
using default FireDAC settings. But I think you must check Database
ResourceOptions
CmdExecMode. Change to am_NonBlocking. But I do not have to change that
by default.
Regards Radovan
On 25.11.2019 18:34, Edson
In Delphi I have 2 functions that works (I override default sqlite round):
const
ExtEps = 1.0842021725E-19;
DblEps = 2.2204460493E-16;
KnownErrorLimit = 1.234375;
SafetyFactor = 2;
MaxRelErrDbl = DblEps * KnownErrorLimit * SafetyFactor;
MaxRelErrExt = ExtEps * KnownErrorLimit *
?
/Lars
-Oprindelig meddelelse-
Fra: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] På
vegne af Radovan Antloga
Sendt: 12. oktober 2018 10:10
Til: sqlite-users@mailinglists.sqlite.org
Emne: Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked
Try
Try to change database name (extension).
For example:
mydb.sqlite
mydb.sdb
mydb.db3
I would use .sqlite extension and exclude that
files from antivirus check.
Regards
Lars Frederiksen je 12.10.2018 ob 9:11 napisal:
Hello,
I have made (in Delphi) a program that writes to a sqlite database.
DbGrid is linked with DataSource and DataSource
with DataSet. DataSet can be TFDQuery or TFDTable.
You can read TFDTable.RecNo onclick event of DbGrid.
Why do you need that?
You do not have to write fields. Just put dbedit controls
on your form and link them with DataSource. On record
change
select 100.0 * sum(survived) / count(*) as tot_pct_survived
FROM passengers
Regards
Radovan
frknozdmr01 je 26.09.2018 ob 3:03 napisal:
Hi, I need to find the percent of passengers survived? (total). How do you do
it? I tried the comment below but it did not work.
SELECT
SUM(CASE WHEN
Thank you Peter!
I like sqlite so much and I think we all benefit if
errors are fixed. I see I was not very clear with my
first post. Will do better next time. Yes would
be nice if people would try to understand first
not just think on title text.
Talking about sqlite I use it for web
ite> select d from (select c as d from (select a as c from test));
d
1
sqlite> create table test2 as
...> select d from (select c as d from (select a as c from test));
sqlite> SELECT * FROM test2;
a <=
1
sqlite>
email signature Klaus Maas
THANK YOU!
Richard Hipp je 22.12.2017 ob 20:29 napisal:
Your trouble ticket is here: https://sqlite.org/src/tktview/3b4450072511
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
a.
with PostgreSQL I get table test2 with name d.
Thank you very much for your time!
Richard Hipp je 22.12.2017 ob 20:06 napisal:
On 12/22/17, Radovan Antloga <radovan.antl...@siol.net> wrote:
My point is you do not have to change anything regards
to how select works. SELECT sta
, 2017 1:45 PM
To: SQLite mailing list
Subject: Re: [sqlite] Changed behaviour or bug using field alias in 3.21.0
On 12/22/17, Radovan Antloga <radovan.antl...@siol.net> wrote:
In my example I have AS clause so rule 1.
You did not understand my question.
I think what you are asking for is t
je 22.12.2017 ob 19:45 napisal:
On 12/22/17, Radovan Antloga <radovan.antl...@siol.net> wrote:
In my example I have AS clause so rule 1.
You did not understand my question.
I think what you are asking for is that we should enhance rule 1 so
that it applies even if the AS clause is con
In my example I have AS clause so rule 1.
sqlite select statement is correct or name
is correct.
sqlite create table as statement create table
with different name that select statement return
Problem is different result or name.
Richard Hipp je 22.12.2017 ob 19:27 napisal:
These are the
Dec 2017, at 4:50pm, Radovan Antloga <radovan.antl...@siol.net> wrote:
select d from (select c AS d from (select a AS c from test));
I get d as column name. If I create table with
create table as I get a as column name.
As I wrote, you did not specify AS for d, so you cannot depend on a
hard to understand.
Simon Slavin je 22.12.2017 ob 17:58 napisal:
On 22 Dec 2017, at 4:50pm, Radovan Antloga <radovan.antl...@siol.net> wrote:
select d from (select c AS d from (select a AS c from test));
I get d as column name. If I create table with
create table as I get a as colum
Thank you very much to understand my point!
This is exactly what I think. I have name
and select is working ok. It gives me my
name but create table as not.
David Raymond je 22.12.2017 ob 17:59 napisal:
I think the underlying feeling here is that if you're not doing anything
tricky, and just
Sorry but this is not related to my example.
I have AS in inner select. My select return
name as specified.
Problem I have is with create table as where
name is changed.
I give example like this:
select d from (select c AS d from (select a AS c from test));
I get d as column name. If I create
eplained some day
create table as will create name like 1, 2, 3, 4
Long names sometimes are used for excel export or some
simple reports with just sql behind.
R Smith je 22.12.2017 ob 12:34 napisal:
On 2017/12/22 11:06 AM, Radovan Antloga wrote:
I'm using sqlite from version 2. I have
sers [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im
Auftrag von Radovan Antloga
Gesendet: Freitag, 22. Dezember 2017 10:06
An: sqlite-users@mailinglists.sqlite.org
Betreff: Re: [sqlite] [EXTERNAL] Re: Changed behaviour or bug using field alias
in 3.21.0
I'm using sqlite from version 2. I have
: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im
Auftrag von Radovan Antloga
Gesendet: Donnerstag, 21. Dezember 2017 16:35
An: sqlite-users@mailinglists.sqlite.org
Betreff: [EXTERNAL] Re: [sqlite] Changed behaviour or bug using field alias in
3.21.0
Behaviour is not consistent
be the same as when just using select statement.
Best Regards
Radovan
select a from (select b from (select c from test)))
Richard Hipp je 21.12.2017 ob 14:52 napisal:
The behavior change is a bug fix. See
http://sqlite.org/src/info/de3403bf5ae for details.
On 12/21/17, Radovan Antloga
will see that first column name is VP instead of P.
In previous versions name was P not VP.
Best Regards
Radovan Antloga
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
You must have ISO8601 that has format
-MM-DD not /MM/DD. If you compare
strings it will not work. See result of
this query:
select date('now', '-1 days')
you get: 2017-08-23
Regards
Radovan
Matthew Halliday je 24.08.2017 ob 15:21 napisal:
Looks like it's me.
VBScript "NOW" =
e,
drive;
returns a blank set. Does the order in the query make a difference?
Its probably me missing something here.
On Thu, Aug 24, 2017 at 10:48 AM, Radovan Antloga <radovan.antl...@siol.net>
wrote:
Hi,
you don't have all columns in group by.
You should have grup by 1,2,3. Column
Hi,
you don't have all columns in group by.
You should have grup by 1,2,3. Column 3
is expression.
Regards,
Radovan
Matthew Halliday je 24.08.2017 ob 11:41 napisal:
Correct:
SELECT strftime(date_time, -2) as iDATE from tmp_dspace_import
Result
21/08/2017 11:43:05
21/08/2017 11:43:05
this with two sql-s. First is insert
and second is update.
I didn't know I could use dummy value for
grouping. I see this is not just sqlite
specific. I tried also with Firebird DB
and it works. So I will modify my program.
Thank you!
Clemens Ladisch je 07.02.2017 ob 8:40 napisal:
Radovan
where B is null
and A > 3;
-- bug sql using agg function (also with other functions: max, avg)
select min(A)
from TEST
where B is null
and A > 3;
if you replace min(A) with * you get empty result set as expected
but with min or max or avg you get one record
Best Regards
Radovan A
Sorry to post this to quick. I just checked this
with Firebird and I get same result. I did not
expect that.
Sorry once again !!
Radovan Antloga je 06.02.2017 ob 18:34 napisal:
Hi,
I discovered a bug using sqlite 3.15.2. It is simple
to reproduce. Try this SQL-s:
CREATE TABLE TEST
where B is null
and A > 3;
-- bug sql using agg function (also with other functions: max, avg)
select min(A)
from TEST
where B is null
and A > 3;
if you replace min(A) with * you get empty result set as expected
but with min or max or avg you get one record
Best Regards
Radovan A
sql should be:
select b.Name, a.Title, c.Year
from Books a
left outer join Authors b on a.AuthorID = b.AuthorID
left outer join Years c on a.YearID = c.IDYear
I think your table Years is redundant.
Why store only one integer in table Years
as you could store directly into Books.
So I would have
After line:
UPDATE foo SET bar=5678;
put this sql command:
COMMIT;
If you execute all statements in one sql
(except last), they are executed in one transaction.
Regards
Radovan
Adam Goldman je 27.10.2016 ob 11:52 napisal:
Hi,
I expected the test case below to print 5679, but it prints 1235
, 2016 7:49 PM
To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org>
Subject: Re: [sqlite] Problem with rename table
On 9/6/16, Radovan Antloga <radovan.antl...@siol.net> wrote:
Hi Richard !
I can't find a solution how to fix my database after I have renamed
table DOKUMENTI t
(dokumenti_trigger1) -
no such table main.dokumenti.
TIA
Radovan Antloga
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
See this:
http://www.sqlite.org/releaselog/3_7_6.html
Regards,
R.Antloga
S, Jan Hudec piše:
> Hello All,
>
> [Is this correct place to report a bug, or can I create it in Fossil
> somehow?]
>
> Semantics of operations on integers changed between 3.7.5 and 3.7.6. It does
> not seem to be
S, Igor Tandetnik piše:
> Radovan Antloga<radovan.antl...@siol.net> wrote:
>> create table test (a integer not null, b float not null);
>>
>> update test
>> set b = 0.0 / 0;
>>
>> you will get error: test.b may not be null
> Appears to be working as
this:
update test
set b = 0.0 / 0;
you will get error: test.b may not be null
I reproduced also with windows command-
line shell.
Best Regards !
Radovan Antloga
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman
(drop table T2)
I get SQLite error 6 database table is locked.
So while statements are in progress it is not possible
to drop any tables.
Best Regards
Radovan Antloga
__ Informacija od ESET NOD32 Antivirus, zbirka virusnih definicij 4990
(20100401) __
To sporočilo je preveril
ly 12, 2008 10:54 PM
Subject: Re: [sqlite] Using real
>
> On Jul 12, 2008, at 4:41 PM, Radovan Antloga wrote:
>
>> please check this sql:
>>
>> select cast((2.3 * 100) as integer), cast(round(2.3 * 100) as
>> integer), 2.3 * 100, cast(230.0 as integer)
>>
>> I
please check this sql:
select cast((2.3 * 100) as integer), cast(round(2.3 * 100) as integer), 2.3 *
100, cast(230.0 as integer)
Is this proper behaviour ?
Thanks in advance,
RA
___
sqlite-users mailing list
sqlite-users@sqlite.org
42 matches
Mail list logo
