no, it's the dropping of an extended stored procedure in the master database. the DROP PROCEDURE does not allow a database to be qualified, but does not work unless the selected DB is MASTER.
Any ideas?
Hi,
Is there any way I can remain in context during an update to another table? The problem I'm having is that if I capture the current table I'm in to a variable, and then perform a USE statement, I immediatly leave the context of my current table for the new one. Now, if I do an EXECUTE...
Hi, many thanks for your replies - I tried the simplest solution first (ProdAir) - I entered this as the syntax:
exec master.dbo.sp_addextendedproc 'xp_mystoredproc', 'mysqlxp.dll'
and it all worked perfectly. Many thanks to both of you for your solutions.
Yum.
Hi, I'm pretty new to actually doing something useful in SQL, so can someone shed some light on my problem. I need to change from my current database to the master database, execute some sp_addextendedproc statements, then return to the previous database. Thats it. I don't know the name of the...
Hi,
I have an MDI window, which has a number of forms within it. If one of these forms calls a common dialog (for example to search for a file), and then decides while the common dialog is open to switch Applications (e.g. to Windows Explorer etc) and then switches back, the focus is lost on...
Right, got it working now :) Finally. Thanks for all your help. The trick was to fix the MyProc facility as specified above, but also to alter the hook type in SetWindowsHookEx to: WH_GETMESSAGE - It's hooking it's little heart out now ;))
Thanks again!
Yum.
Hi, thanks for that - I see what you mean, I've applied the changes - MyProc now uses copymemory to stuff any message into the MSG structure:
Public Function MyProc(ByVal uMsg As Long, _
ByVal wParam As Long, _
ByVal lParam As Long) As Long...
Could you be a little more specific? As I understand it the MyProc function serves to hook the messages, which only accept three parameters - the message id, and l+w param's. I can't really see whats missing?
Thanks
You could use Excels built in objects to store a formula, but you can't store it in a variable - however variables could form part of a formula that you construct in vba. If you know what actions you want to perform in Excel (for instance highlight 10 cells, sort by column A, then B etc), you...
In this instance, yes, the parent and child are running in the same thread. The code above is just a test to try and get hooking with a custom message working. I finally intend to apply it to an MDI Window where numerous children are spawned, and I need to be able to invoke operations on some...
Hi, got a problem getting my hooking procedure to work and I'd be grateful for some pointers. Basically I want to send a custom message to another window, but currently, the hooking procedure (which is initializing and terminating fine) is not picking up any message(s) from the child window -...
It might be worth exploring the SQL Enterprise Manager's query builder. That way you can play around a bit and see if you can get something similar to whay you need.
If you open SQL Enterprise manager, then go to Your database, then tables, then select a table, right click and select query -...
Yep, I know that - sorry, my typo. It should say (mycolumn,'hello') - but it doesn't alter the fact it still doesn't work and that the supplied SQL Online Book example doesn't work for me either :(
Hi,
I have a very simple database, containing two tables (each with 3 fields - 1 Primary Key, and two data fields). The datafields are of type: varchar(100), and: text respectively. I have created a new full text index on both tables through the wizard. However, when I run a query (super...
For those interested, the solution to my problem was here:
http://support.microsoft.com/support/kb/articles/Q259/7/25.ASP
(Linked from this page:)
http://www.vbrad.com/pf.asp?p=Articles/janmay01/art_aspless.htm
You don't. Thats not how it works. As a client you receive the final HTML result formed from your actions in the browser. Remember, the recordset is created serverside, the results mined and populated into the HTML page serverside, and the results served to you - All you get is HTML with the...
Right, This should be simple, but it's not - it's causing me endless grief. Basically, I have an ultra simple ASP page, and an ultra simple DLL with a single class. I have created an 'application' directory in IIS, and pathed it to my simple asp page. When I launch the ASP page, it instansiates...
Hi,
Basically, let me set the scene, got a form with an embedded frame - now it has a textbox embedded into it - and I want to prevent the user being able to edit the contents without using textbox.disabled = true. Now, I understand *basically* how Win32 API works, and have implemented a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.