>Has anyone duplicated (or failed to duplicate) common VFP functions as SQL 2000 UDFs? Looks like a good way to easy the transition of VFP views which are littered with IIF(), NVL(), etc.
Dan, what you really need to do is get to know the built-in SQL2K functions. Look at ISNULL (check_expression , replacement_value) as a substitute for NVL(). SQL has an IIF() function which is the same as VFPs, and also a CASE statement for inline evaluaitons.
Précédent
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