The EWB manual shows a very simple method of creating a dataset at runtime and filling it with data.

How do I create a dataset at runtime and change the properties and data source accordingly, much like what the dataset manager does?

I suppose that the dataset can be disposed off using the Free method?

Frederick

Frederick,

<< How do I create a dataset at runtime and change the properties and data source accordingly, much like what the dataset manager does? >>

You can't access any of that information from an EWB client application.  An EWB client application is completely unaware of how the dataset information is generated on the server-side.

<< I suppose that the dataset can be disposed off using the Free method? >>

Yes, any class instance can be freed using the Free method.

Tim Young
Elevate Software
www.elevatesoft.com

Tim,

/*
You can't access any of that information from an EWB client application.  An EWB client application is completely unaware of how the dataset information is generated on the server-side.
*/

The following example from Delphi will not work then?

I have 2 tables; one with 10 fields and another with 5 fields and one form and one query. My designtime defined query has all fields selected from the first table. When the user accesses the same form that uses the second table, I vary the query's SQL text to select all fields from table 2.

Frederick

Frederick,

<< The following example from Delphi will not work then? >>

No.

Tim Young
Elevate Software
www.elevatesoft.com

Tim,

I have a desktop application that handles data for 4 companies and the data are in 4 separate directories.

When a user starts my web application, they select which company they want to access the data for and the web application is suppose to switch datasets accordingly.

Assuming that the web application uses 30 datasets, it is correct to say that I have to create 120 datasets so that the web application can switch to the datasets relevant to each company?

Frederick

Frederick,

you can use an EWB Web Server module along with TEWBDatabaseAdapter/TEWBDataSetAdapter components to surface your various databases.

Uli

Uli,

/*
you can use an EWB Web Server module along with TEWBDatabaseAdapter/TEWBDataSetAdapter components to surface your various databases.
*/

I guess this requires using Rad Studio to create the modules?

Frederick

On 10/9/2015 11:20 AM, Frederick Chin wrote:
> I guess this requires using Rad Studio to create the modules?

Yes - Delphi actually is all that's needed (no need for Rad Studio) but
it's still a commercial product.

If you want to just evaluate this they do have a 30 day trial edition of
delphi available and that should be good enough to try out a module to
see if it's something you want to do.


Raul

Raul,

/*
Yes - Delphi actually is all that's needed (no need for Rad Studio) but
it's still a commercial product.

If you want to just evaluate this they do have a 30 day trial edition of
delphi available and that should be good enough to try out a module to
see if it's something you want to do.
*/

OK. I'll wait for the EWB modules for Delphi 10S to be available before diving in.

Frederick