The simple answer is yes, there are performance differences, but it all depends on what you are trying to acheive. Without further details I cannot say more. The best way to find out id to try it. Bob Ashfield Consultants Ltd

Hi Werries If ADO doesn't think that a requested cursor-type is possible then it silently changes to another type. I don't normally use bookmarks - so its not something that I have a problem with. I normally use GetRows() to grab the recordset's contents into a 2-dimensional array. This allows me to close the recordset and grab any output parameters. Have a good weekend. Regards Andy PS: Have you set "Set nocount on" in the stored procedure? If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message".

The cursor type won't change. Your SQL is still returning that same recrodset no matter if it's done by stored proc or by a SQL statement you pass in. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

hi you can use ghedit.msc and scrip to determine when windows are shutting down. goto : Run -> gpedit.msc -> computer configuration -> windows setting -> scripts ->shutdown. and then add your vb script that you want to run at shutdown.

Did you try creating a mutex? As far as I know, that is the general solution to such problem, and can be used in any language, since is supported by the OS through APIs. If CreateMutex() returns ERROR_ALREADY_EXISTS means there's an already running instance of your application. Regards, Bornish ESRI Developer Network Compilers demystified - Function pointers in Visual Basic 6.0 Enables the use of function pointers in VB6 and shows how to embed native code in a VB application.

It doesn't show you dialog again, because you created rule (disable your application). If you removed this rule from firewall rules list, it would ask you.

I strongly recommend you use the ISO date format yyyyMMdd, interpretation of which is not subject to the locale or language settings of your SQL Server installation or the connection. So I would use SET @Date = '20070214'. Stability. What an interesting concept. -- Chris Maunder

Werries wrote: Chris Who's Chris? Upcoming events: * Glasgow: SQL Server 2005 - XML and XML Query Plans, Mock Objects, SQL Server Reporting Services... Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton My website

Thanks for your reply, I appreciate it. Regards, Werries A programmer's life is good... or is it?? Ek dink nie so nie!

ALTER TABLE dbo.Staff ADD MaxDisk real NULL Apparently it's not OK to start a bonfire of Microsoft products in the aisles of CompUSA even though the Linuxrulz web site says so

Hi there, Thanks for your time. I've figure it out. It's easy, use the PaperBin property of the Printer Class to specify the tray to use. Regards, Werries A programmer's life is good... or is it?? Ek dink nie so nie!

Hi there, Thanks for all those who have take time to help me on this post. I’ve solved my issues. I’ve tried to update Interop dll’s via InstallShield, but was not successful because the version numbers of the Interop dll’s did not change. On the end I used the QuickPatch option of InstallShield to remove the original Interop dll and copy in a new Interop dll. This worked fine. Regards, Werries A programmer's life is good... or is it?? Ek dink nie so nie!

If I understand the question, no you can't edit the .DLL. You have to change the code, compile it, then replace the .DLL file with the new one. With InstallShield, you can make a patch installation that will make the necessary changes to the .DLL file, but it needs the original .DLL file and the new one to build the edit patch because the edit will only work on the version of the .DLL file. It's a heck of a lot easier to just unregister and replace the old .DLL file with the new one and re-register. Dave Kreskowiak Microsoft MVP - Visual Basic

I've answered my own question. I exported the wrong entries from my local Registry Database. Thanks for those who was bordered by this. Regards. A programmer's life is good... or is it?? Ek dink nie so nie!

In times when a control creates a huge error (often due to stack overflows or null reference exceptions), I have found that if you close the IDE and rename the code file that the IDE was designing the IDE will claim the code file is missing from the solution and will not load the code that was causing the problem. Then you simply need to rename the code file back to the original and then debug what could be causing such a HUGE problem. This is common when I create user controls that need to be tested through the IDE. Regards, 1tg46 Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.