not sure what the fuss is all about! its a feature supported by (almost) all the languages out there!!! with all due respect, looks like you are just frustrated for having to work in vb!!! ..peace... :rose: btw... yes i do develop in vb most of the time :)

which OS are you on? it seems to work fine on W7 x64 much quicker than its previous cousins! cheers

you are right - (for now) its not important as to which value gets updated. The SQLServer version of the script simply updates the t2.Field with the last found record. So for 'n2' t2.Field1 will always end-up with value 'c' I was looking for an equivalent in ORACLE so that it will always update with the last row found. The actual issue is much bigger and i was looking for a quick-fix without introducing a major change. Looks like we need to address the issue with the current design before spending any further time on this issue, Thanks for your inputs. Cheers Kalyan

you are right - (for now) its not important as to which value gets updated. The SQLServer version of the script simply updates the t2.Field with the last found record. So for 'n2' t2.Field1 will always end-up with value 'c' I was looking for an equivalent in ORACLE so that it will always update with the last row found. The actual issue is much bigger and i was looking for a quick-fix without introducing a major change. Looks like we need to address the issue with the current design before spending any further time on this Thanks for your inputs. Cheers Kalyan

Thanks for your reply.
I do know that multiple values is what is causing this issue. Using DISTINCT would not work as the values being returned are distinct already. It would still return 2 rows for n2
This issue is due to ORACLE not supporting the same syntax as SQLSERVER. (as far as i know)
I am more comfortable with SQLServer than ORACLE and hence was checking if anyone else came across this issue. Kalyan

I have two tables with the following structure. Table 1
Name Field1

n1 a
n2 b
n2 c
n3 d

Table 2
ID Name Field1

1 n1 NULL
2 n2 NULL
3 n3 NULL

Usually, Table1.Name and Table1.Field1 have a 1..1 relationship. however in very-rare circumstances they do tend to have 1..n I need to update Table2.Field1 with Table1.Field1; In SQL Server we could write the following update statement to satisfy our business conditions. UPDATE Table2 SET Table2.Field1 = T1.Field1 FROM Table1 t1, Table2 t2 WHERE t1.Name = t2.Name; In oracle, we were having the below statement. UPDATE Table2 SET Field2 = (SELECT t1.FIELD1 FROM Table1 t1, Table2 t2 WHERE t1.Name = t2.Name); This statement works for Table1 having 1..1 relationship between Table1.Name and Table1.Field1 For 1..n relationship the ORACLE version fails with the following error - ORA-01427: single-row subquery returns more than one row The SQLServer sql works for both the cases 1..1 and 1..n; given the nature of the join. Could someone guide me with appropriate sql for the above issue? I am looking for a bulk update statement rather than using PL/SQL to go through each recrod in Table2. Thanks for your help. Kalyan

modified on Monday, June 7, 2010 10:55 AM

Thanks Ray. Unfortunately, my application will have to live with it for now. Thanks for your reply. :)

hi All, I have an issue for which i need some guidance/help. I've tried to be concise but please excuse me if you do not find it so. I have a windows service which interacts with ms-office (and other) applications using their API. I usually switch-off interactivity support if provided by the library/API so that no messagebox's are thrown during execution. However, occasionally due to an unforeseen situation, we get a msgbox pop-up which blocks the service thread. Given the nature of the application, its difficult to identify if the thread is blocked due to a message box or due to some processing overhead in the 3rd party application. one of the solutions i thought of is as follows - implement a monitoring thread to check if the office app does not return control. if control is not returned within a given interval, kill the app and exit the task(which is not best but feasible most of the times) however this seems more of a brute-force approach and it doesnt tell me what the issue is. In some of the cases the issue may not be reproducible immediately. Is there a more graceful approach? has anyone resolved such an issue earlier on how to identify the above situation? Thanks in advance Kalyan

Hi all, I would like to monitor AD-lookup requests coming from member servers in the domain. We have a windows 2008 DC and a windows 2003 server. The Win2k3 server is running an ASP.net application. From time-to time, this application server queries the AD for user information. I am interested in monitoring what requests are coming into the DC. to be more specific, I am looking for something like SQLServer profiler tool. Can this information be written to event log on the server? are there any options that I can configure to enable logging on the server? Thanks in advance for your help. Cheers, Kalyan

Hi Luc, Thanks for a quick reply. I looked at generics and was hoping there may be a complex alternative which i might find interesting :omg: i have opted for the following to keep it simple 1 dictionary for quick retrieval by userid 2 lists for containing active and inactive users. i wonder how this will scale for larger number of users! Thanks to you i learnt about lambda expressions today. :thumbsup: Go you still prefer datatables for these kind of operations when dealing with disconnected data? Cheers Kalyan

Hi All, This is my first post and hope i am placing it in the right forums - I have the following class Class User Dim UserID as integer Dim IsActive as boolean Dim Username as string End Class i need to perform lookups on UserID or IsActive Get user with ID = X (returns one object) Get all active Users (returns multiple objects - possibly a list) Get all inactive users (returns multiple objcets - possibly a list) for quicker retrieval using userid, i intend to use the generics dictionary dim Users as Dictionary (Of integer, User) are there any generics implementations which allow me to use quickly retrieve all active users or inactive users as well? Just wanted to check with you experts before embarking on my own. :) Thanks in advance Kalyan

Have you tried TinyXP? possibly having some licensing issues please verify, I am assuming you have a valid XP license. I've tried it and Its blazing fast!:thumbsup: Cheers Kalyan

hi hammad it is possible that your page is passing a blank string instead of NULL to the query. check if the following works in line 4

AND (upper(TRIM("STATUS")) LIKE ('%' || upper(TRIM(nvl(:STATUS,'%')) || '%')

i havent been able to check it but hope that helps.

Its the maintenance i was worried about. But there appears to be no better way. Many thanks for posting your suggestion. :)

Hi All, I hope i am posting in the right forum as i am looking for a .Net related solution rather than a pure XML solution. I have the following class which i serialise using default XML serialisation. Class UserA UserID UserName Description Comments End Class Later, my requirements changed and i had to generate 2 views of the same data. In my 1st view, i would generate XML for the whole object (all 4 properties) My 2nd view - include only UserID and UserName. i modified the code as below Interface iUser UserID UserName End Class Class UserA Implements iUser UserID implements iUser.UserID UserName implements implements iUser.UserName Description Comments End Class I intended to serialise appropriate objects (iUser or UserA) based on my view requirements. Unfortunately, i realised that XML serailisation does not work on interfaces - end to my dreams of getting it easy :( My question is - if i have an Object instance, can i use any feature with serialisation to generate multiple views of an object? I have ventured towards creating seperate classes, ISerializable, etc. looking for suggestions on whats the best way to take this forward. Thanks in advance.

modified on Thursday, August 13, 2009 4:23 AM