Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: yumbelie
  • Order by date
  1. yumbelie

    Remaining in table context for execute statement

    thanks, thats sorted it :)
  2. yumbelie

    Remaining in table context for execute statement

    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?
  3. yumbelie

    Remaining in table context for execute statement

    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...
  4. yumbelie

    Simple Task Problem

    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.
  5. yumbelie

    Simple Task Problem

    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...
  6. yumbelie

    Restoring Focus on Common Dialog when switching apps

    Thanks, I'll give it a whirl.
  7. yumbelie

    Restoring Focus on Common Dialog when switching apps

    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...
  8. yumbelie

    Fun With Hooks

    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.
  9. yumbelie

    Fun With Hooks

    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...
  10. yumbelie

    Fun With Hooks

    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
  11. yumbelie

    Help with automated regression

    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...
  12. yumbelie

    Fun With Hooks

    ...be able to invoke operations on some child windows by sending messages from others. But currently, the simple example above just fails to work - It *should* technically cause the custom message to be intercepted by the hook, and invoke a debug.print message - but it's just not showing up -If...
  13. yumbelie

    Fun With Hooks

    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 -...
  14. yumbelie

    Trouble w/Query

    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 -...
  15. yumbelie

    Full Text Problem

    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 :(
  16. yumbelie

    Full Text Problem

    ...and: text respectively. I have created a new full text index on both tables through the wizard. However, when I run a query (super simple SELECT * FROM mytable1 WHERE CONTAINS(mytable,'hello') no result is returned. I receive no errors, just as if the query returned no results. I have tested...
  17. yumbelie

    Debugging ASP VB6 DLL

    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
  18. yumbelie

    How do I query a Client side recordset? Please!

    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...
  19. yumbelie

    Debugging ASP VB6 DLL

    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...
  20. yumbelie

    Using Win32 to capture events

    ...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 Subclassing procedure (which I understand - mostly ;)) and which is invoked when the form...

Part and Inventory Search

Back
Top