"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 = 'óÕÂÓÞÅÔÁ') Ä×Á ÒÁÚÁ ×ÙÐÏÌÎÑÅÔÓÑ, ÜÔÏ ÎÅÐÒÁ×ÉÌØÎÏ, ÚÁÓÁÄÁ ÐÒÏÓÔÏ. îÁÄÏ ÐÒÁ×ÉÔØ ÄÁÎÎÁÑ ÉÄÅÑ ÐÏ ÞÕÔØ ÞÕÔØ ×ÖÉ×ÁÅÔÓÑ. äÅÌÏ × ÔÏÍ, ÞÔÏ ÎÁ ×ÓÅ ÓÌÕÞÁÉ ÖÉÚÎÉ ËÏÌÏÎÏË ÎÅ ÎÁÌÅÐÉÛØ, ÐÒÉÈÏÄÉÔÓÑ ÄÅÌÁÔØ ÄÉÎÁÍÉÞÅÓËÉÅ É ÔÏ ÓÏÚÄÁÀÔÓÑ ÏÎÉ ÐÏ ÍÅÒÅ ÎÅÏÂÈÏÄÉÍÏÓÔÉ É ÔÏÌØËÏ ËÏÇÄÁ × ÎÉÈ ÚÎÁÞÅÎÉÅ ÚÁÐÉÛÅÔÓÑ.