|
Pages: [1]
|
 |
|
Author
|
Topic: Accessing fields in an update statement (Read 447 times)
|
|
GedB
|
How would I access the fields in an update statement. Say, for example, I wanted to set all Saleries to 30,000 for programmers I would write db-update/where employees Salery 30000 [Job = "Programmer"]
However, what if I wanted to increase all saleries by 10%? This doesn't work: db-update/where employees Salery [Salery * .10] [Job = "Programmer"]
|
|
|
|
|
Logged
|
|
|
|
|
Ashley
|
RebDB does not currently support expressions in either the set or select clause, so neither of the following is currently possible: db-update/where Employees Salary [Salary * 1.1] [Job = "Programmer"]
or: db-select/where [Salary * 1.1] Employees [Job = "Programmer"]
I need to add this to the doco as a limitation.
|
|
|
|
|
Logged
|
|
|
|
|
|
Pages: [1]
|
|
|
 |