Does anyone know how I can use iif in this statement?
This is a foxpro code that works,

SELECT esm_namf as First_Name, esm_naml as Last_Name, ;

[<a href="View.rep?esm_id=] + TRANSFORM(esm_id) + [">View</a> | ] +;

[<a href="Create.rep?mode=edit&menu=1&esm_id=] + TRANSFORM(esm_id) +[">Edit</a> ] as action;

FROM TEsm ORDER BY First_Name ASC;
INTO CURSOR TQuery

But I have a problem:

if the esm_id=1 I want to show
[<a href="View.rep?esm_id=] + TRANSFORM(esm_id) + [">View</a> | ] +;

but if esm_id is not =1 I want to show both
[<a href="View.rep?esm_id=] + TRANSFORM(esm_id) + [">View</a> | ] +;

[<a href="Create.rep?mode=edit&menu=1&esm_id=] + TRANSFORM(esm_id) +[">Edit</a> ] as action;

This is a foxpro program, but maybe some sql programer can resolve for me.

I tried to use iif in several ways but I couldn't resolve.

Thanks
Kon

Hi, I have already resolved the problem above.
But I have another one

I have the source code:

SELECT esm_namf as First_Name, esm_naml as Last_Name, ;
IIF(esmid == esm_id, ;
[<a href="ViewEsm.rep?esm_id=] + TRANSFORM(esm_id) + [">View</a> | ] +;
[<a href="CreateEditEsm.rep?mode=edit&menu=1&esm_id=] + TRANSFORM(esm_id) + [">Edit</a> ], ;
[<a href="ViewEsm.rep?esm_id=]+TRANSFORM(esm_id)+[">Kon</a>]) as action;
  WHERE esm_id > 0 FROM TEsm;
  ORDER BY First_Name ASC;
  INTO CURSOR TQuery

When esmid is equal as esm_id the program should show this 2 links

[<a href="ViewEsm.rep?esm_id=] + TRANSFORM(esm_id) + [">View</a> | ] +;
[<a href="CreateEditEsm.rep?mode=edit&menu=1&esm_id=] + TRANSFORM(esm_id) + [">Edit</a> ], ;

BUUTTT it's just showing the first one (View), never the Edit one appears.

Does anyone knows why?

Thanks again
Kon

What code are you writing here?

What are all the [ and ] all about in your code?

You are using a + when you should be using a & if your are trying to write ASP. If so replace:

[<a href="ViewEsm.rep?esm_id=] + TRANSFORM(esm_id) + [">View</a> | ] +;
[<a href="CreateEditEsm.rep?mode=edit&menu=1&esm_id=] + TRANSFORM(esm_id) + [">Edit</a> ], ;

With:

<a href="ViewEsm.rep?esm_id="<%= TRANSFORM(esm_id) %>">View</a>
<a href="CreateEditEsm.rep?mode=edit&menu=1&esm_id=<% = TRANSFORM(esm_id) %>">Edit</a>

Should this post be in the SQL section of the forum? I cant see an SQL related problem here. Sorry if I have completely mis understood and mis read your post

Wind is your friend
Matt