Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » Elevate Web Builder Technical Support » Support Forums » Elevate Web Builder General » View Thread |
Messages 1 to 6 of 6 total |
DBISAM DBSRVR / EWBSRVR |
Wed, Feb 13 2013 10:57 AM | Permanent Link |
Christian Ahlgrimm | 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 |
Wed, Feb 13 2013 4:37 PM | Permanent Link |
Chris Holland SEC Solutions Ltd. Team Elevate | 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 > |
Thu, Feb 14 2013 2:08 AM | Permanent Link |
Christian Ahlgrimm | 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 > |
Thu, Feb 14 2013 2:34 AM | Permanent Link |
Uli Becker | 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 |
Thu, Feb 14 2013 12:36 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Fri, Feb 15 2013 5:33 AM | Permanent Link |
Christian Ahlgrimm | 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 |
This web page was last updated on Friday, November 1, 2024 at 07:01 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |