Pocket PowerBuilder SalesDB Pocket PowerBuilder PDA Pocket PowerBuilder Mobile Solution Pocket PowerBuilder Pocket PowerBuilder C:\Program Files\Sybase\Pocket PowerBuilder 1.0 %PPB% ASA 8.0.2 ASA 9 ASA 6 7 8.0.1 PDA PDA PDA Pocket PowerBuilder Virtual Machine (VM) PDA PDA Adaptive Server Anywhere (ASA) database and MobiLink Client Pocket PowerBuilder Installation Guide SalesDB PDA Pocket PowerBuilder MobiLink Pocket PowerBuilder MobiLink PDA PDA Adaptive Server Anywhere (ASA) 8 Adaptive Server Anywhere 9 Oracle Sybase ASE Microsoft SQL Server DB2 PDA ASA Pocket PC (PPC) PDA 1
1. Adaptive Server Anywhere remote database consolidated database Database remote database PDA consolidated database ( Oracle ASE DB2 ) consolidated database remote database consolidated database consolidated database PDA remote database 2. Pocket PowerBuilder IDE SaleDB.SaleDB PDA 3. SaleDB Pocket PowerBuilder IDE. 4. SaleDB Pocket PC PDA 60 SaleDB PDA Part 1: ASA databases SalesDB PDA remote database remote database consolidated database consolidated database MobiLink PDA 1. %PPB%\Code Examples\SalesDB\db ( C:\Program Files\Sybase\Pocket PowerBuilder 1.0\Code Examples\SalesDB\db) MakeDB.cmd MakeDB8.cmd ASA9 MakeDB.cmd ASA8.0.2 MakeDB8.cmd saledb.db consolidated database saledb_remote.db database ODBC DSN 2
ASA8.0.2 ASA9 MakeDB.cmd ASA DB ASA8.0.2 ASA9 ASA8.0.2 DB MakeDB8.cmd 2. DOS DOS DOS DB Sybase Central 1. Sybase SQL Anywhere 8 Sybase Central. : Adaptive Server Anywhere 9, SQL Anywhere Studio SQL Anywhere 9 2. Tools -> Connect. 3. Adaptive Server Anywhere 8/9. 4. ODBC Data Source name Browse SalesDB. 3
5. Advanced JDBC-ODBC bridge (ASA 8) or ianywhere JDBC driver (ASA 9) radio button 6. OK 7. SalesDB tables Table 4
8. Sybase Central SalesDB_remote remote database salesdb_remote.db PDA consolidated database MobiLink 1. Sybase Central Tools -> Connect. 2. MobiLink Synchronization. 3. ODBC Data Source name SalesDB. 5
4. Advanced JDBC-ODBC bridge (ASA 8) ianywhere JDBC driver ( ASA 9) radio button 5. OK 6. Synchronized Tables Customer. 7. download_cursor event SELECT cust_id, cust_name FROM Customer WHERE last_modified >? 6
consolidated database PDA remote database 8. (upload) upload_insert upload_update upload_delete upload_insert INSERT INTO Customer( cust_id, cust_name ) VALUES(?,? ) 7
PDA remote database consolidated database 9. upload_update upload_delete Event SQL MobiLink MobiLink 10. Sybase Central Part 2: SalesDB database profile Pocket PowerBuilder IDE Pocket PowerBuilder PDA PDA remote database Pocket PowerBuilder remote database profile Database Profile 1. Sybase Pocket PowerBuilder 1.0 Pocket PowerBuilder Pocket PowerBuilder 2. Pocket PowerBuilder Tools Database Profile. 3. ODB ODBC New 4. Profile Name SalesDB_remote 5. Data Source SalesDB_remote 8
6. User ID Password PDA DSN 7. ODB ODBC SalesDB_remote ASA SalesDB workspace SalesDB pkl salesdb_tutorial.pkl workspace target SalesDB workspace: 1. File New. 2. Workspace Workspace OK 9
3. workspace SalesDB_tutorial %PPB%\Code Examples\SalesDB\tutorial 4. File New. 5. Target Existing Application OK 10
6. salesdb_tutorial.pkl PKL 7. salesdb_tutorial application Next 8. Next Target SalesDB f_conn function 11
( PDA remote database) globle function f_conn function 1. File New. 2. PB Object Function OK 3. Return Type: (None) Function Name: f_conn sqlca.dbms='odb' sqlca.dbparm="connectstring='dsn=salesdb_remote'" // establish DB connection connect using sqlca; PDA ASA ASA ASA 12
4. File Save function f_conn f_conn function salesdb salesdb application ue_postopen event event f_conn salesdb application close evnet f_disconn function DataWindow d_orders DataWindow object 1. Pocket PowerBuilder File -> New. 2. DataWindow Freeform. 13
3. SQL Select Next 4. Select Tables customer orders product 5. Open 6. Table Layout order order_id customer cust_name product prod_name orders quant product price orders disc status notes DataWindow DataWindow Syntax Pocket PowerBuilder SQL order_id 1. Sort 2. orders. order.id 3. Ascending 14
Syntax Pocket PowerBuilder SQL Pocket PowerBuilder SQL SQL DataWindow Object 1. Return to DataWindow Painter File Return to DataWindow Painter Save DataWindow DataWindow Object Save SQL Query 15
2. Next Color and Border Settings 3. Finish DataWindow Object 4. DataWindow Object File Save DataWindow 5. d_orders OK 6. order_id Order Id: orders_order_id Delete 7. Cust Name: label Text Customer 8. label Prod Name Product Quant Quantity Disc Discount 9. Ctrl 16
10. Save menu Menu Item 1. Pocket PowerBuilder System Tree m_salesdb 17
2. tree menu Order Insert Menu Item 3. File menu item 4. File Insert Submenu Item 5. Synchronize menu item 6. 4-5 submenu items Sync Options Exit menu item 7. menu Name m_file m_synchronize m_syncoptions m_exit 8. 18
9. Exit Clicked Event // Terminate application f_disconn() Halt Close 10. Save MobiLink remote database consolidated database MobiLink MobiLink Synchronization Wizard 1. Pocket PowerBuilder File New 19
2. Database MobiLink Synchronization for ASA OK 3. Next 4. Next salesdb_tutorial.pkl MobiLink pkl 5. SalesDB_remote Test Connection successful Next 6. Browse SalesDB_remote.DSN ( %PPB%\Code Examples\SalesDB ) 20
7. Next 8. ASA remote database publication salesapi publication Next 9. Next MobiLink 10. MobiLink Next 21
11. PDA \ end-user Prompt user for password and runtime changes Next 12. Show all except vc and vp (-v+) MobiLink Next 22
13. Finish MobiLink Synchronization Wizard nvo_salesdb_tutorial_sync gf_salesdb_tutorial_sync s_salesdb_tutorial_sync_parms gf_salesdb_tutorial_configure_sync nvo_salesdb_tutorial_sync MobiLink gf_salesdb_tutorial_sync global function s_salesdb_tutorial_sync_parms structure MobiLink gf_salesdb_tutorial_configure_sync global function Windows/Windows CE (registry) Adaptive Server Anywhere 9 nvo_salesdb_tutorial_sync ASA_REGPATH constant string ASA_REGPATH = "HKEY_CURRENT_USER\Software\Sybase\Adaptive Server Anywhere\8.0" ASA 9 constant string ASA_REGPATH = "HKEY_CURRENT_USER\Software\Sybase\Adaptive Server Anywhere\9.0" MobiLink Synchronization Wizard windows w_salesdb_tutorial_sync w_salesdb_tutorial_sync_options 23
W_salesdb_tutorial_sync Windows end-user PDA 1. Pocket PowerBuilder m_salesdb 2. File Sync Options 3. Clieked Event // Open the Sync Options window gf_salesdb_tutorial_configure_sync() // Fetch data f_refresh_orders(-1) Sync Options gf_salesdb_tutorial_sync function Synchronize 4. Pocket PowerBuilder m_salesdb 5. File Sync Options 6. Clieked Event // Start synchronization if gf_salesdb_tutorial_sync(string(::g_emp_id), "") <> 0 then MessageBox("Error", " MobiLink Synchronization Error. "); End if // Fetch data f_refresh_orders(-1) 7. Save 24
window saledb w_orders window 1. Pocket PowerBuilder File New 2. PB Object Window OK 3. window Title SalesDB tutorial MenuName m_salesdb DefaultSize 4. File Save Window 5. Windows w_orders 6. Insert Control DataWindow DataWindow Control Window 7. DataWindow Name dw_orders DataObject d_orders HscrollBar VscrollBar 8. Insert Control CommandButton DataWindow 9. cb_prev < Previous 10. 25
cb_next Next > cb_approve Approve cb_deny Deny Event 1. cb_prev 2. clicked event f_scroll(-1) DataWindow 3. cb_next: f_scroll(1) cb_approve: f_approve_deny(approve) cb_deny: f_approve_deny(deny) 4. Save w_orders window 1. Pocket PowerBuilder salesdb_tutorial application 2. script view open event 3. open event 4. ue_postopen event 5. ue_postopen event 6. application 7. m_salesdb menu 26
8. Order -> Delete submenu item 9. clicked event 10. Menu 11. f_scroll function 12. f_scroll function 13. f_scroll function 14. 11-13 f_scroll_last f_approve_deny f_refresh_orders f_set_dir_btn_enabled PDA Part 3: SalesDB Pocket PowerBuilder MobiLink Server MobiLink Server StartML.cmd StartML8.cmd ASA9 StartML.cmd ASA 8.0.2 StartML8.cmd %PPB%\Code Examples\SalesDB\db StartML.cmd StartML8.cmd MobiLink Server SalesDB consolidated database MobiLink Server MobiLink Server Pocket PowerBuilder 1. Pocket PowerBuilder 2. Run Run. 3. SalesDB SalesDB_remote remote database 4. Sync Options MobiLink user password MLUser 50 5. 27
6. Part 4: SalesDB project Pocket PowerBuilder PDA Pocket PowerBuilder Project 1. Pocket PowerBuilder File New. 2. Project Application OK 3. Executable File Name SalesDB_tutorial.exe 4. WinCE PDA PDA PDA Deployment Target Device (ARM) Project PDA PDA PDA PPC 2000 Emulator PPC 2002 Emulator Project \Program Files PDA 28
5. File Save Project 6. Project p_salesdb_tutorial 7. Project Project Pocket PowerBuilder Porject Run Deploy Workspace PDA \program Files SalesDB_tutorial.exe remote database PDA DNS ASA remote database Remote database ASA PDA remote database SalesDB_remote PDA.db.log subscription remote database subscription.db PDA.db.log PDA PDA DSN %PPB%\ Code 29
Examples\SalesDB SalesDB_remote.DSN PDA ASA Adaptive Server Anywhere 9 SalesDB_remote.DSN start=\program Files\Sybase\ASA\dbsrv8.exe dbsrv8.exe dbsrv9 driver=dbodbc9.dll [ODBC] uid=dba pwd=sql enginename=salesdb_remote databasename=salesdb_remote databasefile=\program Files\Sybase\ASA\SalesDB_remote.db start=\program Files\Sybase\ASA\dbsrv9.exe driver=dbodbc9.dll PDA 1. Pocket PowerBuilder SalesDB_remote.DSN %PPB%\Code Examples\SalesDB database file start ASA PDA ASA 2. PDA ActiveSync 3. 4. My Pocket PC 5. SalesDB_remote.DSN My Pocket PC 6. PDA \Program Files Sybase ASA 7. SalesDB_remote.db SalesDB_remote.log PDA %PPB%\Code Examples\SalesDB \db\fresh PDA PDA \Program Files\Sybase\ASA PPC 2002 30
1. Pocket PowerBuilder SalesDB_remote.DSN %PPB%\Code Examples\SalesDB database file start ASA 2. CEFileVw.exe c:\program Files\Windows CE Tools\Common\Platman\bin\cefilevw.exe 3. SalesDB_remote.DSN \ 4. SalesDB_remote ASA 5. SalesDB_remote.db SalesDB_remote.log \Program Files\Sybase\ASA %PPB%\Code Examples\SalesDB \db\fresh PPC 2000 1. Pocket PowerBuilder SalesDB_remote.DSN %PPB%\Code Examples\SalesDB database file start PPC 2002 \Program Files\ASA\ 2. SalesDB_remote.DSN C:\Program Files\Windows CE Tools\wce300\MS Pocket PC\emulation\palm300 3. SalesDB_remote.db SalesDB_remote.log C:\Program Files\Windows CE Tools\wce300\MS Pocket PC\emulation\palm300\Program Files\ASA %PPB%\Code Examples\SalesDB \db\fresh Pocket PC 2000 SalesDB_remote.DSN Pocket PC 2000 SalesDB_remote.DSN \sybase SalesDB_remote.DSN [ODBC] uid=dba pwd=sql enginename=salesdb_remote databasename=salesdb_remote databasefile=\program Files\ASA\SalesDB_remote.db start=\program Files\ASA\dbsrv8.exe 31
MobiLink synchronization server PDA MobiLink synchronization server MobiLink Server StartML.cmd StartML8.cmd ASA9 StartML.cmd ASA 8.0.2 StartML8.cmd %PPB%\Code Examples\SalesDB\db StartML.cmd StartML8.cmd MobiLink Server SalesDB consolidated database MobiLink Server PDA SalesDB 1. Pocket PC PDA PDA Menu /Program Files 2. SalesDB_tutorial.exe SalesDB 3. SalesDB Sync Options window MobiLink user password MLUser 51 MLPassword 4. PDA remote database MobiLink server File Sync Options MobiLink host port number MobiLink server IP 5. PDA PDA PDA 32
SalesDB Pocket PowerBuilder Adaptive Server Anywhere MobiLink Pocket PowerBuilder SQL Anywhere Studio Part 5: Troubleshooting Question: PDA SalesDB Connect to Adaptive Server remote database Answer: DSN SalesDB_remote.DSN PDA databasefile start Question: PDA MobiLink Error: Protocol version mismatch 33
Answer: PDA ASA engine MobiLink server 8.0.2 build 4229 Pocket PowerBuilder ASA 8.0.2 build 4251 Question: PDA MobiLink Communication error occurred while receiving data from the MobiLink server Answer: MobiLink server MobiLink server log Question: PDA MobiLink Connecting to MobiLink server at using dbsock8.dll Answer: SalesDB File Sync Options ML Server MobiLink Server host IP port number Question: PDA ASA MobiLink Synchronization Error in command near "-pd" Answer: PDA ASA engine MobiLink server 8.0.2 build 4229 Pocket PowerBuilder ASA 8.0.2 build 4251 34