[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: JDBCR4 question



Folks..  this question isn't related to FTPAPI or HTTPAPI.  Let's talk 
about it on one of the following forums:

    http://forums.systeminetwork.com

    http://lists.midrange.com/mailman/listinfo/rpg400-l

I would prefer the former.  (Especially since the question is about a 
tool published via System iNetwork.)

Thanks!


On 2/11/2011 10:56 AM, Gerald Magnuson wrote:
>
>     Excuse me, probably the wrong place...
>
>     I just created a program using JDBCR4 connecting to a MSSQL server.
>
>     What I have works, but I would like to improve it...
>
>     I just need to know I have a record, I don't need to return a result
>     set...
>
>     What Can I do instead of jdbc_nextRow?
>
>
>     My Code:
>
>       // Prepare SQL statement string to return drawings
>
>         prepstm = JDBC_prepStmt(conn:'SELECT dbo.docPub.DocId, ' +
>
>            'dbo.docPub.CurrentRevId, ' +
>
>            'dbo.docPub.Name, ' +
>
>            'dbo.docPub.Path  ' +
>
>            'FROM  dbo.docPub '  +
>
>            'WHERE dbo.docPub.Name = ? ') ;
>
>
>         if (prepstm = *NULL);
>
>           jdbc_close(conn);
>
>           return;
>
>         endif;
>
>
>         JDBC_SetString(prepstm:1:IDRAW) ;
>
>
>       rs = jdbc_ExecPrepQry(prepstm);
>
>
>       $Count = 0 ;
>
>       dow (jdbc_nextRow(rs));
>
>         $Count += 1 ;
>
>           Leave ;
>
>       enddo;
>
>
>     Gerald Magnuson
>
>     Supervisor, System i Adminstration&  Development
>
>     IBM Certified Specialist, i5 Administration
>
>     The Knapheide Manufacturing Company
>
>     Quincy, Illinois
>
>     (217) 592-5291
>
>
>
>
> -----------------------------------------------------------------------
> This is the FTPAPI mailing list.  To unsubscribe, please go to:
> http://www.scottklement.com/mailman/listinfo/ftpapi
> -----------------------------------------------------------------------

-----------------------------------------------------------------------
This is the FTPAPI mailing list.  To unsubscribe, please go to:
http://www.scottklement.com/mailman/listinfo/ftpapi
-----------------------------------------------------------------------