Search results

Hi, Can anyone please tell me if we can a select statement to find the constraints. To be clear, will this work in Access, it works in oracle SELECT u2.table_name FROM user_constraints u1, user_constraints u2 WHERE u1.table_name = 'PART' AND u2.r_constraint_name = u1.constraint_name And...

Hi, Can some one please tell me how I can use a delete query. I have the following code, but it does not work. Please let me know where I am going wrong --------------------------------- Dim StrSQL As String StrSQL = "Delete FROM PLANT WHERE PLANT_CODE = ' " & PLANT_CODE_txt & " ' "...

URGENT!!!!delete child record and later delete the parent record Hi, I am using a for to delete records from the tables in access 2000 that are linked to oracle 9i. Now, I am trying to delete the child records from other tables, then the user tries to delete the parent record from the parent...