• When using IfNull in my SQL, records are ignored

    I know my data table has nulls in it. If my select statement doesn't include those fields, I get hundreds of records. If I include those fields with an IfNull, it skips all but 4 records. Here's my testing snippet: C/Exec sql C+ DECLARE C1 CURSOR FOR C+ SELECT C+ accountID, C+ ifNull(address,' ')...

    Frydaze120 pointsBadges:
  • Is it possible on iSeries that an index is defined keeping in mind an sql select criteriea however when the queryis run this index does not get used.

    Is it possible on i series that an index is defined keeping in mind an sql select criteriea however when the queryis run this index does not get used. We had an issue wherein an entire library had to be cleared and all files from had to be restored from a previous backup, after the backup was...

    JohnsonMumbai1,160 pointsBadges:
  • How to create a progress screen for use with a VB Script Logon script?

    Hi I have recently created a VB Script to replace the existing Kix logon script. The VB Script Disconnects the network drives and then maps the drives depending on the users security group membership via active directory. The Printers are then mapped and the default set depending on the user group....

    Sharlene55 pointsBadges:
  • Can Visual Basic be used to control a piece of mechanical equipment?

    Before I spend a lot of time learning VB (I am an old Basic man) I want to know if it can control a process, the way a PLC does. Or should I be looking at another device or language. I can use a plc, but I'd rather use a Windows based processer. PLCs are too darn specific. Each one has its own...

    GTPJim35 pointsBadges:
  • Stored Procedures called from RPG programs

    I created a stored procedure that returns a result set. I am using it in a PHP program and all works great. Pass in a account Id and returns all hits for valid records for that account. We have a excel report and subfile screen that runs off a green screen that needs to retreive this same data. My...

    nu40400 pointsBadges:
  • Business Intelligence Platform Integration

    Hi and thanks for reading. I'm very green when it comes to database integration.  I'm currently working for a web-based communications firm that has an end-to-end, information sharing system.  Long story short, it's offers a CRM, system tracking, document sharing and streamline capabilities. My...

    Ando14855 pointsBadges:
  • Change fonts in drop down box created with autofilter in Excel 2003

    1. Is there a way to change the font size of the an auto filter drop down box?

    Mmppmm10 pointsBadges:
  • Report / File repository for AS/400 V5R4

    Currently we have a home grown web application where we send our reports from the AS400 so our clients can view them. They are converted into a Monarch format. We would like to replace this with something else. We need to be able to put out .csv files, .pbf files and other types in addition to just...

    CharlieBrowne41,380 pointsBadges:
  • Two SQL server synchronization

    How can I merge two SQL Server databases? One sql server is in web  and another in local machine  both sql servers will have daily data transactions entries. how to merge those daily data transactions between the two sql server?  i am new to sql synchronization and merging. could you kind...

    Qqqqqqqqqqqqqqqqqqqq20 pointsBadges:
  • Website monitoring suggestions?

    Suggestions for website monitoring? Is there something that monitors for security vulnerabilities?

    NewnanIT1,110 pointsBadges:
  • Value of() in SQL Server?

    what is the equivalent statement of valueof() of oracle in sql server?

    Prcvjr220 pointsBadges:
  • Create QA database with only some production tables

    I have a large database with some tables that have largely static data. I need to make a new database on a different server with the same table structure with the static data tables intact (keys, etc.). The other tables must be empty. They're all in the same filegroup in the original database. I've...

    Rwaltz5 pointsBadges:
  • Adding New Parameter to a existing Crystal reports 9.5

    I have a exsiting crystal rpt that passes 5 parameters to a stored proc.  We have added 1 more parameter to the procedure now when attempting to run the crystal rpt it errors out with proc expects parameter "new" (new being the added parameter).   I have been unable to get around this. Can...

    Ftrucks015 pointsBadges:
  • Lotus Notes 8.5.1 error message

    Get error message that say " You are attempting to upgrade a multi user installation " I have unistalled the other version 6.5.1 . The one am trying to install is notes_designer_admin_851_w32 .. am using XP 32bit

    Canafishdrown15 pointsBadges:
  • Dynamically Add Picture Control in a window in PowerBuilder

    Good day, In PowerBuilder, how can I add a picture control on a specific location on a window progmatically or at runtime...?  thanks.

    Bogus215 pointsBadges:
  • RAID 0 with an Internal and External Drive?

    I was wondering if I could be able to set up my default hard drive and a new external hard drive for RAID 0. My internal disk drive is a ST3160815AS ATA Device (149 GB, IDE). And I have a My Passport Essential 500 GB USB 2.0 Portable External Hard Drive WDBAAA5000AD6-NESN. Will I be able to have a...

    DrApocalypse5 pointsBadges:
  • Date conversion (to_char) behavior

    Hi everybody. We are experiencing a strange behavior with a "to_char" conversion: We are using Oracle 8i and Developer 6i. An application need to know the day of the week (number of day) of a given date, and we are doing that with "to_char(given_date,'D')". This returns a 1 for sunday, and 7 for...

    carlosdl70,220 pointsBadges:
  • Fill Char-elements w For Loop in Array

    How to: use a For-loop to assign alphabetic symbols to Char-elements in 1 dim array with a upperbound of 15 or so(so not the whole alphab.)

    Kogia5 pointsBadges:
  • Inconsistent behaviour of VB.NET

    I have a form which is displaying some user specific details. After pressing save button which is on form , if i close the form and then again displays it to user the changes done are working , but if i don't close the form then the changes done didn't reflected.

    Honeyprogrammer35 pointsBadges:
  • Can we change opacity of an MDI child window in VB.NET?

    can we change opacity of an MDI child window in VB.Net?

    Bvicky9920 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