SQLCODE 30 on fetch SQLRPGLE
Hello All,  I’m trying to execute a fetch into DS on a SQL statement and keep getting code 30: Number of host variables less than result values. The DS and SELECT statement both have the same number of values as far as I can see.  Here’s the DS and select fields code: D ClaimRecDS     [...]

Answer Question   |  March 17, 2012  9:09 PM
coalesce, NULL values, SQL, SQLRPGLE

Crystal Reports and Null Values
Simplified form of problem - Customers in Cdata, Sales data in SData. SData includes Salesman as a field that can be null. (Often filled, but not required.) A customer can have multiple sales – Report has customer ID as a group, and their is a time value to limit which sales are reported. Need function [...]

Answer Question   |  November 10, 2009  7:33 PM
Crytal Reports, NULL values

How to remove the values of xml tags null without removing the tag names?
Hi, I have the following xml : … …. <A> <B> <C>11122</C> <D>loop</D> <E>30-03-05</E> <F>integer</F> <G>decimal</G> <H /> </B> </A> … …. I need to remove all the values under <payment_details> so that the xml will be in the desired format as below: … …. <A> <B> <C></C> <D></D> <E></E> <F></F> <G></G> <H /> </B> [...]

Answer Question   |  June 25, 2009  12:00 PM
MSXML.DOMDocument, NULL values, XML

Microsoft Access: Hiding form fields with Null values
Hello, I have a table that has Name F1 F2 F3 F4 Wes x Bob x x Mark x x and so on. Certain names have a check mark “x” and others do not. I need to be able to pull up someones name and see a summary of what they have “x”‘s in. I [...]

Answer Question   |  April 30, 2009  11:22 PM
Access VBA, Microsoft Access, Microsoft Access forms, NULL values, VBA, Visual Basic for Applications

Hiding form boxes with null values
Hello, I have a table that has Name vs F1/F2/F3/F4 and so on. Certain names have a check mark “x” and others do not. I need to be able to pull up someones name and see a summary of what they have “x”‘s in. I created a Columnar form that has each name as a [...]

Answer Question   |  April 28, 2009  9:42 PM
forms, NULL values, Visible

Handling null values in XMLType function
I have xmlfile stored in table in CLOB column.It contains some null rows with some spaces. While parsing that column, am using xmltype function on that column, then it is giving error :LPX-00229 input source is empty, beacuse of null clob columns. I have to craete an function index also using xmltype and some aother [...]

Answer Question   |  November 12, 2008  6:11 AM
CLOB, Error LPX-00229, NULL values, XML Parser Messages, XMLType

Error In SQL SERVER DataBase
am trying to insert four varchar(50) values in a table which is with a primarykey column id_number. i didnt check : “True” to the null field . so it should not allow null values in table. but while am trying . it allows null values. including primary key column. how is possible ? pls help [...]

Answer Question   |  July 28, 2008  9:41 AM
Database programming, NULL values, Primary keys, SQL Server errors, VARCHAR, Visual Studio, Visual Studio 2008

Cancel button on the input box function
In the input box operation, the cancel button does not actually cancel the operation, what am I doing wrong? Instead it returns a null value and continues with the rest of the string of code

Answer Question   |  July 10, 2008  1:59 PM
NULL values, Strings