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...
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...
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 created a Columnar form that...
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 seperate sheet; listing all of the...
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...
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 me....
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


