--- In firebird-support@yahoogroups.com, bwc3068 wrote:
hi--
always a great place to get help!!
here's what i have data wise:
Tag ID Date
ABC 11 2012
DEF 11 2011
GHJ 11 2010
HHH 22 2012
ZZZ 22 2011
AAA 22 2010
AAK
Hi,
i was wrong that this can not be done by select
i don't know that rows can get value from select :)
try this without execute block as previous
select
X2.TAG, X2.ID, X2.ROK
from
(SELECT * FROM XXX A1 ORDER BY A1.TAG) AS X1
LEFT JOIN (SELECT * FROM XXX A2 ORDER BY A2.TAG) X2 ON X2.ID=X1.ID
Hi all,
(Using FB 1.5)
Do inserts in FB benefit from ordered or sequential PK?
Please allow me to clarify. I intend to use High/Low for table PKs. With this
approach, it is very possible that PKs will not be in sequential order as they
are inserted into the db. Will this be an issue in FB?
I
At 10:21 a.m. 26/01/2013, Jeff wrote:
Hi all,
(Using FB 1.5)
Do inserts in FB benefit from ordered or sequential PK?
No.
Please allow me to clarify. I intend to use High/Low for table PKs.
I don't know what that might be.
With this approach, it is very possible that PKs will not be in
Jeff wrote:
I based this question on this article:
http://www.codeproject.com/Articles/388157/GUIDs-as-fast-primary-keys-under-multiple-database
I'd expand on Helen's comment ...
The article is not particularly clear on what problem is trying to be solved?
All it is doing is adding a