General information
Forum:
Microsoft SQL Server
Hi Mike:
I have not been able to accomplish what I want to do is SQL yet, but that is OK. I will get it eventually.
I have been doing some more reading and think I know exactly what I need to do. I believe my question is a lot more precise than last time.
The only problem is the CODING to make it happen.
Here is what I am trying to do:
1. create a stored proceedure in SQL
2. call this newly created stored proceedure from the recordset design time control property box in Interdev.
3. set the paramater once I am there
OK: What I need to learn how to do is write the code for the stored proceedure, to create the paramater I am trying to pass.
Goal:
I simply want to pass the value in my njuris_id field of my jurisdictions ASP/form to my njuris_id field of my country_assign ASP/form. Period.
Can you help me with this code? If so, here are the specifics, and maybe you can show me exactly how you would construct the code.
Example: Let's say I am on the following record in my jurisdiction ASP/form:
njuris_id 17
cjurisname USA
cjuristype Country
I want to click my command button on my parent form and have it open up my child form and have it look like:
suborassign_id 1
njuris_id USA, 17 &&this is where I am trying to pass the variable/parameter. The USA will be displayed, but it will be "reading" the 17.
cjuristype "blank" awaiting input
I just need help contructing this stored proceedure in SQL, to make this happen.
If you can help me with the coding to do this, I would really appreciate it.
thanks Michael.
I appreciate your comments made earlier. After reading the stuff I wrote to you , it didn't come across very clear, so I think I did a much better job asking you what i need in this post..... I hope! I promise I will not ask another question posted directly towards you on this particular issue. I certainly do not want to wear out my welcome on this thread.
tia
jason
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only