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
I have added this to the next update:
When do you need the new download ?
Thats great Max. A very fast response
I could do with it as soon as its available!
Thank you
No problem!
Did you try this after the new update ?