@Set
>The above query cannot possibly use any index for the nodes table (well,
>I'm a bit uncertain about indexes defined with COMPUTED BY, but I doubt
Yes the query was not using the indices even if they are defined,
lately I learned from SO that indices are not used with expressions. An the
Hi Jianbo
Once I had the same error message and it turned out that my x32 program was
using x64 fbclient.dll because it was first in the path (x32 fbclient.dll was
further down the path). After I fixed that, all was ok. Sorry, no other ideas…
:(
Zoran
From: firebird-support@yahoogrou
Hi Zoran,
Thanks for you reply,
I have checked the fbclient.dll file, it is x32 and my OS is windows 7 x32.
Do you have any other ideas on this problem?
Thanks,
Jianbo
At 2016/1/7 21:31, 'Zoran' zoran...@gmail.com [firebird-support]:
Check if fbclient.dll is has the right bitness (x32 or x
Den 06.01.2016 14:42, skrev Sonya Blade sonyablade2...@hotmail.com
[firebird-support]:
> update elements E set E.END_I = (select n.node_num from nodes N
> where abs(E.X_I -N.XI)<0.001 and abs(E.Y_I - N.YI)<0.001 and
> abs(E.Z_I-N.ZI)<0.001 )
The above query cannot possibly use any index for the n
Hi Bhavbhuti,
please have a look at Firebird's EXTRACT functions.
e.g.
select extract(year from CAST('1990-01-01' as Date)) from RDB$DATABASE;
returns 1990. Hope this helps.
Regards
Martin
