Buy Now
Sign in

auto detect doesnt work

samir1903 , April 23 2019, 20:55
S
samir1903 182
April 23 2019, 20:55 #386222
I have tried all type of write action but doesnt give what i am looking for
i put update where condition aid=student_no
what i am looking for is if this student no exist update if not insert
after there is insert update and all other sections exists, dont tell me use switch or php
healyhatman 9
April 24 2019, 05:47 #386231
Auto detect works off of the primary key. If you're having trouble what you can do is have a read data action looking for the record to update. If it's found, have a save data action set to update. If it's not found, have one set to insert.
Can also try the "Insert - on duplicate key update"
Web developer at SkySpider.com.au - I DO NOT work for ChronoEngine!
Donations: paypal.me/healyhatman
Professional Work: kamron@skyspider.com.au
Custom CF / CC Plugins and Extensions: skyspider.com.au/store
admin 28
April 24 2019, 09:47 #386263
 1
"Insert - on duplicate key update" will do what you need!
Max
If your main question got answered then please mark the answer using the button!
Did you try the new ChronoForms7 ? if yes then please send us your comments!!
S
samir1903 182
April 24 2019, 13:20 #386274
insert on update doesnt work
i have read aid:student_no
then form data provider is this db read
then i have module Student[name].........
then when i say db save what ever you say doesnt work
even when i open text puts comes loaded with new student page whit your suggestion
admin 28
April 24 2019, 20:31 #386282
What is the debug result of the "save data" ?
Max
If your main question got answered then please mark the answer using the button!
Did you try the new ChronoForms7 ? if yes then please send us your comments!!