Problem With Oracle NUMBER(1) column.

Results 1 to 3 of 3

Thread: Problem With Oracle NUMBER(1) column.

  1. #1
    NeedsHelp Guest

    Default Problem With Oracle NUMBER(1) column.

    I am retrieving data from an Orcale DB. One of the fields<BR>I am retrieving data from is defined as NUMBER(1). I can retrieve other NUMBER fields with different lengths. However<BR>for this field I can not retrieve the data it is returning<BR>a non valid VB type (I tried using TypeName on the retrieved field) every time I attempt to evaluate the field in an expression the app crashes. Has any one ever heard of this before?<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Problem With Oracle NUMBER(1) column.

    First port of call is to use the SQL plus interface to test whether you can retrieve data from the database directly.<BR><BR>If this works then try Response.Write your value to the screen before you try to evaluate it.<BR><BR>If this works then use cint function before you evaluate it.<BR><BR>If none of these work consider changing the length to maybe 2, it shouldn&#039t effect tablespace dramatically.<BR><BR>Failing that you &#039ll have to post up a bit more info:-<BR>error message<BR>the code where you are performing the evaluation<BR><BR>Good luck<BR>James

  3. #3
    You Guest

    Default Thank


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts