• MySQL stored procedure debugger tool

    Hi, I am looking for a MySQL stored procedure debugger tool for Ubuntu (Unix). Can someone help?

    Perfsid5 pointsBadges:
  • 24 hr clock in Microsoft Access

    Microsoft Access allows you to open your table in datasheet view, select FIELDS from TABLE TOOLS and select from the drop down MORE FIELDS and then select TIME 24 so you can use military time. Problem is when you attempt to type in military time, it shows a calendar on the side and only allows you...

    MANDONA135 pointsBadges:
  • Relationship between database and knowledgebase

    What is the relationship between database and knowledgebase?

    Mkaaa15 pointsBadges:
  • Collation

    What is simple definition and example of collation?

    Raviknowledge5 pointsBadges:
  • Access 2003 parameter query bollixed

    The query searches a table looking for three fields, one of which is the Year. The year parameter request works just fine [Year as yyyy]. The query then goes on and asks for a second parameter for a field that was not included as a requested field. Any hints given are appreciated - thank you wem3rd

    wem3rd65 pointsBadges:
  • Create Button to Open Specific Form

    I have a continuous subform. I have added a command button beside each record on the subform to open another form, which is specific to that record. Every time I use the control wizard to make the button, the record I want is not opened. My relationship is Continuous ID to Button Number. I am not...

    a2rose2l5 pointsBadges:
  • Application retirement and database archiving

    Hi! I have a constantly developing application and i want to archive its DB. The DB tables structures constantly change. My idea is to develop non changing core structures (tables) of production tables. It will be something like physical DataMart. For example if I have client information in...

    shorri5 pointsBadges:
  • StartDates

    How would you write the "Where" clause (sql) for abstracting just the "Year" out of a startdate like 03/12/2013 which would result in an answer of "2013"?

    nrgbmill5820 pointsBadges:
  • Access List

    Hello there, I would like to set up a firewall and i need some help in order to use the correct filters (access lists). I want to achieve the following: 1. The external users can access the server (website and ftp) in the DMZ 2. The external user can download files from the server via ftp 3. The...

    Olych5 pointsBadges:
  • What is the best method to connect Oracle and DB2 DB with HIGH reliability and speed?

    Hello, My company currently has 2 ERP systems: JDE (in Oracle) and another which has 3 of our divisions. The decision has been made to move the remaining 3 divisions to JDE. The other divisions currently push pricing to the 2nd ERP system from home grown Contract Systems on the System i nightly...

    MaryKyrrynMathias70 pointsBadges:
  • IF and then statement in query

    I'm having issues with an if statement in a query. Basically I need to know how to get the following: If field 1 is > 0% then field 2 = 25. I don't know VBA

    tphester5 pointsBadges:
  • Java CSV reader (+charts)

    Hello there, I'm trying to create a Java web application which will do the following: -upload .CSV files -store them in a database -will display charts depending on the content of the .CSV file Any ideas? It HAS to be in JAVA! Thanks in advance, Peter

    pforos220 pointsBadges:
  • Teacher’s salaries

    I created a database for contracts using Access 2003. I changed a calculation in a form that was created and it works on the form, but when I open a query it's still displaying the old totals from the old calculation method. What do I need to do to make it change in the query also?

    Smith35 pointsBadges:
  • Database how to connect OpenOffice base to Visual Basic

    How do I connect OpenOffice base to Visual Basic?

    Learn5 pointsBadges:
  • Trigger removed

    How to know if some one had removed the trigger from the file? We have a situation like this so how to know who did that? Shall we get the data from journaling?

    Anu143525 pointsBadges:
  • Trigger

    Guys, we got a problem here...our file is associated with Insert and delete trigger. So will an SQL delete query execution trigger the job attached?

    Anu143525 pointsBadges:
  • Trouble creating SQL statement from MS Access Form

    I'm creating an INSERT statement from the text fields in a form. This is a snippet: mySQL = mySQL & Combo0 & "','" & Text3 & "','" & Text5 & "','" & Text7 I am alternating the double and single quotation marks to enclose the entire statement as a single STRING while...

    MarcC5 pointsBadges:
  • Can somebody provide me SQL questions based on various situation?

    I have started working on SQL DB. During an interview question, there were various situations given through which we need to write some queries. Questions/ Situations where UNION , ORDERBY , JOINS , DATE Functions and others are used. Can somebody provide me SQL Join situation questions for...

    Mayurkhe295 pointsBadges:
  • MS Access database

    I have a MS Access database with records that I have uploaded to Windows Server. I wish to have an user open the records on their local machine and be able to add/edit records on the remote server. What is the simplest way to accomplish this? I have also created a data access page. It seems that...

    Mgregory0 pointsBadges:
  • MS Access 2007, IIF and Null expressions

    Ok what I want to do is very simple but nothing I have found is helping me. I have a field that sometimes contains a value and but most of the time it is empty. What I want to do is write an expression that says if there is something in this field, then “25”. I believe that I should be using...

    Phil12550120 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following