تعليم اوراكل حتى الاحتراف

 ‫א‬‫א‬‫א‬ ã¹]<gè…‚jÖ]æ<ËÖ]<Üé×Ãj×Ö<íÚ^ÃÖ]<퉉ö¹] ‫א‬‫א‬‫א‬‫א‬

  J‫א‬‫א‬

١٦٢

 

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

 

 W،،‫א‬‫א‬،‫א‬



‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬   ‫א‬ ‫א‬  ،‫א‬    ‫א‬ ‫א‬ ‫א‬ ‫א‬ ‫א‬ 

‫א‬‫א‬ ‫א‬‫א‬‫א‬‫א‬

 ‫؛‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬

 K ‫א‬‫א‬‫א‬ 

‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬

  ‫א‬        ،‫א‬ ‫א‬‫א‬   ‫א‬  ‫א‬ ‫א‬ ‫א‬ ‫א‬ ‫א‬   ‫א‬    ، 

‫א‬،‫א‬‫א‬‫א‬‫א‬ ‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬

     ‫א‬  ‫א‬   ،‫א‬     K‫א‬‫א‬،‫א‬‫א‬ 

??? ‫א‬‫א‬?‫א‬‫א‬  K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬ 

‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬ ،‫א‬،‫א‬‫א‬‫א‬‫א‬  K‫א‬‫א‬‫א‬‫א‬‫א‬ 

،‫א‬‫א‬‫א‬‫א‬

 K‫א‬ 

 ‫א‬‫א‬‫א‬‫א‬

 

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

 

‫א‬‫א‬‫א‬‫א‬

‫א‬،‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬،‫א‬ SQL-Plus،‫א‬‫א‬‫א‬‫א‬  ‫א‬‫א‬‫א‬

‫א‬ ‫א‬‫א‬  K‫א‬

‫א‬‫א‬ ‫א‬‫א‬Oracle‫א‬

 KOracle Developer‫א‬‫א‬‫א‬‫א‬،‫א‬ ‫א‬‫א‬  ‫א‬‫א‬

Oracle‫א‬ ‫א‬‫א‬‫א‬‫א‬‫א‬  W‫א‬‫א‬



 WOracle Developer‫א‬‫א‬

‫א‬‫א‬WForm Builder  K‫א‬‫א‬‫א‬‫א‬

 K‫א‬‫א‬‫א‬WReport Builder  K‫א‬‫א‬‫א‬WGraphics Builder

‫א‬‫א‬WQuery Builder  K

 

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

‫א‬‫א‬‫א‬‫א‬‫א‬  W‫א‬‫א‬‫א‬‫א‬ S_CUSTOMER Description Data type   ‫؟‬Null



Column Name

J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J

