Forums

Hi Folks

Im stuck on this.

On DB Save

I need to increase the value of an INT field by 1

I have tried a number of methods 

eg. batch_total_allocated=.$batch_total_allocated. +1

I get the error Incorrect integer value: '$batch_total_allocated + 1' for column.....

what is the correct way to do this in chronoforms

I should add I am doing this in modify data source

You have ChronoForms v8 ?

Yes Max V8  Thanks

Use an SQL in the DBSave like:

UPDATE tabelnaam SET veldnaam = veldnaam + 1 WHERE id = 123;

veldnaam must be a numeric datatype!

Paul

the option to use sql is not available in v8 on the DB save data

I have tried adding it to the where data statement but it will not run

Thats great Max. A very fast response

I could do with it as soon as its available!

Thank you