Selecting Null from a DDDW using custom datawindow component

 I have a dropdown datawindow which selects products from a product table. I
also allow selection of all products by using NULL as the 'Select All' value

SELECT product_no as prod_no,
               product_desc as desc
FROM products
UNION
SELECT NULL as prod_no,
               '(All Products) as desc
FROM products

I then have a computed field, which is used as the display column, with the
following expression

if(IsNull(prod_no),'(All Products)',desc)

Whenever I select the '(All Products)' from the dropdown through the web dw
component I get the following error.

"Item '(All Products)' does not pass validation test"

Any ideas ? ( Powerbuilder 8.01, Jaguar 3.6.1, Powerdynamo 3.5 ) ( this
works fine in client/server app )



0
Colin
2/27/2002 4:11:06 PM
sybase.easerver.general 7903 articles. 0 followers. Follow

1 Replies
470 Views

Similar Articles

[PageSpeed] 23

Do you have the "empty value is null" property checked?

--
Larry Cermak [Team Sybase]
Branick Consulting, Inc.
www.branick-inc.com
Web DataWindow eBook


"Colin Brown" <colinbrown@eircom.net> wrote in message
news:xTyM0l6vBHA.328@forums.sybase.com...
> I have a dropdown datawindow which selects products from a product table.
I
> also allow selection of all products by using NULL as the 'Select All'
value
>
> SELECT product_no as prod_no,
>                product_desc as desc
> FROM products
> UNION
> SELECT NULL as prod_no,
>                '(All Products) as desc
> FROM products
>
> I then have a computed field, which is used as the display column, with
the
> following expression
>
> if(IsNull(prod_no),'(All Products)',desc)
>
> Whenever I select the '(All Products)' from the dropdown through the web
dw
> component I get the following error.
>
> "Item '(All Products)' does not pass validation test"
>
> Any ideas ? ( Powerbuilder 8.01, Jaguar 3.6.1, Powerdynamo 3.5 ) ( this
> works fine in client/server app )
>
>
>


0
Larry
2/28/2002 3:35:58 PM
Reply:

Similar Artilces:

how to use a customizer HTML Datawindow component in Jaguar
Hi, I try to use a customizer HTML Datawindow component in Jaguar instead of the basic HTML Datawindow. I use it to define the name of the DW and the parameters of the connection. That's the result on my browser: ---------------------------------------------------------------------------- -- Warning: undefined variable newObject.sourceLocation.sourceURL[sourceURL] near line 695 in "/testhtmldw.htm" Warning: undefined variable newObject.sourceLocation.sourceFileName[sourceFileName] near line 696 in "/testhtmldw.htm" Warning: undefined variable newObject.so...

Problem at use methods of components EAServer as stored procedures in DataWindow.
I create in PowerBuilder object DataWindow with DataSource as stored procedures. Stored procedures are methods of component EAServers which returns resultset. All works perfectly if the method does not have parameters. If the method has parameters PowerBuilder dysplaying error message box: Cannot create DataWindow 'SystemException - IDL:omg.org/CORBA/MARSHAL:1.01 execute PackageName.Component.method;1' Any ideas? Best regards, can you post the code in the method? -- Dean Jones TeamSybase PowerTeam, Inc. www.powerobjects.com "Ivan Lisenkov" <...

Having problems with Components that use other Custom Components [Edit]
I need to understand how the components work and interact with each other better. I have three components that I have created for my software so they can be included in a bunch of related applications. Host.bpl - Low level Disk I/O, Licensing, INI file functions, encryption, etc. Database.bpl - Database functions for many different databases Resource.bpl - GUI level functions. Any visual components My Database component uses the Host component for some of its functions My Resource component uses the Host and Database component functions All I need to place on my high level applicati...

