Help with Calculated Field PLEASE!!

[richard]

I have a field called invoice_number and I am trying to calculate it's value. It is an integer.
Here is my code:
INSERT INTO `invoice` (`invoice_number`)
VALUE ( `%ID%` + 1000)
WHERE `invoice`.`ID` = `%ID%`;

it does not work, what am I doing wrong ?

[jsetzer]

INSERT INTO `invoice` (`invoice_number`)

(1) SQL queries for Calculated Fields in AG must return exactly one value. You have to define a SELECT statement rather than an INSERT command.

---

WHERE `invoice`.`ID` = `%ID%`

(2) Also, always use proper qoutes:
single qoutes ' for 'values' and backticks ` for table- and column-names `tn`.`cn`

---

Try this instead:

Code: Select all

SELECT 12345
FROM `invoice`
WHERE `invoice`.`ID` = '%ID%';

Replace 12345 by the formula you need.



Tip
Whenever you have problems with custom database commands, check for SQL errors in Administration area.

Wish
When posting here, please always put code fragments inside [code]...[/code] blocks for better readability.

[richard]

Thanks for the help, I just figured it out as you sent me the answer.