write stored procedure with 'if else'

[shital]

hi,
Hi all,



I want to write a stored procedure in MS Access 2007, which will have 'If else condition'

example:

if (@flag=0)
Select * from Table1;
else if (@flag=1)
Select * from Table2;
else
Select * from Table3;

How can i write the Stored Procedure in MS Access 2007, which will give me the above output?

Thanks in advance....

[maximus]

the quetion that I would like to ask here is what are you trying achieve:

here is a simple example:

I have a text Box Text1 based on its value i will change the row source of a Combobox in the form Combo1. The code is attached to a command button:

Dim strSQL as String

If Me.Text1=1 then
strSQl="Select * From Table1"
elseid Me.Text1=2 then
strSQL="Select * From Table2"
Else
strSQL="Select * From Table 3"
End if

Me.Combo1.RowSource=strSQL

[shital]

hi,
in above query 'flag' will be assigned runtime in c#.net application and Access is my backend.
As per the 'flag' value i want to fetch data from different table.

[Peter M]

If you only have two options then If ... Then .... Else ... End If would work but you might want to use the Case statement instead.

Select Case varflag 'Go to the "Case based on the varFlag value

case 1
select * from Table1

case 2
select * from Table2

case 3
select * from Table3

case else
msgbox "Invalid Flag!"

end select


Peter

[Gicu]

Hi!

Would you please explain some more about your intended use of this. Access doesn't really have stored procedures, you will probably need to use VBA. How do you intend to call this from your c#.net application? What do you except it to return (ADO recordset, DAO recordset)?

Cheers,
Vlad

[Micron]

maybe don't expect too many responses. The last post before this recent activity was almost 8 years ago?

[Gicu]

Thanks Micron, never really looked at that until now....

[Micron]

Maybe anything this old that isn't archived somehow (like the ones marked Solved) should be automatically. IMO nobody ought to be restarting something this old, even if you're the OP. This is one of many that I've clicked on that I wish the OP would mark so that we're not wasting time looking at solved (or in this case, outdated) stuff. Don't know what view you like to use, but in "New Posts" list, the number of views is a clue. This one is over 2,800 as of today.
BTW, you're not the first!

[Peter M]

My apologies! - I never noticed. It was near the top (not sure how my view is sorted - I'll check!) but sounded like something that I could contribute to. I'll check the dates from now on!

[Micron]

No apologies needed. That didn't come across right. I had hijackers and the op in mind, not the likes of you and me. Pretty sure I'm guilty of the same thing.