Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved Re: Triggering a Powerbuilder event function when there is an insert of data in a table

  1. How-to
0
Votes
Undo
  1. Sivaprakash BKR
    Sivaprakash BKR
  2. PowerBuilder
  3. Friday, 29 October 2021 13:06 PM UTC

Hello,

Powerbuilder 2019 R3, Postgresql 11

I want to trigger a function in Powerbuilder (to print, actually) whenever there is an insert of data in a particular table with a particular value in a field.  Is it possible ?

In Detail:

Billing data will be added from a mobile application and on save I want to print it to a thermal printer.  Bluetooth printers are not working at this point, as we have lot of disturbances in between.  WiFi thermal printers are not available here (is there any ?).  Searching alternative ways to print it.   

One option I thought is to trigger a Powerbuilder function which will print that particular record(s) in a predefined format and printer.   But no sure whether it's possible.

Would like to hear whether it's possible or not ?   Else any other solution to print from an Android Tab is available to a distantly placed thermal printer? 

Happiness Always
BKR Sivaprakash

 

  1. PostgreSQL
  2. PowerBuilder (Appeon)
  3. Print
PB Desktop app will not execute, PBVM190.dll Excep...
Powerclient with parameters
Responses (1)
Brad Mettee
Brad Mettee Accepted Answer Pending Moderation
  1. Friday, 29 October 2021 14:05 PM UTC
  2. PowerBuilder
  3. # 1

I don't know of any way to have the database trigger an event in the PB app, but you can do it with a two step process.

Step 1 - add a trigger to the database that inserts a record into a "print me" table with the data that will be printed (or record numbers from a table(s) that contain the data)

Step 2 - on a timer from the main window, check for records in the "print me" table, take appropriate steps to print when necessary

 

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.