>public myconnection >myconnection = sqlstringconnect("Driver={Microsoft Access Driver (*.mdb)};Dbq=e:\asoft\db1;Uid=admin;Pwd=") >* db1 is mdb name >sqlexec(myconnection,"select * from table1", 'cursor1') > >*To save record >fld1=thisform.text1.value >fld2=thisform.text2.value >fld3=thisform.text3.value >fld4=thisform.text4.value > >myinsert="insert into table1 (sno,name,phone,city) values(?fld1,?fld2,?fld3,?fld4)" >&& table1 is table name in db1.mdb >>Now I want to edit/update record1, what codes should I use?
TEXT TO myUpdate PRETEXT 15 UPDATE table1 SET [name] = ?fld2, phone = ?fld3, city = ?fld4 WHERE sno = ?fld1 ENDTEXT