Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread UPDATE table with basic SQL command
Wed, Sep 2 2015 1:12 PMPermanent 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

<< 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&section=getting_started

Tim Young
Elevate Software
www.elevatesoft.com
Image