J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J ENUMBER(7

EVARCHAR2(50



NOT NULL



EVARCHAR2(25



EVARCHAR2(30



EVARCHAR2(400



NOT NULL 

















 







 





 ID

NAME

PHONE

 ADDRESS CITY

EVARCHAR2(20













EVARCHAR2(30











 COUNTRY

EVARCHAR2(75











ZIP_CODE

EVARCHAR2(9 ENUMBER(7 ENUMBER(7

















EVARCHAR2(255



CREDIT_RATING



 

S_DEPT Description Data type  



 SALES_REP_ID







REGION_ID



‫؟‬Null

STATE





COMMENTS

Column Name

J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J ENUMBER(7



ENUMBER(7



EVARCHAR2(25



NOT NULL







NOT NULL 









 ID

NAME

REGION_ID

 

S_EMP Description Data type  

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

‫؟‬Null



Column Name

J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J

J J J J J J J J J J J J J J J ENUMBER(7

EVARCHAR2(25





EVARCHAR2(25

NOT NULL

NOT NULL















 ID

LAST_NAME

 FIRST_NAME

EVARCHAR2(8       USERID DATE      START_DATE EVARCHAR2(255      COMMENT ENUMBER(7



ENUMBER(7



EVARCHAR2(25 ENUMBER(11,2 ENUMBER(4,2

  







 







 







 

 MANAGER_ID 







TITLE

 DEPT_ID

 SALARY

COMMISSION_PCT

 

S_ITEM Description Data type  

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

‫؟‬Null



Column Name

J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J

J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J ENUMBER(7



NOT NULL



 ORD_ID

ENUMBER(7



NOT NULL



 ITEM_ID

ENUMBER(7



NOT NULL

 PRODUCT_ID

ENUMBER(9



ENUMBER(11,2 ENUMBER(9













S_ORD Description Data type  















PRICE

QUANTITY

 QUANTITY_SHIPPED

‫؟‬Null



Column Name

J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J ENUMBER(7

ENUMBER(7 DATE  DATE  ENUMBER(7



NOT NULL

   



 ID

NOT NULL  CUSTOMER_ID   DATE_ORDERED   DATE_SHIPPED     SALES_REP_ID

ENUMBER(11,2









EVARCHAR2(6









S_PRODUCT Description Data type   ‫؟‬Null



EVARCHAR2(1















TOTAL

PAYMENT_TYPE

 ORDER_FILLED

Column Name

 

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J ENUMBER(7

EVARCHAR2(50





EVARCHAR2(255 ENUMBER(7

ENUMBER(7

NOT NULL

NOT NULL

 

ENUMBER(11,2



 





EVARCHAR2(25

 









 









 ID NAME

 SHORT_DESC  LONGTEXT_ID





 IMAGE_ID

SUGGESTED_WHLSL_PRICE 

S_REGION Description Data type   ‫؟‬Null





 WHLSL_UNITS

Column Name

J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J

J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J ENUMBER(7

EVARCHAR2(50



NOT NULL



NOT NULL











ID

NAME

 

S_TITLE Description Data type  

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

‫؟‬Null



Column Name

J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J

J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J EVARCHAR2(25



NOT NULL

S_INVENTORY Description Data type   ‫؟‬Null







TITLE

Column Name

J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J

J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J FNUMBER(7



NOT NULL

FNUMBER(9



FNUMBER(7

PRODUCT_ID

NOT NULL 



WAREHOUSE_ID

 AMOUNT_IN_STOCK









REORDER_POINT

FVARCHAR2(255 DATE  

 

FNUMBER(9

FNUMBER(9













MAX_IN_STOCK

OUT_OF_STOCK_EXPLANATION  RESTOCK_DATE

 ‫א‬‫א‬‫א‬ ã¹]<gè…‚jÖ]æ<ËÖ]<Üé×Ãj×Ö<íÚ^ÃÖ]<퉉ö¹] ‫א‬‫א‬‫א‬‫א‬

‫א‬‫א‬

 Form Builder

Form Builder 

١

 ‫א‬‫א‬ Form Builder

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

 W‫א‬‫א‬  Form Builder‫א‬‫א‬  W‫א‬‫א‬  W‫א‬ ‫א‬‫א‬ KForm Builder‫א‬ J ١

KForm Builder‫א‬‫א‬ J ٢ KObject Navigator J ٣ KLayout Editor J ٤

KConnect‫א‬‫א‬ J ٥ KCompile File J ٦

‫א‬‫א‬‫א‬‫א‬ J ٧ Runtime Form‫א‬

‫א‬‫א‬‫א‬‫א‬ J ٨ KEnter Query Mode ‫א‬‫א‬‫א‬‫א‬ J ٩ KExecute Query Mode

 W‫א‬‫א‬‫א‬  K٪١٠٠‫א‬‫א‬‫א‬  W‫א‬‫א‬

 W‫א‬‫א‬ K •



 K • K •

 W‫א‬‫א‬  K‫א‬‫א‬‫א‬‫א‬،‫א‬ -١-

 ‫א‬‫א‬ Form Builder

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

 Form Builder

Oracle Developer‫א‬‫א‬‫א‬‫א‬Form Builder‫א‬

‫א‬‫א‬،‫א‬‫א‬‫א‬

‫א‬‫א‬‫א‬

 K‫א‬

 WForm Builder‫א‬  Form Builder‫א‬



  W‫א‬Form Builder‫א‬‫א‬   -٢-

 ‫א‬‫א‬ Form Builder

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

Object Navigator‫א‬ J ١  ‫א‬‫א‬‫א‬‫א‬

،‫א‬‫א‬ ‫א‬،‫א‬

Kobject‫א‬،Navigator‫א‬  W‫א‬‫א‬

 KF3 J ١  KObject NavigatorTools J ٢

W‫א‬



              

‫א‬ObjectsForm Builder‫א‬‫א‬‫א‬‫א‬  WObject Navigator‫א‬ 

-٣-

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

Form Builder

 

EObjectF‫א‬

 K‫א‬‫א‬‫א‬  K‫א‬‫א‬ 

Module1 Trigger Alerts

 K‫א‬

‫א‬ ‫א‬‫א‬ Attached Libraries  ‫א‬

‫א‬ ،‫א‬ 

Data Block

،Data Block‫א‬  ‫א‬‫א‬

Data Block‫א‬ ‫א‬‫א‬‫א‬‫א‬ Data Block    Control Block

Data Block‫א‬  K‫א‬‫א‬

  ‫א‬‫א‬W

Items

‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬ ‫א‬  ‫א‬Data Block‫א‬

 KCanvas‫א‬‫א‬‫א‬Canvas

‫א‬‫א‬ ‫א‬‫א‬

Canvases

 Canvas‫א‬‫א‬‫א‬

Canvas،Data Block

 KWindows

‫א‬Item  K٢٥٥varchar2

Editor

‫א‬W

 LOVs

 K‫א‬‫א‬‫א‬‫א‬‫א‬

Parameter

 K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬ -٤-

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

Form Builder

 

EObjectF‫א‬

K‫א‬‫א‬‫א‬‫א‬‫א‬  K‫א‬‫א‬‫א‬ K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬   ‫א‬‫א‬ ‫א‬  K‫א‬    ‫א‬‫א‬ ‫א‬‫א‬

Popup Menus Program Unit Record Groups Visual Attribute

 Windows

 K

‫א‬Form Builder‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬  KObject Navigator‫א‬

 Layout Editor‫א‬ J ٢  ،‫א‬‫א‬‫א‬‫א‬

،‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬Tool Palette‫א‬ ‫א‬‫א‬‫א‬Toolbar‫א‬ K‫א‬‫א‬‫א‬‫א‬ Layout Editor‫א‬



-٥-

 ‫א‬‫א‬ Form Builder

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

‫א‬‫א‬  ‫א‬‫א‬‫א‬W  KObject Navigator‫א‬

 W‫א‬‫א‬

 F2 J ١ Layout EditorTools J ٢

Property Palette‫א‬ J ٣ ‫א‬‫א‬‫א‬ ‫א‬‫א‬  ‫א‬‫א‬‫א‬

‫א‬‫א‬ K‫א‬‫א‬‫א‬

Layout Editor‫א‬‫א‬‫א‬‫א‬

 WObject Navigator

 F4 J ١ KProperty PaletteTools J ٢

-٦-

 ‫א‬‫א‬ Form Builder

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

  ‫א‬



 

-٧-

 ‫א‬‫א‬ Form Builder

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

 ‫א‬‫א‬  Running a Form Builder Application

Form ‫א‬‫א‬‫א‬‫א‬Run

 K‫א‬‫א‬‫א‬Run-time Form‫א‬‫א‬Builder

 W‫א‬‫א‬‫א‬

 K‫א‬‫א‬‫א‬ConnectFile J ١

Compile‫א‬‫א‬

 W‫א‬

 AdministrationFile J ١

Compile File J ٢ 

 W‫א‬‫א‬‫א‬‫א‬ program J ١

Run Form J ٢

Client/Server J ٣

Ctrl + R J ٤

 KERunF‫א‬‫א‬‫א‬‫א‬



‫א‬‫א‬MDI Parent Window‫א‬‫א‬‫א‬‫א‬  K‫א‬        -٨-

 ‫א‬‫א‬ Form Builder

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

 Run Time Form‫א‬





‫א‬‫א‬‫א‬‫א‬‫א‬MDI Parent Window  

١

 ‫א‬

٢

 ‫א‬‫א‬

٣

‫א‬‫א‬‫א‬‫א‬‫א‬  K‫א‬

٤ 

،‫א‬ ‫א‬‫א‬‫א‬ ‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬  K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬  -٩-

 ‫א‬‫א‬ Form Builder

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

 ‫א‬‫א‬  ENormal ModeF‫א‬‫א‬W‫א‬‫א‬ ‫א‬‫א‬Run-Time Form‫א‬‫א‬‫א‬‫א‬‫א‬  ‫א‬ 

 WNormal Mode‫א‬‫א‬  K‫א‬‫א‬‫ א‬-

K K‫א‬ K‫א‬ -

ECommit recordFK‫א‬ -

KERollback RecordFK‫א‬‫א‬‫ א‬-

KData Block‫ א‬-

KExit Form‫א‬‫ א‬-

 KNormal Mode‫א‬‫א‬  K‫א‬‫ א‬-



 WEnter Query modeE‫א‬F‫א‬W‫א‬‫א‬  K‫א‬‫א‬‫א‬‫א‬‫א‬  EEnter Query ModeF‫א‬‫א‬

 KF7EnterQuery -

‫א‬،‫א‬‫א‬  ‫א‬ K‫א‬‫א‬

 ‫א‬‫א‬

 KF8ExecuteQuery -

 KLIKE‫א‬E٪F‫א‬‫א‬‫א‬W - ١٠ -

 ‫א‬‫א‬ Form Builder

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

 WEnter Query Mode‫א‬‫א‬  K‫א‬‫ א‬-

K‫א‬‫ א‬-

K‫א‬‫א‬‫א‬ -



 WEnter Query Mode‫א‬‫א‬

 KECurrent Data BlockF‫א‬‫א‬‫א‬ -

K‫א‬‫ א‬-

  ‫א‬‫א‬ ‫א‬‫א‬‫א‬ K

K‫א‬ -

K‫א‬  

  

- ١١ -

 ‫א‬‫א‬ Form Builder

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

 ‫א‬‫א‬‫א‬‫א‬

 EInsert RecordF‫א‬

‫א‬‫א‬Data Block‫א‬‫א‬

 W‫א‬‫א‬‫א‬

 KInsertRecord -

K‫א‬ECreateF‫א‬‫א‬ -

K‫א‬‫א‬‫א‬‫ א‬-

 ‫א‬ ‫א‬‫א‬‫א‬ K‫א‬



 EUpdate RecordF‫א‬

‫א‬‫א‬‫א‬ ‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬

 K‫א‬‫א‬‫א‬‫א‬ 

 EDelete RecordF‫א‬ ‫א‬‫א‬‫א‬ ‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬

 W‫א‬‫א‬

 KRemoveRecord -

K‫א‬‫א‬DeleteEXF‫א‬‫א‬ -

K‫א‬‫א‬‫א‬ -



‫א‬Data Base‫א‬ ‫א‬‫א‬‫א‬  W‫א‬‫א‬Commit  KSaveAction -

K‫א‬‫א‬‫א‬ -

K‫א‬F10 - ١٢ -

 ‫א‬‫א‬ Form Builder

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

‫א‬‫א‬‫א‬ ‫א‬‫א‬‫א‬EF  W‫א‬‫א‬،Rollback‫א‬

 KClear AllAction -



 W‫א‬‫א‬،‫א‬  KExitAction -

KExit‫א‬‫א‬‫א‬ -

K‫א‬‫א‬‫א‬ -



- ١٣ -

 ‫א‬‫א‬‫א‬ ã¹]<gè…‚jÖ]æ<ËÖ]<Üé×Ãj×Ö<íÚ^ÃÖ]<퉉ö¹] ‫א‬‫א‬‫א‬‫א‬

‫א‬‫א‬

Module

Module 

٢

 ‫א‬‫א‬ Module

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

W‫א‬‫א‬ DetailMaster،Data Block  W‫א‬‫א‬  W‫א‬ ‫א‬‫א‬  KData Block Wizard‫א‬Data Block K١

KData Block Wizard‫א‬DetailMaster K٢ KDetailMaster K٣ K‫א‬ K٤ W‫א‬‫א‬‫א‬  K٪٨٠‫א‬‫א‬‫א‬ 

 KW‫א‬‫א‬ 

 W‫א‬‫א‬  K • K •  K •



W‫א‬‫א‬  K‫א‬‫א‬‫א‬‫א‬،‫א‬

- ١٤ -

 ‫א‬‫א‬ Module

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

 Module Create a Basic Form Module Module،‫א‬ModuleForm Builder‫א‬‫א‬‫א‬  Data Block‫א‬‫א‬ ‫א‬Data Block  K‫א‬

 WModule‫א‬‫א‬‫א‬‫א‬   Module

  KModule J ١

KitemsData Blocks‫א‬ J ٢ KData Blocks‫א‬‫א‬‫א‬‫א‬ J ٣

KModule‫א‬‫א‬ J ٤ KItems‫א‬ J ٥

K‫א‬‫א‬‫א‬‫א‬ J ٦ K‫א‬‫א‬ J ٧ - ١٥ -

 ‫א‬‫א‬ Module

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

 EModuleF •  W‫א‬EModuleF W‫א‬E‫א‬F‫א‬ -

Data   ‫א‬EUse the Data Block WizardF‫ א‬o

K‫א‬‫א‬Block Object NavigatorForm Builder‫א‬‫א‬‫ א‬J W‫א‬EModuleF

KForm‫א‬ o

K‫א‬‫א‬Create‫א‬ o

KForm‫א‬New‫א‬‫א‬‫א‬File o  W‫א‬EModuleF‫א‬‫א‬ • K‫א‬‫א‬EModuleF‫א‬‫א‬ o

‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬   o K‫א‬‫א‬‫א‬‫א‬F4‫א‬

K‫א‬Objects‫א‬W  K‫א‬Data Blocks‫א‬

 

 EModuleF‫א‬ • ‫א‬ObjectsObjectsModule  KEModuleF



 W‫א‬Object‫א‬

 K‫א‬‫א‬Object‫א‬‫א‬‫א‬Object Navigator - ١٦ -

 ‫א‬‫א‬ Module

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

Property ‫א‬ToolsObject‫א‬‫א‬Object Navigator -

Palette ‫א‬Layout EditorObject Navigator‫א‬Object‫א‬  KF4

  W‫א‬‫א‬EModuleF‫א‬

 Object Navigator‫א‬‫א‬‫א‬Name‫א‬J ١ Object‫א‬‫א‬Coordinate System‫א‬J ٢  K‫א‬‫א‬

- ١٧ -

 ‫א‬‫א‬ Module

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

 Data Block

،Control Block   ‫א‬Data Block   ‫א‬

Data Block   ‫א‬ EModuleF ‫א‬ Data Block‫א‬ Data Block‫א‬

 KData Block Wizard‫א‬‫א‬‫א‬ 

 Data Block Data Block Wizard ‫اﺳﺘﺪﻋﺎء‬

‫א‬

layout Wizard ‫א‬

 Data Block ‫א‬ ‫א‬





 WData Block Wizard‫א‬Data Block‫א‬ • W‫א‬‫א‬‫א‬‫א‬ Object Navigator KData Block Wizard‫א‬Tools o

‫א‬ Object Navigator‫א‬‫א‬ o KData Block Wizard

Create‫א‬Data Block‫א‬Object Navigator o KUse Data Block Wizard‫א‬‫א‬‫א‬ - ١٨ -

 ‫א‬‫א‬ Module

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

 K‫א‬‫א‬Data Block Wizard‫א‬Layout Editor o

W‫א‬Type Page -

Table ‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬

Stored ‫א‬‫א‬‫א‬  ‫א‬‫א‬‫א‬or View

 K‫א‬‫א‬Next‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬Procedure

- ١٩ -

 ‫א‬‫א‬ Module

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

 KTable Page‫א‬‫א‬ 





‫א‬‫א‬Browse‫א‬  ‫א‬‫א‬‫א‬  K‫א‬

‫א‬‫א‬‫א‬Refresh

 K‫א‬‫א‬

 <<>>‫א‬‫א‬Data Block‫א‬‫א‬‫א‬‫א‬‫א‬

 K‫א‬‫א‬‫א‬<>‫א‬‫א‬‫א‬‫א‬‫א‬ ‫א‬Constraints‫א‬‫א‬Enforce Data Integrity‫א‬ ‫א‬ 

 KData Block‫א‬‫א‬‫א‬  W‫א‬‫א‬Next‫א‬

- ٢٠ -

 ‫א‬‫א‬ Module

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

 KFinish Page‫א‬‫א‬ -





Create the Data Block, then call the layout Wizard‫א‬‫א‬ ‫א‬

Finish‫א‬‫א‬Data Block‫א‬Layout Wizard  KLayout Wizard‫א‬‫א‬

 ‫א‬‫א‬  Just Create the data block‫א‬ ‫א‬   KData Block‫א‬Data Block  Canvas Page‫א‬‫א‬ -

 - ٢١ -

 ‫א‬‫א‬ Module

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

Canvas‫א‬‫א‬Data Block‫א‬New Canvas‫א‬‫א‬  W‫א‬‫א‬Next‫א‬Content‫א‬ Data Block Page‫א‬‫א‬ -

 Canvas‫א‬Data Block‫א‬‫א‬‫א‬  W‫א‬‫א‬Next‫א‬

KPageItem‫א‬‫א‬ -

- ٢٢ -

 ‫א‬‫א‬ Module

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

‫א‬ ‫א‬Data Block‫א‬ ‫א‬  W‫א‬‫א‬Next‫א‬،Canvas‫א‬ KStyle Page‫א‬‫א‬ -



 ‫א‬‫א‬‫א‬  K‫א‬‫א‬‫א‬ Data Block‫א‬Form

 K‫א‬‫א‬‫א‬ Data Block‫א‬Tabular  Rows PageNext‫א‬



- ٢٣ -

 ‫א‬‫א‬ Module

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

‫א‬ ‫א‬ ،‫א‬ ‫א‬ ‫א‬  K‫א‬‫א‬،‫א‬‫א‬،‫א‬

 WFinishNext‫א‬





‫א‬Data Block‫א‬ ‫א‬

‫א‬Finish‫א‬Layout  KData Block‫א‬

EModuleF‫א‬ • ‫א‬OK‫א‬ ‫א‬‫א‬  ‫א‬Save‫א‬File o Kfmb‫א‬

Compiling Module‫א‬ • ‫א‬EExecutable ModuleF‫א‬‫א‬

 fmxK‫א‬‫א‬‫א‬  W‫א‬

 Compile FileAdministration‫א‬‫א‬File KCtrl+T‫א‬ -

- ٢٤ -

 ‫א‬‫א‬ Module

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

EModuleF‫א‬ • RunProgram o KRun icon‫א‬ o

CTRL + R‫א‬‫א‬ o



‫א‬ • Convert‫א‬Administration‫א‬‫א‬File o Form , Menu , F‫א‬EModuleF  ‫א‬‫א‬‫א‬‫א‬‫א‬

Convert‫א‬EPL/SQL Libraries , Object Libraries Kfmt‫א‬‫א‬



 W‫א‬‫א‬ •

Object list ‫א‬Administration‫א‬‫א‬File o

txt‫א‬‫א‬‫א‬Report

 K‫א‬‫א‬ •

 ‫א‬‫א‬‫א‬  Compilation‫א‬‫א‬  ‫א‬‫א‬

Form Module binary

fmbK

Form Module executable Form Module Text

fmxK fmtK



- ٢٥ -

 ‫א‬‫א‬ Module

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

 Master – Detail Relationship‫א‬‫א‬‫א‬‫א‬‫• א‬ ‫א‬‫א‬ Detail‫א‬‫א‬ Master‫א‬‫א‬  ‫ א‬o ‫א‬‫א‬Foreign Key‫א‬‫א‬Master‫א‬‫א‬Primary Key Detail KMaster Detail‫א‬‫ א‬o KDetailMaster‫א‬‫א‬ o



 Detail Data Block‫א‬Master Data Block‫א‬‫א‬





- ٢٦ -

 ‫א‬‫א‬ Module

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

KData Block Wizard‫א‬ Master‫א‬‫א‬‫א‬‫א‬‫א‬Data Block Wizard‫ א‬o

•

  ‫א‬  ‫א‬‫א‬Detail Data Block Wizard W‫א‬‫א‬





‫א‬ Auto-Join data blocks‫א‬ ‫א‬Master-Detail page‫א‬   ‫א‬‫א‬‫א‬‫א‬‫א‬Create Relationship Detail ‫א‬‫א‬Foreign key‫א‬‫א‬‫א‬‫א‬Data Blocks‫א‬

 KBlock

‫א‬Detail‫א‬Master‫א‬OK‫א‬

‫א‬Next‫א‬Join Condition‫א‬‫א‬‫א‬Master – Detail  KData Block‫א‬ 

 W‫א‬‫א‬‫א‬‫א‬‫• א‬  ‫א‬Relation‫א‬ Master    ‫א‬‫א‬‫ א‬o W‫א‬‫א‬Create

- ٢٧ -

 ‫א‬‫א‬ Module

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 





  RelationDept‫א‬Master Block‫א‬‫א‬‫א‬

Join ‫א‬‫א‬‫א‬Detail‫א‬‫א‬Dept‫א‬

 W‫א‬‫א‬Detail‫א‬‫א‬Master‫א‬‫א‬Condition Detail.Foreign Key = Master.Primary key



‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬OK‫א‬ ‫א‬‫א‬  W‫א‬‫א‬Master Block‫א‬‫א‬‫א‬‫א‬ Master Block‫א‬‫א‬ ‫א‬‫א‬

Non-Isolated

Detail ‫א‬‫א‬  ‫א‬‫א‬Detail Block‫א‬‫א‬ Master Block‫א‬‫א‬‫א‬‫א‬Block

 ‫א‬‫א‬Master‫א‬‫א‬ 

Cascading

 K‫א‬‫א‬‫א‬

Isolated

Detail‫א‬‫א‬

  ‫א‬ - ٢٨ -

 ‫א‬‫א‬ Module

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 





 W‫א‬‫א‬‫א‬‫א‬‫א‬ ‫א‬Detail Block‫א‬‫א‬    WCoordination‫א‬Master Block‫א‬‫א‬ Master Block‫א‬‫א‬‫א‬‫א‬

 KDetail Block‫א‬‫א‬‫א‬Detail Block‫א‬‫א‬  KDetail Block‫א‬‫א‬‫א‬

Deferred with Auto Query Deferred without Auto Query

‫א‬Detail Block‫א‬‫א‬ Prevent Masterless Operations  KMaster Block‫א‬‫א‬ 

- ٢٩ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

Module

 Data Block‫א‬

‫א‬‫א‬Layout EditorData Block‫א‬ 

 K‫א‬‫א‬‫א‬‫א‬،‫א‬‫א‬‫א‬  

  ‫א‬

 ‫א‬

EFE‫א‬F  EFEF‫א‬‫א‬‫א‬ EFE‫א‬F  EFEF‫א‬‫א‬‫א‬ ‫א‬‫א‬‫א‬‫א‬E‫א‬F  K‫א‬‫א‬

‫א‬‫א‬‫א‬‫א‬E‫א‬‫א‬‫א‬F  K‫א‬‫א‬‫א‬‫א‬ ‫א‬‫א‬‫א‬‫א‬E‫א‬F  K‫א‬‫א‬ ‫א‬‫א‬‫א‬‫א‬E‫א‬‫א‬F  K‫א‬‫א‬‫א‬

‫א‬‫א‬‫א‬‫א‬E‫א‬‫א‬‫א‬F  K‫א‬‫א‬‫א‬‫א‬ ‫א‬‫א‬‫א‬‫א‬E‫א‬‫א‬F  K‫א‬‫א‬‫א‬  K‫א‬ - ٣٠ -

 

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

Module

 ‫א‬

 ‫א‬  ‫א‬

 K‫א‬  K‫א‬  K‫א‬  K‫א‬  K‫א‬  Data Block‫א‬‫א‬‫א‬  W‫א‬‫א‬‫א‬‫א‬Size objectsArrange‫א‬‫א‬

 Height‫א‬‫א‬‫א‬Width‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬

 W

 K‫א‬‫א‬

No Change

 K‫א‬‫א‬‫א‬‫א‬

Smallest

 K‫א‬‫א‬‫א‬‫א‬

Largest

 K‫א‬‫א‬‫א‬‫א‬

Average

‫א‬‫א‬‫א‬‫א‬

Custom

Units‫א‬‫א‬‫א‬ - ٣١ -

 ‫א‬‫א‬ Module

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

 ‫א‬‫א‬‫א‬‫א‬Width‫א‬W

‫א‬‫א‬No Change‫א‬Height‫א‬

Width‫א‬‫א‬‫א‬‫א‬Height‫א‬  KNo Change‫א‬

- ٣٢ -

 ‫א‬‫א‬ Module

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

 

 ‫א‬Module  J ١

S_CUSTOMERData Block Wizard‫א‬‫א‬Data Block  K‫א‬

CV_CUSTOMERCanvasData Block‫א‬‫א‬

 KCustomer ‫א‬Canvas‫א‬‫א‬‫א‬ ‫א‬ KRUN،Cust4Module‫א‬‫ א‬J ٢

KCUSTOMERSObject Navigator‫א‬Module‫א‬‫א‬ J ٣

Canvas‫א‬Data Block‫א‬‫א‬Layout Editor‫א‬ J ٤ W‫א‬



 K‫א‬Module  J ٥

S_ORDData Block Wizard‫א‬‫א‬Data Block  TOTAL‫א‬‫א‬

CV_ORDERCanvasData Block‫א‬‫א‬

 KOrders ‫א‬Canvas‫א‬‫א‬‫א‬ ‫א‬

S_ITEMData Block Wizard‫א‬‫א‬Data Block‫א‬ J ٦  K‫א‬

‫א‬ S_ORD‫א‬Data Block‫א‬  KS_ITEM‫א‬Data Block - ٣٣ -

 ‫א‬‫א‬ Module

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

CV_ORDER ‫א‬ORD_ID‫א‬Data Block‫א‬‫א‬

  ،‫א‬Data Block‫א‬‫א‬،Canvas Data Block‫א‬ ،Tabular StyleData Block‫א‬  K‫א‬

S_ORDObject Navigator‫א‬Data Blocks‫א‬  KS_ITEM  KItems ‫א‬

 KORD4‫א‬‫ א‬J ٧ Data Block Wizard‫א‬‫א‬Data Block J ٨ ‫א‬‫א‬S_INVENTORY

 KData BlockOUT_OF_STOCK_EXPLANATION CanvasData

Block‫א‬‫א‬

 KTabular Style‫א‬CV_INVENTORY

Object Navigator‫א‬Data Blocks‫א‬  K‫א‬S_ITEMS_INVENTORY

‫א‬S_item‫א‬S_Item_S_InventoryRelation J ٩

Detail‫א‬‫א‬Master‫א‬‫א‬ S_Item‫א‬ S_Inventory KS_Inventory

‫א‬‫א‬S_Item‫א‬‫א‬Record

 KDetail‫א‬‫א‬Records KShipped‫א‬‫א‬Quantity Shipped‫א‬Prompt‫א‬S_Item‫א‬ J ١٠ KStock‫א‬‫א‬Amount in StockPrompt‫א‬S_Inventory‫א‬ J ١١ ‫א‬ORDERS‫א‬Object Navigator‫א‬Module‫א‬‫א‬ J ١٢  K‫א‬

- ٣٤ -

 ‫א‬‫א‬‫א‬ ã¹]<gè…‚jÖ]æ<ËÖ]<Üé×Ãj×Ö<íÚ^ÃÖ]<퉉ö¹] ‫א‬‫א‬‫א‬‫א‬

‫א‬‫א‬ Frame ‫א‬

Frame‫א‬

Data Block‫א‬‫א‬

Data Block‫א‬‫א‬

٣

 ‫א‬‫א‬

J ‫א‬‫א‬

Frame‫א‬Data Block‫א‬‫א‬

 ١٦٢

 ‫א‬  

W‫א‬‫א‬ Frame‫א‬‫א‬،Data Block‫א‬  W‫א‬‫א‬  W‫א‬‫א‬‫א‬  KProperty Palette‫א‬‫ א‬K١

‫א‬Frame‫א‬Data Block‫א‬‫ א‬K٢ KProperty Palette  ‫א‬Data Block‫א‬ ‫ א‬K٣ K‫א‬

KControl Block K٤ W‫א‬‫א‬‫א‬  K٪٨٠‫א‬‫א‬‫א‬   KW‫א‬‫א‬ 

 W‫א‬‫א‬  K • K •  K •



W‫א‬‫א‬  K‫א‬‫א‬‫א‬‫א‬،‫א‬

- ٣٥ -

 ‫א‬‫א‬

J ‫א‬‫א‬

Frame‫א‬Data Block‫א‬‫א‬

 ١٦٢

 ‫א‬  

Frames‫א‬&Data Block‫א‬‫א‬ Working with Data Blocks and Frames  KBata Block‫א‬‫א‬‫א‬ Data Block‫א‬‫א‬‫א‬  W‫א‬‫א‬

Layout WizardData Block Wizard: Reentrant Wizard • KData Block‫א‬‫א‬‫א‬‫א‬

K‫א‬‫א‬‫א‬Layout Editor‫א‬W Layout Editor • Data Block‫א‬‫א‬WData Block Property Palette • K‫א‬

Data Block‫א‬‫א‬‫א‬  WFrame Property Palette • K‫א‬‫א‬‫א‬ Property Palette‫א‬ Module‫א‬Module‫א‬EobjectF ،‫א‬ ‫א‬  K‫א‬

 WProperty Palette‫א‬

 KProperty Palette‫א‬ToolsObject Navigator‫א‬ o ‫א‬‫א‬‫א‬‫א‬‫א‬Object Navigator‫א‬ o K

K‫א‬‫א‬‫א‬‫א‬‫א‬Layout Editor‫א‬ o

‫א‬‫א‬‫א‬Layout EditorObject Navigator‫א‬ o KF4‫א‬

 ‫א‬‫א‬Layout EditorObject Navigator‫א‬ o KProperty Palette‫א‬‫א‬‫א‬‫א‬



- ٣٦ -

 ‫א‬‫א‬

J ‫א‬‫א‬

Frame‫א‬Data Block‫א‬‫א‬

 ١٦٢

 ‫א‬  

W‫א‬ • ‫ﺷﺮﻳﻂ‬

‫اﻟﺒﺤﺚ ﻟﻠﺨﻠﻒ‬

‫ﻏﻠﻖ وﻓﺘﺢ اﻟﺨﺎﺻﻴﺔ‬

‫اﻟﺒﺤﺚ ﻟﻸﻣﺎم‬ ‫اﻟﺒﺤﺚ ﻋﻦ‬

‫اﺳﻢ اﻟﺨﺎﺻﻴﺔ‬

‫ﻗﻴﻤﺔ‬

 WProperty Palette‫א‬

 ‫א‬‫א‬‫א‬WE‫א‬FProperty list o K‫א‬‫א‬‫א‬

‫א‬‫א‬ ‫א‬ WE  ‫א‬FFind Field o K‫א‬‫א‬‫א‬،

‫א‬‫א‬‫א‬ W‫א‬‫א‬Toolbar o K‫א‬ Property Palette Icons‫א‬

K‫א‬‫א‬‫א‬‫א‬W‫א‬ K‫א‬‫א‬‫א‬W - ٣٧ -

 ‫א‬‫א‬

J ‫א‬‫א‬

Frame‫א‬Data Block‫א‬‫א‬

 ١٦٢

 ‫א‬  

Visual Attributes‫א‬‫א‬

 ‫א‬‫א‬‫א‬‫א‬‫א‬

Object Navigator ‫א‬Visual Attribute‫א‬

 KE‫א‬‫א‬‫א‬F‫א‬‫א‬‫א‬EobjectF

EVisual AttributeF‫א‬‫א‬‫א‬‫א‬

Data Block‫א‬‫א‬‫א‬

 KVisual Attribute‫א‬Data Block‫א‬ 

Visual Attribute‫א‬



       - ٣٨ -

 ‫א‬‫א‬ Frame‫א‬Data Block‫א‬‫א‬

J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

 Data Block‫א‬

 W‫א‬‫א‬‫א‬ KGeneral o

 KNavigator o  KRecords o

 KDatabase o  KAdvanced Database o  KScrollbar o

 KFont and Color o

 KCharacter mode o KInternational o



Navigation •  KData Block‫א‬‫א‬‫א‬‫א‬‫א‬

‫א‬‫א‬‫א‬‫א‬WNavigation Style o W‫א‬‫א‬‫א‬‫א‬EnterTab‫א‬ K‫א‬‫א‬‫א‬‫א‬WSame Record

K‫א‬‫א‬‫א‬‫א‬‫א‬WChange Record Data Block‫א‬  ‫א‬‫א‬ ‫א‬WChange Data Block K‫א‬

Data Block‫א‬WPrevious/Next Navigation Data Block o K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬

- ٣٩ -

 ‫א‬‫א‬

J ‫א‬‫א‬

Frame‫א‬Data Block‫א‬‫א‬

 ١٦٢

 ‫א‬  

WDatabase •  ‫א‬‫א‬‫א‬‫א‬ Data ‫א‬

 KData Base‫א‬‫א‬Block

‫א‬Yes‫א‬‫א‬WDatabase Data Block o ‫א‬،Data Block  ‫א‬‫א‬‫א‬

‫א‬‫א‬‫א‬No‫א‬‫א‬

KControl Block

‫א‬‫א‬Yes ‫א‬WEnforce Primary Key o   ‫א‬ ‫א‬

K

‫א‬WQuery / Insert / Update / Delete Allowed o K‫א‬‫א‬‫א‬‫א‬

‫א‬  ‫א‬‫א‬WQuery Data Source Type o Procedure  ‫א‬ ‫א‬،‫א‬

KFROM clause queryTransaction Triggers

  ‫א‬‫א‬‫א‬‫א‬WQuery Data Source Name o

‫א‬  ،‫א‬‫א‬ ‫א‬Data Block‫א‬ KProcedureFROM clauseTableQuery Data Source Type

‫א‬‫א‬  ‫א‬‫א‬WQuery Data Source Columns o

‫א‬  ‫א‬،‫א‬  ‫א‬‫א‬

KProcedureFROM clauseTableQuery Data Source Type

‫א‬‫א‬‫א‬‫א‬WWhere Clause o K

‫א‬‫א‬‫א‬WORDER BY Clause o K‫א‬ ‫א‬‫א‬WLocking Mode / Key Mode o KOracle‫א‬ Data Block‫א‬‫א‬ - ٤٠ -

 ‫א‬‫א‬ Frame‫א‬Data Block‫א‬‫א‬

J ‫א‬‫א‬  ١٦٢

 ‫א‬  

‫א‬Yes‫א‬WUpdate Changed Columns Only o ‫א‬‫א‬ ،‫א‬‫א‬‫א‬

‫א‬ ‫א‬    

K‫א‬‫א‬

 Yes‫א‬ ‫א‬WEnforce Column Security o ‫א‬‫א‬‫א‬‫א‬‫א‬Data Block‫א‬ K‫א‬

‫א‬‫א‬ WMaximum Query Time o ‫א‬،‫א‬ ‫א‬‫א‬‫א‬‫א‬

KYesQuery All Records

‫א‬‫א‬WMaximum Records Fetched o ،‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬ KYesQuery All Records‫א‬ WRecord • ‫א‬ERecordsF‫א‬‫א‬  KData Block‫א‬

‫א‬WCurrent Record Visual Attribute Group o Object Navigator‫א‬‫א‬Visual Attribute‫א‬ ،Data Block‫א‬ERecordsF‫א‬‫א‬ERecordF‫א‬

‫א‬‫א‬‫א‬‫א‬ECurrent RecordF‫א‬‫א‬

K‫א‬‫א‬Visual Attribute‫א‬‫א‬

‫א‬‫א‬‫א‬WQuery Array Size o ‫א‬  ‫א‬‫א‬‫א‬‫א‬

‫א‬  ‫א‬‫א‬،EQueryF‫א‬ K‫א‬

- ٤١ -

 ‫א‬‫א‬

J ‫א‬‫א‬

Frame‫א‬Data Block‫א‬‫א‬

 ١٦٢

 ‫א‬  

‫א‬‫א‬‫א‬‫א‬WNumber of Records Buffered o ‫א‬‫א‬‫א‬‫א‬K‫א‬‫א‬‫א‬‫א‬

K٣‫א‬‫א‬Number of Record Displayed‫א‬

- ٤٢ -

 ‫א‬‫א‬

J ‫א‬‫א‬

Frame‫א‬Data Block‫א‬‫א‬

 ١٦٢

 ‫א‬  

‫א‬‫א‬‫א‬WNumber of Record Displayed o KCanvas‫א‬‫א‬Data Block‫א‬‫א‬

‫א‬‫א‬‫א‬WQuery All Record o   ‫א‬yes‫א‬‫א‬، ‫א‬‫א‬

Calculated summation‫א‬ItemData Block‫א‬

Data ‫א‬‫א‬‫א‬‫א‬WRecord Orientation o

KHorizontalVerticalBlock

Control ‫א‬‫א‬‫א‬WSingle Record o

Control Block‫א‬‫א‬K‫א‬‫א‬Block KData Block‫א‬

Scroll Bar • ‫א‬Scroll bar‫א‬‫א‬‫א‬ Data Block‫א‬

  ‫א‬‫א‬WShow Scroll Bar o KData Block‫א‬

‫א‬Canvas‫א‬‫א‬WScroll Bar Canvas o K‫א‬

Tap Page Canvas‫א‬WScroll Bar Tap Page o KData Block‫א‬‫א‬‫א‬

‫א‬‫א‬‫א‬WScroll Bar Orientation o K

‫א‬‫א‬‫א‬ ‫א‬WScroll Bar X/Y Position o KCanvas‫א‬‫א‬

‫א‬WScroll Bar Width / Height o K‫א‬ ‫א‬‫א‬‫א‬ WReverse Direction o K‫א‬‫א‬

- ٤٣ -

 ‫א‬‫א‬

J ‫א‬‫א‬

Frame‫א‬Data Block‫א‬‫א‬

 ١٦٢

 ‫א‬  

 Frame Data Block‫א‬ Frame‫א‬

 K‫א‬ 

Frame‫א‬

 ‫א‬Data Block‫א‬‫א‬WLayout Data Block o KData Block‫א‬EFrameF‫א‬،Frame‫א‬‫א‬

‫א‬‫א‬‫א‬WUpdate Layout o K‫א‬‫א‬

 ‫א‬ ‫א‬‫א‬WAutomatically ‫א‬ ‫א‬ ‫א‬‫א‬  K‫א‬

‫א‬ ‫א‬‫א‬  ‫א‬‫א‬‫א‬WManually K‫א‬‫א‬‫א‬

K‫א‬‫א‬‫א‬‫א‬‫א‬WLocked

- ٤٤ -

 ‫א‬‫א‬ Frame‫א‬Data Block‫א‬‫א‬

J ‫א‬‫א‬  ١٦٢

 ‫א‬  

Layout‫א‬‫א‬WLayout Style o ‫א‬،TabularForm

KAutomatic‫א‬Update Layout

‫א‬‫א‬‫א‬WDistance Between Records o ‫א‬Tabular‫א‬‫א‬

KAutomatic‫א‬Update Layout   ‫א‬‫א‬‫א‬‫א‬WX/Y Position o KCanvas‫א‬‫א‬

K‫א‬‫א‬‫א‬WWidth / Height o



W‫א‬Property Palette‫א‬ • ‫א‬‫א‬Shift‫א‬‫א‬ o

‫א‬‫א‬‫א‬‫א‬‫א‬

K

‫א‬‫א‬Freeze‫א‬ o ‫א‬Freeze‫א‬

K

 • ‫א‬‫א‬   o K‫א‬‫א‬

 • ‫א‬‫א‬‫א‬  ‫א‬‫א‬‫א‬ o

‫א‬‫א‬Ctrl‫א‬‫א‬

Object NavigatorCopy‫א‬Edit‫א‬Select all ‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬

K‫א‬‫א‬‫א‬‫א‬Past - ٤٥ -

 ‫א‬‫א‬ Frame‫א‬Data Block‫א‬‫א‬

J ‫א‬‫א‬  ١٦٢

 ‫א‬  

WControl Block • W‫א‬‫א‬Control Block‫א‬

Create‫א‬ Object NavigatorData Block‫א‬‫ א‬o KBuild a new data block manually‫א‬‫א‬‫א‬

‫א‬‫א‬‫א‬‫א‬‫א‬ o

،No‫א‬Query Allowed / Insert Allowed / Update Allowed / Delete Allowed Query Data ‫א‬No‫א‬Database Data Block

KNone‫א‬Source Type

WData Block‫א‬ • ‫א‬Delete‫א‬‫א‬‫א‬Data Block‫א‬‫ א‬o K‫א‬‫א‬‫א‬

- ٤٦ -

 ‫א‬‫א‬

J ‫א‬‫א‬

Frame‫א‬Data Block‫א‬‫א‬

 ١٦٢

 ‫א‬  

 

 W‫א‬‫א‬‫א‬‫א‬‫א‬Cust4  Cust4Control Block K١

 KS_CUSTOMERControlControl Block‫א‬ K٢

   ‫א‬ ‫א‬‫א‬Frame‫א‬‫ א‬K٣ K‫א‬‫א‬‫א‬

KCust5‫א‬‫ א‬K٤

 ‫א‬‫א‬‫א‬‫א‬‫א‬ORD4  Ord4Control Block K٥

 KS_InventoryControlControl Block‫א‬ ‫א‬Record‫א‬‫א‬S_InventoryS_Item K٦ Visual Attribute،‫א‬

KS_InventoryS_Item

K٤Records‫א‬S_Item K٧

 ‫א‬‫א‬  ‫א‬ ‫א‬‫א‬‫א‬ ‫א‬S_Item K٨ K‫א‬‫א‬

‫א‬ ‫א‬ ‫א‬‫א‬ Frame‫א‬  ‫ א‬K٩ K‫א‬‫א‬

 KOrd5‫א‬‫ א‬K١٠

- ٤٧ -

 ‫א‬‫א‬‫א‬ ã¹]<gè…‚jÖ]æ<ËÖ]<Üé×Ãj×Ö<íÚ^ÃÖ]<퉉ö¹] ‫א‬‫א‬‫א‬‫א‬

‫א‬‫א‬

Normal Forms‫א‬‫א‬

Normal Forms ‫א‬‫א‬

٤

 ‫א‬‫א‬‫א‬ Text Item‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

W‫א‬‫א‬  KText Item‫א‬‫א‬ W‫א‬‫א‬  W‫א‬‫א‬‫א‬  KText Item‫א‬ K١

 KText Item‫א‬ K٢ KText Item‫א‬‫א‬‫א‬‫ א‬K٣

W‫א‬‫א‬‫א‬ K٪٨٠‫א‬‫א‬‫א‬   KW‫א‬‫א‬ 

 W‫א‬‫א‬  K •  K • K •





W‫א‬‫א‬ K‫א‬‫א‬‫א‬‫א‬،‫א‬

- ٤٧ -

 ‫א‬‫א‬‫א‬ Text Item‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

 Text Item‫א‬‫א‬  Working with Text Items

 Text Item • ‫א‬Text Item‫א‬  K‫א‬‫א‬‫א‬

‫א‬Interface Object‫א‬Text Item‫א‬  K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬



Text Item‫א‬ •  Text Item‫א‬

 Layout Editor o

KLayout Editor KText Item‫א‬‫א‬‫א‬‫א‬

KCanvas‫א‬‫א‬Canvas‫א‬‫ א‬

‫א‬‫א‬‫א‬‫א‬ K‫א‬‫א‬‫א‬ - ٤٨ -



 ‫א‬‫א‬‫א‬ Text Item‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

Object Navigator o KObject Navigator

K‫א‬‫א‬‫א‬‫א‬Data Block‫א‬‫א‬ KData Block‫א‬‫א‬Item‫א‬

KCreate‫א‬ ‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬ ‫א‬‫א‬‫א‬‫א‬‫א‬

Canvas‫א‬Canvas،Text Item‫א‬Item Type  K‫א‬‫א‬‫א‬

- ٤٩ -

 ‫א‬‫א‬‫א‬ Text Item‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

 Text Item‫א‬ General Property‫א‬ • Text Item‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬  K‫א‬‫א‬‫א‬‫א‬

Name o

 K‫א‬‫א‬

Item Type o

 K‫א‬‫א‬

Physical Property‫א‬ • ‫א‬‫א‬‫א‬‫א‬

‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬ ،Canvas K‫א‬‫א‬،Canvas

Visible o

،‫א‬‫א‬‫א‬‫א‬ ‫א‬ ‫א‬‫א‬‫؟‬‫א‬‫א‬    ‫א‬ 

‫א‬ ‫؟‬Data Block‫א‬‫א‬‫א‬‫א‬

‫א‬‫א‬

No‫א‬‫א‬ yes‫א‬‫א‬  K‫א‬‫א‬

‫א‬‫א‬

، ‫א‬‫א‬Data Block‫א‬‫א‬

‫א‬‫א‬،Data Block‫א‬  K‫א‬Data Block‫א‬

Canvas o

،‫א‬‫א‬Canvas‫א‬‫א‬

 K‫א‬Canvas‫א‬‫א‬‫א‬‫א‬ - ٥٠ -

 ‫א‬‫א‬‫א‬ Text Item‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

‫א‬‫א‬Data Block‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬ ،Data Block‫א‬  ، ‫א‬  K‫א‬Data Block‫א‬‫א‬‫א‬

‫א‬VisibleCanvasVisible‫א‬

‫א‬‫א‬‫א‬ Canvas‫א‬

 KLayout Tab Page o

‫א‬‫א‬Tab Page‫א‬‫א‬

 KCanvas‫א‬

X Position o KCanvas‫א‬‫א‬‫א‬X‫א‬‫א‬‫א‬

 KY‫א‬X‫א‬‫א‬Canvas‫א‬ Y Position o

KCanvas‫א‬‫א‬‫א‬Y‫א‬‫א‬‫א‬‫א‬

 KY‫א‬X‫א‬‫א‬Canvas‫א‬ Width o

 K‫א‬‫א‬

Height o

 K‫א‬‫א‬

Bevel o  K‫א‬‫א‬E‫א‬‫א‬‫א‬F‫א‬

Show Vertical Scrollbar o

‫א‬‫א‬‫א‬‫א‬

Multi lineMulti line‫א‬‫א‬  Kyes‫א‬

- ٥١ -

 ‫א‬‫א‬‫א‬ Text Item‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

Records Property‫א‬ •  K‫א‬‫א‬‫א‬‫א‬ 

 Records Property‫א‬

 WCurrent Record Visual Attribute Group o

   Data Block‫א‬ ‫א‬

Records‫א‬‫א‬Record‫א‬Data Block‫א‬

‫א‬‫א‬،‫א‬Visual Attribute‫א‬

‫א‬‫א‬Record‫א‬‫א‬‫א‬Visual Attribute Data Block‫א‬ ‫א‬،‫א‬  K‫א‬‫א‬

Distance Between Records o

 K‫א‬‫א‬‫א‬‫א‬

Number Of Item Displayed o

‫א‬Canvas‫א‬‫א‬‫א‬‫א‬   Data Block‫א‬   ‫א‬

‫א‬‫א‬‫א‬‫א‬‫א‬ Data Block‫א‬ ‫א‬‫א‬  ‫א‬‫א‬Canvas‫א‬  KData Block‫א‬ - ٥٢ -

 ‫א‬‫א‬‫א‬ Text Item‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

Font and Color Property‫א‬ • ‫א‬  ‫א‬‫א‬‫א‬‫א‬‫א‬  K‫א‬‫א‬

Visual Attribute Group o ‫א‬‫א‬Visual Attribute‫א‬‫א‬

 K‫א‬‫א‬‫א‬‫א‬،‫א‬ Font Name o

 K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬

Font Size o

 K‫א‬‫א‬‫א‬‫א‬‫א‬

Font Weight o

 K‫א‬‫א‬‫א‬‫א‬‫א‬

Font Style o

 K‫א‬‫א‬‫א‬‫א‬‫א‬

Font Spacing o

‫א‬ ‫א‬‫א‬‫א‬ ‫א‬

 K‫א‬

Foreground Color o  K‫א‬‫א‬‫א‬‫א‬‫א‬

Background Color o

 K‫א‬‫א‬‫א‬‫א‬‫א‬

Fill Pattern o

 K‫א‬‫א‬‫א‬‫א‬‫א‬

- ٥٣ -

 ‫א‬‫א‬‫א‬ Text Item‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

Prompt Property‫א‬ • K‫א‬Prompt‫א‬‫א‬‫א‬ Prompt o

 K‫א‬‫א‬‫א‬‫א‬

Prompt Display Style o

EHiddenF‫א‬‫א‬‫א‬‫א‬‫א‬ Canvas‫א‬‫א‬‫א‬EFirst RecordF‫א‬‫א‬‫א‬

 KEAll RecordF

Prompt Justification o

 K‫א‬‫א‬‫א‬‫א‬

Prompt Attachment Edge o

 K‫א‬‫א‬‫א‬‫א‬‫א‬

Prompt Alignment o

 K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬

Prompt Attachment Offset o

 K‫א‬‫א‬‫א‬‫א‬‫א‬

Prompt Reading Order o

 ‫א‬ ‫א‬  ‫א‬‫א‬‫א‬‫א‬‫א‬ ‫א‬  K‫א‬

- ٥٤ -

 ‫א‬‫א‬‫א‬ Text Item‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

Prompt Font and Color Property‫א‬ • Prompt‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬  K‫א‬

Prompt Visual Attribute Group o ‫א‬‫א‬‫א‬Visual Attribute‫א‬‫א‬

 K‫א‬

Prompt Font Name o

 K‫א‬‫א‬‫א‬‫א‬‫א‬

Prompt Font Size o  K‫א‬‫א‬‫א‬‫א‬ Prompt Font Weight o  K‫א‬‫א‬‫א‬‫א‬







Prompt Font Style o

 K‫א‬‫א‬‫א‬‫א‬

 Prompt Font Spacing o

 K‫א‬‫א‬‫א‬‫א‬‫א‬

Prompt Foreground Color o  K‫א‬‫א‬‫א‬‫א‬

- ٥٥ -



 ‫א‬‫א‬‫א‬ Text Item‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

 ‫א‬‫א‬‫א‬‫א‬ ‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬

‫א‬‫א‬‫א‬‫א‬Layout EditorW‫א‬‫א‬

 K‫א‬‫א‬Associate Prompt tool

 ‫א‬‫א‬‫א‬

 WData Property‫א‬ • K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬ Data Type o

 K‫א‬‫א‬‫א‬‫א‬‫א‬

Maximum Length o

 K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬

Fixed Length o

‫א‬  ‫א‬‫א‬‫א‬

 K‫א‬‫א‬‫א‬

- ٥٦ -

 ‫א‬‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

Text Item‫א‬‫א‬

Initial Value o  ‫א‬‫א‬F‫א‬‫א‬‫א‬‫א‬‫א‬

 ‫א‬‫א‬‫א‬ ‫א‬K ‫א‬E  W‫א‬‫א‬

 ‫א‬‫א‬$$Date$$

 K‫א‬‫א‬‫א‬‫א‬‫א‬$$DateTime$$ 

Required o  K‫א‬‫א‬‫א‬‫א‬



Format Mask o

،‫א‬‫א‬ ‫א‬  ‫א‬GJ 

 W‫א‬‫א‬



 ٩J 

 ‫א‬‫א‬DJ 

 K‫א‬‫א‬‫א‬‫א‬

٩٩YJ [٩٩٩[E[٩٩٩YFYW  K–

‫א‬G999D99٩٩٩W  K‫א‬‫א‬  W‫א‬‫א‬

 ‫א‬MM

 K‫א‬yyyy



 ‫א‬DD

‫א‬‫א‬MON  DD/MON/YYYYW 

Lowest Allowed Value o  K‫א‬‫א‬‫א‬‫א‬ - ٥٧ -

 ‫א‬‫א‬‫א‬ Text Item‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

Highest Allowed Value o  K‫א‬‫א‬‫א‬‫א‬ 

Copy Value from Item Property

 Copy Value from Item o  K‫א‬‫א‬‫א‬



Keyboard Navigable o

 ‫א‬‫א‬‫א‬‫א‬‫א‬ ‫א‬‫א‬

 K‫א‬‫א‬‫א‬‫א‬ Previous Navigation Item o   ‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬

 KData Block‫א‬ Next Navigation Item o

‫א‬‫א‬‫א‬‫א‬ ‫א‬‫א‬

 KData Block‫א‬

- ٥٨ -



 ‫א‬‫א‬‫א‬ Text Item‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

Database Property‫א‬ • ‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬ K‫א‬‫א‬‫א‬‫א‬‫א‬ Database Item o

‫א‬‫א‬‫א‬‫א‬

 KControl ItemData Item‫א‬ Column Name o

‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬ ‫א‬

 K‫א‬

Primary Key o

 ‫א‬‫א‬‫א‬‫א‬

 K‫א‬Primary Key‫א‬‫א‬

Query Only o

‫א‬ ‫א‬‫א‬

 KUpdateInsert Query Allowed o

 K‫א‬‫א‬‫א‬‫א‬

Case Insensitive Query o Capital‫א‬‫א‬‫א‬‫א‬

 KSmall‫א‬

Insert Allowed o

 K‫א‬‫א‬‫א‬

Update Allowed o

 K‫א‬‫א‬‫א‬

Update Only If Null o ‫א‬‫א‬  ‫א‬ ‫א‬‫א‬

 K‫א‬

- ٥٩ -

 ‫א‬‫א‬‫א‬ Text Item‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

Functional Property‫א‬ •  K‫א‬‫א‬‫א‬‫א‬ 

 Functional Property‫א‬

 WEnable o

 ‫א‬،‫א‬‫א‬‫א‬‫א‬

‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬  ،

 K‫א‬

WJustification o

‫א‬،‫א‬‫א‬‫א‬‫א‬  ‫א‬

 K‫א‬‫א‬‫א‬‫א‬‫א‬ WMulti-Line o



،‫א‬‫א‬‫א‬

 K‫א‬YES‫א‬  - ٦٠ -

 ‫א‬‫א‬‫א‬ Text Item‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

WWrap Style o  ‫א‬  ‫א‬‫א‬‫א‬‫א‬ ‫א‬‫א‬،‫א‬‫א‬

 KYesMulti-Line



WCase Restriction o  ‫א‬‫א‬‫א‬‫א‬‫א‬

 K‫א‬‫א‬‫א‬‫א‬ Help‫א‬



 WHint o

،‫א‬‫א‬‫א‬‫א‬

‫א‬،‫א‬‫א‬ ‫א‬‫א‬

 Kyes‫א‬Display Hint Automatically

- ٦١ -

 ‫א‬‫א‬‫א‬ Text Item‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

   W‫א‬‫א‬‫א‬‫א‬‫א‬ Cust5 KCanvas‫א‬Region Id‫ א‬K١ KComments‫ א‬K٢

W‫א‬Form‫א‬ K٣



 KCust6‫א‬‫ א‬K٤



 W‫א‬‫א‬‫א‬‫א‬‫א‬ Ord5 Customer_NameText Item،S_ORD‫א‬ K١  ‫א‬‫א‬،S_ORD‫א‬‫א‬‫א‬

‫א‬،Customer Name‫א‬‫א‬ ‫א‬،‫א‬‫א‬‫א‬‫א‬ KCV_ORDER Canvas‫א‬‫א‬‫א‬

Sales_Rep_NameText Item،S_ORD‫א‬ K٢  ‫א‬‫א‬،S_ORD‫א‬‫א‬‫א‬

‫א‬،Sales Rep Name‫א‬‫א‬‫א‬،‫א‬‫א‬‫א‬‫א‬ KCV_ORDER Canvas‫א‬‫א‬‫א‬ - ٦٢ -

 ‫א‬‫א‬‫א‬ Text Item‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

 ‫א‬‫א‬ Date_Ordered‫א‬،S_ORD‫א‬ K٣ KRecordS_ORD

Item_TotalText Item،S_ORD‫א‬ K٤ ‫א‬ ‫א‬‫א‬،S_ORD‫א‬‫א‬‫א‬

‫א‬‫א‬‫א‬،Item_Total‫א‬‫א‬ ‫א‬،‫א‬‫א‬‫א‬

‫א‬‫א‬‫א‬‫א‬،CV_ORDER Canvas‫א‬ KG990D99٩٩٩

Price, Quantity , Quantity_Shipped‫א‬‫א‬‫א‬‫א‬،S_Item K٥ K‫א‬

‫א‬‫א‬‫א‬‫א‬‫א‬ ‫א‬‫א‬،S_Item K٦ K‫א‬‫א‬

W‫א‬Form‫א‬،ORD5 K٧

 ‫א‬Product_IdRecords‫א‬،S_Inventory K٨ K

- ٦٣ -

 ‫א‬‫א‬‫א‬ Text Item‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

Form‫א‬،CV_Inventory Canvas‫א‬ K٩ W‫א‬



 KORD6‫א‬‫ א‬K١٠

- ٦٤ -

 ‫א‬‫א‬‫א‬ ã¹]<gè…‚jÖ]æ<ËÖ]<Üé×Ãj×Ö<íÚ^ÃÖ]<퉉ö¹] ‫א‬‫א‬‫א‬‫א‬

‫א‬‫א‬

LOVs

LOVs 

٥

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 LOVs

 ١٦٢

 

W‫א‬‫א‬  KEditor‫א‬List Of ValuesELOVF‫א‬‫א‬  W‫א‬‫א‬  W‫א‬‫א‬‫א‬  KEditor‫א‬LOV‫א‬ K١

 KData BlockLOV K٢ KData BlockEditor K٣ W‫א‬‫א‬‫א‬ K٪١٠٠‫א‬‫א‬‫א‬   KW‫א‬‫א‬ 

 W‫א‬‫א‬ 

 K •  K • K •



W‫א‬‫א‬ K‫א‬‫א‬‫א‬‫א‬،‫א‬

- ٦٥ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 LOVs

 ١٦٢

 



EditorLOVs‫א‬ Creating LOVs and Editors

 LOV‫א‬ • ‫א‬‫א‬ ‫א‬،‫א‬‫א‬‫א‬

 KVariables‫א‬Canvas‫א‬Item



WLOV‫א‬‫א‬‫א‬‫א‬ •  W‫א‬‫א‬LOV‫א‬

‫א‬‫א‬‫א‬‫א‬ ‫א‬‫א‬W‫ א‬o  KLOV‫א‬ KText ItemLOV‫א‬‫א‬W‫ א‬o

KSeveral ItemsLOV‫א‬‫א‬W‫ א‬o ‫א‬‫א‬LOV‫א‬W‫ א‬o

‫א‬‫א‬K،‫א‬LOV‫א‬

K‫א‬‫א‬  W‫א‬LOV‫א‬ •  W‫א‬‫א‬‫א‬LOV‫א‬‫א‬ Edit F9LOV‫א‬‫א‬‫א‬ o OK‫א‬‫א‬‫א‬‫א‬Display List  K‫א‬‫א‬

    

- ٦٦ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 LOVs

 ١٦٢

 

LOV‫א‬

 W‫א‬Objects‫א‬LOV‫א‬

‫א‬‫א‬ ‫א‬Object‫א‬‫א‬WRecord Group o  KLOV‫א‬‫א‬

‫א‬‫א‬  ‫א‬،‫א‬WLOV‫א‬ o KRecord Group

K‫א‬LOV‫א‬‫א‬‫א‬EItemF‫א‬WText Items o



 WRecord Groups •

‫א‬ ‫א‬‫א‬،‫א‬

‫א‬Select Statement‫א‬LOV‫א‬

 K‫א‬

 KLOVs‫א‬‫א‬‫א‬Record Group‫א‬‫א‬



LOVs and Record Groups



  - ٦٧ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 LOVs

 ١٦٢

 

W‫א‬‫א‬‫א‬LOV‫א‬ • ‫א‬Create‫א‬Object NavigatorLOV‫ א‬K١  W‫א‬

 Use ‫א‬‫א‬  LOV‫א‬ ‫א‬‫א‬ K٢  Build a new LOV manuallythe LOV Wizard

LOV‫א‬Build a new LOV manually‫א‬‫א‬‫ א‬K٣ KLOVOK‫א‬

  ‫א‬‫א‬LOV‫א‬Record Group‫א‬ K٤  W‫א‬‫א‬Create‫א‬Record Group





‫א‬Static Values‫א‬‫א‬ K٥  K‫א‬‫א‬‫א‬‫א‬Based on the Query below

‫א‬‫א‬ ‫א‬Query Text‫א‬ K٦ Record GroupOK‫א‬،‫א‬ WLOV‫א‬‫א‬‫א‬‫א‬ K٧ - ٦٨ -



 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 LOVs

 ١٦٢

 

 LOV‫א‬ • WTitle o

 KLOV‫א‬‫א‬‫א‬

WX Position and Y Position o

 K‫א‬LOV‫א‬‫א‬

WWidth and Height o

 KLOV‫א‬‫א‬

WColumn Mapping Properties o

 W‫א‬





Column EQueryF‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬

‫א‬‫א‬Data Block‫א‬‫א‬F‫א‬Name ‫א‬‫א‬Return ItemELOV‫א‬ LOV‫א‬‫א‬‫א‬Display WidthLOV‫א‬

‫א‬‫א‬Record Group‫א‬‫א‬Column Title  K‫א‬

- ٦٩ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 LOVs

 ١٦٢

 

WFilter before Display o LOV‫א‬‫א‬‫א‬

‫א‬  

 K‫א‬‫א‬‫א‬

WAutomatic Display o

‫א‬LOV‫א‬‫א‬ ‫א‬LOV‫א‬‫א‬‫א‬‫א‬

 KLOV‫א‬‫א‬LOV LOV Properties







WAutomatic Refresh o ‫א‬Yes‫א‬

‫א‬‫א‬LOV‫א‬‫א‬

 K‫א‬‫א‬NO،‫א‬

WAutomatic Select o

‫א‬LOV‫א‬‫א‬ Yes‫א‬ ‫א‬‫א‬NO‫א‬‫א‬

 KOK‫א‬

- ٧٠ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 LOVs

 ١٦٢

 

WAutomatic Position o LOV‫א‬‫א‬Yes‫א‬ ‫א‬‫א‬‫א‬‫א‬‫א‬

 KLOV‫א‬‫א‬ LOV Properties

 WAutomatic Column Width o





‫ א‬Yes‫א‬

 KLOV‫א‬

 K‫א‬Record Group‫א‬LOVsW  WData Block‫א‬LOV‫א‬ o ‫א‬‫א‬‫א‬‫א‬LOV‫א‬‫א‬‫א‬‫א‬ ‫א‬‫א‬LOV‫א‬‫א‬ List Of Values ‫א‬‫א‬

 K‫א‬

- ٧١ -



 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 LOVs

 ١٦٢

 

 WWizard‫א‬‫א‬LOV‫א‬‫• א‬  W‫א‬‫א‬Create‫א‬Object NavigatorLOV‫א‬ 





Wizard‫א‬‫א‬LOV‫א‬ ‫א‬‫א‬ Use the ‫א‬‫א‬‫א‬Build a new LOV manuallyUse the LOV Wizard

 W‫א‬‫א‬OK‫א‬LOV Wizard 

  Record GroupLOV‫א‬ ‫א‬

 W‫א‬‫א‬Next‫א‬KRecord Group 

- ٧٢ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 LOVs

 ١٦٢

 



 W‫א‬‫א‬‫א‬‫א‬

Query Builder‫א‬‫א‬Build SQL Query ‫א‬‫א‬‫א‬‫א‬  ‫א‬

 K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬

 K‫א‬‫א‬‫א‬Import SQL Query

 K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬Connect  K‫א‬‫א‬‫א‬SQL Query Statement

 KSQL‫א‬‫א‬Check Syntax  K‫א‬‫א‬Next‫א‬‫א‬

 - ٧٣ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 LOVs

 ١٦٢

 

‫א‬‫א‬‫א‬ ‫א‬‫א‬ ‫א‬LOV‫א‬‫א‬‫א‬ ‫א‬‫א‬‫א‬Record Group‫א‬

‫א‬ ‫א‬،LOV‫א‬LOV‫א‬

 K‫א‬‫א‬Next‫א‬LOV‫א‬ 





 ‫א‬ ‫א‬‫א‬‫א‬‫א‬  ‫א‬ •  KReturn Value

Width •

K‫א‬LOV‫א‬Title‫א‬ •   ‫א‬‫א‬ ‫א‬‫א‬Look Up Return item • K‫א‬Data Block‫א‬

‫א‬‫א‬Automatically size Columns •  K‫א‬

  

- ٧٤ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 LOVs

 ١٦٢

 

 J W‫א‬‫א‬Next‫א‬



  ‫א‬

 KLOV‫א‬‫א‬Title •

KLOV‫א‬Width •

KLOV‫א‬‫א‬Height • ‫א‬‫א‬‫א‬‫؟‬Do you want Form Runtime to position your LOV‫א‬‫א‬ •  ‫א‬‫א‬LOV‫א‬Form‫א‬

‫א‬LOV‫א‬Yes‫א‬‫א‬‫א‬ Left‫א‬‫א‬ ‫א‬NO ‫א‬‫א‬‫א‬‫א‬ KTop‫א‬‫א‬ 

- ٧٥ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 LOVs

 ١٦٢

 

 W‫א‬‫א‬Next‫א‬

  Retrieve



 ‫א‬

rows at a time‫א‬‫א‬‫א‬ •

Refresh record group data before displaying LOV •

‫א‬‫א‬LOV‫א‬‫א‬

KLOV‫א‬ Let the user filter records before displaying them • K‫א‬‫א‬EF  W‫א‬‫א‬Next‫א‬

 - ٧٦ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 LOVs

 ١٦٢

 

 ‫א‬  K‫א‬LOV‫א‬‫א‬‫א‬ •

 KWizard‫א‬‫א‬LOV‫א‬Finish‫א‬ • Edit‫א‬

‫א‬‫א‬‫א‬‫א‬‫א‬ ‫א‬‫א‬

 K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬  W‫א‬‫א‬ •  W‫א‬‫א‬‫א‬‫א‬‫א‬

EditEditCTRL + E‫א‬‫א‬ OK‫א‬ ‫א‬

K‫א‬‫א‬‫א‬ 

 WEditor • Create‫א‬Editor ‫א‬  ‫א‬‫א‬‫א‬ ‫א‬‫א‬‫א‬‫א‬ ‫א‬

 K‫א‬‫א‬‫א‬‫א‬Editor  Editor‫א‬ • WTitle/Bottom Title o

 K‫א‬‫א‬‫א‬‫א‬

WWidth/Height o

 K‫א‬ WX Position / Y Position o

 K‫א‬‫א‬

WWrap Style o

‫א‬‫א‬‫א‬‫א‬  KWord‫א‬‫א‬‫א‬‫א‬‫א‬ - ٧٧ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 LOVs

 ١٦٢

 

WShow Vertical Scroll Bar o  K

- ٧٨ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 LOVs

 ١٦٢

 

   W‫א‬‫א‬‫א‬‫א‬‫א‬ORD6

Id , Name‫א‬LOV Wizard‫א‬LOV‫א‬ K١ ،S_Item‫א‬‫א‬Product_Id‫א‬‫א‬S_Product‫א‬

‫א‬‫א‬،٢٥ID،LOV‫א‬  ‫א‬

‫א‬Record‫א‬،‫א‬‫א‬‫א‬pixels٣٠LOV

  Product_IdLOV‫א‬IDLOV‫א‬

KProducts_LovLOV‫א‬‫א‬،S_Item 

KORD7‫א‬‫ א‬K٢



 W‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬CUST6

Id , First_Name , ‫א‬LOV Wizard‫א‬LOV‫א‬ K١

‫א‬‫א‬First_Nmae , Last_Name‫א‬‫א‬Last_Name ‫א‬Sales_Rep_Id‫א‬ ‫א‬S_Emp‫א‬Name  ‫א‬

،٢٥ID،LOV‫א‬ ‫א‬،S_Customer‫א‬ ‫א‬،‫א‬‫א‬‫א‬pixels٣٠LOV‫א‬‫א‬

LOV‫א‬IDLOV‫א‬Record LOV‫א‬‫א‬،S_CustomerSales_Rep_Id

KSales_Rep_Id

 ‫א‬،S_Customer‫א‬CommentsEditor K٢

‫א‬‫א‬‫א‬ CommentsEditor‫א‬

K‫א‬‫א‬



KCUST7‫א‬‫ א‬K٣

- ٧٩ -

 ‫א‬‫א‬‫א‬ ã¹]<gè…‚jÖ]æ<ËÖ]<Üé×Ãj×Ö<íÚ^ÃÖ]<퉉ö¹] ‫א‬‫א‬‫א‬‫א‬

‫א‬‫א‬





٦

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 

 ١٦٢

 

W‫א‬‫א‬  K‫א‬‫א‬‫א‬  W‫א‬‫א‬  W‫א‬‫א‬‫א‬  K‫א‬‫א‬‫א‬‫א‬ K١  KCheck Box‫א‬ K٢

KList Item K٣ KRadio Group‫א‬‫א‬ K٤ W‫א‬‫א‬‫א‬ K٪١٠٠‫א‬‫א‬‫א‬ 

 KW‫א‬‫א‬ 

 W‫א‬‫א‬ 

 K •  K • K •

 W‫א‬‫א‬ K‫א‬‫א‬‫א‬‫א‬،‫א‬

- ٨١ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 

 ١٦٢

 

 

Creating Additional Input Items  WInput Items • ‫א‬‫א‬Input Item‫א‬  W‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬ KCheck box o KList item o KRadio group o Input Items‫א‬‫א‬‫• א‬  W‫א‬‫א‬Input Items‫א‬ K o

K  o K  o

K ‫ א‬o

- ٨٢ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 

 ١٦٢

 

 Check Box‫א‬ Check Box‫א‬ • ‫א‬‫א‬،EFCheck Box‫א‬ ‫א‬ ‫א‬KOFFON‫א‬‫א‬‫א‬‫א‬‫א‬    KuncheckedcheckedCheck Box‫א‬



WCheck Box‫א‬ •  WCheck Box‫א‬  KCheck box‫א‬ o

KLayout‫א‬Check box‫א‬‫א‬‫א‬‫ א‬o Kobject navigatorCreate‫א‬‫ א‬o

Check Box‫א‬



   - ٨٣ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 

 ١٦٢

 

WCheck box‫א‬ • WData Type o

Check box‫א‬ ‫א‬  ‫א‬‫א‬

 K‫א‬E‫א‬‫א‬F‫א‬‫א‬ WLabel o  K‫א‬‫א‬‫א‬‫א‬





WAccess Key o

Check  ‫א‬‫א‬  ‫א‬



 Kbox

WInitial Value o ‫א‬Check box‫א‬‫א‬‫א‬‫א‬‫א‬

 Kuncheckedchecked‫א‬‫א‬‫א‬ 

WValue When Checked o ‫א‬‫א‬Check box‫א‬ ‫א‬ ‫א‬  ‫א‬‫א‬Checked  KChecked‫א‬Check Box‫א‬‫א‬

WValue When Unchecked o ‫א‬‫א‬Check box‫א‬ ‫א‬

‫א‬  ‫א‬‫א‬،Unchecked  KUnchecked‫א‬Check Box‫א‬‫א‬

- ٨٤ -



 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 

 ١٦٢

 

WCheck Box Mapping of Other Values o ‫א‬ ‫א‬‫א‬Check box‫א‬‫א‬

   ‫א‬‫א‬‫א‬‫א‬  KUncheckedCheckedNot AllowedW‫א‬‫א‬‫א‬‫א‬‫א‬ Check Box‫א‬

 WMouse Navigate o



‫א‬Check box‫א‬ ‫א‬‫א‬

 K‫א‬ 

WCheck Box‫א‬Check box‫א‬ • Check ‫א‬  Check Box‫א‬  W‫א‬‫א‬‫א‬Box

Item Property Palette‫א‬‫א‬‫א‬‫א‬‫א‬ o

KCheck BoxType Label o

Value When Checked o Value When Unchecked o

Check Box Mapping of Other Values o KInitial Value o - ٨٥ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 

 ١٦٢

 

LayoutCheck Box‫א‬ •  W‫א‬‫א‬‫א‬Check Box‫א‬

 ‫א‬‫א‬Data Block‫א‬Canvas‫א‬Layout ‫ א‬o Check Box‫א‬

‫א‬‫א‬‫א‬Canvas‫א‬‫א‬Check Box‫א‬‫א‬‫א‬‫א‬ o KCheck Box‫א‬

 ‫א‬‫א‬‫א‬‫א‬‫א‬ o KCheck Box‫א‬

Label o

Value When Checked o Value When Unchecked o

Check Box Mapping of Other Values o KInitial Value o               - ٨٦ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 

 ١٦٢

 

List Item‫א‬‫א‬

،‫א‬‫א‬List Item‫א‬‫א‬  K‫א‬‫א‬‫א‬‫א‬

WList Item‫א‬‫א‬ •  WList Item‫א‬‫א‬

‫א‬WPoplist o KNull‫א‬‫א‬‫א‬

K‫א‬‫א‬WTlist o ‫א‬WCombo box o KNull‫א‬‫א‬

List Item‫א‬‫א‬

 WList Items‫א‬‫א‬‫א‬‫א‬‫א‬ • K‫א‬‫א‬‫א‬ o

KCanvas‫א‬‫א‬‫א‬‫א‬ o Kradio group o

K‫א‬‫א‬ o

- ٨٧ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 

 ١٦٢

 

WList Item‫א‬‫א‬ •  WList Item‫א‬‫א‬  KList Item o

KLayout‫א‬List Item‫א‬‫א‬‫א‬‫א‬‫ א‬o Kobject navigatorCreate‫א‬‫ א‬o WList Item‫א‬‫א‬‫א‬ • WElement in List o

 ،‫א‬‫א‬‫א‬

 W‫א‬‫א‬‫א‬  K‫א‬List Element

‫א‬ ‫א‬List Item Value‫א‬ KList Element‫א‬



 ‫א‬‫א‬



  - ٨٨ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 

 ١٦٢

 

WList Style o List ‫א‬‫א‬‫א‬‫א‬

 KItem

WMapping of Other Values o



‫א‬‫א‬‫א‬  K‫א‬



Mapping of Other Values

 WMouse Navigate o  K‫א‬‫א‬‫א‬‫א‬‫א‬

- ٨٩ -



 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 

 ١٦٢

 

List Item List Item‫א‬‫א‬‫• א‬  W‫א‬List Item ‫א‬‫א‬‫א‬ o

‫א‬‫א‬ o List Item‫א‬Item Type o

 More‫א‬Element in List‫א‬‫א‬  o OK‫א‬List Item value‫א‬List Element‫א‬‫א‬

‫א‬Initial Value‫א‬‫א‬‫א‬ o K‫א‬ LayoutList Item • ‫א‬‫א‬Data Block‫א‬Canvas‫א‬Layout ‫ א‬o List Item‫א‬‫א‬

‫א‬‫א‬‫א‬Canvas‫א‬‫א‬List Item‫א‬‫א‬ o ‫א‬List Item‫א‬ List Item‫א‬‫א‬

K‫א‬



WList Item‫א‬‫א‬Null‫א‬‫• א‬ ‫א‬‫א‬‫א‬‫א‬List Item‫א‬‫א‬‫א‬ YesRequired‫א‬ ،‫א‬Null‫א‬Null‫א‬ Tlists‫א‬Null‫א‬poplist‫א‬‫א‬Null‫א‬

 KCombo box‫א‬ 

    - ٩٠ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 

 ١٦٢

 

 Radio Group‫א‬‫א‬ Radio Group‫א‬‫א‬ • ‫א‬ ‫א‬Radio Group‫א‬‫א‬  ‫א‬‫א‬‫א‬‫א‬ ‫א‬‫א‬

 K‫א‬‫א‬

Radio Group‫א‬‫א‬‫א‬‫א‬‫א‬ • K‫א‬ o

KRadio Group‫א‬ o Koffon‫א‬‫א‬Radio Button o

‫א‬ ‫א‬‫א‬ ‫א‬‫א‬‫א‬W  ‫א‬‫א‬،‫א‬‫א‬‫א‬Check Box  List ElementsRadio Buttons‫א‬‫א‬‫א‬‫א‬ Radio Group‫א‬‫א‬ •  WRadio Group‫א‬‫א‬  KRadio Group‫א‬ o KLayout‫א‬Radio Group‫א‬‫א‬‫ א‬o

Kobject navigatorCreate‫א‬‫ א‬o

- ٩١ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 

 ١٦٢

 

WRadio Group‫א‬‫א‬ • WData Type o

 K‫א‬‫א‬‫א‬‫א‬‫א‬ 

WMapping of Other Values o

 ‫א‬‫א‬ ‫א‬‫א‬ ‫א‬ ‫א‬‫א‬‫א‬‫א‬‫א‬

 K‫א‬‫א‬ 

Mapping of Other Values



 WMouse Navigation o

 K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬

- ٩٢ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 

 ١٦٢

 

WRadio Button • WName o

Radio Radio button‫א‬‫א‬  ‫א‬

 KGroup

WAccess Key o  K‫א‬‫א‬‫א‬‫א‬





WLabel o

Radio ‫א‬Radio‫א‬‫א‬‫א‬‫א‬

 KGroup

WRadio Button Value o

Radio ‫א‬Radio‫א‬‫א‬‫א‬

 K Group



 Radio Group‫א‬‫א‬ • KRadio Group‫א‬‫א‬ ‫א‬‫א‬Object Navigator‫א‬‫א‬‫א‬ o KRadio GroupItem Type

Radio Group‫א‬Mapping of Other Value o Radio Button

Initial Value‫א‬ o

Radio Button‫א‬Radio Button o Name‫א‬ o Value o

KRadio ButtonLabel o - ٩٣ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 

 ١٦٢

 

KLayoutRadio Group‫א‬‫א‬ • ‫א‬‫א‬Data Block‫א‬Canvas‫א‬Layout ‫ א‬o Radio Button‫א‬‫א‬

Radio Button‫א‬‫א‬ o

‫א‬‫א‬Radio Button‫א‬‫א‬‫א‬‫א‬ o

K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬ o Radio Group‫א‬Mapping of Other Value o Radio Button

Initial Value‫א‬ o

Radio Button‫א‬Radio Button o Name‫א‬ o Value o

KRadio ButtonLabel o

- ٩٤ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 

 ١٦٢

 

   W‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬Cust7

List ItemCredit_Rating‫א‬،S_Customer K١ Poor , Good , List Item‫א‬‫א‬‫א‬‫א‬،Popup List‫א‬

،‫א‬‫א‬ ‫א‬‫א‬Excellent ‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬،Poor‫א‬‫א‬‫א‬

KGoodRecord‫א‬



KCust8‫א‬‫ א‬K٢ 

W‫א‬‫א‬‫א‬‫א‬‫א‬ORD7

‫א‬،Check Box‫א‬ Order_Filled‫א‬،S_Ord K١ ‫א‬N Unchecked‫א‬،‫א‬‫א‬YChecked ‫א‬،NRecord‫א‬‫א‬‫א‬‫א‬،‫א‬

Order Label‫א‬Prompt‫א‬‫א‬،NY‫א‬

K‫א‬LabelCheck Box‫א‬،Filled Radio Group‫א‬Payment_Type‫א‬،S_Ord K٢

،‫א‬‫א‬ ‫א‬Cash , Credit ،CreditTCashSAccess Key‫א‬‫א‬

‫א‬‫א‬‫א‬‫א‬،CreditCredit Cash‫א‬Cash Label KCash



 ORD8‫א‬‫ א‬K٣

- ٩٥ -

 ‫א‬‫א‬‫א‬ ã¹]<gè…‚jÖ]æ<ËÖ]<Üé×Ãj×Ö<íÚ^ÃÖ]<퉉ö¹] ‫א‬‫א‬‫א‬‫א‬

‫א‬‫א‬

Noninput

Noninput 

٧

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Noninput

 ١٦٢

 

W‫א‬‫א‬  K‫א‬‫א‬‫א‬‫א‬  W‫א‬‫א‬  W‫א‬‫א‬‫א‬  K‫א‬‫א‬‫א‬‫א‬ K١  KDisplay Item‫א‬ K٢

KImage Item‫א‬ K٣ KSound Item‫א‬ K٤ KPush Button‫א‬ K٥

KCalculated Item‫א‬‫א‬ K٦ W‫א‬‫א‬‫א‬ K٪١٠٠‫א‬‫א‬‫א‬   KW‫א‬‫א‬ 

 W‫א‬‫א‬ 

 K •  K • K •

 W‫א‬‫א‬ K‫א‬‫א‬‫א‬‫א‬،‫א‬

- ٩٦ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Noninput

 ١٦٢

 

 Noninput Creating Noninput Items  WNoninput Items • ،‫א‬Noninput Item  ‫א‬Noninput Item‫א‬ 

 ‫א‬‫א‬‫א‬‫א‬ KDisplay Items o KImage Items o

KCalculated Items o  ‫א‬‫א‬ KSound Items o

KPush Buttons o  K Noninput Items

- ٩٧ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Noninput

 ١٦٢

 

Display Item‫א‬

Display ItemText Item‫א‬Display Item‫א‬

‫א‬‫א‬‫א‬ ‫א‬ ‫א‬ ‫א‬Display item‫א‬،‫א‬‫א‬‫א‬‫א‬  K

 KText Item‫א‬‫א‬‫א‬ Display item‫א‬W  WDisplay Item‫א‬ •  WDisplay Item‫א‬  KLayout Editor‫א‬‫א‬Display Item‫א‬‫א‬ o KObject NavigatorCreate‫א‬ o

KDisplay Item o

 

WLayout EditorDisplay Item‫א‬ • Data ‫א‬  ‫א‬Layout o K‫א‬‫א‬‫א‬Block

‫א‬‫א‬Display item‫א‬‫א‬‫א‬ o

KDisplay Item‫א‬‫א‬‫א‬‫א‬Canvas‫א‬‫א‬ o ‫א‬ Display Item‫א‬‫א‬ o

‫א‬‫א‬  Name‫א‬‫א‬‫א‬‫א‬‫א‬

K‫א‬‫א‬‫א‬

    

- ٩٨ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Noninput

 ١٦٢

 

  ‫א‬

 WObject NavigatorDisplay Item‫א‬ • ‫א‬‫א‬Data Block‫א‬ Object Navigator o KDisplay Item

KCreate‫א‬‫א‬ o K‫א‬‫א‬‫א‬‫א‬‫א‬ o KDisplay Item‫א‬Item Type o



WDisplay Item‫א‬ • K‫א‬‫א‬‫א‬‫א‬Object Navigator o K‫א‬‫א‬‫א‬‫א‬‫ א‬o

KDisplay Item‫א‬Item Type o

- ٩٩ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Noninput

 ١٦٢

 

Image Item‫א‬

‫א‬‫א‬،‫א‬Graphic Object‫א‬  ‫א‬Runtime‫א‬‫א‬ 

 K‫א‬

‫א‬‫א‬‫א‬،‫א‬‫א‬ ‫א‬

 KControl ItemData ItemImage Item‫א‬‫א‬  WImage Item‫א‬ •  W‫א‬Image Item‫א‬‫א‬

 KLONG RAW‫א‬‫א‬‫א‬‫ א‬o K‫א‬‫א‬Trigger‫א‬ o Image ‫א‬Clipboard‫א‬‫א‬ o

KItem



W‫א‬ • ‫א‬‫א‬،   ‫א‬‫א‬ ‫א‬‫א‬‫א‬ ‫א‬‫א‬‫א‬

 KOracle Image Compression‫א‬‫א‬

 ‫א‬



 ‫א‬

 Long Raw‫א‬‫א‬

 ‫א‬

 ‫א‬‫א‬

      

- ١٠٠ -



 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Noninput

 ١٦٢

 

Image Item‫א‬ • Image Format o

 K‫א‬‫א‬‫א‬‫א‬

Image Depth o

 K‫א‬‫א‬‫א‬‫א‬‫א‬

Compression Quality o

 K‫א‬‫א‬‫א‬‫א‬

Display Quality o

 Runtime‫א‬‫א‬‫א‬

Sizing Style o

‫א‬‫א‬‫א‬

‫א‬، Corp‫א‬ ‫א‬ ‫א‬  KAdjust‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬

Show Horizontal / Vertical Scrollbar o

‫א‬‫א‬‫א‬‫א‬  ‫א‬ 

 K‫א‬

Show Palette o

‫א‬‫א‬‫א‬‫א‬ ‫א‬  W‫א‬‫א‬‫א‬

 ‫א‬‫א‬‫א‬

 K‫א‬‫א‬

 K‫א‬‫א‬‫א‬

 K‫א‬‫א‬‫א‬

- ١٠١ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Noninput

 ١٦٢

 

WImage Item‫א‬ •  WImage Item‫א‬

 KLayout Editor‫א‬‫א‬Image Item‫א‬‫א‬ o KObject NavigatorCreate‫א‬ o

KImage Item o



WLayout EditorImage Item‫א‬ •  Data Block‫א‬Layout o Image Item‫א‬‫א‬‫א‬ o

‫א‬‫א‬‫א‬‫א‬Data Block‫א‬Canvas‫א‬‫א‬ o

‫א‬Image tool‫א‬‫א‬  ‫א‬‫א‬  o Canvas‫א‬

K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬ o   ‫א‬





- ١٠٢ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Noninput

 ١٦٢

 

Sound Item‫א‬  ‫א‬  Sound Item‫א‬

Sound Item‫א‬،‫א‬‫א‬

 KControl ItemData Item  WSound Item‫א‬ •  W‫א‬‫א‬‫א‬

 K‫א‬LONG RAW‫א‬‫א‬‫ א‬o K‫א‬Trigger‫א‬ o

WSound Item‫א‬‫• א‬ ‫א‬‫א‬‫א‬‫א‬‫א‬   W‫א‬‫א‬   ‫א‬‫א‬



     - ١٠٣ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Noninput

 ١٦٢

 

 ‫א‬

 ‫א‬

 ‫א‬‫א‬

Play

 ‫א‬‫א‬

Record

 ‫א‬

Rewind

 ‫א‬

Fast Forward

 ‫א‬‫א‬

Volume

 ‫א‬‫א‬‫א‬‫א‬

Time Indicator

K‫א‬‫א‬‫א‬‫א‬‫א‬

Slider

WSound Item‫א‬ •  WSound Item‫א‬

 KLayout Editor‫א‬‫א‬Sound Item‫א‬‫א‬ o KObject NavigatorCreate‫א‬ o

KSound Item o WLayout EditorSound Item‫א‬ • ‫א‬‫א‬  ‫א‬ Data Block‫א‬ Layout

‫א‬‫א‬‫א‬Data Block‫א‬Canvas‫א‬‫א‬‫א‬‫א‬Sound Item Sound tool‫א‬‫א‬  ‫א‬‫א‬‫א‬ Sound Item‫א‬‫א‬‫א‬‫א‬Canvas‫א‬‫א‬  K‫א‬‫א‬‫א‬



 WSound Item‫א‬ • Sound Format o ‫א‬  ‫א‬‫א‬  K‫א‬

Audio Channel o

‫א‬‫א‬‫א‬‫א‬‫א‬

 KStereoMonoAutomatic‫א‬ - ١٠٤ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Noninput

 ١٦٢

 

Compress o

 K‫א‬‫א‬

Sound Quality o

 K‫א‬‫א‬

- ١٠٥ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Noninput

 ١٦٢

 

 Push Button Item‫א‬

‫א‬‫א‬Push Button Item‫א‬

 K‫א‬‫א‬‫א‬ W‫א‬ • ‫א‬‫א‬WText button o

K‫א‬‫א‬WIconic Button‫א‬ o

WCreate a Push Button‫א‬‫• א‬ Push Button‫א‬‫א‬ ‫א‬LayoutPush Button‫א‬  KCreateObject Navigator   ‫א‬



  WPush Button‫א‬ • WLabel o

 K‫א‬‫א‬

WIconic o

 K‫א‬‫א‬ - ١٠٦ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Noninput

 ١٦٢

 

WIcon Filename o  K‫א‬‫א‬‫א‬‫א‬‫א‬ WTool tip o  K‫א‬‫א‬‫א‬‫א‬

- ١٠٧ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Noninput

 ١٦٢

 

Calculated Item‫א‬

‫א‬‫א‬‫א‬‫א‬

Display Item‫א‬،  KCalculation Property‫א‬ 

 WCalculation mode‫א‬ • ‫א‬‫א‬‫א‬WFormula o K‫א‬‫א‬

Formula Mode

 ،‫א‬‫א‬‫א‬WSummary o ،‫א‬‫א‬‫א‬‫א‬‫א‬

KSUM , Count , Avg , Max , Min , Stddev , Variance‫א‬

‫א‬ ‫א‬‫א‬‫א‬‫א‬‫א‬

 K    

- ١٠٨ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Noninput

 ١٦٢

 



Summary Mode





 Calculated Item •  W‫א‬‫א‬Display Item‫א‬ WCalculation Mode o

 KSummaryFormula‫א‬‫א‬‫א‬



WFormula o   ‫א‬‫א‬‫א‬‫א‬

EWF‫א‬ ‫א‬‫א‬‫א‬Data Block‫א‬‫א‬ ‫א‬  ‫א‬K‫א‬‫א‬‫א‬  KFormulaCalculation mode

 WSummary Function o

،‫א‬‫א‬‫א‬ ‫א‬‫א‬‫א‬‫א‬

 KSummaryCalculation mode‫א‬‫א‬ 

- ١٠٩ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Noninput

 ١٦٢

 

WSummarized Block o ‫א‬‫א‬‫א‬Data Block‫א‬ ‫א‬ ‫א‬  K‫א‬‫א‬‫א‬

WSummarized Item o

 K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬



‫א‬‫א‬‫א‬‫א‬W     ‫א‬‫א‬Query All Record‫א‬Summary ،‫א‬‫א‬‫א‬‫א‬ ‫א‬‫א‬‫א‬ ‫א‬‫א‬Data Block‫א‬  Kyes‫א‬‫א‬

         

      - ١١٠ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Noninput

 ١٦٢

 

   W‫א‬‫א‬‫א‬‫א‬‫א‬ORD8

DescriptionDisplay Item،S_Item‫א‬ K١ KDescription‫א‬

‫א‬Image

Item،S_Item‫א‬ K٢

KProduct_Image





‫א‬Display Item،S_Item‫א‬ K٣

‫א‬‫א‬‫א‬‫א‬‫א‬Image_Description KDescription‫א‬

Push Button،Control‫א‬Control Block‫א‬ K٤ ،‫א‬Iconic Button‫א‬‫א‬،Product_Lov K‫א‬‫א‬‫א‬‫א‬‫א‬ W‫א‬‫א‬Item_Total‫א‬‫א‬،S_Item‫א‬ K٥  S_Item.quantity_shipped * S_Item.Price  K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬ ،Total‫א‬Display Item،S_Item‫א‬ K٦

‫א‬Item_Total‫א‬ ‫א‬‫א‬‫א‬  ‫א‬‫א‬‫א‬

‫א‬‫א‬‫א‬،S_Item‫א‬ ‫א‬‫א‬‫א‬،G999G990D999

- ١١١ -



 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Noninput

 ١٦٢

 

W‫א‬Form‫א‬ K٧ 



  KORD9‫א‬‫ א‬K٨



 W‫א‬‫א‬،‫א‬‫א‬‫א‬Cust8

Push ButtonControl‫א‬Control Block‫א‬ K١ ‫א‬Iconic Button  ‫א‬‫א‬،Sales_Rep_Lov K KCust9‫א‬‫ א‬K٢

- ١١٢ -

 

 ‫א‬‫א‬‫א‬ ã¹]<gè…‚jÖ]æ<ËÖ]<Üé×Ãj×Ö<íÚ^ÃÖ]<퉉ö¹] ‫א‬‫א‬‫א‬‫א‬

‫א‬‫א‬ Canvas & Windows

Canvas & Windows 

٨

 ‫א‬‫א‬ Canvas & Windows

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

W‫א‬‫א‬  KCanvas‫א‬Windows‫א‬‫א‬  W‫א‬‫א‬  W‫א‬‫א‬‫א‬  KContent Canvas‫א‬Windows‫א‬ K١

 KContent Canvas‫א‬Windows‫א‬‫א‬ K٢

W‫א‬‫א‬‫א‬ K٪١٠٠‫א‬‫א‬‫א‬ 

 KW‫א‬‫א‬ 

 W‫א‬‫א‬ 

 K •  K • K •

 W‫א‬‫א‬ K‫א‬‫א‬‫א‬‫א‬،‫א‬

- ١١٣ -

 ‫א‬‫א‬ Canvas & Windows

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

 CanvasWindows Creating Windows and Content Canvases  Window • ،‫א‬‫א‬‫א‬‫א‬Objects‫א‬‫א‬  K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬



 Canvas • ‫א‬Objects‫א‬Window‫א‬ Canvas‫א‬  K‫א‬‫א‬‫א‬‫א‬

CanvasWindow‫א‬Canvas‫א‬

 K‫א‬Window‫א‬Canvas‫א‬،

‫א‬ Canvas‫א‬ 

 K‫א‬Canvas

Windows and Canvas





- ١١٤ -

 ‫א‬‫א‬ Canvas & Windows

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

 Content Canvas • ‫א‬‫א‬،Canvases‫א‬‫א‬Form Builder

‫א‬‫א‬ ‫א‬Canvas‫א‬Content CanvasCanvas‫א‬  KCanvas‫א‬‫א‬‫א‬‫א‬،‫א‬‫א‬

  Content Canvas‫א‬Window‫א‬‫• א‬

 K‫א‬Window‫א‬‫א‬Content Canvas o

Window‫א‬Content Canvas o ‫א‬‫א‬Window‫א‬Content Canvases‫א‬‫א‬

KContent Canvases‫א‬‫א‬‫א‬

Window‫א‬Content Canvases o KContent Canvas ،‫א‬‫א‬Window‫א‬Content Canvas‫א‬Runtime‫א‬ o

Form Builder‫א‬،Window‫א‬‫א‬‫א‬

‫א‬‫א‬K  Canvas‫א‬   Form Builder‫א‬Canvas‫א‬

 K‫א‬‫א‬‫א‬ 

 ‫א‬ • ‫א‬‫א‬ ‫א‬‫א‬  W‫א‬

 K‫א‬Content Canvases‫א‬ o KInitial Canvas‫א‬‫א‬Canvas‫א‬Canvases‫א‬‫ א‬o

- ١١٥ -

 ‫א‬‫א‬ Canvas & Windows

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

Window‫א‬‫א‬ •  W Modal Window‫א‬‫ א‬o

 ‫א‬‫א‬Restricted Window

 W

K‫א‬‫א‬‫א‬‫א‬ K

K‫א‬‫א‬ Modeless Window‫א‬‫ א‬o

Unrestricted Window

W

K‫א‬ K K‫א‬‫א‬‫א‬‫א‬‫א‬



Window • ‫א‬WindowWindow  KCreate

Window Properties‫א‬ • X / Y Position o

 K‫א‬‫א‬YX‫א‬‫א‬

Width / Height o

 K‫א‬

Bevel o

 K‫א‬ - ١١٦ -



 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

Canvas & Windows

  EWindowsF‫א‬



      ١

MDI parent Window

٢

X/Y position

٣

Title

٤

Document window

٥

Dialog window

٦

Show vertical scrollbar

٧

Show horizontal scrollbar

Show Horizontal / Vertical Scrollbar o  K‫א‬‫א‬‫א‬  - ١١٧ -

 ‫א‬‫א‬ Canvas & Windows

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

Title o  K‫א‬‫א‬



Primary Canvas o

 K‫א‬‫א‬Canvas‫א‬‫א‬

 Window Style o  KDialog‫א‬Document‫א‬‫א‬





Modal o

Modeless ‫א‬‫א‬ ‫א‬Modal‫א‬

 K‫א‬‫א‬ Hide on Exit o  K‫א‬‫א‬





Close Allowed o

 K‫א‬

 Maximize Allowed o

 K‫א‬

Minimize Allowed o  K‫א‬

- ١١٨ -





 ‫א‬‫א‬ Canvas & Windows

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

Move Allowed o  K‫א‬‫א‬



Resize Allowed o

 K‫א‬‫א‬

 Inherit Menu o

 K‫א‬‫א‬‫א‬

- ١١٩ -

 ‫א‬‫א‬ Canvas & Windows

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

‫א‬ •   Content ،Content Canvas

‫א‬Content CanvasK‫א‬‫א‬‫א‬Canvas  KWindowContent Canvas

 Content Canvas •  WContent Canvas Layout Wizard‫א‬ o

Data Block‫א‬ Layout Wizard‫א‬‫א‬‫א‬‫א‬

KData Block‫א‬Content Canvas



Layout Editor‫א‬ o

Layout Editor  ‫א‬

 K‫א‬Content Canvas 

Object Create‫א‬ ‫א‬Content Canvas •

KNavigator



Content Canvas • Canvas Type o

 KCanvas‫א‬‫א‬

- ١٢٠ -

 ‫א‬‫א‬ Canvas & Windows

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

Window o  KContent Canvas‫א‬‫א‬‫א‬



Content Canvas‫א‬

 Width / Height o  K‫א‬ Bevel o

 K‫א‬

- ١٢١ -



 ‫א‬‫א‬ Canvas & Windows

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

   W‫א‬‫א‬،‫א‬‫א‬‫א‬Cust9

 ‫א‬،Win_Inventory ‫א‬‫א‬Window‫א‬‫א‬  K١ KCustomer InformationTitle

KCust10‫א‬‫ א‬K٢

 

 W‫א‬‫א‬،‫א‬‫א‬‫א‬ORD9

Title ‫א‬،Win_Order ‫א‬‫א‬Window‫א‬ K١ KOrders and Items

‫א‬Canvas‫א‬‫א‬Win_InventoryWindow K٢ KStock LevelsTitle ‫א‬،Cv_Inventory

KORD10‫א‬‫ א‬K٣

  

- ١٢٢ -

 ‫א‬‫א‬‫א‬ ã¹]<gè…‚jÖ]æ<ËÖ]<Üé×Ãj×Ö<íÚ^ÃÖ]<퉉ö¹] ‫א‬‫א‬‫א‬‫א‬

‫א‬‫א‬

Canvas‫א‬‫א‬

Canvas ‫א‬‫א‬

٩

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Canvas‫א‬‫א‬

 ١٦٢

 

W‫א‬‫א‬ KCanvas‫א‬‫א‬  W‫א‬‫א‬  W‫א‬‫א‬‫א‬  K‫א‬‫א‬‫א‬‫א‬Canvas‫א‬‫א‬‫א‬‫א‬ J ١

 Content CanvasStacked Canvas J ٢

 KToolbar Canvas J ٣ KTabbed Canvas J ٤ W‫א‬‫א‬‫א‬ K٪١٠٠‫א‬‫א‬‫א‬  KW‫א‬‫א‬ 

 W‫א‬‫א‬  K •



 K •

 K •

 W‫א‬‫א‬ K‫א‬‫א‬‫א‬‫א‬،‫א‬

- ١٢٢ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Canvas‫א‬‫א‬

 ١٦٢

 

Canvases‫א‬‫א‬ Working with Other Canvases  Canvas‫א‬‫א‬ •  WCanvas‫א‬‫א‬  KStacked Canvas o KToolbar Canvas o Tab CanvasK o

  Canvas‫א‬‫א‬

  WStacked Canvas • K‫א‬Content Canvas‫א‬Stacked Canvas‫א‬  KCanvas‫א‬Content Canvas‫א‬‫א‬



 WStacked Canvas‫א‬‫• א‬ K‫א‬‫א‬ o K o K o

K o K o - ١٢٣ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Canvas‫א‬‫א‬

 ١٦٢

 

 Stacked Canvas‫א‬ • Viewport X Position o

 K‫א‬Stacked Canvas‫א‬X‫א‬‫א‬‫א‬



Viewport Y Position o

 K‫א‬Stacked Canvas‫א‬Y‫א‬‫א‬‫א‬

 Stacked Canvas‫א‬





- ١٢٤ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Canvas‫א‬‫א‬

 ١٦٢

 

١ Content Canvas ٢ Stacked Canvas ٣ Viewport X/Y position ٤ Viewport height ٥ Viewport width Viewport Width o  K‫א‬Stacked Canvas‫א‬‫א‬ Viewport Height o  K‫א‬Stacked Canvas‫א‬‫א‬ Show Horizontal Scrollbar o  KStacked Canvas‫א‬‫א‬ Show Vertical Scrollbar o





 KStacked Canvas‫א‬‫א‬

   WStacked Canvas •

Object ‫א‬Layout EditorStacked Canvas

 Navigator ‫א‬‫א‬‫א‬Create ‫א‬Object Navigator J ١ KStacked‫א‬Canvas Type

‫א‬‫א‬‫א‬‫א‬Stacked Canvas‫א‬Layout Editor J ٢  KStacked Canvas‫א‬

 

- ١٢٥ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Canvas‫א‬‫א‬

 ١٦٢

 

 Toolbar Canvas ‫א‬  ‫א‬‫א‬‫א‬Canvas‫א‬‫א‬‫א‬  K‫א‬Canvas  W‫א‬

Vertical toolbar •

‫א‬ ‫א‬‫א‬‫א‬‫א‬‫א‬

 K‫א‬‫א‬‫א‬KWindow‫א‬ Horizontal toolbar •

‫א‬  ‫א‬‫א‬‫א‬‫א‬‫א‬  K‫א‬‫א‬‫א‬KWindow‫א‬

MDI toolbar •

K‫א‬‫א‬‫א‬‫א‬‫א‬

  Toolbar Canvas ‫א‬‫א‬‫א‬Create‫א‬Object Navigator KHorizontal/Vertical Canvas‫א‬Canvas Type



 Toolbar Canvas  Canvas Type o

Horizontal Toolbar Canvas‫א‬‫א‬

 KVertical ToolbarToolbar  WWindow o

 K‫א‬‫א‬‫א‬‫א‬



 

- ١٢٦ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Canvas‫א‬‫א‬

 ١٦٢

 

 WWidth o  K‫א‬‫א‬



 WHeight o

 K‫א‬‫א‬

 Tab Canvas‫א‬  ‫א‬‫א‬Canvases‫א‬‫א‬

،‫א‬‫א‬  ‫א‬

 KTab Page‫א‬ 

 Tab Page‫א‬ ‫א‬Tab Page،Tab Page‫א‬‫א‬Tab Canvas Tab ‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬Tab Page،‫א‬

 KPages   WTab Pages‫א‬‫א‬‫א‬

 K‫א‬‫א‬ J

K‫א‬ J

K‫א‬‫א‬‫א‬‫א‬ J

  Tab Canvas‫א‬ Layout Object NavigatorTab Canvas‫א‬

 F‫א‬Tab Canvas‫א‬‫א‬Tab PageEditor  KTab Pages‫א‬EData Block‫א‬    - ١٢٧ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Canvas‫א‬‫א‬

 ١٦٢

 

Tab Canvas‫א‬





    ١ Viewport X/Y position ٢ Viewport width ٣ Viewport height ٤ Tab attachment edge   WObject Navigator‫א‬Tab Canvas Canvas‫ א‬J ١

KCanvasCreate‫א‬ J ٢

KTab PageCanvas Type‫א‬Canvas‫א‬‫א‬ J ٣

  WLayout Editor‫א‬Tab Canvas KTab Page‫א‬‫א‬‫א‬ J ١

- ١٢٨ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Canvas‫א‬‫א‬

 ١٦٢

 

KTable Canvas‫א‬‫ א‬J ٢ KTab Pages‫א‬ J ٣   WTab Pages  W‫א‬‫א‬Object Navigator‫א‬  KTab Canvas‫ א‬J ١

KTab Page‫א‬ J ٢

  Create‫ א‬J ٣ KCreate

K‫א‬‫א‬Tab Page‫א‬‫א‬‫ א‬J ٤



 Tab Canvas‫א‬ Viewport X Position o

 K‫א‬Tab Canvas‫א‬X‫א‬‫א‬‫א‬

Viewport Y Position o

 K‫א‬Tab Canvas‫א‬Y‫א‬‫א‬‫א‬



Viewport Width o

 K‫א‬Tab Canvas‫א‬‫א‬

Viewport Height o

 K‫א‬Tab Canvas‫א‬‫א‬

 Tab Attachment o

 ‫א‬‫א‬Tab Pages‫א‬‫א‬

  ‫א‬  ‫א‬‫א‬‫א‬

 K‫א‬ 

- ١٢٩ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Canvas‫א‬‫א‬

 ١٦٢

 

 Tab Pages‫א‬ Label o

 KTab Page‫א‬‫א‬‫א‬

- ١٣٠ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Canvas‫א‬‫א‬

 ١٦٢

 

 



 W‫א‬‫א‬،‫א‬‫א‬‫א‬ORD10

،Win_Order‫א‬Window‫א‬ToolbarHorizontal Toolbar Canvas K١  K٣٠Canvas‫א‬‫א‬

 Push ButtonsControl‫א‬Control Block‫א‬ K٢ Stock_Button

W‫א‬‫א‬ KLabel : Stock

KMouse Navigate : No KKeyboard Navigable : No Show_Help_Button

KCanvas : Toolbar

Label : Show Help KMouse Navigate : No

KKeyboard Navigable : No Exit_Button

KCanvas : Toolbar

Label : Exit KMouse Navigate : No

KKeyboard Navigable : No KCanvas : Toolbar

 ‫א‬،Win_Order‫א‬Window‫א‬Cv_HelpStacked Canvas K٣

٢٧٠‫א‬Viewport WidthStacked Canvas‫א‬  K‫א‬‫א‬Stacked Canvas‫א‬٢١٥‫א‬Viewport Height

KObject Navigator‫א‬CanvasStacked Canvas‫ א‬K٤

Hide_HelpPush ButtonControl Block‫א‬ K٥ Hide_Help_Button

Label : Hide Help KMouse Navigate : No Canvas : Cv_Help - ١٣١ -

‫א‬‫א‬

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Canvas‫א‬‫א‬

 ١٦٢

 

 ‫א‬Stacked Canvas‫א‬‫א‬



 KORD11‫א‬‫ א‬K٦   W‫א‬‫א‬،‫א‬‫א‬‫א‬Cust10

‫א‬‫א‬Tab PagesTab_CustomerTab Canvas K١ S_Customer‫א‬Address , Billing , Comments W‫א‬Tab Pages‫א‬

 WAddress‫א‬Tab Page‫א‬

 - ١٣٢ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Canvas‫א‬‫א‬

 ١٦٢

 

 WBilling‫א‬Tab Page‫א‬ 



  WComments‫א‬Tab Page‫א‬



 KCust11‫א‬‫א‬J ٨ - ١٣٣ -

 ‫א‬‫א‬‫א‬ ã¹]<gè…‚jÖ]æ<ËÖ]<Üé×Ãj×Ö<íÚ^ÃÖ]<퉉ö¹] ‫א‬‫א‬‫א‬‫א‬

‫א‬‫א‬

Triggers‫א‬

Triggers ‫א‬

١٠

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Triggers‫א‬

 ١٦٢

 

W‫א‬‫א‬  Triggers‫א‬‫א‬ W‫א‬‫א‬  W‫א‬‫א‬‫א‬  KTrigger‫א‬ K١

 KTriggers‫א‬E‫א‬‫א‬F‫א‬‫ א‬K٢  K‫א‬Triggers‫א‬Scope‫ א‬K٣ W‫א‬‫א‬‫א‬ K٪١٠٠‫א‬‫א‬‫א‬ KW‫א‬‫א‬ 

 W‫א‬‫א‬ 

 K •  K •

 K •



W‫א‬‫א‬  K‫א‬‫א‬‫א‬‫א‬،‫א‬

- ١٣٣ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Triggers‫א‬

 ١٦٢

 

 Triggers‫א‬  Introduction to Triggers

 Trigger • ،EF‫א‬ Trigger‫א‬ ‫א‬   

Trigger‫א‬‫א‬،‫א‬‫א‬‫א‬‫א‬،‫א‬

 KTrigger‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬

Form ‫א‬‫א‬‫א‬،Trigger

 W‫א‬‫א‬‫א‬‫א‬Builder  K‫א‬‫א‬‫ א‬o

K‫א‬‫א‬‫א‬ o EModuleF‫א‬‫ א‬o K‫א‬ o

KEModuleF‫א‬‫א‬‫א‬ o KEModuleF‫א‬‫א‬‫א‬‫א‬‫א‬‫ א‬o K‫א‬‫ א‬o Trigger‫א‬ •

 ‫א‬‫א‬ ‫א‬‫א‬Trigger ‫א‬‫א‬

 WTrigger‫א‬‫א‬

 K‫א‬‫א‬‫א‬‫א‬‫א‬W Trigger‫א‬ o K‫א‬‫א‬‫א‬WTrigger‫א‬ o

‫א‬‫א‬W Trigger‫א‬ o KEModuleF‫א‬Data Block  - ١٣٤ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Triggers‫א‬

 ١٦٢

 

 Trigger • ‫א‬‫א‬،Trigger‫א‬‫א‬‫א‬E‫א‬F‫א‬Trigger‫א‬  W‫א‬‫א‬Trigger‫א‬EModuleF‫א‬Trigger‫א‬

‫א‬FormTrigger‫א‬W Form‫א‬ o KForm‫א‬Form

‫א‬‫א‬Trigger‫א‬W Block‫א‬ o ‫א‬‫א‬‫א‬‫א‬،‫א‬‫א‬

K

‫א‬‫א‬‫א‬ItemTrigger‫א‬W Item‫א‬ o K‫א‬Item‫א‬Item‫א‬‫א‬،Item

 Trigger‫א‬  ‫א‬

• Form • Block • Item







Triggers‫א‬

‫א‬‫א‬Item‫א‬Post-Query Trigger  KForm‫א‬ 

 Trigger‫א‬‫א‬ • Built in ١٠٠،Trigger‫א‬‫א‬‫א‬Trigger‫א‬  KForm Builder‫א‬‫א‬EFTriggers

Trigger‫א‬‫א‬   ‫א‬‫א‬Built in trigger‫א‬  WTrigger‫א‬‫א‬‫א‬‫א‬E_F‫א‬ - ١٣٥ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Triggers‫א‬

 ١٦٢

 

‫א‬Trigger‫א‬‫א‬‫א‬W _Key o ‫א‬‫א‬K‫א‬

KTrigger‫א‬

K‫א‬Trigger‫א‬‫א‬‫א‬W 

_On o

K‫א‬Trigger‫א‬‫א‬‫א‬W

_Pre o

K‫א‬Trigger‫א‬‫א‬‫א‬W

_Post o

K‫א‬Trigger‫א‬‫א‬‫א‬W

_When o





 Triggers‫א‬‫א‬ Trigger

• • • • •

‫א‬‫א‬

Pre_ Post_ When_ On_ Key_



 

Trigger‫א‬ • ‫א‬‫א‬،‫א‬Trigger‫א‬‫א‬  ‫א‬Trigger‫א‬

 WTrigger‫א‬‫א‬‫א‬‫א‬‫א‬،PL/SQL‫א‬  K‫א‬‫א‬‫א‬PL/SQL o KSQL o

K‫א‬‫א‬‫א‬ o

KBuilt in subprogram‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬ o

- ١٣٦ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Triggers‫א‬

 ١٦٢

 

  Triggers ‫א‬

 • • • •

Triggers ‫א‬



Statements PL/SQL. User Subprograms.

Built-in Subprograms

   

WExecution Hierarchy‫א‬Trigger‫א‬ •

Form Builder‫א‬  ‫א‬Trigger 

 K‫א‬‫א‬‫א‬Trigger‫א‬

  ‫א‬Execution Hierarchy‫א‬

Trigger‫א‬‫א‬،‫א‬Trigger  W‫א‬‫א‬

K‫א‬‫א‬Trigger‫א‬W Override • K‫א‬Trigger‫א‬Trigger‫א‬W

 K‫א‬Trigger‫א‬Trigger‫א‬W

- ١٣٧ -

After • Before •

 ‫א‬‫א‬‫א‬ ã¹]<gè…‚jÖ]æ<ËÖ]<Üé×Ãj×Ö<íÚ^ÃÖ]<퉉ö¹] ‫א‬‫א‬‫א‬‫א‬

‫א‬‫א‬

Trigger‫א‬

Trigger ‫א‬

١١

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Trigger‫א‬

 ١٦٢

 

W‫א‬‫א‬  KTriggers‫א‬Form Builder‫א‬‫א‬Built In‫א‬‫א‬‫א‬‫א‬‫א‬ W‫א‬‫א‬  W‫א‬‫א‬‫א‬  KTrigger‫א‬‫א‬ K١

 KForm Builder‫א‬‫א‬Built In‫א‬‫א‬‫א‬ K٢  When-Button-Pressed Trigger K٣ W‫א‬‫א‬‫א‬ K٪١٠٠‫א‬‫א‬‫א‬ KW‫א‬‫א‬ 

 W‫א‬‫א‬ 

 K •  K •

 K •



W‫א‬‫א‬  K‫א‬‫א‬‫א‬‫א‬،‫א‬

- ١٣٨ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Trigger‫א‬

 ١٦٢

 

 Triggers‫א‬ Producing Triggers  WSmart Triggers‫א‬‫א‬Trigger •

Data Block‫א‬Object

 Module‫א‬Data Block Module‫א‬Items Smart ‫א‬‫א‬‫א‬Object Navigator

‫א‬Smart Trigger ‫א‬‫א‬،Triggers ‫א‬‫א‬،Layout EditorData Block‫א‬‫א‬ ،Object‫א‬‫א‬‫א‬‫א‬‫א‬Trigger‫א‬  

Trigger‫א‬‫א‬Form Builder‫א‬Trigger

 KTrigger‫א‬‫א‬PL/SQL Editor 

WTrigger • Smart Trigger‫א‬‫א‬Trigger  W‫א‬‫א‬Smart Trigger‫א‬‫א‬Trigger‫א‬ Object Navigator o

‫א‬‫א‬Item‫א‬Data Block‫א‬Form‫א‬Trigger‫א‬‫א‬

Create‫א‬Trigger‫א‬EScopeF‫א‬Trigger  K‫א‬‫א‬Trigger‫א‬Triggers‫א‬

WPL/SQL o

 KTriggers‫א‬‫א‬New‫א‬

WLayout Editor o

 ‫א‬‫א‬‫א‬Trigger‫א‬‫א‬Object ‫א‬‫א‬

Trigger‫א‬Triggers‫א‬PL/SQL Editor‫א‬ ‫א‬‫א‬‫א‬،Trigger‫א‬PL/SQL Editor‫א‬

‫א‬‫א‬PL/SQL‫א‬TriggerEObjectF  KTrigger‫א‬‫א‬‫א‬ - ١٣٩ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Trigger‫א‬

 ١٦٢

 

WPL/SQL •  WTrigger‫א‬‫א‬‫א‬‫א‬

Source Pane Trigger ‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬



  W‫א‬

 KTrigger

Type

 KTrigger‫א‬ Object

 Item‫א‬‫א‬Item‫א‬‫א‬Trigger‫א‬Item  Trigger‫א‬E‫א‬F

 K‫א‬‫א‬‫א‬‫א‬‫א‬

Name

Source Pane

  WPL/SQL‫א‬‫א‬‫א‬ •

‫א‬‫א‬‫א‬‫א‬‫א‬‫ א‬o K‫א‬‫א‬‫א‬‫א‬‫א‬

K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬ K‫א‬‫א‬‫א‬‫א‬

K‫א‬‫א‬ o Syntax Palette‫א‬ o  ‫א‬SQL‫א‬‫א‬‫א‬

 Syntax Palette‫א‬Program‫א‬،PL/SQL - ١٤٠ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Trigger‫א‬

 ١٦٢

 

‫א‬‫א‬‫א‬‫א‬Triggers‫א‬‫א‬ o Find ‫א‬Program‫א‬‫א‬‫א‬،

Kand Replace

Trigger‫א‬ o KCompile

SQL‫א‬‫א‬Compile‫א‬Trigger‫ א‬o K‫א‬

Compile‫א‬RunCompile‫א‬Triggers‫ א‬o K  WTrigger‫א‬‫א‬ •

 W‫א‬Trigger‫א‬‫א‬

‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬WDeclaration‫א‬ o KDeclare‫א‬

‫א‬‫א‬Wexecutable Statement‫א‬‫א‬ o KTrigger‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬ KEndBegin‫א‬‫א‬Declaration

‫א‬،‫א‬WException handlers‫א‬ o K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬،Exception  W • ENDBEGIN  Trigger‫א‬‫א‬ o W‫א‬When_Validate_Item‫א‬Trigger‫א‬ ‫א‬

S_item.price IS NULL THENW IF

‫؛‬S_item.price := :S_item.stdpriceW ‫؛‬END IF

‫؛‬Calculate_total - ١٤١ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Trigger‫א‬

 ١٦٢

 

ENDBEGIN  ‫א‬Trigger‫א‬‫א‬ o W‫א‬When_Button_Pressed‫א‬Trigger‫א‬ DECLARE Vn_descount number‫؛‬ BEGIN Vn_descount :=calculate_descount (:S_item.product_id , :S_item.quantity‫(؛‬ MESSAGE(‘ Descount : ‘||to_char(vn_descount‫((؛‬

 Trigger‫א‬Exception‫א‬‫א‬‫א‬ ‫א‬ o W‫א‬

Insert Into Log_Tab (Log_Val, Log_UserE Values (:S_Dept.Id, :Global.Username‫؛‬E

Exception When Others Then MESSAGE (‘Error ! ‘,||Sqlerrm‫؛‬E

WForm Builder‫א‬‫א‬‫א‬‫א‬‫• א‬ ‫א‬‫א‬Form Builder‫א‬Trigger‫א‬‫א‬‫א‬‫א‬  W‫א‬

‫א‬Variables‫א‬ ‫א‬‫א‬‫א‬WPL/SQL‫א‬ K١ colon‫א‬‫א‬‫א‬‫א‬‫א‬،Declaration

‫א‬‫א‬‫א‬‫א‬‫א‬  ‫א‬‫א‬‫א‬ ،EWF

K‫א‬‫א‬‫א‬‫א‬Triggers

‫א‬Variable‫א‬‫א‬‫א‬‫א‬WForm Builder‫א‬‫א‬ K٢

‫א‬PL/SQL‫א‬‫א‬‫א‬‫א‬‫א‬Form Builder   ‫א‬‫א‬‫א‬‫א‬،EWFcolonVariable‫א‬‫א‬

‫א‬‫א‬Form Builder‫א‬‫א‬KPL/SQL‫א‬‫א‬ KPL/SQL Block‫א‬‫א‬‫א‬Declaration - ١٤٢ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Trigger‫א‬

 ١٦٢

 

WForm Builder‫א‬‫א‬‫א‬ • WEItem (text, list, check box, and son on‫א‬ K١

 Data Block‫א‬‫א‬‫א‬ K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬

K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬

WGlobal Variable‫א‬ K٢

K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬

KModules‫א‬‫א‬‫א‬‫א‬‫א‬ WSystem Variables‫א‬ K٣

K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬ K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬

WParameter‫א‬ K٤

K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬ K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬

 WGlobal‫א‬‫א‬‫א‬‫• א‬ ‫א‬Global‫א‬‫א‬‫א‬ Default_Value‫א‬‫א‬ ‫א‬‫א‬‫א‬E’Default _value (‘Turkey’ , ‘Global.countryW‫א‬

 KTurkey‫א‬‫א‬‫א‬CountryGlobal

 W‫א‬‫א‬ • Block‫א‬ ‫א‬Item‫א‬‫א‬ Item‫א‬‫א‬‫א‬ o W‫א‬‫א‬Item‫א‬‫א‬‫א‬ WBlock3.Product_id : = : Block2.product_id‫؛‬ Block2‫א‬Product_id‫א‬‫א‬‫א‬‫א‬‫א‬  KBlock3‫א‬Product_id‫א‬

- ١٤٣ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Trigger‫א‬

 ١٦٢

 

 ‫א‬‫א‬GlobalGlobal‫א‬‫א‬‫א‬ o W‫א‬‫א‬ WGlobal.Customer_id : = : Block1.id‫؛‬ ‫א‬Block1‫א‬id‫א‬‫א‬‫א‬‫א‬‫א‬  K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬Customer_id

‫א‬‫א‬SystemSystem‫א‬‫א‬‫א‬ o W‫א‬‫א‬ IF : System.mode : = ‘ Normal ’ then Ok_to_leave_block : = true‫؛‬ End If‫؛‬

 NormalMode‫א‬‫א‬‫א‬‫א‬‫א‬ ‫א‬‫א‬ParameterParameter‫א‬‫א‬‫א‬ o W‫א‬‫א‬ IF : Parameter.Starting_point = 2 then

 ‫؛‬E’Go_block (‘Block2 End If‫؛‬

 ٢Starting_point‫א‬‫א‬‫א‬‫א‬‫א‬

‫א‬Object Navigator‫א‬Parameter‫א‬‫א‬  K‫א‬‫א‬Parameter‫א‬‫א‬Create‫א‬Parameter 

 WBuilt in Subprograms‫א‬‫א‬‫• א‬ ،‫א‬‫א‬‫א‬‫א‬Form Builder‫א‬ ‫א‬ ‫א‬‫א‬‫א‬Package‫א‬‫א‬‫א‬

 KFunction‫א‬Procedure

 W‫א‬‫א‬Built in Subprograms‫א‬‫א‬‫א‬  ‫א‬  ‫א‬‫א‬‫א‬‫א‬‫א‬WStandard Extensions Packages o KPackage‫א‬ - ١٤٤ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Trigger‫א‬

 ١٦٢

 

‫א‬‫א‬   ‫א‬‫א‬‫א‬‫א‬‫א‬W‫א‬‫א‬Package‫א‬‫א‬‫א‬‫ א‬o 

K‫א‬‫א‬‫א‬‫א‬Package

- ١٤٥ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Trigger‫א‬

 ١٦٢

 

 WBuilt in Subprograms‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬ • ،Triggerbuilt in subprogram‫א‬‫א‬

Trigger‫א‬‫א‬‫א‬

 W

‫א‬Triggers‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬WUnrestricted Built-ins o KTriggers‫א‬‫א‬‫א‬‫א‬

‫א‬Triggers‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬WRestricted Built-ins o K‫א‬Triggers‫א‬‫א‬‫א‬‫א‬

  ‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬



- ١٤٦ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Trigger‫א‬

 ١٦٢

 

١

Open PL/SQL code

٢

Select built-in

٣

Past names or arguments

٤

Modify pasted code

 WBuilt in Subprograms‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬ • ‫א‬‫א‬  Form Builder  Trigger ‫א‬‫א‬Trigger‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬  W

Trigger‫א‬‫א‬  ‫א‬‫א‬‫א‬ ‫א‬‫א‬‫א‬ K١ Built In Package‫א‬Object Navigator‫א‬‫א‬‫א‬

Past  ‫א‬Navigator‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬

‫א‬Past Argument‫א‬‫א‬‫א‬‫א‬name

‫א‬  ‫א‬‫א‬‫א‬ ،‫א‬‫א‬‫א‬‫א‬

K ‫א‬ ProgramPL/SQL Editor‫א‬‫א‬‫א‬‫א‬ K٢

‫א‬ ‫א‬‫א‬‫א‬ Built In‫א‬Syntax Palette‫א‬

KInsert  W‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬ • ،‫א‬‫א‬‫א‬‫א‬WENTER_QUERY procedure K١ K ‫א‬‫א‬‫א‬‫א‬

K‫א‬‫א‬‫א‬WEXECUTE_QUERY Procedure K٢ K‫א‬‫א‬‫א‬‫א‬‫א‬WEXIT_FORM procedure K٣ - ١٤٧ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Trigger‫א‬

 ١٦٢

 

‫א‬‫א‬WGET_ITEM_PROPERTY function K٤ K‫א‬‫א‬

Data    ‫א‬‫א‬‫א‬WGO_BLOCK Procedure K٥

KBlock

KItem‫א‬‫א‬‫א‬WGO_ITEM Procedure K٦ KCanvas‫א‬‫א‬‫א‬WSHOW_VIEW Procedure K٧ KCanvas‫א‬‫א‬‫א‬WHIDE_VIEW Procedure K٨ K‫א‬‫א‬‫א‬WMESSAGE Procedure K٩

‫א‬‫א‬‫א‬WSET_ITEM_PROPERTY Procedure K١٠ K

‫א‬LOV   ‫א‬‫א‬‫א‬WSHOW_LOV Procedure K١١ K‫א‬

LOV  ‫א‬‫א‬‫א‬WLIST_VALUE Procedure K١٢ K LOV‫א‬‫א‬‫א‬

 WTriggers‫א‬ •

‫א‬‫א‬Sales_Rep_Lov‫א‬Push ButtonTriggerJ ١  WTrigger‫א‬‫א‬‫א‬‫א‬When_Button_PressedTrigger‫א‬ IF SHOW_LOV(’sales_rep_lov’) THEN NULL‫؛‬ END IF‫؛‬

Trigger‫א‬‫א‬‫א‬Push ButtonTriggerJ ٢  W‫א‬‫א‬When_Button_Pressed

Exit_Form‫؛‬

‫א‬Data Block‫א‬Push ButtonTriggerJ ٣  W‫א‬‫א‬When_Button_PressedTrigger‫א‬‫א‬ Go_Block (' Data Block Name‫؛‬E' Execute_Query‫؛‬ - ١٤٨ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 Trigger‫א‬

 ١٦٢

 

 

 W‫א‬‫א‬،‫א‬‫א‬‫א‬Cust11

‫א‬Sales_Rep_Lov‫א‬LOV‫א‬Trigger J ١  KSales_Rep_Lov_Button‫א‬

KCust13‫א‬‫ א‬J ٢  W‫א‬‫א‬،‫א‬‫א‬‫א‬Ord11

‫א‬‫א‬Product_Lov‫א‬Lov‫א‬Trigger J ٣ KProduct_Lov_Button KExit_Button‫א‬‫א‬‫א‬Trigger J ٤ ‫א‬‫א‬Cv_Help‫א‬Stacked CanvasTrigger J ٥ KShow_Help_Button

‫א‬‫א‬Cv_Help‫א‬Stacked CanvasTrigger J ٦ KHide_Help_Button

‫א‬‫א‬S_Inventory‫א‬‫א‬Trigger J ٧ KStock_Button‫א‬‫א‬

 KORD13‫א‬‫ א‬J ٨

- ١٤٩ -



 ‫א‬‫א‬‫א‬ ã¹]<gè…‚jÖ]æ<ËÖ]<Üé×Ãj×Ö<íÚ^ÃÖ]<퉉ö¹] ‫א‬‫א‬‫א‬‫א‬

‫א‬‫א‬

‫א‬

‫א‬

١٢

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ‫א‬

 ١٦٢

 

W‫א‬‫א‬  KReport‫א‬‫א‬ W‫א‬‫א‬  W‫א‬‫א‬‫א‬ KReport‫א‬ K١

 KObject Navigator‫א‬ K٢

KReport‫א‬‫א‬ K٣ KReport‫א‬Run K٤ W‫א‬‫א‬‫א‬ K٪٨٠‫א‬‫א‬‫א‬ KW‫א‬‫א‬ 

 W‫א‬‫א‬ 

 K •  K •

 K •

 W‫א‬‫א‬  K‫א‬‫א‬‫א‬‫א‬،‫א‬

- ١٤٩ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ‫א‬

 ١٦٢

 

 

Oracle Developer‫א‬‫א‬‫א‬‫א‬Report Builder‫א‬ Form ‫א‬‫א‬  ‫א‬‫א‬‫א‬

 K‫א‬‫א‬‫א‬‫א‬،Builder   WReport Builder‫א‬ 

Report Builder‫א‬



  W‫א‬Form Builder‫א‬‫א‬ 

Object Navigator‫א‬  ‫א‬‫א‬،‫א‬‫א‬

Navigator‫א‬‫א‬‫א‬  Kobject‫א‬

- ١٥٠ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ‫א‬

 ١٦٢

 

  ‫א‬‫א‬Form Builder‫א‬‫א‬  WE‫א‬‫א‬F‫א‬

 K‫א‬‫א‬‫א‬‫א‬‫א‬WDataJ ‫א‬‫א‬‫א‬WLayoutJ

 K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬  W‫א‬‫א‬  F3 K١

Object NavigatorTools K٢  Object Navigator‫א‬ 



  

- ١٥١ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ‫א‬

 ١٦٢

 

 W‫א‬Object‫א‬Object Navigator‫א‬  K‫א‬‫א‬‫א‬‫א‬

MODULE1

 ،‫א‬‫א‬  ‫א‬ ،‫א‬ ‫א‬‫א‬‫א‬ ‫א‬‫א‬‫א‬‫א‬‫א‬

Live Previewer

 KLayout Model‫א‬‫א‬ ‫א‬‫א‬،‫א‬‫א‬ ‫א‬‫א‬  K‫א‬‫א‬‫א‬‫א‬

Data Model

‫א‬‫א‬‫א‬‫א‬

‫א‬،‫א‬‫א‬‫א‬ Layout Editor‫א‬‫א‬‫א‬‫א‬‫א‬ Layout Model

‫א‬،‫א‬  K‫א‬ ‫א‬‫א‬‫א‬ ‫א‬‫א‬

‫א‬‫א‬Form Module

Form Builder‫א‬‫א‬‫ א‬Parameter Form

 ‫א‬‫א‬،‫א‬  K‫א‬‫א‬ 

- ١٥٢ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ‫א‬

 ١٦٢

 

 ‫א‬  Object Categories

‫א‬  ‫א‬‫א‬Report Builder‫א‬‫א‬  W‫א‬E‫א‬F‫א‬ Report Level‫א‬J ١  Report Level Object‫א‬



 

‫א‬‫א‬Trigger‫א‬‫א‬‫א‬‫א‬ Report Level Objects‫א‬،‫א‬‫א‬‫א‬‫א‬  W‫א‬‫א‬  K‫א‬  K‫א‬‫א‬Triggers‫א‬ ‫א‬Procedures‫א‬‫א‬‫א‬Functions‫א‬‫א‬

Properties Triggers

PL/SQL  K‫ א‬Program Units

- ١٥٣ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ‫א‬

 ١٦٢

 

Data Model‫א‬J ٢   Data Model‫א‬ 





‫א‬،‫א‬‫א‬‫א‬Data Model‫א‬ Data ‫א‬،Object Navigator‫א‬Data Model‫א‬

 W‫א‬‫א‬Model

K‫א‬‫א‬‫א‬Select‫א‬ Query  K‫א‬ Group ،‫א‬‫א‬‫א‬‫א‬

‫א‬‫א‬   Columns  K‫א‬

‫א‬   

Data Link

،‫א‬‫א‬‫א‬

Parameter

 K‫א‬‫א‬

 KSystem‫א‬ ‫א‬‫א‬



- ١٥٤ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ‫א‬

 ١٦٢

 

Layout Model‫א‬J ٣   Layout Model‫א‬





،‫א‬Layout Model‫א‬  W‫א‬،‫א‬‫א‬‫א‬

‫א‬  K‫א‬‫א‬

Report Frame

 K‫א‬ Frame  ‫א‬‫א‬‫א‬‫א‬‫א‬ Field  ‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬  K‫א‬‫א‬

Biolerplate

 

- ١٥٥ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ‫א‬

 ١٦٢

 

 Parameter Form Objects‫א‬J ٤ 

 Parameter Form Objects‫א‬





،‫א‬‫א‬‫א‬‫א‬Parameter Form‫א‬ Parameter ‫א‬،‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬

 WForm

 K‫א‬‫א‬‫א‬ Field ‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬

 K‫א‬

Biolerplate  

Layout Model‫א‬ ‫א‬ ‫א‬‫א‬‫א‬‫א‬ ‫א‬،‫א‬‫א‬  ،‫א‬

،‫א‬ ‫א‬‫א‬‫א‬‫א‬‫א‬Tool Palette

‫א‬‫א‬‫א‬‫א‬Toolbar‫א‬

K‫א‬‫א‬‫א‬

‫א‬‫א‬‫א‬ ‫א‬‫א‬‫א‬  KObject Navigator

- ١٥٦ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ‫א‬

 ١٦٢

 

 W‫א‬‫א‬  F2J

Layout EditorToolsJ



Property Palette‫א‬ ‫א‬‫א‬‫א‬‫א‬ ‫א‬ ‫א‬ ‫א‬‫א‬

‫א‬‫א‬‫א‬‫א‬ K‫א‬ 

Object Layout Model‫א‬‫א‬‫א‬ ‫א‬

 WNavigator

 F4J

KProperty PaletteToolsJ

- ١٥٧ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ‫א‬

 ١٦٢

 

 ‫א‬  Running a Report

Compile‫א‬‫א‬   ‫א‬  W‫א‬

 AdministrationFileJ

Compile FileJ

 W‫א‬‫א‬‫א‬‫א‬  programJ

Run ReportJ

Ctrl + RJ

 KERunF‫א‬‫א‬‫א‬‫א‬J 

Runtime‫א‬

١

٢

٣

٤



٥

 ‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬

-١

 K‫א‬ J ٢

 K‫א‬‫א‬ J ٣  K‫א‬ J ٤  K‫א‬ J ٥

- ١٥٨ -

 ‫א‬‫א‬‫א‬ ã¹]<gè…‚jÖ]æ<ËÖ]<Üé×Ãj×Ö<íÚ^ÃÖ]<퉉ö¹] ‫א‬‫א‬‫א‬‫א‬

‫א‬‫א‬

‫א‬

‫א‬

١٣

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ‫א‬

 ١٦٢

 

W‫א‬‫א‬  KTabularReport‫א‬ W‫א‬‫א‬  W‫א‬‫א‬‫א‬ KTabular K١

KForm Like K٢

K‫א‬‫א‬ K٣ W‫א‬‫א‬‫א‬ K٪٨٠‫א‬‫א‬‫א‬ KW‫א‬‫א‬ 

 W‫א‬‫א‬ 

 K •  K •

 K •



W‫א‬‫א‬  K‫א‬‫א‬‫א‬‫א‬،‫א‬

- ١٥٩ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ‫א‬

 ١٦٢

 

 ‫א‬

Create Report

‫א‬‫א‬‫א‬‫א‬

‫א‬ Report Builder

‫א‬Report Builder‫א‬‫א‬‫א‬،Report Wizard‫א‬  WReport Wizard‫א‬ 

 Report Wizard‫א‬‫א‬ 

‫א‬

Create

 ‫א‬‫א‬Create‫א‬Module‫א‬‫א‬‫א‬ •

- ١٦٠ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ‫א‬

 ١٦٢

 





 ‫א‬‫א‬OkUse the Report Wizard‫א‬‫א‬  Report Style





- ١٦١ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ‫א‬

 ١٦٢

 

‫א‬‫א‬‫א‬،Report Style‫א‬‫א‬  W‫א‬‫א‬‫א‬ ‫א‬‫א‬‫א‬

 

‫א‬‫א‬‫א‬‫א‬

 

 K‫א‬

 ‫א‬

Tabular

Form Like

 ‫א‬‫א‬‫א‬  ‫א‬  KForm Builder‫א‬‫א‬

Mailing Label

‫א‬‫א‬‫א‬  ‫א‬ ‫א‬‫א‬‫א‬‫א‬

Form Letter

‫א‬ ‫א‬‫א‬‫א‬

‫א‬

  ‫א‬‫א‬  ‫א‬

Group Left

 KForm Builder‫א‬

  ‫א‬،‫א‬  

 ‫א‬

،‫א‬‫א‬‫א‬‫א‬،

 K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬

‫א‬‫א‬‫א‬‫א‬

‫א‬

  ‫א‬‫א‬  ‫א‬

Group Above

‫א‬،‫א‬‫א‬

 

  ‫א‬،‫א‬‫א‬‫א‬  ‫א‬   K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬



- ١٦٢ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ‫א‬

 ١٦٢

 

 Create Tabular Report ETabularF‫א‬Report Style‫א‬Tabular Report

 WQuery Type‫א‬،Next‫א‬

 Query Type





‫א‬‫א‬‫א‬،‫א‬‫א‬‫א‬‫א‬‫א‬ ،‫א‬Select‫א‬SQL statement‫א‬ ‫א‬‫א‬‫א‬Express query‫א‬‫א‬

 K‫א‬‫א‬ 

،‫א‬‫א‬‫א‬SQL statement‫א‬‫א‬  WData‫א‬Next‫א‬     - ١٦٣ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ‫א‬

 ١٦٢

 

  Data‫א‬





Query Statement‫א‬‫א‬ Query Builder‫א‬‫א‬‫א‬  W‫א‬‫א‬‫א‬

 - ١٦٤ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ‫א‬

 ١٦٢

 

‫א‬‫א‬،‫א‬‫א‬‫א‬‫א‬‫א‬ ‫א‬‫א‬‫א‬CloseInclude‫א‬

 W‫א‬‫א‬‫א‬

 OK‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬  K‫א‬‫א‬

Next‫א‬‫א‬Data‫א‬‫א‬  Fields‫א‬

 - ١٦٥ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ‫א‬

 ١٦٢

 

‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬ <>‫א‬‫א‬‫א‬‫א‬<<>>‫א‬ Next‫א‬‫א‬،‫א‬‫א‬‫א‬  Calculation Total‫א‬‫א‬

 ،‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬

 Label‫א‬Next‫א‬‫א‬



 - ١٦٦ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ‫א‬

 ١٦٢

 

‫א‬‫א‬Label‫א‬ Next‫א‬‫א‬،Width  WTemplate

 ‫א‬،‫א‬‫א‬‫א‬‫א‬‫א‬

Report Wizard‫א‬‫א‬Next‫א‬  W



 KReport Wizard‫א‬Finish‫א‬ - ١٦٧ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ‫א‬

 ١٦٢

 

 Form-Like Report ،،Form-Like Report

‫א‬Form-Like‫א‬‫א‬Report Style‫א‬‫א‬

 KTabular Report‫א‬‫א‬Next‫א‬   Report‫א‬  ‫א‬  SaveFile K١

K‫א‬‫א‬‫א‬‫א‬‫א‬ K٢

  ‫א‬ ‫א‬‫א‬،‫א‬‫א‬ ،‫א‬‫א‬‫א‬Report Wizard‫א‬‫א‬‫א‬  W‫א‬‫א‬‫א‬‫א‬

‫א‬‫א‬‫א‬‫א‬Report Wizard‫א‬‫א‬ J ١  KLayout

KReport Wizard‫א‬Tools J ٢

Object ‫א‬Module1‫א‬‫א‬‫א‬‫א‬ J ٣

KNavigator

        - ١٦٨ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ‫א‬

 ١٦٢

 

 Live Previewer‫א‬‫א‬ ،‫א‬ ‫א‬‫א‬Live Previewer

‫א‬،‫א‬ ‫א‬‫א‬‫א‬  ‫א‬ ‫א‬‫א‬‫א‬‫א‬‫א‬

 KLayout Model 

Live Previewer



١

 ‫א‬‫א‬‫א‬

٣

 ‫א‬‫א‬

٢

 ‫א‬‫א‬

٤

 ‫א‬ 

 WLive Previewer‫א‬‫א‬‫א‬  K‫א‬‫א‬ J

K‫א‬‫א‬ J K‫א‬‫ א‬J

K‫א‬ J

K‫א‬‫א‬‫א‬‫א‬ J

K‫א‬‫א‬‫א‬‫ א‬J

K‫א‬‫א‬‫א‬‫א‬‫א‬ J - ١٦٩ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ‫א‬

 ١٦٢

 

 ‫א‬‫א‬  W‫א‬‫א‬Live Previewer‫א‬‫א‬‫א‬  K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬ J ١

‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬ J ٢

‫א‬‫א‬‫א‬‫א‬‫א‬

 ‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬ 

 ‫א‬‫א‬‫א‬



 ‫א‬



‫א‬‫א‬‫א‬



 ‫א‬‫א‬  ‫א‬‫א‬‫א‬‫א‬‫א‬  ‫א‬ J K‫א‬‫א‬ J K‫א‬ J

K‫א‬‫א‬ J

 W‫א‬‫א‬

 K‫א‬‫א‬‫א‬‫א‬‫א‬ J ١

K‫א‬‫א‬‫א‬‫א‬‫א‬ J ٢ - ١٧٠ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ‫א‬

 ١٦٢

  

 ‫א‬‫א‬

‫א‬‫א‬‫א‬  ‫א‬



١

 ‫א‬

٤

‫א‬‫א‬‫א‬

٢

‫א‬‫א‬

٥

‫א‬‫א‬‫א‬

٣

‫א‬ 

 

 K‫א‬‫א‬  W‫א‬‫א‬‫א‬  K‫א‬‫א‬‫א‬ K١ K‫א‬‫א‬‫א‬‫א‬ K٢ ‫א‬‫א‬



- ١٧١ -



 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ‫א‬

 ١٦٢

 

‫א‬‫א‬  K‫א‬‫א‬ 

 Edit Text‫א‬  W‫א‬‫א‬‫א‬‫א‬‫א‬  K‫א‬‫א‬‫א‬‫א‬ J ١

K‫א‬‫א‬‫א‬‫א‬ J ٢ K‫א‬‫א‬‫א‬‫א‬‫א‬ J ٣

K‫א‬‫א‬‫ א‬J ٤



 K‫א‬‫א‬‫א‬‫א‬‫א‬  W‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬  K‫א‬‫א‬‫א‬‫א‬ J ١

K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫ א‬J ٢



Conditional Formatting‫א‬‫א‬



 - ١٧٢ -

 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ‫א‬

 ١٦٢

 

 ‫א‬‫א‬ ،‫א‬  W‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬  K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬ J ١ KConditional FormattingFormat J ٢ KNew‫ א‬J ٣ K‫א‬‫א‬ J ٤

K‫א‬‫א‬‫א‬‫א‬‫א‬ Format J ٥

KOK‫א‬ J ٦



 ‫א‬‫א‬‫א‬‫א‬،‫א‬ ‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬

،‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬  W‫א‬‫א‬‫א‬  K‫א‬‫א‬‫א‬‫א‬ J ١

K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬ J ٢ 

 ‫א‬‫א‬‫א‬‫א‬،‫א‬



 

  - ١٧٣ -



 ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ‫א‬

 ١٦٢

 

 

‫א‬Report Wizard‫א‬‫א‬S_emp K١ ‫א‬K‫א‬‫א‬‫א‬Tabular K‫א‬‫א‬‫א‬

KSalary‫א‬ K٢

K‫א‬Comm‫א‬Salary‫א‬‫א‬‫ א‬K٣ KSalary‫א‬‫א‬،Salary‫א‬ K٤

KComm‫א‬‫א‬‫א‬‫א‬  K٥ KBold‫א‬Comm‫ א‬K٦

KComm_Pct‫א‬‫א‬Comm‫א‬‫א‬ K٧ K‫א‬‫א‬‫א‬‫א‬ K٨  

- ١٧٤ -

 ‫א‬‫א‬‫א‬ ã¹]<gè…‚jÖ]æ<ËÖ]<Üé×Ãj×Ö<íÚ^ÃÖ]<퉉ö¹] ‫א‬‫א‬‫א‬‫א‬

