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

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

  1. Wednesday, 3 January 2018 16:38 PM
  2. PowerBuilder
  3. # 1
0
Votes
Undo

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
  2. PowerBuilder
  3. # 2
0
Votes
Undo

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.
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.