|
C/Exec SQL C+ Select * Into :QryExtDs from QryExtFlds C+ where QreLink = :Linkno and QreFName = :ShFld C/End-Exec This works without a cursor, but only if there are not multiple records that match the search criteria. > However I don't think a simple > select datafld into :Myhostvar > from myfield > where primarykey='xyz' > Can be prepared and executed without a cursor. Ron Hawkins
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 [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.