![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » Elevate Web Builder Technical Support » Support Forums » Elevate Web Builder General » View Thread |
Messages 1 to 10 of 10 total |
![]() |
Fri, Jun 12 2015 6:25 AM | Permanent Link |
Michael Saunders | I have managed to get the DataSetClient / DatasetModule example going and would now like to use this as a guide to developing a project that replaces the Biolife Dataset with a set of tables from an Elevate DB Database. I believe this should be straightforward but I cannot find any examples to get me off the ground and I would really appreciate a basic template of the coding needed for in particuilar the server side stuff
I assume that I need to add the tables and ConfigFile stuff when I configure the server and therefore do not need the Database/Dataset Adaptors but not what else to do and what components to place in my EDBModule I assume also that I need to develop a Module to be registered but find the terms DataSets, CustomDataSets and Custom Datsets Module confusing If I use the built in Databases provided then does this mean that they are not called Custom and if so why is the Module called a Custom Datsets Module I can see that once all these silly frustrations are cleared up my requirements form this product should be well sorted Thanks |
Fri, Jun 12 2015 12:21 PM | Permanent Link |
Uli Becker | Michael,
it's not clear what your "scenario" is. If you just want to develop an application that communicates with EDB, you don't need any modules except you want to use stored procedures or anything else besides tables or queries. I guess you are using the EWB Webserver? Uli |
Fri, Jun 12 2015 3:56 PM | Permanent Link |
Michael Saunders | Uli Becker wrote:
Michael, it's not clear what your "scenario" is. If you just want to develop an application that communicates with EDB, you don't need any modules except you want to use stored procedures or anything else besides tables or queries. I guess you are using the EWB Webserver? Uli Thanks for replying Yes I want to use the EWB WebSever I can already connect to EDB using the built in IDE server to a dataset I have defined using the Dataset Manger Now I would like to take this a stage further To quote from the manual "The Elevate Web Builder web server allows modules created using Embarcadero RAD Studio and Delphi to be registered in the web server and used to handle dynamic requests to the web server. This allows the developer to offload computationally-intensive or database-intensive work to the natively-compiled web server modules, and then use simple server requests in the front-end Elevate Web Builder applications to make requests to the modules and receive back responses along with the relevant data/content." I can also connect to my EDB database by configuring the Server Datasets tab What confuse me is what do I do next The above quote from the manual implies that I need to develop a Module but the Server Content tab wants me to specify a Custom Datsets Module (Like the Biolife in the example provided I assume ? ) I understood that EDB was not a Custom Dataset however so where do I place my code and how do I start and what components do I use in my Module etc This is all probably obvious to you but please clarify as unfortuantley ther seems no example for this anywhere Thanks |
Fri, Jun 12 2015 4:09 PM | Permanent Link |
Uli Becker | Michael,
it's still not clear, what you want to do with a module. Please elaborate. If you generally want to know how a module works, I can send you some code, but not before Sunday - I'm not at home. Maybe someone else can help you immediately. Uli |
Fri, Jun 12 2015 4:38 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Michael,
<< I can also connect to my EDB database by configuring the Server Datasets tab What confuse me is what do I do next The above quote from the manual implies that I need to develop a Module but the Server Content tab wants me to specify a Custom Datsets Module (Like the Biolife in the example provided I assume ? ) I understood that EDB was not a Custom Dataset however so where do I place my code and how do I start and what components do I use in my Module etc >> You can use *any* non-visual Delphi components in a web server module. For a custom dataset module, you can use the included TDatabaseAdapter and TDataSetAdapter components to hook up TDataSet-descendant components so that you can easily generate/consume the necessary JSON for EWB. << This is all probably obvious to you but please clarify as unfortuantley ther seems no example for this anywhere >> There's no example project, other than the custom dataset module example, but how you create/code modules is covered quite extensively in the modules manual: http://www.elevatesoft.com/manual?action=topics&id=ewb1mod&product=rsdelphi&version=XE§ion=getting_started as well as a complete overview of them in the EWB manual: http://www.elevatesoft.com/manual?action=viewtopic&id=ewb1&topic=Modules I'll be including more module example projects in EWB 2, but the above links should be sufficient to get you started. The reason that more module examples weren't included in EWB 1.x is because it did not support adding server modules to the IDE. So, there was no way to automate the example installations, and it was particularly difficult to explain the entire process of setting up the web server simply for a module example project. Tim Young Elevate Software www.elevatesoft.com |
Fri, Jun 12 2015 5:21 PM | Permanent Link |
Michael Saunders | Uli Becker wrote:
Michael, it's still not clear, what you want to do with a module. Please elaborate. If you generally want to know how a module works, I can send you some code, but not before Sunday - I'm not at home. Maybe someone else can help you immediately. Uli I want to take a portion of a desktop application already written for EDB and enable it to eventually run from a hand held device The desktop app runs on a LAN and uses the EDB Server for access There will be a quite a bit of Dephi code to execute (Maybe even incorporating FastReport) That is why I am looking to do this using a Server Module. I would very much appreciate reviewing anything that you can provide as i am sure that it will help clear up my confusion and I can certainly wait a couple of days or so Thanks |
Fri, Jun 12 2015 6:16 PM | Permanent Link |
Michael Saunders | "Tim Young [Elevate Software]" wrote:
Michael, << I can also connect to my EDB database by configuring the Server Datasets tab What confuse me is what do I do next The above quote from the manual implies that I need to develop a Module but the Server Content tab wants me to specify a Custom Datsets Module (Like the Biolife in the example provided I assume ? ) I understood that EDB was not a Custom Dataset however so where do I place my code and how do I start and what components do I use in my Module etc >> You can use *any* non-visual Delphi components in a web server module. For a custom dataset module, you can use the included TDatabaseAdapter and TDataSetAdapter components to hook up TDataSet-descendant components so that you can easily generate/consume the necessary JSON for EWB. << This is all probably obvious to you but please clarify as unfortuantley ther seems no example for this anywhere >> There's no example project, other than the custom dataset module example, but how you create/code modules is covered quite extensively in the modules manual: http://www.elevatesoft.com/manual?action=topics&id=ewb1mod&product=rsdelphi&version=XE§ion=getting_started as well as a complete overview of them in the EWB manual: http://www.elevatesoft.com/manual?action=viewtopic&id=ewb1&topic=Modules I'll be including more module example projects in EWB 2, but the above links should be sufficient to get you started. The reason that more module examples weren't included in EWB 1.x is because it did not support adding server modules to the IDE. So, there was no way to automate the example installations, and it was particularly difficult to explain the entire process of setting up the web server simply for a module example project. Tim Young Elevate Software www.elevatesoft.com I thought I would try using EWB 1 whilst waiting for EWB 2 just to get some experience as my client is pushing me for some progress So if the release of EWB 2 is imminent I could hang on I have already been able to compile and register a Module in the EWB Server but I am unclear as to how this would need to be altered from the Biolife example to use EDB instead EG Do I need to reference it as a Custom DataSet Module in the Server Configuration even though it is a supported Database (ie EDB DBISAM and ADO) and what EDB Components do I need (if any) in the Module |
Mon, Jun 15 2015 11:46 AM | Permanent Link |
Uli Becker | Michael,
I uploaded one of my modules to the binaries for you. Unfortunately I have no time to comment anything at the moment - hope it helps anyway. Uli |
Tue, Jun 16 2015 6:02 AM | Permanent Link |
Michael Saunders | Uli Becker wrote:
Michael, I uploaded one of my modules to the binaries for you. Unfortunately I have no time to comment anything at the moment - hope it helps anyway. Uli Many thanks Uli Hopefully I have managed to resolve a lot of my issues and realise I was trying to do to much to soon. Your examples resolves a few things for me as well MIke |
Tue, Jun 16 2015 7:43 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Michael,
<< I thought I would try using EWB 1 whilst waiting for EWB 2 just to get some experience as my client is pushing me for some progress So if the release of EWB 2 is imminent I could hang on >> Yeah, it will be released by Monday, June 22 (probably on Monday, if it looks like Thursday or Friday of this week for a release). << I have already been able to compile and register a Module in the EWB Server but I am unclear as to how this would need to be altered from the Biolife example to use EDB instead EG Do I need to reference it as a Custom DataSet Module in the Server Configuration even though it is a supported Database (ie EDB DBISAM and ADO) and what EDB Components do I need (if any) in the Module >> Yes, you would need to reference it as a custom dataset module if you want to use the custom dataset modules resource name setting (default "customdatasets") as part of the path to the datasets. You can also just use it like a normal web server module with the modules resource name setting (default "modules"). The only difference is the resource name used to in the URL: the functionality of the module doesn't change. You would replace the TClientDataSet component with the necessary ElevateDB TEDBSession, TEDBDatabase, and TEDBTable/TEDBQuery/TEDBScript/TEDBStoredProc components that you need to access your data, just like in a normal Delphi data module. You would then need to add TDatabaseAdapter and TDataSetAdapter components. There are a couple of options here: 1) Using the same TDataSetAdapter for all of the TEDBTable/TEDBQuery/TEDBScript/TEDBStoredProc components on the web server module, or 2) using a different TDataSetAdapter for each. The main difference is in how you handle this event: http://www.elevatesoft.com/manual?action=viewmethod&id=ewb2mod&product=rsdelphi&version=XE&comp=TEWBDatabaseAdapter&method=GetDataSetAdapter If you go with the 1) route, then any event handler for this event must set the TEWBDataSetAdapter.DataSet property: http://www.elevatesoft.com/manual?action=viewprop&id=ewb2mod&product=rsdelphi&version=XE&comp=TEWBDataSetAdapter&prop=DataSet and then call the TEWBDataSetAdapter.Initialize method: http://www.elevatesoft.com/manual?action=viewmethod&id=ewb2mod&product=rsdelphi&version=XE&comp=TEWBDataSetAdapter&method=Initialize being sure to handle this event: http://www.elevatesoft.com/manual?action=viewevent&id=ewb2mod&product=rsdelphi&version=XE&comp=TEWBDataSetAdapter&event=OnInitialize to make sure that the dataset key information is set so that the EWB dataset adapter code can find the correct rows during updates and deletes, as well as generate the proper row key values for BLOB load URLs that are generated as part of the JSON for the dataset rows. If you go with 2), then you can hard-code all of this information into each TEWBDataSetAdapter instance on the web server module. EWB 2 has this new TEWBDatabaseAdapter method: http://www.elevatesoft.com/manual?action=viewmethod&id=ewb2mod&product=rsdelphi&version=XE&comp=TEWBDatabaseAdapter&method=HandleRequest that handles all of the nitty-gritty of the dataset requests, so it will make most of the old request handling code in EWB 1.x unnecessary. If you have any other questions, please let me know. Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Wednesday, August 14, 2024 at 07:31 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |