Since WinDev Magazine focuses on practical, code-heavy, solution-oriented articles for developers, I have drafted a .
// Inside the "Save" button of an Order window HAdd(Outbox_Table, "TYPE", "ORDER_CREATED") HAdd(Outbox_Table, "PAYLOAD", JSONBuild(Order_Record)) HAdd(Outbox_Table, "STATUS", "PENDING") // Commit the local transaction immediately HTransactionEnd(Global_DB, hCommit) windev magazine
[Your Name] Audience Level: Intermediate to Advanced Time to read: 10 minutes 1. The Problem: The Two-Speed IT Department Many of our readers manage warehouses, logistics, or medical systems where the core business runs on a WinDev Desktop application linked to an HFSQL Server (on-premise). However, management now wants a mobile or web portal (built in WebDev) hosted in the cloud. However, management now wants a mobile or web
This architecture respects the network boundaries: the cloud never touches your firewall, and the premise never blocks the user for network errors. Since WinDev Magazine focuses on practical
How to use HFSQL replication and WebDev services to keep your legacy desktop app in sync with a modern mobile portal.
HAdd(Cloud_Order)
// In the WebDev project initialization (Server code) HDescribeReplication("CloudDB", "CUSTOMER", "Replication_ON_PREMISE") HReplicationCreate("CloudDB", "CUSTOMER", "Product_Table", "127.0.0.1", "MasterDB") HFSQL replication uses delta packets. It is 1,000x faster than CSV exports. Only new/modified records travel over the wire. 4. Step 2: The Real-Time Transaction Queue (The "Transactional" Lane) For high-write data (Orders, Inventory Movements), replication can cause conflicts. Use an Outbox pattern .