Re: Column size

 Message from: TL_TL 

OK, seems like the table was refreshed during the night, because today I'm getting all the text from that field.
Please someone tell me what I have to do to  save changes / refresh it by my self...

Thank You,
TL.

_______________________________________

Historical Messages 


Author: Talia
Date: Mon Oct 31 04:06:20 PDT 2011
OK, seems like the table was refreshed during the night, because today I'm getting all the text from that field.
Please someone tell me what I have to do to  save changes / refresh it by my self...

Thank You,
TL.
__

Author: Talia
Date: Sun Oct 30 12:01:18 PDT 2011
Hello,
I have a column (varchar2) that was 15 bytes and later I changed it to 30 bytes.
When I open the "columns" tab, I see that the size of the column is 30.
BUT, When I'm trying to retrieve data from this table from my application, I get the first 15 chars of the text that stored in that field, and not the complete text.
Seems like I need to refresh the table structure somewhere...

Please any help...

Just in case it will help, there is the code I use to retrieve the data (C#): 

 String  strQuery2 =  String .Format( "SELECT * FROM tblSourcesScheduler WHERE strSourceName='{0}'" , strSrcName);
 OracleConnection  oraConn =  new   OracleConnection (strConnString);
 try { oraConn.Open();
 cmd =  new   OracleCommand (strQuery2, oraConn);cmd.CommandType =  CommandType .Text;   dr = cmd.ExecuteReader(); dr.Read(); if  (dr.HasRows)   { setSchedulerValues( dr[ "strWeekDays" ].ToString(),   dr[ "strHours" ].ToString(),dr[ "strMinutes" ].ToString()   ); } } catch  ( Exception  exp)   { } finally { oraConn.Close(); }


Thanks, TL.
__
_______________________________________