‫א‬‫א‬

‫א‬‫א‬

‫א‬‫א‬

١٤

 ‫א‬‫א‬‫א‬ ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

W‫א‬‫א‬  K‫א‬‫א‬ W‫א‬‫א‬  W‫א‬‫א‬‫א‬ KMailing Label K١ KForm Letter K٢

KGroup Left‫א‬Group Above K٣ W‫א‬‫א‬‫א‬ K٪٨٠‫א‬‫א‬‫א‬ KW‫א‬‫א‬ 

 W‫א‬‫א‬ 

 K •  K •

 K •



W‫א‬‫א‬  K‫א‬‫א‬‫א‬‫א‬،‫א‬

- ١٧٥ -

 ‫א‬‫א‬‫א‬ ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

 ‫א‬‫א‬

Create Other types of Report ‫א‬Report Builder‫א‬ ‫א‬‫א‬  W‫א‬‫א‬،Report Wizard‫א‬  Create Mailing Label Report

‫א‬،‫א‬‫א‬‫א‬‫א‬  W‫א‬‫א‬‫א‬‫א‬‫א‬

Form ‫א‬Report Wizard‫א‬‫א‬‫א‬

‫א‬Next‫א‬Mailing Label‫א‬‫א‬Style  W‫א‬

 Query Type