superreview requested: [Bug 264980] [MASv1.8a2++] Installer crashes when using Alt-N key on 'Select Components' step of 'Custom' install : [Attachment 174245] (Av1) <setuprsc.rc>
Serge GAUTHERIE <gautheri@noos.fr> has asked Daniel Veditz <dveditz@cruzio.com> for superreview: Bug 264980: [MASv1.8a2++] Installer crashes when using Alt-N key on 'Select Components' step of 'Custom' install https://bugzilla.mozilla.org/show_bug.cgi?id=264980 Attachment 174245: (Av1) <setuprsc.rc> https://bugzilla.mozilla.org/attachment.cgi?id=174245&action=edit ------- Additional Comments from Serge GAUTHERIE <gautheri@noos.fr> Per comment 14 suggestion. I have no compiler: Could you compile/test/(super-)review this patch ? Thanks....

superreview granted: [Bug 264980] [MASv1.8a2++] Installer crashes when using Alt-N key on 'Select Components' step of 'Custom' install : [Attachment 174245] (Av1) <setuprsc.rc>
Daniel Veditz <dveditz@cruzio.com> has granted Serge GAUTHERIE <gautheri@noos.fr>'s request for superreview: Bug 264980: [MASv1.8a2++] Installer crashes when using Alt-N key on 'Select Components' step of 'Custom' install https://bugzilla.mozilla.org/show_bug.cgi?id=264980 Attachment 174245: (Av1) <setuprsc.rc> https://bugzilla.mozilla.org/attachment.cgi?id=174245&action=edit ------- Additional Comments from Daniel Veditz <dveditz@cruzio.com> r+sr=dveditz ...

Using a custom component
I hired a company to develop a web application. They built most of it in VB because that is what I had started it with. One important piece, they did in C# and compiled it in to a DLL. I believe this is a "custom component". This component is called at the end of the application and it's function is to create a PDF file using static text and data from SQL 2005. I have done this before without compiling the PDF generation piece. I am having trouble getting the flow process I need to have happen for a smooth end user experience. On the last page when a user clicks a button that...

Using datawindows from the EAServer
Hi there, I hava succeeded to deploy a datawindow on the application, but I can't figure out how I'm going to use it. When I have a JDataWindowControl on my form how do I put the datawindow object, which is a Corba object, into thar form? Second, when I'm trying to invoke a method on the object that I have got through my lookup I'll get a org.omg.Corba.UNKNOWN exception with minor code 0 and completion status as not completed. Why does I get such an error? Hope to here from you soon regarding this two issues. Thanks in regards, Jess ...

Unable to select EAServer Component
While creating a new 'Web DataWindow Page', if I select 'Web DW Container' as the component type, then on the next screen where I am supposed to 'Select EAServer DataWindow Component', I am unable to select the component although I can see the component there. What am I doing wrong? Any pointers will be appreciated. Example from Tutorial: In the 'Select EAServer DataWindow Component' screen, I get this: EAServer Host: localhost pbtutor_package pbtutor_component But I cannot select this 'pbtutor_component'. When I click N...

