will be possible using EWB for presentation data from Access mdb database or dbf table?

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

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

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
>

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

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
>

Raul thank you.

Rado

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

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