‫א‬‫א‬‫א‬،‫א‬‫א‬‫א‬‫א‬‫א‬

،‫א‬Select‫א‬SQL statement‫א‬ ‫א‬‫א‬‫א‬Express query‫א‬‫א‬  K‫א‬‫א‬

- ١٧٦ -

 ‫א‬‫א‬‫א‬ ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

،‫א‬‫א‬‫א‬ SQL statement‫א‬‫א‬  WData‫א‬Next‫א‬  Data‫א‬

  Query Statement‫א‬‫א‬  KQuery Builder‫א‬‫א‬‫א‬  Next‫א‬‫א‬Data  ‫א‬‫א‬

‫א‬‫א‬‫א‬‫א‬،Fields‫א‬  W‫א‬‫א‬

 - ١٧٧ -

 ‫א‬‫א‬‫א‬ ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

 ‫א‬‫א‬‫א‬ ‫א‬‫א‬‫א‬ ‫א‬ ‫א‬‫א‬‫א‬،‫א‬‫א‬‫א‬>‫א‬‫א‬  W‫א‬

 K‫א‬‫א‬‫א‬‫א‬W

New LineJ ١

 K‫א‬‫א‬‫א‬EF‫א‬W

 DashJ ٣

 K‫א‬‫א‬‫א‬‫א‬W

