Bob ----

Check what you're doing carefully. I tried both code examples with a non-existant field and got SQL column 'myfield' not found in *both* cases.


>I want to create a cursor with known fields from one with unknown fields. Suppose cursor In does *not* have the field myField:
>
>When I try:
>SELECT IIF(FSIZE('MYFIELD','In')=0,'Default',In.myfield) AS outfield;
> FROM In INTO CURSOR Out
>
>I get "SQL field myfield not found"
>
>However, if I leave out the alias:
>SELECT IIF(FSIZE('MYFIELD','In')=0,'Default',myfield) AS outfield;
> FROM In INTO CURSOR Out
>
>...it works.
>
>I'm nervous about this. Is it robust to use the second technique?