[gjtrd]

Сообщение от Asinkrit

DBLookupComboboxEh2.KeyValue; если память не подводит..

Спасибо, получилось.
Еще один вопрос есть. Пытаюсь создать представление в интербейз. Пишет ошибку must specify column name for view select expression on line 1. Запрос ниже.

Код:

Create View Kniga AS 
Select B.ID_BOOK AS ID, B.DATA AS DATA, B.DoC AS NAKL, B.Vid AS VID, B.KOL AS KOL, B.PICE_Book AS CENA, P.Name_post AS NAME, M.Name_Mat AS MAT from Book B, Post P, Dept D, Mat M
Where (b.Id_post=p.ID_post) AND (B.ID_dept IS NULL) AND (b.ID_MAT=m.ID_MAT) 
union 
Select B.ID_BOOK AS ID, B.DATA AS DATA, B.DoC AS NAKL, B.Vid AS VID, B.KOL AS KOL, B.PICE_Book AS CENA, D.Name_dept AS NAME, M.Name_Mat AS MAT from Book B, Post P, Dept D, Mat M
Where (b.ID_dept=d.ID_DEPT) AND (B.ID_POST IS NULL) And (b.ID_MAT=m.ID_MAT);