CommaJ ٤

 K‫א‬‫א‬‫א‬‫א‬W

 K‫א‬‫א‬‫א‬‫א‬‫א‬W

 SpaceJ ٢

 PeriodJ ٥ 

 K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬  WTemplateNext‫א‬‫א‬ 



- ١٧٨ -

 ‫א‬‫א‬‫א‬ ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

‫א‬  ،‫א‬‫א‬‫א‬‫א‬‫א‬ ‫א‬ Report ‫א‬ ‫א‬Next‫א‬

 WWizard



  KReport Wizard‫א‬Finish‫א‬  KMailing Label Create Form-Letter Report

‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬

 W‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬،‫א‬‫א‬

Form ‫א‬Report Wizard‫א‬‫א‬‫א‬

‫א‬Next‫א‬Form-Letter‫א‬‫א‬Style  ‫א‬

- ١٧٩ -

 ‫א‬‫א‬‫א‬ ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

 Query Type

 ‫א‬‫א‬،‫א‬‫א‬‫א‬‫א‬‫א‬ ،‫א‬Select‫א‬SQL statement‫א‬

‫א‬‫א‬‫א‬Express query‫א‬‫א‬  K‫א‬‫א‬

،‫א‬‫א‬‫א‬ SQL statement‫א‬‫א‬  WData‫א‬Next‫א‬



