Создание базы данных “Электроприборы”, страница 10

*       * Called By:  ON SELECTION BAR 2 OF POPUP поисквзави     

*       * Prompt:     самого дешёвого прибора                    

*       * Snippet:    18                                         

*       *                                                        

*       *********************************************************

*

PROCEDURE _0j8113zdv

SELECT TOP 1 Electrical_devices.type, Electrical_devices.naimenov,;

  Electrical_devices.weight, Electrical_devices.proizvodit,;

  Electrical_devices.price;

 FROM "d:\ngtu\субд\rgr\electrical-devices" Electrical_devices;

 ORDER BY Electrical_devices.price;

*       *********************************************************

*       *                                                        

*       * _0J8113ZDX  ON SELECTION BAR 3 OF POPUP поисквзави     

*       *                                                        

*       * Procedure Origin:                                      

*       *                                                        

*       * From Menu:  ELECTRICAL-DEVICES.MPR,            Record:   23

*       * Called By:  ON SELECTION BAR 3 OF POPUP поисквзави     

*       * Prompt:     общей средней стоимости                    

*       * Snippet:    19                                         

*       *                                                        

*       *********************************************************

*

PROCEDURE _0j8113zdx

SELECT AVG(Electrical_devices.price);

 FROM "d:\ngtu\субд\rgr\electrical-devices" Electrical_devices;

*       *********************************************************

*       *                                                        

*       * _0J8113ZDZ  ON SELECTION BAR 4 OF POPUP поисквзави     

*       *                                                         

*       * Procedure Origin:                                      

*       *                                                        

*       * From Menu:  ELECTRICAL-DEVICES.MPR,            Record:   24

*       * Called By:  ON SELECTION BAR 4 OF POPUP поисквзави     

*       * Prompt:     цены, заданной в пределах                  

*       * Snippet:    20                                         

*       *                                                        

*       *********************************************************

*

PROCEDURE _0j8113zdz

do form d:\ngtu\субд\rgr\price_beetwen.scx