Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to create flexable package
Message
 
 
À
23/09/2004 13:24:33
Information générale
Forum:
Oracle
Catégorie:
Paquets
Divers
Thread ID:
00940366
Message ID:
00945456
Vues:
24
What SQL code are you sending to the server and how are you passing pdCurrDate? pdCurrDate should be a PRIVATE variable in VFP. You SQL should look something like:
PRIVATE pdCurrDate
pdCurrDate = some_date && must be a date datatype
TEXT TO lcSQL TEXTMERGE NOSHOW PRETEXT 1
   BEGIN PackageName.ProcName(pdCurrDate=>?pdCurrDate); END;
ENDTEXT
lnSuccess = SQLEXEC(GetHandle(), lcSQL)
>Hi Mark,
>
>Nope, that produced the same error. The following works with either of the above. But it's straight without the flexability.
>
>SELECT RTRIM(PERS.LAST_NAME) || ', ' || RTRIM(PERS.FIRST_NAME) AS EMP_NAME,
>  PERS.PERS_NO
>FROM EMP,
>  PERS
>WHERE EMP.PERS_NO = PERS.PERS_NO
>  AND (EMP.OUT_DT IS NOT NULL AND EMP.OUT_DT < pdCurrDate)
>  AND EMP.HRS_BASE = 0
>ORDER BY 1;
>
>
>And it's definately on the "EMP.OUT_DT < pdCurrDate" part. Because without that, the orginal flex query works
>
>Mike
Mark McCasland
Midlothian, TX USA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform