So I’m setting up a stored procedure in SQL Server 2000 to access some data on an Oracle database. The DBAs have set up the linked server in SQL Server to the Oracle source with the name ‘DTEST’. I’m going to need to use the OPENQUERY method since I need the statement to execute in…
You are currently browsing the post archives for September 2009.
Create Word Doc and attach to Outlook Email in PowerBuilder
Here is some sample PowerScript from back in 2004. The word document created is saved from a template doc previously created with specific bookmarks used to format the text. oleobject lole_word OLEObject lole_item, lole_attach, lole_outlook string ls_file_name lole_word = CREATE oleobject lole_outlook = Create OLEObject TRY lole_word.connecttonewobject('word.application') CATCH (runtimeerror a) Messagebox('Error','Error connecting with MS Word.…
PowerBuilder – Clearing the clipboard
Powerbuilder’s native ‘clipboard’ method does not clear out the buffer. Here is how to do it: // external function declarations Function boolean OpenClipboard ( & ulong hWndNewOwner & ) Library "user32.dll" Function boolean EmptyClipboard ( & ) Library "user32.dll" Function boolean CloseClipboard ( & ) Library "user32.dll" // code in application PowerObject lpo_parent ULong lul_hWnd…