![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » Elevate Web Builder Technical Support » Support Forums » Elevate Web Builder General » View Thread |
Messages 1 to 2 of 2 total |
![]() |
Wed, Sep 2 2015 1:12 PM | Permanent Link |
Trinione | I need to update a Table with the SQL Update command as in:
UPDATE TableName SET FieldName1 = 'value', FieldName1 = 'value' WHERE FieldID = IDvalue; I am a bit confused on how to do this. Do I create a SQL/Query Dataset with 'UPDATE' and the {Parameters}? Do I create a Table Dataset to work with the Table directly? How do I call it? Do I need to Load? A simple example would be appreciated. Thanks in advance. |
Wed, Sep 2 2015 3:38 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | << Do I create a SQL/Query Dataset with 'UPDATE' and the {Parameters}? >>
No. << Do I create a Table Dataset to work with the Table directly? >> It depends upon whether you have the data loaded on the client-side already. If you do, then great, you can just use a transaction to do the updates: http://www.elevatesoft.com/manual?action=viewtopic&id=ewb2&topic=Transactions If you don't have the data client-side, then you'll need to create a web server module for the EWB Web Server (or for whatever web server you're using) that handles such requests and performs the update on the relevant database. http://www.elevatesoft.com/manual?action=topics&id=ewb2mod&product=rsdelphi&version=XE§ion=getting_started Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, February 11, 2025 at 11:58 AM | Privacy Policy![]() © 2025 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |