You get the dummy entry because SELECT SQL evaluates once all field expressions before any record selection only to establish the output structure. So, if you use a UDF function in the SELECT SQL, the UDF will be evaluated once at the beginning to get the structure. You can deal with this case inside the function.
Vlad
>This is close to what you want. If you include record 1 and record 2 has the same staffid, you will get a double entry. So I put a dummy record for record 1. I didn't have time to figure a better sloution.
>
>Hope this helps
Précédent
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