>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
Doug... I didn't think you could use CASE in SQL pass through... I am in shock that that works...
It sounds like you have a complicated enough 'query' to perhaps write a back end stored procedure to generate the record set.
BOb
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