Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 6 of 6 total
Thread DBISAM Server Procedures
Fri, Nov 11 2016 5:44 PMPermanent Link

Kyle Boatwright

Our current application has a middleware/server application that has many server procedures executed by our Windows client application.  Is there a facility in a Web Builder client application that would allow execution of those same server procedures?
Sat, Nov 12 2016 6:50 AMPermanent Link

Matthew Jones

Kyle Boatwright wrote:

> Our current application has a middleware/server application that has many server procedures executed by our Windows client application.  Is there a facility in a Web Builder client application that would allow execution of those same server procedures?

How does your current client talk to the middleware? If possible, use that. At its core though, EWB just uses the browser and http calls to a server. That server can be anything, so could be a custom server you have written to provide a link to your middleware, or a module in the EWB server, or anything really.

If I were in your situation, assuming nothing ready-rolled, I'd be looking to make a standard web server interface to your middleware using as standard a technology as you can. Could be Delphi, or C#, or whatever, depending on how deep you want it.
Sat, Nov 12 2016 2:38 PMPermanent Link

Kyle Boatwright

"Matthew Jones" wrote:

Kyle Boatwright wrote:

> Our current application has a middleware/server application that has many server procedures executed by our Windows client application.  Is there a facility in a Web Builder client application that would allow execution of those same server procedures?

How does your current client talk to the middleware? If possible, use that. At its core though, EWB just uses the browser and http calls to a server. That server can be anything, so could be a custom server you have written to provide a link to your middleware, or a module in the EWB server, or anything really.

If I were in your situation, assuming nothing ready-rolled, I'd be looking to make a standard web server interface to your middleware using as standard a technology as you can. Could be Delphi, or C#, or whatever, depending on how deep you want it.


Sorry, I did not supply enough info...  

Our application is in Delphi, the DB is DBISAM and the middleware contains the DBISAM server and executes the DBISAM server procedures.  Is there a way in Web Builder to call those DBISAM server procedures is what I meant to ask...
Sat, Nov 12 2016 3:47 PMPermanent Link

Raul

Team Elevate Team Elevate

On 11/12/2016 2:38 PM, Kyle Boatwright wrote:
> Sorry, I did not supply enough info...
> Our application is in Delphi, the DB is DBISAM and the middleware contains the DBISAM server and executes the DBISAM server procedures.  Is there a way in Web Builder to call those DBISAM server procedures is what I meant to ask...

EWB app itself cannot call anything like that. EWB app only make HTTP
requests to a web server - for example EWB Web Server that is included
with EWB.

AFAIK there is no built-in way to call DBISAM server procedures from EWB
Web server right now.

However you can quite easily create a custom module that calls server
side procedures.  You'd need to look at your app logic to see if that is
enough or if you'd want to implement something bit more comprehensive -
it might make sense to make EWB app logic bit different than your delphi
app logic sicne EWB app is a web app.

Raul
Sat, Nov 12 2016 6:09 PMPermanent Link

Kyle Boatwright

Raul wrote:

On 11/12/2016 2:38 PM, Kyle Boatwright wrote:
> Sorry, I did not supply enough info...
> Our application is in Delphi, the DB is DBISAM and the middleware contains the DBISAM server and executes the DBISAM server procedures.  Is there a way in Web Builder to call those DBISAM server procedures is what I meant to ask...

EWB app itself cannot call anything like that. EWB app only make HTTP
requests to a web server - for example EWB Web Server that is included
with EWB.

AFAIK there is no built-in way to call DBISAM server procedures from EWB
Web server right now.

However you can quite easily create a custom module that calls server
side procedures.  You'd need to look at your app logic to see if that is
enough or if you'd want to implement something bit more comprehensive -
it might make sense to make EWB app logic bit different than your delphi
app logic sicne EWB app is a web app.

Raul



Thanks for the info...  

I did not see anyway to make the calls, just wanted to make sure I was not doing something the hard way...
Tue, Nov 15 2016 1:35 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Kyle,

<< Our application is in Delphi, the DB is DBISAM and the middleware contains the DBISAM server and executes the DBISAM server procedures.  Is there a way in Web Builder to call those DBISAM server procedures is what I meant to ask... >>

The easiest way to get that up and running would be to use an EWB Web Server module that calls the DBISAM server procedures and copies the results back to EWB in a format that it can understand, such as JSON.

Are you looking to return an entire dataset (table or query result set), or just basic information like a single set of result values ?

Tim Young
Elevate Software
www.elevatesoft.com
Image