Recent content by deulyd

Hi, I am trying to write a Service application that will have a list of events like that : 2007-08-08 11:00:03 Event 01 2007-08-08 11:00:15 Event 02 2007-08-08 11:00:35 Event 03 2007-08-08 11:00:48 Event 04 ... (can have up to a 1000 entries) I want to raise a MessageBox on the exact...

Thank you sooo much... I never realized that! :) Daniel

Hi, I am trying to pass the Args variable of the Main to another method in the class like that : static void Main(string[] Args) { ParseArguments(Args); } private void ParseArguments(string[] aArgs) { MessageBox.Show("parse"); } But I'm getting that error when compiling : "An object...

Thanks all, I found what was the problem. Windows program for unzip. It was a new server and winrar wasn't installed yet. Cant believe that, windows unzipper filters the exe files!!!! Deulyd

Hi Mufasa, thanks for the quick answer... In the readme file its written : "Start Oracle Universal Installer release 10.1.0.4 located in the unzipped area of the patch set. For example, Oracle_patch\setup.exe." There is absolutely no exe file in the unzipped 238Mb zip file downloaded. I...

Hi all, I am trying to updgrade our 9.2.0.1 Oracle Database to 9.2.0.7 on a Windows Server 2003 OS. I downloaded the Patch "p4163445_92070_WINNT" from Metalink. When I read the readme.html it says that I need to use "Oracle Universal Installer 10.1.0.4" that is included in the package. It is...

Again, that's not it... :/ lets say you got the FieldName inside a variable (sFldName) and you want to access the :NEW value for that field. Is there any way to call something like : x := :NEW.sFldName Thanks Daniel

Hi Mufasa, Its not what I meant... Its just that I need to store new values in an XML string when updating, so I want to check every field values in the :NEW to exclude NULLS. So I create a cursor to get all fields names of the table then I want to access :NEW.sFieldName to verify if null­...

Hi, In a trigger using the :NEW, is there a way to access the value of :NEW with a variable instead of a fieldName. Ex : x := 'FLD1'; :NEW.x -- instead of doing this :NEW.FLD1; Thanks Daniel

Hi, I'm trying to extract the advanced properties of a file to get jpg information such as IsoSpeed, Camera Model, Date Picture Taken, etc. I tried with the fileSystemObject and the dsofile.dll but cannot get them. Anyone has a hint? Thanks Deulyd

Hi guys, thanks to try but those are still too slow! :/ What I did finally is I created a vb app that gets all VERSIONID to delete into a recordset. Then I group all the VERSIONID by group of 20 in an array Then I just run this the amount of time we got 20 versions : delete from LIMSVERSIONS...

Thanks for the lighning quick answer! :D - The already tried the EXIST statement before, but seems to take FOREVER!!! :p - forget about the "MYVERSIONS" table, it supposed to be "LIMSVERSIONS" (typo error, it was its previous name) - What I exactly need is to clear data in LIMSVERSIONS where...

Hi, I have a table named LIMSVERSIONS which links to 5 other table with the VERSIONID field. There is a lot of data in LIMSVERSIONS table (about 20000 rows) and I need to remove all the orphan rows in that table. I tried this way : delete from MYVERSIONS where VERSIONID in ( select...

It works... Thanks!!!

Ok, I've managed to find a way to make the XMLTextReader work and I can now read the data. But within parameters of the XMLTextReader I can get the values and the Elements. But how can I get the lenght of the complex type elements? Thanks Daniel