Is there a master detail example with Builder 2? Coming from a largely SQL background I'm not really seeing how to design master detail interfaces.

thanks!

http://www.elevatesoft.com:8080/masterdetail/masterdetail.html

Thanks Walter! Is the source code running around some where?

On 5/25/2015 10:32 AM, Jeff wrote:
> Thanks Walter! Is the source code running around some where?

This example i believe was part of the EWB1 examples so EWB1 install
would have it - i'm guessing it has just not been converted to EWB2 yet

Raul

Thanks Raul!

I think what I'm really having is a problem figuring out what is built into EWB 2 for Database support. There is ElevateDB, DBISAM, and ADO.

ADO I get, but I have actually never used the other two. Do I have to buy them separately? I'm going to have to do some more reading...

ElevateDB and DBISAM are database engines developed and sold by Elevate Software.

If you choose ElevateDB you can download a Trial version and see how well it integrates with EWB.

Go to the Downloads | ElevateDB area, and grab the 'EDB-ADD - ElevateDB Additional Software and Utilities' package.

On 5/25/2015 12:01 PM, Jeff wrote:
> Thanks Raul!
>
> I think what I'm really having is a problem figuring out what is built into EWB 2 for Database support. There is ElevateDB, DBISAM, and ADO.
> ADO I get, but I have actually never used the other two. Do I have to buy them separately? I'm going to have to do some more reading...

Actually EWB itself has what i would call "generic" data support.

Remember we're talking about javascript running inside of a browser so
there can be no drivers and other dependencies.

Even though documents are not up to date the DB section of manual still
applies :
http://www.elevatesoft.com/manual?action=topics&id=ewb2&section=using_datasets

EWB has a concept of dataset (think cursor and resultset) and supporting
infrastructure (virtual database and transaction support  and data-aware
controls etc).

However all of this is based on sending and receiving JSON data (so not
specific to any specific database engine).

The web server (back end) has to support any database engine you wish to
talk to and it is responsible for "translating" essentially between
database and EWB (this boils down to reading data and converting to JSON
in order to respond to queries from EWB and receiving JSON from EWB and
then executing this into database - insert, update, delete etc).

Hence the EDB/DBISAM/ADO refer to natively supported databases (or
access methods) built into "EWB Web Server". ADO is basically there for
"any other database you want to access (that has ADO provider)".

Note that the JSON spec is published (see the link above) so you can
always write your own back-end also - in php or asp or whatever language
your web server runs and you prefer.

To the actual EWB app all of the databases look alike - just JSON data.

In terms of using EDB and DBISAM specifically - support for them is
already built-into the "EWB Web Server" so no you do not need to buy
anything if you plan to use "EWB Web Server".

Otherwise if you do intend to use one of the 2 (i'd suggest EDB as it's
newer and is unicode etc) with some other back-end then yes you would
need to buy it (edb is sold royalty free so it's one time purchase and
not per install).

However again as i mentioned EDB/DBISAM are just some of the databases
supported by EWB but EWB is completely stand-alone and not in any way
requires either of them.

Raul

Jeff,

<< In terms of using EDB and DBISAM specifically - support for them is
already built-into the "EWB Web Server" so no you do not need to buy
anything if you plan to use "EWB Web Server". >>

I just want to point out that this isn't a mistake on our part.  You can use
them for free if you use them only with the EWB Web Server directly
accessing the databases, and you can download utilities to work with them
from our site:

http://www.elevatesoft.com/download?action=info&category=edb&type=edbadd&majorversion=2&version=2.19

http://www.elevatesoft.com/download?action=info&category=dbisam&type=dbisamadd&majorversion=4&version=4.41

However, if you want to write native applications that access the same
databases, or use the ElevateDB Server or DBISAM Database Server, then
you'll need to purchase a license to the appropriate version of each.

Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" wrote:

Jeff,

<< In terms of using EDB and DBISAM specifically - support for them is
already built-into the "EWB Web Server" so no you do not need to buy
anything if you plan to use "EWB Web Server". >>

I just want to point out that this isn't a mistake on our part.  You can use
them for free if you use them only with the EWB Web Server directly
accessing the databases, and you can download utilities to work with them
from our site:

http://www.elevatesoft.com/download?action=info&category=edb&type=edbadd&majorversion=2&version=2.19

http://www.elevatesoft.com/download?action=info&category=dbisam&type=dbisamadd&majorversion=4&version=4.41

However, if you want to write native applications that access the same
databases, or use the ElevateDB Server or DBISAM Database Server, then
you'll need to purchase a license to the appropriate version of each.

Tim Young
Elevate Software
www.elevatesoft.com

Can you elaborate on which version of ElevateDB is included with EWB?   I was under the impression I would need to purchase the ElevateDB Server version to work with EWB.

Thanks,
TD

On 5/28/2015 11:02 AM, TD wrote:
>   Can you elaborate on which version of ElevateDB is included with EWB?   I was under the impression I would need to purchase the ElevateDB Server version to work with EWB.

I believe it's whatever is the latest (i.e. 2.19 likely in the current
one) - Tim can confirm.

What included is the EDB engine so you can access local edb databases
directly (i.e. ones accessible thru file path by EWB Web Server) or
remote (already existing) EDB Server(s) over network.

EDB Server itself is not included - for that you still need to buy one
of the EDB C/S editions. (non C/S edition includes a 5 connection EDB
server also but it's meant for development and testing).

So basically if all you want is to have EDB database on the same server
as "EWB Web Server" then you're all set with EWB and everything is
"built-in" and supported by the same company.

If you want the EDB database to be on different server then you need to
buy EDB C/S edition. Similarly if you want to develop apps that include
EDB then again you need buy EDB (again C/S edition for example).

Note that EDB is royalty free so once you buy copy per developer you can
distribute it with your app with no extra costs.

Raul