|
I have a need to pass a string to a procedure that will execute an SQL
statement.
Is there a way to include a numeric field with this? I've tried a few
things, buy they've been unsuccessful. I've done this is the past, but can't
locate the example.
In the below example, fields 2 and 5 are numeric. This example fails:
c eval sqlstmt = %trim(sqlstmt) +
c %trim(insert) + ' ' +
c ' ' + %trim(filnam) +
c ' ' + %trim(fields ) +
c ' VALUES(' +
c Q + Value1 + Q + ',' +
c Value2 +
c Q + Value3 + Q + ',' +
c Q + Value4 + Q + ',' +
c Value5 +')'
TIA,
Matt
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.