Re: prepared SELECT - was: runsqlstm

["hwarangron" <hwarangron@xxxxxxx>]

Sorry Rob, for some reason I didn't catch the can be prepared part of your
post.

----- Original Message -----
From: "hwarangron" <hwarangron@cox.net>
To: <midrange-l@midrange.com>
Sent: Friday, July 19, 2002 12:55 PM
Subject: Re: prepared SELECT - was: runsqlstm


>
> C/Exec SQL
> C+ Select * Into :QryExtDs from QryExtFlds
> C+ where QreLink = :Linkno and QreFName = :ShFld
> C/End-Exec
>
> This works without a cursor, but only if there are not multiple records
that
> match the search criteria.
>
>
> > However I don't think a simple
> > select datafld into :Myhostvar
> >  from myfield
> > where primarykey='xyz'
> > Can be prepared and executed without a cursor.
>
> Ron Hawkins
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>