Re: Net.Data - extra blank rows and an SQLSTATE 22003

Nathan,

It works fine in STRSQL...

The only returning two colmns right now, a CHAR(20) and a VARCHAR(60)

I take a param from the user and use it in the SQL.

So far, every time the query results in 1 row, I see that row, a bunch of
blanks and the error. It doesn't matter if I use the default report or a
custom one.

When the parm value results in multiple rows, it works fine.

Charles

On Thu, Oct 23, 2014 at 4:49 PM, Nathan Andelin <nandelin@xxxxxxxxx> wrote:

Nice to see a fellow Net.Data user emerge from the closet ;-)

Just a suggestion that you test the SQL statement via Navigator or STRSQL
first, before inserting it into a Net.Data macro. Look for data types that
may not be converting from say Date to Character, or something along those
lines.

Nathan.
--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.