Create sql View vPriceNorm as SELECT Price.nPriceId as nVPriceId, katalog.cKatalog, Izg.cizg, Post.cpost, Price.ncena,;
	Price.nostat, Price.cupak, Price.nkol, Price.dsrok, Price.npnds;
FROM price LEFT OUTER JOIN post ON Price.npostid = Post.npostid;
	LEFT OUTER JOIN tovar ON Price.ntovarid = Tovar.ntovarid;
   	LEFT OUTER JOIN Katalog ON Tovar.nKatalogId = Katalog.nKatalogId;
   	LEFT OUTER JOIN izg ON Tovar.nizgid = Izg.nizgid;
Where (glKol = .f. and (empty(gcFind) or like('*'+gcFind+'*', Upper(cKatalog)))) or (glKol = .t. and nKol >  0 );
Order by cKatalog

DbSetProp('vPriceNorm', 'View', 'Tables', 'Price')
DbSetProp('vPriceNorm.nVPriceId', 'Field', 'UpdateName', 'price.nPriceId')
DbSetProp('vPriceNorm.nVPriceId', 'Field', 'KeyField', .t.)
DbSetProp('vPriceNorm.nKol', 'Field', 'Updatable', .t.)
DbSetProp('vPriceNorm', 'View', 'SendUpdates', .t.)