Recent content by swathin

Hi, Thanks for your reply. I have one more question, when we use the user_constrains , I get a set of tables that are related, how do I read them one by one to do a dynamic deletion on each table Like say the code that you posted before returns 4 tables and they are plant supplier order...

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 Guys, Thanks for the reply. It worked.Now coming to my next question And if we are using multiple delete queries should we have the DoCmd.RunSQL <variable> after every delete statement or is it after all the statements I need this because, I am trying to delete all records in the child...

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...