When a user validates an order, do not call the API directly (network failures would block the user). Write to a local Outbox table first.
// 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
How to use HFSQL replication and WebDev services to keep your legacy desktop app in sync with a modern mobile portal. When a user validates an order, do not
Since WinDev Magazine focuses on practical, code-heavy, solution-oriented articles for developers, I have drafted a . However, management now wants a mobile or web
[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.
// Write to Cloud HFSQL Cloud_Order.ID = OrderInfo.ID Cloud_Order.Date = OrderInfo.Date Cloud_Order.Status = "SYNCED_FROM_DESKTOP"