FB 1.5
IBExpert
óÔÁÂÉÌØÎÏ ÐÁÄÁÅÔ ÓÅÒ×ÅÒ ÐÒÉ ×ÙÐÏÌÎÅÎÉÉ ÐÒÏÃÅÄÕÒÙ Ó ÓÏÏÂÝÅÎÉÅÍ × ÌÏÇÅ
Access violation.
The code attempted to access a virtual
address without privilege to do so.
This exception will cause the Firebird server
to terminate abnormally.
ðÕÔÅÍ ÎÁÕÞÎÏÇÏ ËÏÍÍÅÎÔÉÒÏ×ÁÎÉÑ ÔÅÌÁ ÐÒÏÃÅÄÕÒÙ ÂÙÌ ÎÁÊÄÅÎ ÏÐÅÒÁÔÏÒ
ÉÚ-ÚÁ ËÏÔÏÒÏÇÏ ÏÎ ÐÁÄÁÅÔ
--------------------
select first 1 s.kod_gruppy_lyudej,s.priznak from uk_s_pernal s
where s.vid_naloga = :W_pr1
order by s.nachalo_perioda desc
into :kod_gruppy_lyudej,:priznak;
-----------------------------
åÓÌÉ ÕÂÒÁÔØ order by ÔÏ ×ÓÅ ÐÒÏÈÏÄÉÔ ÎÏÒÍÁÌØÎÏ
äÁ É ÅÝÅ ÐÒÉ ×ÙÐÏÌÎÅÎÉÉ × SQL ÒÅÄÁËÔÏÒÅ ×ÓÅ ÎÏÒÍÁÌØÎÏ.
îÕ É ÔÒÁÄÉÃÉÏÎÎÏ ×ÏÐÒÏÓ × ÞÅÍ Ñ ÎÅ ÐÒÁ×??
äÌÑ ÐÏÌÎÏÔÙ ËÁÒÔÉÎÙ -
ïÐÉÓÁÎÉÅ ÐÅÒÅÍÅÎÎÙÈ
W_pr1 - varchar(64);
kod_gruppy_lyudej - varchar(6)
priznak - varchar(6)
ïÐÉÓÁÎÉÅ ÔÁÂÌÉÃÙ
CREATE TABLE UK_S_PERNAL (
ID$ INTEGER,
VID_NALOGA VARCHAR(2),
NACHALO_PERIODA DATE,
KONEC_PERIODA DATE,
PRIZNAK VARCHAR(3),
KOD_GRUPPY_LYUDEJ VARCHAR(2),
IMYA_NALOGA VARCHAR(24),
TIP_NALOGA VARCHAR(12)
);
(éÍÅÎÎÏ ÔÁË ÂÅÚ ÐÅÒ×ÉÞÎÏÇÏ ËÌÀÞÁ)
íÁËÍÁË
