ARdbManager 1.0Firebird010050800600Dialog100016777215org.firebirdsql.jdbc.FBDriverjdbc:firebirdsql:localhost/3050:opt/interbase/examples/employee.gdbsysdbamasterkey110Tables10485761010600400Dialog120016777215nullSales104857601010600400Dialog100016777215SALESSELECT * FROM SALESRelations104857601010600400Dialog100016777215RDB$VIEW_RELATIONSSELECT * FROM Project104857601010600400Dialog100016777215PROJECTSELECT * FROM PROJECTEmployees104857601010600400Dialog100016777215EMPLOYEESELECT * FROM EMPLOYEECustomer104857601010600400Dialog100016777215CUSTOMERSELECT * FROM CUSTOMERQueries20971521010600400Dialog120016777215nullSalesGraph115343361010600400Dialog120016777215SELECT 
MONTH(ORDER_DATE),
TOTAL_VALUE

FROM SALES 
ORDER BY MONTH(ORDER_DATE)SalesReport115343361010600400Dialog100016777215SELECT 
C.CUSTOMER,
S.ORDER_STATUS,
S.ORDER_DATE,
S.SHIP_DATE,
S.TOTAL_VALUE
FROM SALES S, CUSTOMER C WHERE (C.CUST_NO = S.CUST_NO)
ORDER BY C.CUST_NO
PO_NUMBEREmployees115343361010600400Dialog100016777215SELECT 

FULL_NAME,
EMP_NO

