Hallo,
sorry in advanced for my poor english, hope, you understand me anyway.
I'm a delphi developer for several years, using dbisam in client-server environment.
Now I tried to get access to the dbisam-tables under the dbisam-databaseserver over a web-client.

Therefore I defined a remote-dataset (database from dbisam-databaseserver) in the EWBSRVR, which runs on another machine (also the dbisam-databaseserver runs there)---> preview in EWBSRVR ok and fast.

Then I defined the same dataset in EWB to bind it to a TGrid for displaying.
Eyerything works well, if the data size is small (max. 100 rows), but when it's bigger, then the browser hangs.

I want to reduce the amount of data as a result of user interaction at runtime (get parameter to build query), but until now I only can reduce the datasize by executing a query in the EWB-Webserver at designtime.

Can I somehow reach then EWB-Webserver from my EWB-program to reduce the requested rows of the dataset-table at runtime.?..   or am I on a completely wrong way ??

at last: thank you for your interesting product, I am sure it will become a great thing.

christian

Hi Christian,

try adding "TOP 100" to your SQL.

or whatever nunmber you require.


Chris Holland
[Team Elevate]

On 13/02/2013 15:57, Christian Ahlgrimm wrote:
> Hallo,
> sorry in advanced for my poor english, hope, you understand me anyway.
> I'm a delphi developer for several years, using dbisam in client-server environment.
> Now I tried to get access to the dbisam-tables under the dbisam-databaseserver over a web-client.
>
> Therefore I defined a remote-dataset (database from dbisam-databaseserver) in the EWBSRVR, which runs on another machine (also the dbisam-databaseserver runs there)---> preview in EWBSRVR ok and fast.
>
> Then I defined the same dataset in EWB to bind it to a TGrid for displaying.
> Eyerything works well, if the data size is small (max. 100 rows), but when it's bigger, then the browser hangs.
>
> I want to reduce the amount of data as a result of user interaction at runtime (get parameter to build query), but until now I only can reduce the datasize by executing a query in the EWB-Webserver at designtime.
>
> Can I somehow reach then EWB-Webserver from my EWB-program to reduce the requested rows of the dataset-table at runtime.?..   or am I on a completely wrong way ??
>
> at last: thank you for your interesting product, I am sure it will become a great thing.
>
> christian
>

Hi Chris,

thanks for that tip, yes, of cource, I did it, but at designtime in the datamodule of  EWBSRVR, than it works.
But, what to do, if the user at runtime wants to see another record (which is not in the top 100)
You know, the query seems to me like a preselection of data, its scope I can not know at designtime, because it should be terminated by the user at runtime.
Or did I understand something wrong ?

Christian Ahlgrimm


Chris Holland wrote:

Hi Christian,

try adding "TOP 100" to your SQL.

or whatever nunmber you require.


Chris Holland
[Team Elevate]

On 13/02/2013 15:57, Christian Ahlgrimm wrote:
> Hallo,
> sorry in advanced for my poor english, hope, you understand me anyway.
> I'm a delphi developer for several years, using dbisam in client-server environment.
> Now I tried to get access to the dbisam-tables under the dbisam-databaseserver over a web-client.
>
> Therefore I defined a remote-dataset (database from dbisam-databaseserver) in the EWBSRVR, which runs on another machine (also the dbisam-databaseserver runs there)---> preview in EWBSRVR ok and fast.
>
> Then I defined the same dataset in EWB to bind it to a TGrid for displaying.
> Eyerything works well, if the data size is small (max. 100 rows), but when it's bigger, then the browser hangs.
>
> I want to reduce the amount of data as a result of user interaction at runtime (get parameter to build query), but until now I only can reduce the datasize by executing a query in the EWB-Webserver at designtime.
>
> Can I somehow reach then EWB-Webserver from my EWB-program to reduce the requested rows of the dataset-table at runtime.?..   or am I on a completely wrong way ??
>
> at last: thank you for your interesting product, I am sure it will become a great thing.
>
> christian
>

Christian,

> Eyerything works well, if the data size is small (max. 100 rows), but when it's bigger, then the browser hangs.

That was reported earlier, and Tim announced an update to fix the
problem. Maybe it hasn't been fixed yet. Just email him to be sure.

Uli

Christian,

<< Can I somehow reach then EWB-Webserver from my EWB-program to reduce the
requested rows of the dataset-table at runtime.?..   or am I on a completely
wrong way ?? >>

There isn't any pagination support in the grid currently, but there will be
soon.  It's one of the main things missing from the grid.  The dataset
itself can store lots of rows without issue, it's primarily the number of
HTML elements required by the grid that is a problem in most browsers.

<< at last: thank you for your interesting product, I am sure it will become
a great thing. >>

I hope you're right.

Tim Young
Elevate Software
www.elevatesoft.com

Hi Tim,

thanks,
Now I take Tedit-fields for displaying, than it works.

wish you the best

christian.



>"Tim Young [Elevate Software]" wrote:

>Christian,

<< Can I somehow reach then EWB-Webserver from my EWB-program to reduce the
>requested rows of the dataset-table at runtime.?..   or am I on a completely
>wrong way ?? >>

>There isn't any pagination support in the grid currently, but there will be
>soon.  It's one of the main things missing from the grid.  The dataset
>tself can store lots of rows without issue, it's primarily the number of
>HTML elements required by the grid that is a problem in most browsers.

<< at last: thank you for your interesting product, I am sure it will become
a great thing. >>

>I hope you're right.

>Tim Young
Elevate Software
www.elevatesoft.com