Re: Values of a Oracle table in C++
Date: Wed, 5 Aug 2009 02:27:17 -0700 (PDT)
Message-ID: <107ccc58-bddd-4762-abd7-7acff5b55001_at_c34g2000yqi.googlegroups.com>
On 4 Ago, 18:36, joel garry <joel-ga..._at_home.com> wrote:
> On Aug 4, 12:21 am, ilbmbo <ilbi..._at_gmail.com> wrote:
>
>
>
> > On 3 Ago, 22:31, TJ Bandrowsky <tbandrow..._at_treatyist.com> wrote:
>
> > > On Aug 3, 6:03 am, ilbmbo <ilbi..._at_gmail.com> wrote:
>
> > > > hy, i'm writing a software in c++ (Visual Studio 2008) for use a
> > > > oracle database and his table.
>
> > > > I used this code to select a table of my Db but i don't know how i can
> > > > see the Vales of the row:
>
> > > > String^ queryString = gcnew String ("SELECT * FROM
> > > > PROVA_LUCA.AFTBSKDA8");
>
> > > > System::Data::OracleClient::OracleCommand^ command = gcnew
>
> > > > System::Data::OracleClient::OracleCommand(queryString,conn);
>
> > > > try
> > > > {
>
> > > > System::Data::OracleClient::OracleDataReader^ reader =
> > > > command-
>
> > > > >ExecuteReader();
>
> > > > while (reader->Read())
> > > > {
>
> > > > "here i can using the values of any rows but i
> > > > don't know the mode."
> > > > }
>
> > > > can you hepl me?
>
> > > If you are writing in C++, have you looked at the OCCI C++ native
> > > classes that Oracle has to use for client connectivity? It looks to
> > > me like you are using .NET as your C++ target...
>
> > hy,
>
> > I have all the value of my table (in Oracle Database) in the reader,
> > but i can only read the value one at one (sorry for my english) with
> > this command:
>
> > String^ dati = gcnew String(this->ogg_textBox_errori->Text);
>
> > isn't possible to create a new table with all the value of my original
> > Db table????
>
thanks for help, i was successful to use datatable with my query result.....
see you in my next problem...eheh
thanks a lot
> There is a variant of the create table SQL command called CREATE TABLE
> AS SELECT. So if you have some sort of selection criteria, you can
> pass the command create table <newtablename> as select * from
> <oldtablename> where <various conditions>; and it will propagate the
> various internal definitions of the old table to the new table.
> Whether you have the privilege to do this, or really want to do this,
> is another issue.
>
> Perhaps you can try to make more clear exactly what you are trying to
> accomplish?
>
> jg
> --
> _at_home.com is bogus.http://www3.signonsandiego.com/stories/2009/aug/04/1b4bofa211316-bofa...
Received on Wed Aug 05 2009 - 04:27:17 CDT