Result - Maple Help

Online Help

All Products    Maple    MapleSim


Home : Support : Online Help : Connectivity : Database Package : Result : Database/Result/UpdateData

Result

  

UpdateData

  

set the value to which an element will be changed

 

Calling Sequence

Parameters

Description

Examples

Calling Sequence

result:-UpdateData( index, data )

Parameters

result

-

Result module

index

-

string or integer; the column to be updated

data

-

the new value

Description

• 

UpdateData sets the value that the element stored in the row (indicated by the row cursor) and the column (indicated by index) will be changed to on a call to UpdateRow. The value the element will be changed to is data.

• 

To update a row, set the new values by by calling UpdateData and then submit these updates by calling UpdateRow.  Changing the current row discards any values set with UpdateData.

• 

Maple can automatically determine the type of the column and convert data; however, this requires querying the type of the column.  To avoid this overhead the type can be specified using an explicit cast. For more information, see conversions.

• 

An element can be set to SQL NULL by passing 'SQLNULL' for data.

• 

Not all Result modules can be updated.  Only Result modules representing tables containing data from a single table (no joins) and a column of primary keys are guaranteed to be updatable.  Particular JDBC Drivers and databases may allow a wider range of updatable tables and thus Result modules.

Examples

Create a Result to be updated.

driverDatabase[LoadDriver]:

conndriver:-OpenConnectionurl,name,pass:resconn:-ExecuteQuerySELECT id,name,number,mass FROM animals:res:-Next

true

(1)

Get the current values.

res:-GetData2

fish

(2)

res:-GetData3

100

(3)

res:-GetData4

0.0100000000000000002

(4)

Set the update values.

res:-UpdateData2,chicken;res:-UpdateData3,6;res:-UpdateData4,2.5

The new values are not sent to the database yet.

res:-GetData2

fish

(5)

res:-GetData3

100

(6)

res:-GetData4

0.0100000000000000002

(7)

Update the row.

res:-UpdateRow

Check the values.

res:-GetData2

chicken

(8)

res:-GetData3

6

(9)

res:-GetData4

2.50000000000000000

(10)

See Also

Database

Database[Result]

Database[Result][GotoRow]

Database[Result][Last]

Database[Result][Next]

Database[Result][Previous]

Database[Result][UpdateRow]

Database[usage]

 


Download Help Document

Was this information helpful?



Please add your Comment (Optional)
E-mail Address (Optional)
What is ? This question helps us to combat spam