Why does this basic select query throw exception in foxpro?

Question

My simplified query is as follows.

select CustomerName as custname from customers where custname='Hey'

It says Column custname is not found. How can I handle this?

In sql it does not throw any exception and accepts custname as a column.

(In fact my query is more like select IIF(...,...,...) as name from customers where custname='Hey' than the above one.)

Answer 1

Try change the column name. In many languages the "name" keyword is reserved

Edit

With the new query, try this:

select IIF(FPOLDOVTiP=0,99,FPOLDOVTiP) AS doviz from pol where IIF(FPOLDOVTiP=0,99,FPOLDOVTiP)=99

You can't use calculated fields on where clause.