Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
IIF and FSIZE in SELECTs
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?
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement