Last post Sep 29, 2010 03:08 AM by Mobzam
Sep 29, 2010 02:31 AM|Mobzam|LINK
I have a table in orcale database where I am inserting records. I am able to insert a record in a table but it is not being saved permenantly.When inserting there is no error. what could be causing this?
Sep 29, 2010 02:41 AM|mosbah|LINK
write (Commit;) after your insert query
in order to save your change ondb
Sep 29, 2010 02:49 AM|Mobzam|LINK
I have done that and it is giving message that added successfully but the record is not being saved permenatly. In the words it is still the same.
Sep 29, 2010 02:53 AM|mosbah|LINK
do you run query directly using oracle or you have the problem only in your code
Sep 29, 2010 03:08 AM|Mobzam|LINK
I am sql statement is ok. Check it below.
INSERT INTO sb_student (Firstname, Surname, Grade)
VALUES ('"+ Fnametxt + "', '"+ Snametxt +"', '"+ Gradetxt +"');