- ١٨٠ -

 ‫א‬‫א‬‫א‬ ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

Query Statement‫א‬‫א‬  KQuery Builder‫א‬‫א‬‫א‬

Next‫א‬‫א‬Data‫א‬‫א‬ ‫א‬‫א‬‫א‬،Fields‫א‬

 W‫א‬‫א‬‫א‬‫א‬‫א‬ 

  ‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬ ‫א‬  W‫א‬‫א‬‫א‬‫א‬،‫א‬‫א‬‫א‬>‫א‬  K‫א‬‫א‬‫א‬‫א‬W

New LineJ ١

 K‫א‬‫א‬‫א‬‫א‬W

 SpaceJ ٢

 K‫א‬‫א‬‫א‬EF‫א‬W

 DashJ ٣

 K‫א‬‫א‬‫א‬‫א‬‫א‬W

 PeriodJ ٥

 K‫א‬‫א‬‫א‬‫א‬W

- ١٨١ -

CommaJ ٤

 ‫א‬‫א‬‫א‬ ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

 WTemplateNext‫א‬‫א‬





‫א‬  ،‫א‬‫א‬‫א‬‫א‬‫א‬ ‫א‬

Report ‫א‬ ‫א‬Next‫א‬

 WWizard



 KReport Wizard‫א‬Finish‫א‬  KForm Letter‫א‬ - ١٨٢ -

 ‫א‬‫א‬‫א‬ ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

