We help IT Professionals succeed at work.

how to insert parameter value in table

kg6lfz
kg6lfz asked
on
92 Views
Last Modified: 2017-03-20
I want to delete a record using parameter. I can delete from one table, but I need to delete it from 2 tables. So, I want to copy the parameter value in a temp table and delete it by inner join from each table. How can I insert parameter value in a table? Thank you very much in advance.

PARAMETERS [Enter Invoice:] Text (10);
Insert Into tbl_temp
Comment
Watch Question

CERTIFIED EXPERT

Commented:
1- if the tables are related then you can setup the relationship in such a way that it should auto delete all linked records.
2- if they are not related then why not use two delete statements, one for each table?
CERTIFIED EXPERT
Most Valuable Expert 2015
Distinguished Expert 2018
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.