Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 9 of 9 total
Thread EWB and mdb database or dbf table?
Wed, Jan 4 2012 1:51 PMPermanent Link

Radovan Šamudovský

Gas-Me-Ra s.r.o.

will be possible using EWB for presentation data from Access mdb database or dbf table?
Wed, Jan 4 2012 3:44 PMPermanent Link

Chris Holland

SEC Solutions Ltd.

Avatar

Team Elevate Team Elevate

Hi,

If you write a web service to "serve up" the data then EWB will be able
to pick up the data via the web service and display it.

Chris Holland
[Team Elevate]

On 04/01/2012 18:51, radosamo wrote:
> will be possible using EWB for presentation data from Access mdb database or dbf table?
>
Wed, Jan 4 2012 4:55 PMPermanent Link

Radovan Šamudovský

Gas-Me-Ra s.r.o.

Hi,

thanks, but I'm new in web application, what is mean "web service to serve up" ?
I must write some web service in Delphi or in something else.
Can you be more detailed?

Rado
Wed, Jan 4 2012 5:14 PMPermanent Link

Chris Holland

SEC Solutions Ltd.

Avatar

Team Elevate Team Elevate

Hi Rado,

Yes, you have to write a routine (or multiple routines) in Deplhi (or
some other language) to run on a web server that will read the data from
the required database and return the results  as a DataTable or similar
to EWB.

Chris Holland
 [Team Elevate]

On 04/01/2012 21:55, radosamo wrote:
> Hi,
>
> thanks, but I'm new in web application, what is mean "web service to serve up" ?
> I must write some web service in Delphi or in something else.
> Can you be more detailed?
>
> Rado
>
Wed, Jan 4 2012 5:59 PMPermanent Link

Radovan Šamudovský

Gas-Me-Ra s.r.o.

Thank you Chris,

can you think about prepare some simple example or step by step manual like to do it in EWB help documentation?

Rado
Wed, Jan 4 2012 7:08 PMPermanent Link

Raul

Team Elevate Team Elevate

Tim has promised to include some examples in the documentation - however
it won't happen til product is officially released.

More general answer to your question is that despite object pascal
syntax EWB is actually generating javascript that runs inside a web
browser. This means couple of things:

(1) Your application is executing in a sandbox with no access to any
local resources like local files or even system information. Hence
accessing MDF or DBF is out of the question

(2) The only way to access external resources is to do a web request
(basically a request to URL and then use whatever data is returned).
This is what Chris meant by web service. In reality you need to a write
a server side application (web service) that will access the MDB/DBF
file in your case and return results in JSON format (since it's natively
supported in EWB).

Wikipedia article is a good starting point to understand this :
http://en.wikipedia.org/wiki/Web_service


Raul

> can you think about prepare some simple example or step by step manual like to do it in EWB help documentation?
>
> Rado
>
Thu, Jan 5 2012 5:53 AMPermanent Link

Radovan Šamudovský

Gas-Me-Ra s.r.o.

Raul thank you.

Rado
Fri, Jan 6 2012 2:34 AMPermanent Link

Šamudovský

Hi,

Do you think to prepare component like DataSource in Delphi for universal access to the another database like elevateDB, access, MSSQL, MySQL and other on the future?
Or do you think to prepare support for local embedded file data source (excel, access, ...) on some next EWB version ?

Rado
Tue, Jan 10 2012 5:01 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Rado,

<< Do you think to prepare component like DataSource in Delphi for universal
access to the another database like elevateDB, access, MSSQL, MySQL and
other on the future?
Or do you think to prepare support for local embedded file data source
(excel, access, ...) on some next EWB version ? >>

The issue with using Delphi code on the back-end is that some ISPs won't
allow ISAPI DLLs anymore, and that (and CGI) are the only way to get Delphi
code working in a web server.  The other alternative is to simply run your
own web server using a hosting solution like AWS (Amazon) where you get
complete access to a server instance that you can do whatever you want with.

As far as ElevateDB and DBISAM are concerned - ElevateDB will definitely
include a built-in web server in the very near future that will allow an EWB
application to talk directly to an EWB Server instance in order to
retrieve/update data from any database.   That will make EWB/EDB a seamless
solution.  However, the EDB side of things will still suffer from the same
ISP issue above.

Apart from using native Delphi code, the other options are PHP, ASP, etc.

--
Tim Young
Elevate Software
www.elevatesoft.com
Image