asked on

Function Needed

I need a function that will delete records from X number of tables with a common uniqud id.

For instance, I have 4 tables - photos, items, stats, equipment

each of them has a field called equipment_id (which is the primary key).

Now, I want to have one function where I pass the id and it deletes all in a table with that id. Those table names are just a sample, in the function I need to be able to pass the names.

Please remember, the Number of tables I will pass to the function will vary.

Thanks!!

SOLUTION

Harisha M G

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

TeRReF

I think mgh_mgharish's solution is very good, but if you insist on only passing the primary key to your function, it becomes more complicated, but doable.
I've written a similar function for a client (It is copyrighted code, so I can't give it to you unfortunately).
What I did was
A show tables query and use that result to loop through al the tables with a describe query. Use that result to check if primary key exists and perform the appropriate action on that table.

Hope this will help

edvinson

ASKER

Very close to what I need, mgh_mgharish .

And thanks fot the tips Terref.

Here's how I would *like* to call the function:

deletefromtables("myuniqueidFieldNameHere",myUniqueValueHere,"photos","items","stats","equipment");

ASKER CERTIFIED SOLUTION

mensuck