FROM EMPLOYEE
Sales115343361010600400Dialog100016777215SELECT * FROM SALES
WHERE CUST_NO = $MASTER
ORDER BY CUST_NO
PO_NUMBERCustomers115343361010600400Dialog100016777215SELECT * FROM CUSTOMERCUST_NOProjects115343361010600400Dialog100016777215SELECT * FROM PROJECTPROJ_IDForms31457281010600400Dialog120016777215nullMain Menu125829121010300250Dialog1200134348281Project Cards7340032106018032Dialog140113421772ShowProjCardsProject Cards02010107016Helv12001016777215Customer Sales7340032101018032Dialog140113421772ShowCustSalesCustomer Sales02010107016Helv12001016777215Sales Table125829121010600400Dialog100016777215Sales0AGED734003216038016026Dialog100016777215AGEDAGED0001038016026Helv12001016777215SalesITEM_TYPE734003216035016026Dialog100016777215ITEM_TYPEITEM_TYPE0001035016026Helv12001016777215SalesDISCOUNT734003216032016026Dialog100016777215DISCOUNTDISCOUNT0001032016026Helv12001016777215SalesTOTAL_VALUE734003216029016026Dialog100016777215TOTAL_VALUETOTAL_VALUE0001029016026Helv12001016777215SalesQTY_ORDERED734003216026016026Dialog1010027008016777215QTY_ORDEREDQTY_ORDERED5001026016026Helv12001016777215SalesPAID734003216023016026Dialog100016777215PAIDPAID1001023016026Helv12001016777215SalesDATE_NEEDED734003216020016026Dialog100016777215DATE_NEEDEDDATE_NEEDED8001020016026Helv12001016777215SalesSHIP_DATE73400321601708026Dialog100016777215SHIP_DATESHIP_DATE8001017016026Helv12001016777215SalesORDER_DATE73400321601408026Dialog100016777215ORDER_DATEORDER_DATE8001014016026Helv12001016777215SalesORDER_STATUS73400324011016026Dialog100016777215ORDER_STATUSORDER_STATUS2001011016026Helv12001016777215SalesSALES_REP73400321608016026Dialog100016777215SALES_REPSALES_REP500108016026Helv12001016777215SalesCUST_NO7340032160506026Dialog100013434828CUST_NOCUST_NO500105016026Helv12001016777215SalesPO_NUMBER7340032160206026Dialog100013421772PO_NUMBERPO_NUMBER100102016026Helv12001016777215SalesCustomer Sales125829121010600400Dialog100016777215CustomersCUST_NO1SalesTable734003235010400200Dialog100016777164Sales TableLabel:05010107016Helv12001016777215ON_HOLD734003216035016026Dialog100016777215ON_HOLDON_HOLD0001035016026Helv12001016777215CustomersPOSTAL_CODE734003216032016026Dialog100016777215POSTAL_CODEPOSTAL_CODE0001032016026Helv12001016777215CustomersCOUNTRY734003216029016026Dialog100016777215COUNTRYCOUNTRY0001029016026Helv12001016777215CustomersSTATE_PROVINCE734003216026016026Dialog100016777215STATE_PROVINCESTATE_PROVINCE2001026016026Helv12001016777215CustomersCITY734003216023016026Dialog100016777215CITYCITY2001023016026Helv12001016777215CustomersADDRESS_LINE2734003216020016026Dialog100016777215ADDRESS_LINE2ADDRESS_LINE22001020016026Helv12001016777215CustomersADDRESS_LINE1734003216017016026Dialog100016777215ADDRESS_LINE1ADDRESS_LINE12001017016026Helv12001016777215CustomersPHONE_NO734003216014016026Dialog100016777215PHONE_NOPHONE_NO2001014016026Helv12001016777215CustomersCONTACT_LAST734003216011016026Dialog100016777215CONTACT_LASTCONTACT_LAST2001011016026Helv12001016777215CustomersCONTACT_FIRST73400321608016026Dialog100016777215CONTACT_FIRSTCONTACT_FIRST200108016026Helv12001016777215CustomersCUSTOMER73400321605016026Dialog100016777215CUSTOMERCUSTOMER200105016026Helv12001016777215CustomersCUST_NO73400321602016026Dialog100016777215CUST_NOCUST_NO500102016026Helv12001016777215CustomersProject Cards125829121010600400Dialog100016777215Projects1PRODUCT73400321608016026Dialog100016777215PRODUCTPRODUCT200108016026Helv12001016777215ProjectsTEAM_LEADER734003216011016026Dialog100016777215TEAM_LEADERTEAM_LEADER5101011016026Helv12001016777215ProjectsEmployeesEMP_NOPROJ_DESC7340032160140300150Dialog10153016777164PROJ_DESCPROJ_DESC10301014016026Helv12001016777215ProjectsPROJ_NAME73400321605016026Dialog100016777215PROJ_NAMEPROJ_NAME200105016026Helv12001016777215ProjectsPROJ_ID73400321602016026Dialog100016777215PROJ_IDPROJ_ID100102016026Helv12001016777215ProjectsReports41943041010600400Dialog120016777215nullCustomer Sales Report136314881010600400Dialog120016777215SalesReport<B>This is an example report from the database employee.fdb</B><I>Here the report ends</I>TOTAL_VALUE73400321601408026Dialog120116777215TOTAL_VALUETOTAL_VALUE0021014016026Helv12001016777215SalesReportSHIP_DATE734003216011016026Dialog120016777215SHIP_DATESHIP_DATE0001011016026Helv12001016777215SalesReportORDER_DATE73400321608016026Dialog120016777215ORDER_DATEORDER_DATE000108016026Helv12001016777215SalesReportORDER_STATUS73400321605016026Dialog120016777215ORDER_STATUSORDER_STATUS200105016026Helv12001016777215SalesReportCUSTOMER73400321602016026Dialog120016777215CUSTOMERCUSTOMER200102016026Helv12001016777215SalesReportGraphics52428801010600400Dialog120016777215nullMacros62914561010600400Dialog120016777215nullAUTOSTART1572864010108026Dialog120016777215HideConnection();
OpenForm("Main Menu");ShowProjCards1572864010108026Dialog120016777215OpenForm("Project Cards");ShowCustSales1572864010108026Dialog120016777215OpenForm("Customer Sales");