Group Report

 ،  ‫א‬‫א‬‫א‬‫א‬

    ‫א‬  ‫א‬،‫א‬  ‫א‬  ‫א‬‫א‬  ‫א‬ ‫א‬‫א‬

‫א‬  ‫א‬  ‫א‬‫א‬‫א‬‫א‬  ‫א‬،‫א‬

 K،Group Above‫א‬

،‫א‬ ‫א‬‫א‬‫א‬

،‫א‬‫א‬  ‫א‬‫א‬‫א‬  Emp ‫א‬ ،‫א‬‫א‬ ‫א‬  ‫א‬‫א‬‫א‬  K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬

 W‫א‬‫א‬‫א‬‫א‬‫א‬

Form ‫א‬Report Wizard‫א‬‫א‬‫א‬

 Group Above‫א‬Group Left‫א‬‫א‬Style

‫א‬Query Type‫א‬‫א‬Next‫א‬

 SQL statement

،‫א‬‫א‬ ‫א‬ Next‫א‬ Query Statement‫א‬‫א‬

Query Builder‫א‬‫א‬‫א‬  K‫א‬

‫א‬‫א‬‫א‬Next‫א‬‫א‬

‫א‬ Next‫א‬‫א‬Data‫א‬

‫א‬‫א‬‫א‬  ‫א‬‫א‬،Group Fields  W‫א‬‫א‬ 

