Forums

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😲

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"

"Insert - on duplicate key update" will do what you need!

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

What is the debug result of the "save data" ?