|
You can do this: * declare cursor C/Exec sql C+ Declare myCursor cursor for P1 C/End-exec * prepare the sql statement C/Exec sql C+ Prepare P1 from :Sqlsmt C/End-exec C/Exec sql C+ Open myCursor C/End-exec -----Original Message----- From: THarteau@xxxxxxxxxxxxxxxxxx [mailto:THarteau@xxxxxxxxxxxxxxxxxx] 0117.04 C EVAL SelSmt = 0117.05 C 'SELECT * FROM JTD WHERE JDJBT# = :JOBNO' 0117.07 C EVAL SqlSmt = 0117.08 C SelSmt + 'ORDER BY ' + L1Fld + ',' + L2Fld 0117.09 C + ',' + 'JDPROD' I'm not sure how to now set up the declare. Any ideas?
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact copyright@midrange.com.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.