Hi

Are there any public rest servers that I can connect to, to play around with EWB.  Not necessarily to
edit data but just display it etc.

Thanks
Godfrey

Godfrey,

<< Are there any public rest servers that I can connect to, to play around
with EWB.  Not necessarily to edit data but just display it etc. >>

You can use the one running from elevatesoft.com  - it's on port 8080 and
includes all of the demo datasets.

Tim Young
Elevate Software
www.elevatesoft.com

I am a complete novice, not sure where to start.  Where can I get a some tips or a tutorial on how to connect?

You can use the one running from elevatesoft.com  - it's on port 8080 and
includes all of the demo datasets.

Godfrey,

<< I am a complete novice, not sure where to start.  Where can I get a some
tips or a tutorial on how to connect? >>

This is where to start with dealing with EWB datasets:

http://www.elevatesoft.com/manual?action=topics&id=ewb1&section=using_datasets

and this is where to start if you plan on making custom server requests for
JSON content:

http://www.elevatesoft.com/manual?action=topics&id=ewb1&section=using_server_requests

If you have any other questions, please let me know.

Tim Young
Elevate Software
www.elevatesoft.com

I am not coming right connecting to the remote server below.  I am trying to create a dataset in the
dataset manager.

Can you be a bit more specific as to what I need to enter in the dataset setup.

When I click the test connection button it says connecting at the bottom but just hangs indefintely

Thanks
Godfrey

You can use the one running from elevatesoft.com  - it's on port 8080 and
includes all of the demo datasets.

Tim Young
Elevate Software
www.elevatesoft.com

Godfrey,

<< I am not coming right connecting to the remote server below.  I am trying
to create a dataset in the dataset manager.

Can you be a bit more specific as to what I need to enter in the dataset
setup. >>

I was referring to creating an application with custom TServerRequest calls
for JSON content.  The EWB server that we have running will return JSON for
calls to URLs like:

http://www.elevatesoft.com:8080/datasets/<name of dataset>

If you want to simply work locally with some test datasets, then you should
use the Install Example Applications link on the Help menu to install the
sample datasets that work with the demos/example apps.

If you have any other questions, please let me know.

Tim Young
Elevate Software
www.elevatesoft.com

Hi Tim

What I want to to is setup a remote server connection using the Dataset Manager in the EWB ide, so I can play around with the data.  I dont know what tables/fields are available in the database.

But there are so many settings in the Connection tab and I dont know which ones to set to connect.  What are the
settings I need to enter to connect.

Thanks

Godfrey,

first try this link in your browser just to make clear what happens:

http://www.elevatesoft.com:8080/datasets/albums?method=rows

With the param "method" set to "rows" you are able to get all rows (in
JSON format) of the dataset "albums" which is part of the demo
application "CDCollector". Another dataset is "tracks".

This link will return the columns of the dataset:
http://www.elevatesoft.com:8080/datasets/albums?method=columns

To connect to the remote database from your application try this:

1. Create a new application
2. Put a TDataset (DataSetName=Albums, Name = dsAlbums) and a TGrid
Component on the main form
3. Set the DataSet property of the grid to dsAlbums
4. Double Click on Columns in the Dataset component
5. Click on the right icon of the DataSet Columns Editor (dsAlbums)
6. Enter this link:
http://www.elevatesoft.com:8080/datasets/albums?method=columns
7. That will populate the columns editor
8. Edit the OnCreate event of the main form:

  Database.BaseURL := 'http://www.elevatesoft.com:8080/datasets/';
  Database.load(dsAlbums);

Run the application and you should see the data in the grid.

Hope that helps.

Regards Uli