Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by swguynos
-
Creating a Remote View with IIF()
Mike, This is the where condition I am using currently in the VFP Local view WHERE Iif(?rnApp=1, .T., tblHeader.iappid=?riAppId) I want to use the same expression in a remote view with SQL backend. Can you please tell me what is the right syntax using Case...When..End ? When I tried...- swguynos
- Post #7
- Forum: Microsoft: FoxPro
-
Creating a Remote View with IIF()
MikeLewis, You are right and I know that. But as I said, using case..when..end in my query for the remote view did not work. Can you point out the right usage with the example I had on my original thread? Thanks- swguynos
- Post #5
- Forum: Microsoft: FoxPro
-
Creating a Remote View with IIF()
This is a remote view. SQL Server does not like IIF() or ICase().- swguynos
- Post #3
- Forum: Microsoft: FoxPro
-
Creating a Remote View with IIF()
Hi, I have a VFP remote view that has a where condition that says something like. WHERE Iif(?rnApp=1, .T., tblHeader.iappid=?riAppId) (and similar ones .....) I read that IIF() needs to be replaced with Case statements. I tried it, but does not seem to work. Has anyone dealt with a...- swguynos
- Thread
- Replies: 7
- Forum: Microsoft: FoxPro
-
Querying Multiple Rows into One Row
Use the Xtab program to generate what you want.- swguynos
- Post #3
- Forum: Microsoft: FoxPro
