×

Good News Everybody!

The new search engine is LIVE!

Please report any problems to david (at) midrange.com.




i'm developing a handler pgm to replicate a CHAIN to a SQL Select...

so i have done everything i need within my handler pgm to do the sql select
and then what i thought i needed to do to loop back through the namesValues
and update the value, valuelenbytes, and hasnullvalue...

I turn on p_IO.found because my row was fetched from the sql select.

but when it returns back to the calling rpg pgm i get...

A character representation of a numeric value is in error.

the dump shows that the fields for the chain (in which i replicated the sql
select for) are all blank.

what am i missing?

btw, i'm working from Dans tutorial at...

http://m.iprodeveloper.com/rpg-progr...pg-open-access
<http://m.iprodeveloper.com/rpg-programming/create-dynamic-sql-handlers-using-rpg-open-access>

and this part i'm referring to is covered under "Executing the statement"

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2026 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.