Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 9 of 9 total
Thread How To Create TDataset At RunTime and Change Properties And Data Source?
Mon, Oct 5 2015 10:10 AMPermanent Link

Frederick Chin

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
Mon, Oct 5 2015 10:50 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

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
Mon, Oct 5 2015 11:21 PMPermanent Link

Frederick Chin

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
Tue, Oct 6 2015 11:05 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Frederick,

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

No.

Tim Young
Elevate Software
www.elevatesoft.com
Thu, Oct 8 2015 10:50 PMPermanent Link

Frederick Chin

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
Fri, Oct 9 2015 3:29 AMPermanent Link

Uli Becker

Frederick,

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

Uli
Fri, Oct 9 2015 11:20 AMPermanent Link

Frederick Chin

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
Fri, Oct 9 2015 11:50 AMPermanent Link

Raul

Globestar Systems

Team Elevate Team Elevate

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
Sat, Oct 10 2015 12:48 AMPermanent Link

Frederick Chin

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
Image