Help with calculated field

You are doing the right thing for display but if you want to write the value back to the database you will need to add some more code using SQL UPDATE command.

You are doing the right thing for display but if you want to write the value back to the database you will need to add some more code using SQL UPDATE command.

thanks.............how would i do this? im a novice!

Hi,
to update records in the database execute UPDATE query in the database directly.

Here is a sample:

UPDATE TableName set Saloon=Price+5

Hi,

Hello Jane
I have tried doing that and it comes back with an SQL syntax error
The table name is `_estimate`
SELECT

id,

collection,

destination,

price,

vehicle,

saloon,

estate,

mpv,

mpvplus,

eightseater

FROM `_estimate`
what I am trying to do is this:
I am trying to write the values of saloon, estate, mpv, mpvplus & eightseater back to the sql tables.
the code i have entered into the viewer are
$value = $data['price'] + 0;

$value = $data['price'] + 5; for the estate field

$value = $data['price'] + 15; for the mpv and so on
I am obviously doing something wrong because when i try to enter your method a syntax error is returned.
Do i use your method in the SQL editor ?
Please help !!!

Execute UPDATE query in the database directly (use any MySQL administrative tool for that).

Execute UPDATE query in the database directly (use any MySQL administrative tool for that).

Hi again !
I have tried that and i still get the syntax error
this is what i have done
SELECT

id,

collection,

destination,

price,

vehicle,

saloon,

estate,

mpv,

mpvplus,

eightseater

FROM `_estimate`

UPDATE `_estimate` SET saloon=price+0
just comes up with syntax SQL error !!
is my syntax correct?
Sorry for being a complete moron !! <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=28999&image=1&table=forumreplies' class='bbc_emoticon' alt=':unsure:' />

Here is the correct query:

UPDATE `_estimate` SET saloon=price+0

Also I recommend you to have a look at the following articles:

http://www.webcheatsheet.com/sql/interacti.../sql_update.php

http://www.w3schools.com/sql/sql_update.asp

Ok it has worked now!!! sorry !! thanks !!!!
But my problem is now that when i adda new record it does not automatically do this i have to go back to the SQL editor and do it manually !
Should i use the "after record updated" command in the events panel if so what is the correct syntax to use?
I will love you for ever if you can show me the correct way !!!! promise!!!!!!

Use Before record added/Before record updated events for this purpose.

Here is a sample:

$values["saloon"] = $data["price"]+5; //for the saloon field

Use Before record added/Before record updated events for this purpose.

Guess what............. It didnt work ! <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=29008&image=1&table=forumreplies' class='bbc_emoticon' alt=':(' />
I can now open up the program in the browser all tables show correctly but when i add a new record it says
Error 8

Undefined variable: data
OMG !!! anything else i can try ?

Sorry for my fault.

Here is the correct code:

$values["saloon"] = $values["price"]+5; //for the saloon field

Sorry for my fault.

You are a STAR!!!!!
Many many thanks !!!!
Think i will stick to stamp collecting !