1. my Java codes generates a query --> delete from 'emp' , but i need it as delete from emp stackoverflow.commy Java codes generates a query --> delete from 'emp' , but i need it as--> delete from emp. Please help me |
2. my Java codes generates a query --> delete from 'emp' , but i need it as--> delete from emp. Please help me stackoverflow.commy Java codes generates a query --> delete from 'emp' , but i need it as--> delete from emp. Please help me |
3. XML as data store. Insert, remove, delete stackoverflow.comI was planning to use XML to store the data for a Java DVD database application I'm writing. I know that the word "database" is right there in the title, but ... |
4. Delete rows with conflicting times using jdbc-odbc stackoverflow.comI wasnt quite sure how to word the title so sorry about that. I am trying to load some start and stop schedule times into a database but sometimes a start ... |
5. How to stop iBatis commiting inserts, updates and deletes? stackoverflow.comI have a problem using iBatis as database framework for a web application. I want to manually commit the transaction after a couple of inserts, but iBatis auto commits it after ... |
6. Netbeans program to access an Access Database insert, update and delete forums.netbeans.orgHi everyone I am having some issue what i am trying to do is a simple database that lets a volunteer logon using just their First and Last name then push a Clock in button or a Clock out button. the database has first name last name clocked in clocked out and hours fields (note the names i use here are ... |
7. Netbeans program to access an Access Database insert, update and delete forums.netbeans.orgHi everyone I am having some issue what i am trying to do is a simple database that lets a volunteer logon using just their First and Last name then push a Clock in button or a Clock out button. the database has first name last name clocked in clocked out and hours fields (note the names i use here are ... |
8. update the table after deleting and editing? coderanch.com |
9. How to define CASCADE DELETE and CASECADE UPDATE? coderanch.com |
10. I can select, insert, update but not delete.. please help coderanch.comHi everybody, My problem is that I can Isnert, Update, and Select from my databse but canot delete. I get always this Exception when I try to delete: ===== DE ACTION NU IS: DELETE java.sql.SQLException: Syntax error or access violation message from server: "Yo u have an error in your SQL syntax; check the manual that corresponds to your My SQL ... |
11. delete from select query coderanch.comHi I have a user table thats related to many tables... i need to delete all the data that's related to that user and data which are related to those tables etc... the thing is there's over 100 tables that i need to delete from... isn't there an easier way to delete everything related to that user without deleting the data ... |
12. Design question - update + insert versus delete + insert coderanch.comHi, I have a design dilemma here. I have a 2D array coming from my front end. array[0][0] = "abc" .... array[0][2] = "bcd" .... array[5][0] = "xyz" .... array[5][2] = "xxx" My database table workSpec structure looks like this (there is no limit on the number of rows and columns) item Row Col Value 1230 0 abc 1230 1 abc ... |
13. automatically delete or insert coderanch.coma good solution for this job , in case that your database support Triggers is to use before Insert and after Delete trigers. you may set these triggers to be fired when you insert a row into that main table to insert the same row into the secondary table . also on deletition of a row from table one you can ... |
14. update/ or delete & insert, question of attitude coderanch.comHi guys, I have a question of attitude: I have a list of empl (group, name, address) and they all belong to a group (eg Accounting). GUI: the user sees on the screen a list of all empl belong to accounting (there are ~ 50) now he wants to click update (cause for some of them he made some changes in ... |
15. problem with update and delete though insert and select working fine coderanch.comHi all, I am facing problem when I am trying to update the data base or when i am trying to delete a tuple. ***************************************************** Plese finf my update string below private final static String UPDATE_TUPLE_STMT= " UPDATE ABC SET A= ?,B = ? WHERE C= ? AND D= ? AND E= ? AND F= ?"; ******************************************************* Pealse find the method ... |
16. Deleting duplicate rows using sql query coderanch.comI have a requirement to delete rows using sql query in oracle database. Actually for instance i have employee table having empname and emplocation. When i write the sql statement as "select * from employee" i get the below results empname emplocation user1 india user2 india user1 india user1 india user3 india user1 india user2 india i have a requirement to ... |