Function IIF in ADP

  • Thread starter Thread starter Jose Perdigao
  • Start date Start date
J

Jose Perdigao

In MDBi use IIF function. How can I use this function in ADP ( view or sp)?
There is a similiar function?
Thnks
José
 
SELECT Table.Field1, CASE WHEN Table.Field = Krit THEN Value1 ELSE
Value2 END AS IIfVal FROM Table WHERE...

Greetings from Würzburg

Gerhard
 
Thanks Gerhard,
It works but is more complex and we spend more time than function iif in mdb
Regards
Jose

SELECT Table.Field1, CASE WHEN Table.Field = Krit THEN Value1 ELSE
Value2 END AS IIfVal FROM Table WHERE...

Greetings from Würzburg

Gerhard
 
Hi Jose,

IMHO the T-Sql CASE function is better of Jet's IIF function

see the Examples
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Call stored procedure in SSMS from Access 2016 doesn't work. 0
Hide views, sp and functions 3
Convert MDB to ADP 10
Add icon in ADP programmatically 5
Editing Views from ADP 8
IIF in MS Access Reports does not work in ADP Reports 1
SQL Function not returning same value over ADP 1
New to ADP 3

Back
Top