User Profile

Collapse

Profile Sidebar

Collapse
pieps86
pieps86
Last Activity: Oct 15 '09, 06:55 PM
Joined: Aug 10 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • pieps86
    replied to ODP.NET OracleCommand.CommandText conversion error
    in C Sharp
    I don't know about that. I am, in fact, debugging to get this error. Using the 'var' keyword is not the issue. I can explicitly declare all types and still get the same result. Nonetheless, using 'var' does not prevent debugging. I'm in VS2008, btw.
    See more | Go to post

      Leave a comment:

    • pieps86
      replied to ODP.NET OracleCommand.CommandText conversion error
      in C Sharp
      Nope, nothing is getting skewed anywhere along the way. I even compared this code with older versions in Team Explorer to see if I could find anything that had been changed recently that would cause this error. Also, the problem only seems to be when I debug the project from within Visual Studio. I can put the DLL with this code in an engine and it runs fine.
      See more | Go to post

        Leave a comment:

      • pieps86
        replied to ODP.NET OracleCommand.CommandText conversion error
        in C Sharp
        C# var

        'var' is new to C# 3.0
        http://msdn.microsoft.com/en-us/library/bb383973.aspx

        Also, it is not including anything abnormal in the connectionstrin g or the commandtext. All quotes are accounted for....
        See more | Go to post

          Leave a comment:

        • pieps86
          started a topic ODP.NET OracleCommand.CommandText conversion error
          in C Sharp

          ODP.NET OracleCommand.CommandText conversion error

          I am running the following lines...

          Code:
                      OracleConnection connection=new OracleConnection("myConnectionStringIsHere");
            connection.Open();
            var startValueParameter=new OracleParameter {ParameterName="@START_VALUE", Value=0};
            var chunkSizeParameter=new OracleParameter {ParameterName="@CHUNK_SIZE", Value=10};
            var command=new
          ...
          See more | Go to post
          • pieps86
            replied to GetInt32 cast problem
            in C Sharp
            GetOrdinal uses min(row_id) because that is the name of the column that is returned. I am using just the int 'min' with GetInt32 because that is the corresponding integer that reader.GetOrdin al("min(row_id) ") returns.

            I noticed that int max looks at the min just after I posted it :)
            See more | Go to post

              Leave a comment:

            • pieps86
              started a topic GetInt32 cast problem
              in C Sharp

              GetInt32 cast problem

              Hello,
              I am querying an oracle database to get the min and max of a field, and I'm trying to do it as efficiently as possible for my C# app. The code I have is as such:

              command.Command Text="SELECT MIN(row_id), MAX(row_id) from my_table t where row_id is not null";
              OracleDataReade r reader=command. ExecuteReader() ;
              int min=reader.GetO rdinal("min(row _id)");...
              See more | Go to post
              No activity results to display
              Show More
              Working...