• SQL Stored Procedures

    I am trying to return a count value from an SQL Stored Procedure in order to test if the record exists or not. I am calling the procedure from java as follows. CREATE PROCEDURE RTVSQL (IN LEVL CHARACTER(1), IN SYLL CHARACTER(4), INOUT FOUND INTEGER(2)) LANGUAGE SQL SELECT COUNT(*) INTO FOUND FROM...

    Jglyons15 pointsBadges:
  • Community Update: New Contest Announcement.

    Now is your chance to win an Amazon gift card based on your activity in the IT Knowledge Exchange Community. Remember: the more you ask, answer or discuss questions, the more Knowledge Points you will earn. This is how the contest works: The top 10 most active members from now until the end of July...

    ITKE409,090 pointsBadges:
  • Alternative to using a cursor in SQL

    What is the best alternative to using a cursor in SQL if I am suffering from performance issues?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Zebra printers on an iSeries platform

    I am on an assignment that has me pulling out what little hair I have remaining. Zebra printers use a language caled ZPL to print thermal labels. Problem is, there is no tool I can locate on the iSeries that produces ZPL code. Zebra offers a product that is PC based. It produces ZPL code that is...

    OldGoat0 pointsBadges:
  • What effect will changing system date have on Exchange/Blackberry?

    We have Windows Small Business Server 2003 with Exchange and Blackberry installed. SAP Business One and SQL are working smoothly. Now we want to change the system date from the last three months back for some upload work with SQL(SAP). If I could change the date, would my server continue to work...

    0 pointsBadges:
  • Error 2501

    While navigating my database I have a button that will take you to a different form using parameters. It works when you either simply click ok or type in a parameter, but when you click cancel it returns an error 2501. What code should i put in to VBA to make it simply close the parameter box and...

    Newguy20085 pointsBadges:
  • ASP.net c#

    hello body, please help me on that i am working on visual studio 2005. asp.net c#. i want to write some code which is about database. i want to save and load my listbox usgin database.

    Zoloshko10 pointsBadges:
  • convert Oracle query into xml file

    Is there any software to convertautomatically oracle table(query)into xml file like JSP in java.

    dnlkc5 pointsBadges:
  • %SST

    Hi, Im traying to get out put of this below mention simple logic code.But im geting out of different.(im trying with my laptop trhough my company server. DCL &FIELD1 *CHAR 10 VALUE('TCS AS/400') DCL &FIELD2 *CHAR 10 CHGVAR(%SST(&FIELD2 1 10))(%SST(&FIELD1 10 1) Can you tell me the value of field2...

    0 pointsBadges:
  • WDSc highlighting just keeps going and going and going . . .

    WDSc: When a section of code is selected by dragging a mouse over the code, it is highlighted. Later, if one wants to select another portion of code with the mouse, everything between the current mouse pointer and the prior selection is selected. Is there a way to cause each mouse-based selection...

    WoodEngineer6,955 pointsBadges:
  • Change Fonts of Menu Item Through VB6

    My program is in varnacular language, i. e. input and output are in Gujarati (Indian) language, by changing the font to "Gopika.ttf". So, during the execution of my program I want to show menus also in Gujarati, i. e. 'Gopika' font. Normally, we change this from desktop --> properties -->...

    Mayuri155 pointsBadges:
  • Replication Storage

    How much storage does Flash SE require?

    Akibbitz5 pointsBadges:
  • Problem in accessing CD Drives (VB/VB.Net 2.0).

    Hi everyone, I'm focusing on a real tough problem that I hav been trying to solve since a long time in VB/VB.Net (2.0). I'm trying to detect the Open or close status of the Cd drive door. I'm using mcisendstring function to query the status, mcisendstring("Status CDAudio Mode"). This function...

    Priyamtheone30 pointsBadges:
  • Access Query Tag

    Is it possible to tag an access query with keywords like you can do in other MS applications?

    Rklawson5 pointsBadges:
  • Parameters in RUNRMTCMD?

    Can I pass parametes in a runrmtcomd?

    J07285 pointsBadges:
  • How to access and use subform data/calculations

    Access 2007 Database; Employee Info; Form:Sick Days Docking/Pay. I created a form with a subform that keeps track of Employee sick days. It transfers totals from the subform onto the main form...Then the main form does a couple calculations on those amounts...But I need to access that information...

    OBI Girl85 pointsBadges:
  • join tables with nested select count and group by

    hi i am having three tables : state, agencydetail, parentdetaills i am running following queries but i am getting wrong result plz help me out where is the problem select state.state,count(ag.agencycode) as registag,count(ff.agencycode) as reportag,count(inp.regno) as incpwait,count(interp.regno)...

    Bijendersverma5 pointsBadges:
  • How do i replace a sql tables field value with another value

    I have the following script that works in Access but not in sql. I trying to replace the the value in the field "RSAMSTORE" with another value I give it (i.e. 999994, etc.) when the data is displayed. In otherwords when the select distinct is ran instead of seeing the value in the table "RSAMSTORE"...

    Ilfoprog50 pointsBadges:
  • Receiving an error consistently in SQL

    I receive the following error constantly in SQL: "Notice: Use of deprecated function sql_query in /var/www/html/includes/sql_layer.php on line 43 Notice: Use of deprecated function sql_fetch_array in /var/www/html/includes/sql_layer.php on line 64" It repeats over and over, and I am not sure how to...

    SQL Server Ask the Experts2,585 pointsBadges:
  • why is a blank cell returned in pivot table when data exists?

    I have a pivot table with one cell that appears blank. when I double click on the total for that row, the field is not blank. Why is the data not displaying in the pivot table? Show all is selected in that field header.

    MightyTightYouth5 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