Recent content by newssis

Hi all, I am trying the aspect to create something like following: I have combo list box to populate the data. But how can i make it to update or insert new records? for example. one vendor id can have multiple code listings but all listing need to be seperat in database. so when i select...

but it will be user application. How i know that data has been saved or not i keep want user to see data but cannot change it. Only new entry needs to have textbox enabled. thanks Pat

Hi, Sorry for confusion. I would like to knwo that how can i disable for user to modify it. In new entry they can entre the data. But once data enter in to htat vendor number filed or text box then they cannot change it again. not even in modify option. But i would still like to see data in...

Hi , I have text box in the C# application form. I would like to have it gray out for everything other than new entry. How can i set up properties like that? Please help? thanks Pat

Hi all, Please advise the steps i need to follow to upgrade from oracle 9.2.0.1 to 9.2.0.6 or apply the patch!! I ran the setup but when i check v$version but it still says 9.2.0.1 please help. thanks Pat

Hi all, I am confuse totally now. I the system which was prebuild and now i have to support and get data. I have DB instance name testep1 and when is do select * from globalname it gives me testet1.. then i tried querying select * from v$database it gives me testep1 and then again when...

Hi all, I have data in table like this : c:/file/datapart/datafile/filename.xls and only want to return filename.xls or any other file extension but not whole path. how can i do that. Thanks Pat

Hi all, i have this statement in procedure and want to do this. if ( exists(select id from table1, table2 where table1.id = table2.id) beging update t1 set col = col . . . from table t1, table t2 where t2.id = t1.id -- I want to send email total count of update end else insert into...

error i get is the file not exist. but the file (any excel) file is process and then it looks for next fine which is not exist. so at then package need to quit succesfully!!

Hi all, I have package that works fine. the process it is doing is: it process the excel file and i have for loop in that. once as the process runs on files it also put file to archived folder. but the problme happens that it fails everytime when it cannot find the file in the source folder. I...

hi how can i know when and what time user was locked? Please help!!

Hi all, I would like to know if i would be able to fill the color in text box as the value of column. Such as I have 4 text box in line. each from 1-25, 2nd 26-50, 3rd 51-75, and 4th 76 -100 range. I want to color the text box as if the value is 24% then color the text box 1 with red.. and...

Hi all, I am trying to create SSIS package from the file attached. But Having problem how to start and import data. There are several(3) tabs or tables in the file and have to import in to DB. also how can i do that so the import will start from the data starting? Please guide and help please!!!