1. John Vanleeuwe
  2. PowerBuilder
  3. Wednesday, 3 January 2018 13:52 PM UTC

Hi all,

We are using PB2017 with SQL Anywhere database.

At the moment our pb application allows the user to 'demand' a status of a certain record. A txt file is being send to our software with the identification of the record and an action trigger being : retrieve status.

This txt is read by our software and the results (being the status of a certain record) will be output into a txt file which then can be read and processed in an external software.

All this works ok , but i would like to start using more modern solutions.

Does anyone have any idea's ? I am thinking of a sort of rest API on my database or something like that ? Does this exist ? Or ... ?

 

I don't like to give them full access through ODBC on my database....

 

 

Grts

John

David Peace (Powersoft) Accepted Answer Pending Moderation
  1. Wednesday, 3 January 2018 16:38 PM UTC
  2. PowerBuilder
  3. # 1

I believe that SQL Anywhere has the capability to host web services. You could create a simple web service and call that from PB.

Alternatively you could write a PB service using Rolands service wrapper and create a TCP/IP listener within that service to receive and send messages to the PB client.

PBNISERV Service wrapper: http://www.topwizprogramming.com/pbniserv.html

TCP/IP winsok code: http://www.topwizprogramming.com/freecode_winsock.html

Both would work fine.

Cheers

David

Comment
There are no comments made yet.
Roland Smith Accepted Answer Pending Moderation
  1. Wednesday, 3 January 2018 14:45 PM UTC
  2. PowerBuilder
  3. # 2

It would be dependent on the capabilities of the external software.

PB 2017 R2 will have new JSON/REST abilities. I believe it will be out by the end of this month.

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.