Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to create flexable package
Message
 
 
To
23/09/2004 13:24:33
General information
Forum:
Oracle
Category:
Packages
Miscellaneous
Thread ID:
00940366
Message ID:
00945456
Views:
25
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform