DB Dev Tools

Development in most programming languages is done with an editor or integrated development environment (IDE). Dev Tools covers issues with the use of that software, rather than the actual programming being written. XCode, Visual Studio and Eclipse are some of the more popular development tools.

Share tech news, updates, or what's on your mind.

Sign up to Post

The below code works but also causes a warning of: "Lambda expression will not be removed from this event handler. Assign the lambda expression to a variable and use the variable to add and remove the event."    

What change is necessary to resolve this warning?

            Dim cb2 As TextBox = TryCast(e.Control, TextBox)
            If cb2 IsNot Nothing Then
                Dim txtEdit As TextBox = DirectCast(e.Control, TextBox)
                RemoveHandler txtEdit.KeyPress, New EventHandler(AddressOf txtEdit_Keypress)
                AddHandler txtEdit.KeyPress, New EventHandler(AddressOf txtEdit_Keypress)
            End If
I'm writing an application to import a file into MS Access.  The application will have a target table already defined, and needs a way to map the columns of spreadsheet/CSV to the columns in the table.  I want to do this using a GUI control which shows the table column names listed on the left, the names of the fields from the source file, and some means of matching them up ... ideally a line drawn between elements on the left to elements on the right.

If drawing lines is asking too much, then the control for Map Custom Fields in Outlook for Contact Import would be a usable alternative.

Where might I find such a control?
I have a Windows 2008 server. In these server there are some events gets generated.
What i want to achieve is that in case of any event which is getting generated I want e-mails to be generated for these servers.
I have separate SMTP server by which I want to relay e-mails.
So i want to know how can i configure my Windows server to relay e-mails via my SMTP server.
Is there any command line tool or by any command line i will be able to connect to my SMTP server & relay e-mails.

I am getting the following error when executing a procedure in toad:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "LEASEOPS01.PROC_ADVICE", line 23
ORA-06512: at line 15

This is what the beginning of the code looks like:

CREATE OR REPLACE procedure LEASEOPS01.proc_advice
 (blockno_var in varchar2, startdate_var in varchar2, enddate_var in varchar2, ENDTIME_VAR in varchar2, BLOCK_VAR in varchar2) is


    EXECUTE IMMEDIATE 'alter table LEASEOPS01.pay_advice nologging';
    execute immediate 'truncate table LEASEOPS01.pay_advice';
        -- -942 = table or view does not exist
        IF (SQLCODE <> -942) THEN
        END IF;


    execute immediate '
insert into

can someone please assist?
Dear experts,

Is there other ways of convert mysql data into excel file or a better and easy way?

These are the methods that I know of:
1. using phpExcel (a php converter program)
2. using mysql OUTFILE command and dump the data into .xls file

I am trying to create an excel file from the data store inside mysql. The excel file has to be version 4.0 or below or else the other program will not recognize the file format.

Is there a mysql2excel command that I can use in linux which can get the job done? (concept is from dbf2mysql) If not is there a similar program that can perform the function of converting mysql data into excel?

I have software that generates html5 code by way of a script.

I don't know how to set up my template to keep text from running past
the end of the container.

Please show me what I have to add to my templater:

<div align="center">
                  <table width="450">
                  <td style="text-align:left; vertical-align: top; font-size: 14;"><b>Full Screen Dynamo best yetxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx<br>
The line breaks here were created by entering return key
The html which is producing the improper results is attached

Thanks in advance,
I have a developer who is wiling to try a new workstation scenario with me, I'm just trying to make sure I am not setting us up for failure.  

It is evidently a PITA to get a development environment setup, and this new developer is wiling to let me try and help him set one up as a VM locally on his win7pro laptop.  The supposed advbantage being if he kills the environment we can roll back.  

After getting windows 7 and office installed and activated, joined to the domain and fully patched , I used windows backup and restore to make a system image.  This image is stored in a folder on his laptop.  If this works we may move if off there.  My question is if he goes using this machine for a few months and then says hey my VM is fubar lets reload that image we took back in the day can I expect this will work alright?  I know with AD there are certain considerations to take into account.  Does it make sense to unjoin it, image and rejoin it to avoid them?

I also have a highly available Hyper V cluster at my disposal...  I could create a VM on that for him and just do snapshots when he wants me to, I just thought we would try the local VM first.  And I thought I might still have AD issues messing with the snapshots.

Does either scenario here sound drastically unsound?
I have a class library that was originally written in VS 2008. The time has come to upgrade it to VS 2010. The library belongs with an application that has its own toolkit. I have installed the latest version of this toolkit. The problem I have is that when I build the code and run the application, I get this error message."Error Message
I need to calculate the week of the year for an SSRS report that I'm writing using Visual Studio 2010.  There are Day, Month and Year functions, but no Week function (like is available in Excel).

So, how do I calculte the week of the year calculation in visual studio 2010?

I need to run a procedure in Oracle, from a Windows form application created in Visual Studio .Net, but have all output from that procedure execution directed to a textbox in the application.  (I do not wish to use Console mode).  The procedure has exception handling and i would like to capture any exception messages to a textbox.  If you executed the procedure from SQLPLUS in a command window, the messages that would show, is want I would like to capture to the textbox, as an example.  I have looked at Oracle notifications functionality but that does not seem to be usable for my requirement.  Can someone suggest a high level explaination of a method to use or an suggest an article that may describe the method to use.  thanks Barry
I'm running the following command in my .cmd file to delete a registry key:

reg delete HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\Folders /v "C:\Program Files\Symantec\Critical System Protection\" /f

The /f switch is suppose to force delete without prompting but it's not doing that,  still getting the following message:

Delete the registry value C:\Program Files\Symantec\Critical System Protection"
/f (Yes/No)?

When I manually select Yes  I get message:

ERROR: The system was unable to find the specified registry key or value.

Can someone please tell me where I'm going wrong with this.

Windows Server 2003

We still have a VB6 application in use. In this application, documents are created in Word for Windows by using an OLE link (Office Automation). The connection is set up with the following code.

2 global variables are declared:

          Global objWdApp As WORD.Application
          Global objWdDoc As WORD.Document

Then the Word object objWdDoc is created for the document that has to be edited:

          Set objWdApp = CreateObject("Word.Application")
          Set objWdDoc = objWdApp.Documents.Open("C:\test\test.doc")

, and the document is activated and made invisible:

          objWdApp.Documents("test.doc").Windows(1).Visible = False

The document can then  be generated , for example using code like this:

          objWdApp.Selection.Font.Bold = true
          Set myTable = ActiveDocument.Tables.Add(Range:=myRange,…………….
          Selection.Borders(wdBorderRight) = true

and so on. This works fine.

However, there is a problem if there are more Word documents open at the time the OLE link is initialized and opened. Using the user interface, the user is able to put the focus on to one of the other Word documents. The OLE commands will then be sent to the document that has the focus, which may not be the one intended. We have solved this by making Word completely invisible so that all other Word documents disappear from view:
          objWdApp.Visible = False

This …

I am using Delphi 7 on Windows 7 and am having problems with spell checker using woll2woll 1st Class component

What is happening is when I right click on the editor and select the spell checker, you get the egg timer and it seems nothing is happeninng, In reality, the spell checker is hidden behing the screen.

I dynamically create an editor:-


I use following to display the spell checker:-

NewEditor.PopupOptions:=[rpoPopupEdit, rpoPopupCut, rpoPopupCopy, rpoPopupPaste,  rpoPopupBold, rpoPopupItalic, rpoPopupUnderline, rpoPopupFont,
rpoPopupBullet, rpoPopupFind, rpoPopupReplace, rpoPopupMSWordSpellCheck  ];




There has got to be a way of catching the onclick event for the spell specker and getting the spell checker to display on front.

When i try to export a report in excel from our product (uses .net framework 4.5.2) i get the following error and also found the link corresponding to it based on it inner stack trace but do not know what to do. Any help will be highly appreciated


Detailed error messages

Type: System.TypeInitializationException
Message: The type initializer for 'System.Windows.Media.Brush' threw an exception.
Source: PresentationCore
Stacktrace:    at System.Windows.Media.KnownColors.SolidColorBrushFromUint(UInt32 argb)
   at IDV.OpenXml.SpreadsheetML.TextMeasurer.MeasureNoWrap(String text)
   at IDV.OpenXml.SpreadsheetML.WorksheetColumnInfo.MeasureMaxmimumDigitWidth(String fontName, Double fontSize, Boolean isBold, Boolean isItalic)
   at IDV.OpenXml.SpreadsheetML.WorksheetColumnInfo.GetDefaultStyleMaximumDigitWidth(Workbook workbook)
   at IDV.OpenXml.SpreadsheetML.Writing.WorksheetWriter.GetColInfoFromColumnInfo(WorksheetColumnInfo info)
   at IDV.OpenXml.SpreadsheetML.Writing.WorksheetWriter.WriteColumns(PartXmlWriter xmlWriter, Worksheet sheet)
   at IDV.OpenXml.SpreadsheetML.Writing.WorksheetWriter.SavePartContentCore(PartRelationshipWriter relationshipWriter, PartXmlWriter xmlWriter, Object partData)
   at IDV.OpenXml.Core.XmlPartContentWriter.SavePartContent(PartRelationshipWriter relationshipWriter, Stream …
When I am hitting a URL in my browser, I am navigating through different web pages (probably because of page forwarding code in each web page that is opened). After the final page is loaded, when I looked for the executed javascripts through F12 DeveloperTools(IE), Firebug(FF) & Developer Tools(Chrome), found the scripts that were most recently executed for the last page that is opened. I want to see all javascripts that were executed as I am passing through different pages. Is it possible?
When editing an Access 2013 App, the ribbon does not include the Database Documenter under the Database Tools tab. I understand that the reasoning behind this situation is that the data tables are being stored in SQL tables on SharePoint, but that doesn't make up for the frustration of not being able to generate the type of documentation which is possible for an Access 2013 Desktop program. Related to this is the lack of being able to graphically view the relationships between tables; again, I already understand that the "relationships" are built in a lookup field that gets values from a related field in another table. But knowing that doesn't solve the lack of being able to view and document what's going on... Any suggestions for documenting an existing Access 2013 App which is running on SharePoint?
Hi I am using VB6 SP6 on win7 SP1 PRO 64bit.
I have found an OCX  named :   VIDEO_CAMERA_ACTIVEX.OCX

This ocx is working well and i have integrated it into my program/project.
I am using it to capture video and stills from a logitech usb camera and save the resulting images to the hard disk.
I am asking if anyone knows of a better, easier, cheaper one that works well.

The reason I ask is:
1. This one is expensive at $89 per user.
2. Video output is *.AVI and still capture output is *.BMP which is all very nice but they are not compressed formats and take a lot of disk space. I would have preferred *.jpg and *.mp4 format.
3. I have managed to use +- 90% of it's capability but it's help file is terrible at describing the parameters to it's methods implementation.

Thank you.

I am working on remote desktop application,based RDP(proxy server )concepts.I want to put the this code in seperate thread.

// Send the packet to all connected clients
void CRDPDlg::SendToAllConnectedClients(CPacket & Packet)
      std::vector<CString> vAliases;
      std::set<sAccept>::iterator itAccept = m_setAccept.begin();
      for (;itAccept != m_setAccept.end();++itAccept)
            // Locate the server
            if (!itAccept->m_bRDV && Packet.m_csServer == itAccept->m_csAlias)
                  // Locate the viewers of this server
                  std::set<CString>::iterator itView = itAccept->m_Viewers.begin();
                  for (;itView != itAccept->m_Viewers.end();++itView)
                        // Locate each viewers connection and send the update
                        CString csViewer = *itView;
                        for (std::set<sAccept>::iterator itAccept2 = m_setAccept.begin();itAccept2 != m_setAccept.end();++itAccept2)
//This has t be in seperate thread.
                              if (itAccept2->m_bRDV && itAccept2->m_csAlias == csViewer)
                                    CTCPSocket & Alias = *(itAccept2->m_pAccept);
                                    Alias << Packet;
I have designing a sports website. The client would like to have different levels of security using userids/passwords. For example, the coaches should have access to their teams to enter scores, the officers of the league should have full access to all the features, etc. Can this be done in wordpress or is there another CMS that is better suited for this
I have a suite of applications for a client. The client wants to install some of the applications in the suite if the user logged in is an administrator only. Regular users should only be able to install the main application. The suite is build with VS 2010. Is this possible with the VS 2010 setup project?
I'm designing a SCADA application I will be using for home automation. It works over a LAN. The client will run on either a Windows or Linux box which has the DACs attached to it. Or it can run standalone using localhost. So I want the server app to be able to create one script that just checks the time of day against a list of time/actions and execute those actions if it time to (turn on hot tub 1 hour before I get home). Then one or more scripts that check for limits or alerts (turn off hot tub heater if temp > 100F). I want the main time of day polling scripts to run in parallel with the limits/alert scripts. I'm writing the app in C#. I want the user to be able to edit and execute the scripts without having to go to a DOS box and do a compile and run the script. I don't want to write my own scripting engine, yet I don't need all the OOP features that come with IronPython, CS-Script or Boo.

How can I pass a string to a document.forms[1][0] and submit using Chrome DevTools?
I am looking for something to restrict the Save As button on PDF in a certain directory.

I know I can add a file.js to the C:\Program Files\Adobe\Acrobat 11.0\Acrobat\Javascripts path that contains

Open in new window

That is all PDF's then.

I was thinking of apply password security to the file and also leveraging javascript to remove the save buttons if the folder location matches the folder location of the file.

I saw that I can use This.Path to get the entire path of the current file.
Can I incorporate IF statement using This.Path then App.hideToolBarButton("Save")?
I am trying to allow a user to copy the data in a Lotus Notes field to the clipboard, so it can be pasted elsewhere.  However, the only way I can seem to do that is to make the field editable, instead of read only.  The field needs to be read only so no changes can occur (after the data has been saved, I do not want it to be modified).  And, I'd like this functionality to be allowed in several fields on a form, not just one field.  Is this possible?
I work for large firm and need to delete left users' home folders from all of the file servers and need to help to get it working

AD accounts are deleted manually by helpdesk guys
only thing left is their home folders on shared drives on file servers, these users EMEA users and I need to point script to their relevant file servers to find users home drivers or I can manually run on the server itself may be? It is all depends on script. I prefer something very simple.
I have txt file  called leftusers.txt and live users are on remote server in D:\User folder
Can you please suggest something? I really appreciate your time and help.

DB Dev Tools

Development in most programming languages is done with an editor or integrated development environment (IDE). Dev Tools covers issues with the use of that software, rather than the actual programming being written. XCode, Visual Studio and Eclipse are some of the more popular development tools.

Top Experts In
DB Dev Tools