Paige:
Read this entire threadMore specifically, if only calling a SP:
lcSQL = "{call MyStoredProc;}"
lnresult = sqlexec(lnHandle, lcSQL, "crsPermit")
>Hello All,
>
>How would I call an Oracle process or function from VFP? I can use ADO or SOL-Pass Thru to process the Oracle data but I'd like to run an existing Oracle process/fuction to "filter" the dataset first. TIA.
>
>Regards,
>
>Paige
Mark McCasland
Midlothian, TX USA