Subject Re: Returning Clause..... :(
Author Cleberson B. Alano
Thank´s Adilson
It´s all ok now !
It´s so dificult find it on web !

Valeu !

Kebe

( Seu nome .. parece ser brasileiro )



--- In Firebird-Java@yahoogroups.com, "Adilson R. Fernandes"
<adilsonrf@...> wrote:
>
> ...
>
> String sql = "insert into Test (name) values (?) returning
id";
>
> FirebirdPreparedStatement stat =
> (FirebirdPreparedStatement)conn.prepareStatement(sql);
>
> try {
> stat.setString(1, "Test");
>
> ResultSet rs = stat.executeQuery();
>
> try {
> if (rs.next()) {
> System.out.println(rs.getInt("id"));
> }
> } finally {
> rs.close();
> rs = null;
> }
>
> conn.commit();
> } finally {
> stat.close();
> stat = null;
> }
>
> ...
>
> Adilson.
>
>
>
> Cleberson B. Alano escreveu:
> > How can I use the "returning clause" inserting data ?
> > The "executeUpdade" return a Result Set ?
> > I search in the web for examples but I´m not found yet !
> > Someboby can help me ?
> >
> > Jaybird 2.1.6
> > FireBird 2.1.0.1
> >
> > Thanks
> >
>
>
>
> [Non-text portions of this message have been removed]
>