"Dmitry Yemanov" <[EMAIL PROTECTED]>
ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: news:[EMAIL PROTECTED]
>
> áÎÄÒ¦Ê öÕË wrote:
>>
>> ÕÐÒÏÝÅÎÎÙÊ ÐÒÉÍÅÒ
>> select COALESCE(GEN_ID(T,1), 0) from rdb$database
>> Õ×ÅÌÉÞÉ×ÁÅÔ ÇÅÎÅÒÁÔÏÒ T ÎÁ 2, Á ÎÅ ÎÁ 1
>
> îÅ ÂÕÄÅÔ.
üÜÜÜÜ ÎÅ ÓÔÏÑÔØ ÂÏÑÔØÓÑ Ñ ÄÁÖÅ É ÎÅ ÚÁÍÅÔÉÌ ÈÏÔÑ É ÂÙÌÏ ÐÒÉ ÁÎÁÌÉÚÅ ÏÄÎÏÇÏ
ÚÁÐÒÏÓÁ ÞÔÏ ÞÔÏ ÔÏ ÓÔÒÁÎÎÏ ÍÎÏÇÏ ÞÔÅÎÉÊ, ÎÏ Ô.Ë. ÓÔÁÌÏ ÒÁÂÏÔÁÔØ ÐÒÉÅÍÌÅÍÏ
ÄÁÌÅÅ ÎÅ ÓÔÁÌ ËÏ×ÙÒÑÔØ, Á ÔÕÔ ÔÁËÏÅ ÂÅÚÏÂÒÁÚÉÅ Õ ÍÅÎÑ ÔÁËÏÅ ÎÁÐÉÞËÁÎÏ
SELECT
COALESCE((SELECT FieldData from D500FieldData S WHERE
S.D500_1 = D500.D500_1 and S.FieldName = 'óÕÂÓÞÅÔÁ'), 0),
COALESCE((SELECT FieldData from D500FieldData S WHERE
S.D500_1 = D500.D500_1 and S.FieldName = 'ïÓÔÁÔËÉ É ÏÂÏÒÏÔÙ'), 0)
FROM D500 WHERE D500.D500_1 = :AD500_1
INTO :SubSchet, :D500_9;
ÐÏÌÕÞÁÅÔÓÑ
(SELECT FieldData from D500FieldData S WHERE
S.D500_1 = D500.D500_1 and S.FieldName = 'óÕÂÓÞÅÔÁ')
Ä×Á ÒÁÚÁ ×ÙÐÏÌÎÑÅÔÓÑ, ÜÔÏ ÎÅÐÒÁ×ÉÌØÎÏ, ÚÁÓÁÄÁ ÐÒÏÓÔÏ. îÁÄÏ ÐÒÁ×ÉÔØ ÄÁÎÎÁÑ
ÉÄÅÑ ÐÏ ÞÕÔØ ÞÕÔØ ×ÖÉ×ÁÅÔÓÑ. äÅÌÏ × ÔÏÍ, ÞÔÏ ÎÁ ×ÓÅ ÓÌÕÞÁÉ ÖÉÚÎÉ ËÏÌÏÎÏË ÎÅ
ÎÁÌÅÐÉÛØ, ÐÒÉÈÏÄÉÔÓÑ ÄÅÌÁÔØ ÄÉÎÁÍÉÞÅÓËÉÅ É ÔÏ ÓÏÚÄÁÀÔÓÑ ÏÎÉ ÐÏ ÍÅÒÅ
ÎÅÏÂÈÏÄÉÍÏÓÔÉ É ÔÏÌØËÏ ËÏÇÄÁ × ÎÉÈ ÚÎÁÞÅÎÉÅ ÚÁÐÉÛÅÔÓÑ.
