• Crystal Report Query – Birthday Formula

    I currently run a report that returns customer birthdays within given date perameters. I use the following formula to calculate birthdays: Date(year(CurrentDate),month({driver_details.drd_dob}), day({driver_details.drd_dob}) ) I then set parameter values to return birthdays within a certain range...

    Burny0810 pointsBadges:
  • validation

    i need to concatinate two fields and send to resultant field in rpg/400. one is numeric and other one is character. so please advice how can i

    Askt1140 pointsBadges:
  • Corrupting database in an VB.NET application in SQL Server 2005

    I have a application in VB.NET with SQL Server 2005 Express Edition. In the last few days, the database is continuously corrupting. I repair it, but the problem continues. I revise my code, but I can't find transactions errors that could produce the problems. Do you have any general ideas?

    SQL Server Ask the Experts2,585 pointsBadges:
  • LotusScript to update or create new record in source database based on request number

    How to code in LotusScript to query and collect data in one db based on a request number, if number found in current database, update fields, if request number not found, create new doc the request id.

    KTTeam5 pointsBadges:
  • VBScript error handling code snippet

    I am running a batch of QTP (test automation tool) scripts written in vb script overnight. Could some one send me an error handling vb script code snippet that I may insert in each script which automatically exists any script that encounters an environmental or any other error in it's run, writes a...

    Ll20005 pointsBadges:
  • WebReady doesn’t load

    Hi All, Am getting this error when i try to open a document from OWA, via webready? The WebReady Document Viewing service is not working correctly because an error occurred. Please contact technical support for your organization. Event log error: Event ID: 68 The WebReady Document Viewing worker...

    Nzcamkay5 pointsBadges:
  • Error code 10: Function sequence error using CPYTOIMPF on AS/400

    I am using the CPYTOIMPF function on an AS400 to copy from one data base file to another. I want to end up with a .CSV file format. It worked once but now I get the following error: Message Id: SQ999999 Error occurred in SQL Call Level Interface. A procedure call encountered an error. The error...

    AS400 - Ask the Expert485 pointsBadges:
  • VB Data Report number format

    I want number field in Data Report to be formatted like 12,90,565 or 89,675 How to do it Please Help me

    Try it90 pointsBadges:
  • CPYTOIMPF – SQL ERROR

    I am using CPYTOIMPF to copy AS400 database file to another AS400 database to get the receiver file in .csv format to download to a pc folder. I get a SQL error " Error occured in SQL Call Level Interface. Function sequence error." Does anyone know what this error means? I know that my receiver...

    Ann45 pointsBadges:
  • Embedded SQL to process ALL members

    Hi, I'm trying to get an RPG with embedded SQL to read all the members in a file. I know I used to be able to do this with an OVRDBF command with *ALL specified for the member, but this doesn't seem to work anymore. In the joblog I get a CPF4268 message which says the file has no members or is not...

    Gilly40023,730 pointsBadges:
  • Joining Tables in SQL Server

    What is the difference between Outerjoin and Left outerjoin.

    Bijaybehera2915 pointsBadges:
  • SQL Column Headings

    When I run an SQL statement the column headings I see are the field names. When any of the other members of our team run the same statement they get the field descriptions as column headings. I have compared user profiles and there are no differences. Is there some other place that this setting is...

    deniseg35 pointsBadges:
  • SQL Stored Procedure

    I need to create a stored procedure with an input parameter of member name to create an Alias, select all the data in the member then drop the Alias. This procdure wil be called by 3rd party software using an odbc connection.

    Markpg155 pointsBadges:
  • Using the SQL IN clause in SQLRPGLE

    Can I use a variable with the IN clause in an iSeries SQLRPGLE program? Can I use: WHERE CUSTID IN(:CUSTNUMS) Instead of: WHERE CUSTID IN(145,1600,352)

    PWMASI5 pointsBadges:
  • Visual Basic

    What would be the code (using regular expression) to match the page , whos title changes during runtime, but we know that it will contain the string "Welcome" in the begining of the title?

    Gaby15 pointsBadges:
  • Query 400 – SSN

    Hi all, I need to strip all but the last 4 digits of employees SSN in a file...I cannot remember what the string is!!! Can someone help? BTW, the current field has NO dashes in the SSN. Thanks in advance!! Rick

    Rmason345 pointsBadges:
  • Update a field in one table after the change on a field in another table using a trigger in SQL

    I have a WODet table and after the field "Complete" is changed to "True" I need to update my SODet table field "UD3" to "True" using a trigger in SQL where dbo.SalesOrderDetails.SalesOrderDetailID = dbo.WorkOrderDetails.SalesOrderDetailID Thank you in advance

    Tanjaatbrenlo40 pointsBadges:
  • PL/SQL: How to check that parameter is case-sensitive?

    Hi Experts how can i check the email id shud take only lower case in PL/SQL block i tried using vpos := REGEXP_LIKE(p_email_address,'[:lower:]','C'); as well vpos ;= REGEXP_LIKE(p_email_address,'[^[:lower:]]','C') But both says wrong type as error and p_email_address is a parameter of procedure and...

    Inprise610 pointsBadges:
  • Using WildCards in IIF Statement

    Hi, I have a query that uses a field on a form to filter what information gets displayed. This is simple I know but what I need it to do is display all records if I don't enter anything in the field on the form. I tried putting the following IIF statement in the Criteria:...

    RoadDust390 pointsBadges:
  • programming

    How can I make .png image function as a button in php when clicked. I tried this code but didnt work:<img src="images/log_in.png" align="middle" name="ok" /> <? $name = $_POST['name']; $pass = $_POST['password']; if (isset($_POST["ok">)) { echo"hie"; } ?> but when I click the button I...

    Azurie50 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