The value is a field in the query [in this case wkdsr.pay_type]. I did not think I could pass an IIF to SQL Server through SQL Passthough? Right now, I am passing a CASE statement within the SELECT statement that is executing properly, but I need another CASE statement nested inside the other CASE statement. [The original code was VFP6 for local data and used nested IIF statements. This is what I am trying to replace as we move the system to client/server.]
Thanks again for your help.
Doug
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