dimitr, kdv
Дорого дня, уважаемые.
авторПредлагаю указать в этом месте явно алиас и сообщить, остается ли ошибка.
автордополню неписаным правилом - начал использовать алиасы у одной таблицы - используй алиасы во всем запросе.
Выполнено назначение алиаса для всех объектов соединений, обращение к полям только через алиас.
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
select
-- vtk
vtk.F123_ISN as VTK_F123_ISN,
vtk.F123_PROJ as VTK_F123_PROJ,
vtk.F123_OG1 as VTK_F123_OG1,
vtk.F123_OG2 as VTK_F123_OG2,
vtk.F123_F311_LIST as VTK_F123_F311_LIST,
((char_length(vtk.F123_F311_LIST) - char_length(replace(vtk.F123_F311_LIST, ';', '')) / 1) + 1) as C_OLD_LINK,
-- F311
cat.F311_ISN,
cat.F311_PROJ,
cat.F311_ZK,
-- calc
(cat.F311_PROJ = vtk.F123_PROJ and cat.F311_ZK between vtk.F123_OG1 and vtk.F123_OG2) as EQ_PROJ_ZK,
-- jpp
jpp.F123_ISN as JPP_F123_ISN,
jpp.F123_OG1 as JPP_F123_OG1,
jpp.F123_OG2 as JPP_F123_OG2,
jpp.F123_LONG_CMN as JPP_F123_LONG_CMN,
cat.F311_DOCNAME,
jpp.F123_NAME
from F123 vtk
join SP_TERMS(vtk.F123_F311_LIST, ';') tr on 0=0
join F311 cat on cat.F311_ISN = cast(tr.NEXT_TERM as integer)
join F123 jpp on jpp.F123_PROJ = vtk.F123_PROJ
and (cat.F311_ZK between jpp.F123_OG1 and jpp.F123_OG2)
and jpp.F123_CLASS = 'ВЕРФЬ' and ((jpp.F123_RTYP in ('69', '90')) or (jpp.F123_RTYP between '61' and '66'))
--and trim(cat.F311_DOCNAME) like trim(jpp.F123_NAME)
and trim(cat.F311_DOCNAME) = trim(jpp.F123_NAME)
where vtk.F123_CLASS = 'ВЕРФЬ'
and vtk.F123_RTYP = '31'
and vtk.F123_F311_LIST <> ''
Ошибка осталась.
The cursor identified in the UPDATE or DELETE statement is not positioned on a row.
no current record for fetch operation.
Содержимое лога
Trace session ID 4 started
2021-05-12T01:49:25.3550 (6808:0000000001631DC0) TRACE_INIT
SESSION_4 FNV
2021-05-12T01:49:25.3550 (6808:0000000001631DC0) FREE_STATEMENT
D:\PP01_12.FDB (ATT_126, SYSDBA:NONE, WIN1251, TCPv4:172.16.97.228/61429)
C:\Program Files (x86)\HK-Software\IBExpert\IBExpert.exe:5532
Statement 324:
-------------------------------------------------------------------------------
select
-- vtk
vtk.F123_ISN as VTK_F123_ISN,
vtk.F123_PROJ as VTK_F123_PROJ,
vtk.F123_OG1 as VTK_F123_OG1,
vtk.F123_OG2 as VTK_F123_OG2,
vtk.F123_F311_LIST as VTK_F123_F311_LIST,
((char_length(vtk.F123_F311_LIST) - char_length(replace(vtk.F123_F311_LIST, ';', '')) / 1) + 1)...
2021-05-12T01:49:25.3550 (6808:0000000001631DC0) START_TRANSACTION
D:\PP01_12.FDB (ATT_126, SYSDBA:NONE, WIN1251, TCPv4:172.16.97.228/61429)
C:\Program Files (x86)\HK-Software\IBExpert\IBExpert.exe:5532
(TRA_11360, READ_COMMITTED | REC_VERSION | NOWAIT | READ_WRITE)
2021-05-12T01:49:25.3550 (6808:0000000001631DC0) PREPARE_STATEMENT
D:\PP01_12.FDB (ATT_126, SYSDBA:NONE, WIN1251, TCPv4:172.16.97.228/61429)
C:\Program Files (x86)\HK-Software\IBExpert\IBExpert.exe:5532
(TRA_11360, READ_COMMITTED | REC_VERSION | NOWAIT | READ_WRITE)
Statement 328:
-------------------------------------------------------------------------------
select
-- vtk
vtk.F123_ISN as VTK_F123_ISN,
vtk.F123_PROJ as VTK_F123_PROJ,
vtk.F123_OG1 as VTK_F123_OG1,
vtk.F123_OG2 as VTK_F123_OG2,
vtk.F123_F311_LIST as VTK_F123_F311_LIST,
((char_length(vtk.F123_F311_LIST) - char_length(replace(vtk.F123_F311_LIST, ';', '')) / 1) + 1)...
0 ms
2021-05-12T01:49:31.3270 (6808:0000000001631DC0) FREE_STATEMENT
D:\PP01_12.FDB (ATT_126, SYSDBA:NONE, WIN1251, TCPv4:172.16.97.228/61429)
C:\Program Files (x86)\HK-Software\IBExpert\IBExpert.exe:5532
Statement 328:
-------------------------------------------------------------------------------
select
-- vtk
vtk.F123_ISN as VTK_F123_ISN,
vtk.F123_PROJ as VTK_F123_PROJ,
vtk.F123_OG1 as VTK_F123_OG1,
vtk.F123_OG2 as VTK_F123_OG2,
vtk.F123_F311_LIST as VTK_F123_F311_LIST,
((char_length(vtk.F123_F311_LIST) - char_length(replace(vtk.F123_F311_LIST, ';', '')) / 1) + 1)...
2021-05-12T01:49:31.3270 (6808:0000000001631DC0) PREPARE_STATEMENT
D:\PP01_12.FDB (ATT_126, SYSDBA:NONE, WIN1251, TCPv4:172.16.97.228/61429)
C:\Program Files (x86)\HK-Software\IBExpert\IBExpert.exe:5532
(TRA_11360, READ_COMMITTED | REC_VERSION | NOWAIT | READ_WRITE)
Statement 329:
-------------------------------------------------------------------------------
select
-- vtk
vtk.F123_ISN as VTK_F123_ISN,
vtk.F123_PROJ as VTK_F123_PROJ,
vtk.F123_OG1 as VTK_F123_OG1,
vtk.F123_OG2 as VTK_F123_OG2,
vtk.F123_F311_LIST as VTK_F123_F311_LIST,
((char_length(vtk.F123_F311_LIST) - char_length(replace(vtk.F123_F311_LIST, ';', '')) / 1) + 1)...
2 ms
2021-05-12T01:49:31.4600 (6808:0000000001631DC0) FREE_STATEMENT
D:\PP01_12.FDB (ATT_126, SYSDBA:NONE, WIN1251, TCPv4:172.16.97.228/61429)
C:\Program Files (x86)\HK-Software\IBExpert\IBExpert.exe:5532
Statement 329:
-------------------------------------------------------------------------------
select
-- vtk
vtk.F123_ISN as VTK_F123_ISN,
vtk.F123_PROJ as VTK_F123_PROJ,
vtk.F123_OG1 as VTK_F123_OG1,
vtk.F123_OG2 as VTK_F123_OG2,
vtk.F123_F311_LIST as VTK_F123_F311_LIST,
((char_length(vtk.F123_F311_LIST) - char_length(replace(vtk.F123_F311_LIST, ';', '')) / 1) + 1)...
2021-05-12T01:49:31.4600 (6808:0000000001631DC0) PREPARE_STATEMENT
D:\PP01_12.FDB (ATT_126, SYSDBA:NONE, WIN1251, TCPv4:172.16.97.228/61429)
C:\Program Files (x86)\HK-Software\IBExpert\IBExpert.exe:5532
(TRA_11360, READ_COMMITTED | REC_VERSION | NOWAIT | READ_WRITE)
Statement 330:
-------------------------------------------------------------------------------
select
-- vtk
vtk.F123_ISN as VTK_F123_ISN,
vtk.F123_PROJ as VTK_F123_PROJ,
vtk.F123_OG1 as VTK_F123_OG1,
vtk.F123_OG2 as VTK_F123_OG2,
vtk.F123_F311_LIST as VTK_F123_F311_LIST,
((char_length(vtk.F123_F311_LIST) - char_length(replace(vtk.F123_F311_LIST, ';', '')) / 1) + 1)...
2 ms
2021-05-12T01:49:31.4750 (6808:0000000001631DC0) EXECUTE_STATEMENT_START
D:\PP01_12.FDB (ATT_126, SYSDBA:NONE, WIN1251, TCPv4:172.16.97.228/61429)
C:\Program Files (x86)\HK-Software\IBExpert\IBExpert.exe:5532
(TRA_11360, READ_COMMITTED | REC_VERSION | NOWAIT | READ_WRITE)
Statement 330:
-------------------------------------------------------------------------------
select
-- vtk
vtk.F123_ISN as VTK_F123_ISN,
vtk.F123_PROJ as VTK_F123_PROJ,
vtk.F123_OG1 as VTK_F123_OG1,
vtk.F123_OG2 as VTK_F123_OG2,
vtk.F123_F311_LIST as VTK_F123_F311_LIST,
((char_length(vtk.F123_F311_LIST) - char_length(replace(vtk.F123_F311_LIST, ';', '')) / 1) + 1)...
2021-05-12T01:49:31.4750 (6808:0000000001631DC0) EXECUTE_PROCEDURE_START
D:\PP01_12.FDB (ATT_126, SYSDBA:NONE, WIN1251, TCPv4:172.16.97.228/61429)
C:\Program Files (x86)\HK-Software\IBExpert\IBExpert.exe:5532
(TRA_11360, READ_COMMITTED | REC_VERSION | NOWAIT | READ_WRITE)
Procedure SP_TERMS:
param0 = varchar(19999), "<NULL>"
param1 = char(1), ";"
param2 = varchar(99), "<NULL>"
2021-05-12T01:49:31.4750 (6808:0000000001631DC0) ERROR AT JStatement::openCursor
D:\PP01_12.FDB (ATT_126, SYSDBA:NONE, WIN1251, TCPv4:172.16.97.228/61429)
C:\Program Files (x86)\HK-Software\IBExpert\IBExpert.exe:5532
335544348 : no current record for fetch operation
2021-05-12T01:49:38.8050 (6808:0000000001631DC0) FREE_STATEMENT
D:\PP01_12.FDB (ATT_126, SYSDBA:NONE, WIN1251, TCPv4:172.16.97.228/61429)
C:\Program Files (x86)\HK-Software\IBExpert\IBExpert.exe:5532
Statement 327:
-------------------------------------------------------------------------------
select RDB$BYTES_PER_CHARACTER from RDB$CHARACTER_SETS
where RDB$CHARACTER_SET_ID = 52
2021-05-12T01:49:38.8050 (6808:0000000001631DC0) START_TRANSACTION
D:\PP01_12.FDB (ATT_126, SYSDBA:NONE, WIN1251, TCPv4:172.16.97.228/61429)
C:\Program Files (x86)\HK-Software\IBExpert\IBExpert.exe:5532
(TRA_11361, READ_COMMITTED | REC_VERSION | NOWAIT | READ_WRITE)
2021-05-12T01:49:38.8050 (6808:0000000001631DC0) PREPARE_STATEMENT
D:\PP01_12.FDB (ATT_126, SYSDBA:NONE, WIN1251, TCPv4:172.16.97.228/61429)
C:\Program Files (x86)\HK-Software\IBExpert\IBExpert.exe:5532
(TRA_11361, READ_COMMITTED | REC_VERSION | NOWAIT | READ_WRITE)
Statement 331:
-------------------------------------------------------------------------------
select RDB$DESCRIPTION from RDB$RELATION_FIELDS
where (RDB$RELATION_NAME = 'F123') and
(RDB$FIELD_NAME = 'F123_F311_LIST')
0 ms
2021-05-12T01:49:38.8210 (6808:0000000001631DC0) EXECUTE_STATEMENT_START
D:\PP01_12.FDB (ATT_126, SYSDBA:NONE, WIN1251, TCPv4:172.16.97.228/61429)
C:\Program Files (x86)\HK-Software\IBExpert\IBExpert.exe:5532
(TRA_11361, READ_COMMITTED | REC_VERSION | NOWAIT | READ_WRITE)
Statement 331:
-------------------------------------------------------------------------------
select RDB$DESCRIPTION from RDB$RELATION_FIELDS
where (RDB$RELATION_NAME = 'F123') and
(RDB$FIELD_NAME = 'F123_F311_LIST')
2021-05-12T01:49:38.8210 (6808:0000000001631DC0) CLOSE_CURSOR
D:\PP01_12.FDB (ATT_126, SYSDBA:NONE, WIN1251, TCPv4:172.16.97.228/61429)
C:\Program Files (x86)\HK-Software\IBExpert\IBExpert.exe:5532
Statement 331:
-------------------------------------------------------------------------------
select RDB$DESCRIPTION from RDB$RELATION_FIELDS
where (RDB$RELATION_NAME = 'F123') and
(RDB$FIELD_NAME = 'F123_F311_LIST')
2021-05-12T01:49:38.8210 (6808:0000000001631DC0) COMMIT_TRANSACTION
D:\PP01_12.FDB (ATT_126, SYSDBA:NONE, WIN1251, TCPv4:172.16.97.228/61429)
C:\Program Files (x86)\HK-Software\IBExpert\IBExpert.exe:5532
(TRA_11361, READ_COMMITTED | REC_VERSION | NOWAIT | READ_WRITE)
0 ms, 1 fetch(es), 1 mark(s)
2021-05-12T01:49:38.8210 (6808:0000000001631DC0) FREE_STATEMENT
D:\PP01_12.FDB (ATT_126, SYSDBA:NONE, WIN1251, TCPv4:172.16.97.228/61429)
C:\Program Files (x86)\HK-Software\IBExpert\IBExpert.exe:5532
Statement 331:
-------------------------------------------------------------------------------
select RDB$DESCRIPTION from RDB$RELATION_FIELDS
where (RDB$RELATION_NAME = 'F123') and
(RDB$FIELD_NAME = 'F123_F311_LIST')
2021-05-12T01:49:38.8210 (6808:0000000001631DC0) START_TRANSACTION
D:\PP01_12.FDB (ATT_126, SYSDBA:NONE, WIN1251, TCPv4:172.16.97.228/61429)
C:\Program Files (x86)\HK-Software\IBExpert\IBExpert.exe:5532
(TRA_11362, READ_COMMITTED | REC_VERSION | NOWAIT | READ_WRITE)
2021-05-12T01:49:38.8210 (6808:0000000001631DC0) PREPARE_STATEMENT
D:\PP01_12.FDB (ATT_126, SYSDBA:NONE, WIN1251, TCPv4:172.16.97.228/61429)
C:\Program Files (x86)\HK-Software\IBExpert\IBExpert.exe:5532
(TRA_11362, READ_COMMITTED | REC_VERSION | NOWAIT | READ_WRITE)
Statement 332:
-------------------------------------------------------------------------------
select RDB$FIELD_SOURCE from RDB$RELATION_FIELDS
where (RDB$RELATION_NAME = 'F123') and
(RDB$FIELD_NAME = 'F123_F311_LIST')
0 ms
2021-05-12T01:49:38.8210 (6808:0000000001631DC0) EXECUTE_STATEMENT_START
D:\PP01_12.FDB (ATT_126, SYSDBA:NONE, WIN1251, TCPv4:172.16.97.228/61429)
C:\Program Files (x86)\HK-Software\IBExpert\IBExpert.exe:5532
(TRA_11362, READ_COMMITTED | REC_VERSION | NOWAIT | READ_WRITE)
Statement 332:
-------------------------------------------------------------------------------
select RDB$FIELD_SOURCE from RDB$RELATION_FIELDS
where (RDB$RELATION_NAME = 'F123') and
(RDB$FIELD_NAME = 'F123_F311_LIST')
2021-05-12T01:49:38.8210 (6808:0000000001631DC0) CLOSE_CURSOR
D:\PP01_12.FDB (ATT_126, SYSDBA:NONE, WIN1251, TCPv4:172.16.97.228/61429)
C:\Program Files (x86)\HK-Software\IBExpert\IBExpert.exe:5532
Statement 332:
-------------------------------------------------------------------------------
select RDB$FIELD_SOURCE from RDB$RELATION_FIELDS
where (RDB$RELATION_NAME = 'F123') and
(RDB$FIELD_NAME = 'F123_F311_LIST')
2021-05-12T01:49:38.8210 (6808:0000000001631DC0) COMMIT_TRANSACTION
D:\PP01_12.FDB (ATT_126, SYSDBA:NONE, WIN1251, TCPv4:172.16.97.228/61429)
C:\Program Files (x86)\HK-Software\IBExpert\IBExpert.exe:5532
(TRA_11362, READ_COMMITTED | REC_VERSION | NOWAIT | READ_WRITE)
0 ms, 1 fetch(es), 1 mark(s)
2021-05-12T01:49:38.8210 (6808:0000000001631DC0) FREE_STATEMENT
D:\PP01_12.FDB (ATT_126, SYSDBA:NONE, WIN1251, TCPv4:172.16.97.228/61429)
C:\Program Files (x86)\HK-Software\IBExpert\IBExpert.exe:5532
Statement 332:
-------------------------------------------------------------------------------
select RDB$FIELD_SOURCE from RDB$RELATION_FIELDS
where (RDB$RELATION_NAME = 'F123') and
(RDB$FIELD_NAME = 'F123_F311_LIST')
2021-05-12T01:49:38.8210 (6808:0000000001631DC0) START_TRANSACTION
D:\PP01_12.FDB (ATT_126, SYSDBA:NONE, WIN1251, TCPv4:172.16.97.228/61429)
C:\Program Files (x86)\HK-Software\IBExpert\IBExpert.exe:5532
(TRA_11363, READ_COMMITTED | REC_VERSION | NOWAIT | READ_WRITE)
2021-05-12T01:49:38.8210 (6808:0000000001631DC0) PREPARE_STATEMENT
D:\PP01_12.FDB (ATT_126, SYSDBA:NONE, WIN1251, TCPv4:172.16.97.228/61429)
C:\Program Files (x86)\HK-Software\IBExpert\IBExpert.exe:5532
(TRA_11363, READ_COMMITTED | REC_VERSION | NOWAIT | READ_WRITE)
Statement 333:
-------------------------------------------------------------------------------
select RDB$BYTES_PER_CHARACTER from RDB$CHARACTER_SETS
where RDB$CHARACTER_SET_ID = 52
0 ms
2021-05-12T01:49:38.8210 (6808:0000000001631DC0) EXECUTE_STATEMENT_START
D:\PP01_12.FDB (ATT_126, SYSDBA:NONE, WIN1251, TCPv4:172.16.97.228/61429)
C:\Program Files (x86)\HK-Software\IBExpert\IBExpert.exe:5532
(TRA_11363, READ_COMMITTED | REC_VERSION | NOWAIT | READ_WRITE)
Statement 333:
-------------------------------------------------------------------------------
select RDB$BYTES_PER_CHARACTER from RDB$CHARACTER_SETS
where RDB$CHARACTER_SET_ID = 52
2021-05-12T01:49:38.8210 (6808:0000000001631DC0) CLOSE_CURSOR
D:\PP01_12.FDB (ATT_126, SYSDBA:NONE, WIN1251, TCPv4:172.16.97.228/61429)
C:\Program Files (x86)\HK-Software\IBExpert\IBExpert.exe:5532
Statement 333:
-------------------------------------------------------------------------------
select RDB$BYTES_PER_CHARACTER from RDB$CHARACTER_SETS
where RDB$CHARACTER_SET_ID = 52
2021-05-12T01:49:38.8210 (6808:0000000001631DC0) COMMIT_TRANSACTION
D:\PP01_12.FDB (ATT_126, SYSDBA:NONE, WIN1251, TCPv4:172.16.97.228/61429)
C:\Program Files (x86)\HK-Software\IBExpert\IBExpert.exe:5532
(TRA_11363, READ_COMMITTED | REC_VERSION | NOWAIT | READ_WRITE)
0 ms, 1 fetch(es), 1 mark(s)
2021-05-12T01:49:42.8760 (6808:0000000001631DC0) ROLLBACK_TRANSACTION
D:\PP01_12.FDB (ATT_126, SYSDBA:NONE, WIN1251, TCPv4:172.16.97.228/61429)
C:\Program Files (x86)\HK-Software\IBExpert\IBExpert.exe:5532
(TRA_11360, READ_COMMITTED | REC_VERSION | NOWAIT | READ_WRITE)
0 ms, 1 fetch(es), 1 mark(s)
|
