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

[Charles Wilt <charles.wilt@xxxxxxxxx>]

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.