I used to read a DBF file via ODBC, but as soon as I name one field is named 'Status' I get an ODBC error.
| if (AANWEZIG ='0', 'In depot', |
| if (AANWEZIG ='1', 'Verhuurd', '')) AS Container.Hist.ContStatus, |
| if (AANWEZIG ='0', 'In depot', |
| if (AANWEZIG ='1', 'Verhuurd', '')) AS Container.Hist.Status, |
The second option would result in an "OBDC read failed" error. When changed to Container.Hist.Status2 it works fine.
Is the word ".Status" a reserved work in any case? Would the period 'matter'; I though the period would help to define a unique name.
P.s.
| AANWEZIG | AS Container.Hist.Status, |
would result in the same eror. The problem is not in the equation.
