Xojo Documentation Xojo Documentation

Method

PostgreSQLDatabase.Notify(name As String)

Supported for all project types and targets.

Sends a notification named "Name".

Notes

Clients that have used the Listen method for the name will be get the notification. To receive notifications, call the CheckForNotifications method. Notifications are received in the PostgreSQLDatabase.ReceivedNotification event handler.

The Notify method does not have a way to send a payload. As a workaround you can call the command directly instead:

db.ExecuteSQL("NOTIFY ""UpdateCustomers"", '5, 10, 15'")

Sample Code

Send the "RefreshAll" notification:

// db is a previously connected PostgreSQLDatabase
db.Notify("RefreshAll")