- ١٨٣ -

 ‫א‬‫א‬‫א‬ ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 





‫א‬‫א‬‫א‬‫א‬‫א‬  ‫א‬‫א‬ ‫א‬‫א‬‫א‬‫א‬‫א‬ ‫א‬‫א‬ Next  W‫א‬‫א‬ 



 - ١٨٤ -

 ‫א‬‫א‬‫א‬ ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬ Calculation ‫א‬‫א‬‫א‬‫א‬‫א‬Next

 Total

  ، ‫א‬‫א‬‫א‬  ‫א‬‫א‬ ‫א‬‫א‬‫א‬‫א‬ ‫א‬

 Next‫א‬‫א‬،  ‫א‬‫א‬‫א‬  Label‫א‬



 - ١٨٥ -

 ‫א‬‫א‬‫א‬ ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

‫א‬‫א‬Label‫א‬ Next‫א‬‫א‬،Width  WTemplate





‫א‬،‫א‬‫א‬‫א‬‫א‬‫א‬ Report Wizard‫א‬‫א‬Next‫א‬  W

 - ١٨٦ -

 ‫א‬‫א‬‫א‬ ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

 KReport Wizard‫א‬Finish‫א‬    ‫א‬ ‫א‬ ‫א‬‫א‬‫א‬‫א‬

 K‫א‬‫א‬

 ‫א‬  ‫א‬‫א‬

Detail  ‫א‬‫א‬Master  W‫א‬‫א‬‫א‬

 K‫א‬‫א‬ J ١ ‫א‬ QueriesData ModelObject Navigator‫א‬ J ٢ K‫א‬Q1‫א‬

‫א‬‫א‬Layout‫א‬F2 J ٣ W‫א‬

 ‫א‬‫א‬‫א‬‫א‬J ٤ ،‫א‬‫א‬‫א‬‫א‬، Detail‫א‬‫א‬ Data ToolsData Wizard‫א‬

 ‫א‬‫א‬Wizard

- ١٨٧ -

 ‫א‬‫א‬‫א‬ ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 





 Next‫א‬،‫א‬‫א‬ ‫א‬ SQL ‫א‬ ‫א‬ ‫א‬،‫א‬‫א‬   ‫א‬ ‫א‬‫א‬

 K‫א‬Select‫א‬‫א‬statement 

،‫א‬‫א‬‫ א‬ Next‫א‬ Query Statement‫א‬‫א‬ Query Builder‫א‬‫א‬‫א‬  K‫א‬

 

‫א‬  ‫א‬‫א‬‫א‬‫א‬ Next‫א‬‫א‬

 K‫א‬‫א‬‫א‬

- ١٨٨ -

 ‫א‬‫א‬‫א‬ ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 





‫א‬‫א‬ Next‫א‬‫א‬ ‫א‬‫א‬ ‫א‬،Calculation Total‫א‬‫א‬‫א‬  K‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬

 K‫א‬‫א‬‫א‬Next‫א‬‫א‬ 

، ‫א‬Layout‫א‬ ‫א‬‫א‬ J ٤ ‫א‬،‫א‬  ‫א‬‫א‬ ‫א‬‫א‬‫א‬

  ،‫א‬‫א‬‫א‬‫א‬‫א‬

 W‫א‬‫א‬‫א‬‫א‬،‫א‬‫א‬‫א‬‫א‬ KData Link‫א‬ K١

،‫א‬‫א‬  ‫א‬ ‫א‬    K٢ W‫א‬‫א‬،‫א‬‫א‬‫א‬‫א‬



- ١٨٩ -

 ‫א‬‫א‬‫א‬ ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

Data Link ‫א‬

‫ ﺁﻟﻲ‬Q1 ‫א‬ 



،Q2‫א‬‫א‬Q1‫א‬ ‫א‬   ،‫א‬   Q1‫א‬ ‫א‬‫א‬Deptno ‫א‬Q2‫א‬‫א‬Deptno1‫א‬

Deptno1‫א‬Q1‫א‬ ‫א‬Deptno‫א‬،‫א‬

 KQ2‫א‬‫א‬ 

‫א‬،‫א‬‫א‬ ‫א‬ J ٥  W‫א‬‫א‬Q2‫א‬‫א‬

Report ‫א‬Layout‫א‬‫א‬‫ א‬K١

‫א‬‫א‬ Report WizardTools،Wizard Next‫א‬Group Left‫א‬Group Above‫א‬

‫א‬‫א‬  ‫א‬ ‫א‬‫א‬ W‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬



- ١٩٠ -

 ‫א‬‫א‬‫א‬ ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 





Empno‫א‬‫א‬‫א‬Deptno‫א‬

 KPrimary Key‫א‬‫א‬‫א‬،‫א‬‫א‬

‫א‬‫ א‬ Next‫א‬‫ א‬K٢ Q1‫א‬ ،‫א‬‫א‬‫א‬

W‫א‬KQ2‫א‬‫א‬،





- ١٩١ -

 ‫א‬‫א‬‫א‬ ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

 Next‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬ K٣ ‫א‬Label Page‫א‬   ‫א‬‫א‬ ‫א‬Label،‫א‬

‫א‬‫א‬‫א‬ Template Page‫א‬‫א‬ KFinish‫א‬،‫א‬

‫א‬‫א‬ K٤







    ‫א‬E  F ‫א‬

 K‫א‬‫א‬

- ١٩٢ -

 ‫א‬‫א‬‫א‬ ‫א‬‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

 

‫א‬‫א‬EmpGroup Above‫א‬ J ١ Emp‫א‬‫א‬‫א‬Mgr‫א‬

KEmployee‫א‬‫ א‬J ٢



‫א‬‫א‬‫א‬DeptGroup Above‫א‬ J ٣ K‫א‬‫א‬‫א‬‫א‬Emp،‫א‬

KEmp_Dept‫א‬‫ א‬J ٤



S_CustomerMailing Label‫א‬ J ٥ Credit_Rating،phone،Country،City،Address،Name،Id‫א‬‫א‬ KSend me message‫א‬

‫א‬S_CustomerForm Letter‫א‬ J ٦



W‫א‬

Mr. (Name) It is nice to see you We are send you the package on your address which is (Address) in the city (city) in your country (Country) , and we are call you in your phone which is (phone) Thank you،



- ١٩٣ -



 ‫א‬

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

 ‫א‬ ‫א‬   ١ 

 ‫א‬  W‫א‬‫א‬  Form Builder 

 ١٤

 W‫א‬‫א‬  Module 

 ٣٥

 W‫א‬‫א‬  Frame‫א‬Data Block‫א‬‫ א‬

 ٤٧

 W‫א‬‫א‬‫א‬  Text Item‫א‬‫ א‬



 

 ٦٥

 W‫א‬‫א‬  LOVs 

 ٨٠

 W‫א‬‫א‬   



  ٩٦

 W‫א‬‫א‬  Noninput 

١١٣

 W‫א‬‫א‬  Canvas & Windows 

١٢٢

 W‫א‬‫א‬  Canvas‫א‬‫ א‬

١٣٣

 W‫א‬‫א‬  Triggers‫א‬ 

١٣٨

 W‫א‬‫א‬  Trigger‫א‬ 

١٤٩

 W‫א‬‫א‬  ‫א‬ 



   

 ‫א‬

  

 J ‫א‬‫א‬

 ‫א‬

 ١٦٢

 

١٥٩

 W‫א‬‫א‬  ‫א‬ 

١٧٥

 W‫א‬‫א‬‫א‬  ‫א‬‫א‬  



     

    ‫א‬‫א‬‫א‬‫א‬‫א‬‫א‬  ‫א‬E‫א‬F‫א‬‫א‬ GOTEVOT appreciates the financial support provided by BAE SYSTEMS