Using keys when selecting in dddw
Hi ! Using dddw and selecting in a list using keys (none editable dw). A strange thing happens when i.e a dddw-list contains : P8,P9,PO,PPgen,PTer. When pressing P , it jumps over P9 and sometimes PO (as if PB think it is a repeat of P's). I have to wait some time between each P-press to receive each pbm_dwnkey. Is there some other event that can be trapped ? Other ideas ? regards /jostein frorud ...

Using ShareData and DDDW in DataWindows
Hi I wrote a simple script in which I use two datawindows that share data with the ShareData Function. I have a problem: when I use a Drop Down Data Window in the master window it's all ok, but when i use another DDDW (or even the same) in the other DataWindow, the DDDW is empty. Thank you in advance, Antonio SCP Calcolatori wrote: > > Hi > I wrote a simple script in which I use two datawindows that > share data with the ShareData Function. > I have a problem: when I use a Drop Down Data Window > in the master window it's all ok, but when i use anot...

datawindows in composite datawindow used in datawindow.NET, are not sliding up
Hi, Problem: datawindows in composite datawindow used in "datawindow.NET", are not sliding up , if one dw is not visible or did not retrieve data. Resulting in unwanted spaces. The height of blank white space is equal to the height of the datawindow art design time. When I looked at the generated JavaScript, I noticed there is "div" for the datawindow with height 0.00in which is supposed to be not visible. Tried different options with html/xhtml/xml same result. But slides up ok when exported to pdf(using saveas) on web and in PB10.5 application. Also s...

Using custom template with List component
I am curent using a List component to store a url, however I need to overload the template and each item will be in its own cell in a table, but on the same row. Problem is that although I seem to have items in the list, the data is never being shown. I think its the way I am accessing the data in the list, ie I am passing the MobileListItem into a "code behind" method on the page, however when I place a breakpoint on this method it is never called?, and to confuse me even more, when I make the call to the method errornous the page fails! Would really appreciate some help, n...

no event on selection using drop down datawindow
I am having a problem with a datawindow. In this datawindow are five fields in four dropdown datawindows and one edit that are bound to the same datawindow. (When the dropdown is selected all fields are displayed in the dropdown) This table is a list of the valid combinations of these five fields. One of these fields is the fiscal year and the other four are codes assciated eith that year and each other. Lets say there is code DOH1 in FY 2000 and also a code DOH1 in fiscal year 1999. the user wants to select DOH1 for 1999 but mistakenly selects DOH1 for 2000. The users then reali...

Multiple Selections in Child DataWindow DDDW
Dear All, I would like to know, is there any possibility to select more than one record in DropDownDataWindowss attached to a column in a DataWindow Thanks in advance 1. Use: GetChild method of DataWindow control to get DropDown DW as a DatawindowChild object 2. Work with DatawindowChild object to set the selection "Sybase" <kr_vasudev@hotmail.com> schrieb im Newsbeitrag news:40e4fe47$1@forums-2-dub... > Dear All, > > I would like to know, is there any possibility to select more than one > record in DropDownDataWindowss attached ...

Web resources about - Selecting Null from a DDDW using custom datawindow component - sybase.easerver.general

PowerBuilder - Wikipedia, the free encyclopedia
PowerBuilder is an integrated development environment owned by Sybase , a division of SAP . It has been in use since 1991, peaking around 1998 ...

Intelligent Versus Surrogate Keys
Should I use business columns as primary key fields for tables in thedatabase, or generate artificial primary key values? When business-related ...

chevy volt
ProEXR File Description =Attributes= channels (chlist) compression (compression): Zip dataWindow (box2i): [0, 0, 5119, 2475] displayWindow (box2i): ...

Enable - A comprehensive solution for the localization of PowerBuilder applications Untitled Document ...
Enable is localization/ translation tool used by PowerBuilder developers to make their applications multilingual.Enable is a powerful tool that ...

comp.lang.clipper.visual-objects - Google Groups
comp.lang.clipper.visual-objects 1-20 von 33006 Themen werden angezeigt Integrity of a file marcosm...@gmail.com 09:35 Combobox value Lu 08:12 ...

Sybase PowerBuilder tool readied for Microsoft's .Net
Developers can choose Win32 or newer style .Net development

PowerToTheBuilder - PowerBuilder UI Controls
HOME - COMPONENTS - PB UI DESIGNER - DOWNLOAD\PURCHASE - SUPPORT - FAQ - ABOUT Take Control of your UI with PB Ultimate Suite PowerToTheBuilder.com ...

Beautiful iPad Mini 3 Concept Reimagines Appleā€™s Tablet With iPhone 6 Design, Gold Color [Images]
The iPhone 6 may be grabbing all of the recent headlines due to its impending announcement, but spare a thought for those who prefer to stay ...

Java Networking - Real's HowTo
Real's HowTo Custom Search Java Language String and Number Applet AWT Swing Environment IO Javascript interaction JDBC Thread Networking JSP ...

Business Intelligence Products - Database Management, Data Warehousing & Mobility Software - Sybase Inc ...
Sybase offers a variety of Business Intelligence (BI) software like products for database management, data warehousing and mining, data integration ...

Resources last updated: 12/29/2015 1:51:42 PM