Drop Down Datawindow issues in Datawindow

We recently moved from version 8.0.3 9704 to 8.0.3 9977. 
Since this move we have had nothing but grief with
DropDownDatawindow style columns.

Basically - we have columns that are dropdowns that the user
can enter their values into or, scroll down and select from.
 We then have code that verifies that the value entered in
the column exists in the drop down list (i.e. is the data
entered by the user valid).

When we get the value from the column (using either dot
notation or, getitem functions) PB is giving us the display
value for the drop down NOT the code value.

SOMETIMES when we delete the column and re-add it - it will
suddenly work.  However, in dataobjects with multiple drop
downs - fixing one seems to mess up another.

ANY HELP IS APPRECIATED.  I'm at a loss as to how to resolve
this.

TIA!!!
1
William
7/20/2004 7:51:57 PM
sybase.powerbuilder.datawindow 28057 articles. 4 followers. Follow

5 Replies
748 Views

Similar Articles

[PageSpeed] 56

What's the reason for moving from 8.0.3 9704 to an interim
build instead of 8.04?

> We recently moved from version 8.0.3 9704 to 8.0.3 9977.
> Since this move we have had nothing but grief with
> DropDownDatawindow style columns.
>
> Basically - we have columns that are dropdowns that the
> user can enter their values into or, scroll down and
> select from.
>  We then have code that verifies that the value entered in
> the column exists in the drop down list (i.e. is the data
> entered by the user valid).
>
> When we get the value from the column (using either dot
> notation or, getitem functions) PB is giving us the
> display value for the drop down NOT the code value.
>
> SOMETIMES when we delete the column and re-add it - it
> will suddenly work.  However, in dataobjects with multiple
> drop downs - fixing one seems to mess up another.
>
> ANY HELP IS APPRECIATED.  I'm at a loss as to how to
> resolve this.
>
> TIA!!!
0
Philip
7/20/2004 9:53:39 PM
> What's the reason for moving from 8.0.3 9704 to an interim
> build instead of 8.04?
>
> > We recently moved from version 8.0.3 9704 to 8.0.3 9977.
> > Since this move we have had nothing but grief with
> > DropDownDatawindow style columns.
> >
> > Basically - we have columns that are dropdowns that the
> > user can enter their values into or, scroll down and
> > select from.
> >  We then have code that verifies that the value entered
> > in the column exists in the drop down list (i.e. is the
> > data entered by the user valid).
> >
> > When we get the value from the column (using either dot
> > notation or, getitem functions) PB is giving us the
> > display value for the drop down NOT the code value.
> >
> > SOMETIMES when we delete the column and re-add it - it
> > will suddenly work.  However, in dataobjects with
> > multiple drop downs - fixing one seems to mess up
> another. >
> > ANY HELP IS APPRECIATED.  I'm at a loss as to how to
> > resolve this.
> >
> > TIA!!!

The company I work for uses some other vendors software -
they are developing using 9704 - one of the "higer ups"
thought we should be at the same version - makes no sense I
know - anyway, you asked....

Any idea about the DDDW problem?
0
William
7/21/2004 1:51:13 PM
> > What's the reason for moving from 8.0.3 9704 to an
> > interim build instead of 8.04?
> >
> > > We recently moved from version 8.0.3 9704 to 8.0.3
> > > 9977. Since this move we have had nothing but grief
> > > with DropDownDatawindow style columns.
> > >
> > > Basically - we have columns that are dropdowns that
> > > the user can enter their values into or, scroll down
> > > and select from.
> > >  We then have code that verifies that the value
> > > entered in the column exists in the drop down list
> > > (i.e. is the data entered by the user valid).
> > >
> > > When we get the value from the column (using either
> > > dot notation or, getitem functions) PB is giving us
> > > the display value for the drop down NOT the code
> > value. >
> > > SOMETIMES when we delete the column and re-add it - it
> > > will suddenly work.  However, in dataobjects with
> > > multiple drop downs - fixing one seems to mess up
> > another. >
> > > ANY HELP IS APPRECIATED.  I'm at a loss as to how to
> > > resolve this.
> > >
> > > TIA!!!
>
> The company I work for uses some other vendors software -
> they are developing using 9704 - one of the "higer ups"
> thought we should be at the same version - makes no sense
> I know - anyway, you asked....
>
> Any idea about the DDDW problem?

Yes. I don't believe you :-)
0
Philip
7/21/2004 3:27:26 PM
> > > What's the reason for moving from 8.0.3 9704 to an
> > > interim build instead of 8.04?
> > >
> > > > We recently moved from version 8.0.3 9704 to 8.0.3
> > > > 9977. Since this move we have had nothing but grief
> > > > with DropDownDatawindow style columns.
> > > >
> > > > Basically - we have columns that are dropdowns that
> > > > the user can enter their values into or, scroll down
> > > > and select from.
> > > >  We then have code that verifies that the value
> > > > entered in the column exists in the drop down list
> > > > (i.e. is the data entered by the user valid).
> > > >
> > > > When we get the value from the column (using either
> > > > dot notation or, getitem functions) PB is giving us
> > > > the display value for the drop down NOT the code
> > > value. >
> > > > SOMETIMES when we delete the column and re-add it -
> > > > it will suddenly work.  However, in dataobjects with
> > > > multiple drop downs - fixing one seems to mess up
> > > another. >
> > > > ANY HELP IS APPRECIATED.  I'm at a loss as to how to
> > > > resolve this.
> > > >
> > > > TIA!!!
> >
> > The company I work for uses some other vendors software
> > - they are developing using 9704 - one of the "higer
> > ups" thought we should be at the same version - makes no
> > sense I know - anyway, you asked....
> >
> > Any idea about the DDDW problem?
>
> Yes. I don't believe you :-)

ugh... help.....
0
William
7/21/2004 3:56:54 PM
> > > > What's the reason for moving from 8.0.3 9704 to an
> > > > interim build instead of 8.04?
> > > >
> > > > > We recently moved from version 8.0.3 9704 to 8.0.3
> > > > > 9977. Since this move we have had nothing but
> > > > > grief with DropDownDatawindow style columns.
> > > > >
> > > > > Basically - we have columns that are dropdowns
> > > > > that the user can enter their values into or,
> > > > > scroll down and select from.
> > > > >  We then have code that verifies that the value
> > > > > entered in the column exists in the drop down list
> > > > > (i.e. is the data entered by the user valid).
> > > > >
> > > > > When we get the value from the column (using
> > > > > either dot notation or, getitem functions) PB is
> > > > > giving us the display value for the drop down NOT
> > > > the code value. >
> > > > > SOMETIMES when we delete the column and re-add it
> > > > > - it will suddenly work.  However, in dataobjects
> > > > > with multiple drop downs - fixing one seems to
> > > > mess up another. >
> > > > > ANY HELP IS APPRECIATED.  I'm at a loss as to how
> > > > > to resolve this.
> > > > >
> > > > > TIA!!!
> > >
> > > The company I work for uses some other vendors
> > > software - they are developing using 9704 - one of the
> > > "higer ups" thought we should be at the same version -
> > > makes no sense I know - anyway, you asked....
> > >
> > > Any idea about the DDDW problem?
> >
> > Yes. I don't believe you :-)
>
> ugh... help.....


Alright - well - it seems that it only seems to be an issue
if "Allow Edit" is checked..... Is this a documented bug??
Does anyone know if it's fixed in 804?
0
William
7/21/2004 6:21:09 PM
Reply:

Similar Artilces:

DataWindow This, DataWindow That...
Blah blah blah You've heard it enough that you don't even want to comment on how many times... The DataWindow. ....but it can't be enough anymore...can it? This from one of our colleagues (and yes my apologies for taking it out of context)... "...PB covers all you need to do that in ONE Tool. This includes Windowprogramming ( meaning the interface to the user: Windows, Sheets, diallougeboxes, etc.), Database operability AND Reporting! Well, I see als well as many other PB users that some of the implementations and features PB offers are improvable. But thi...

Drop down datawindow within a datawindow
I have a datawindow that is attached to a PL/SQL stored procedure that is supposed to list records. Several of the fields in the list are identified as Style DropDownDW. The intent is that for these fields there will be multiple values available by using a vertical scroll bar and arrow. For example, a record in the window might have Name Address Medical Code Medical code would also be a drop down list box with multiple values. Is there a simple way to implement this in Powerbuilder 9? What kind of PB coding constructs would be necessary? Thanks Please post this question ...

Drop down datawindow within datawindow
I have a datawindow that is attached to a PL/SQL stored procedure that is supposed to list records. Several of the fields in the list are identified as Style DropDownDW. The intent is that for these fields there will be multiple values available by using a vertical scroll bar and arrow. For example, a record in the window might have Name Address Medical Code Medical code would also be a drop down list box with multiple values. Is there a simple way to implement this in Powerbuilder 9? What kind of PB coding constructs would be necessary? Thanks Generally, the steps are: ...

How to share the datawindow to inner datawindow of nested datawindow
How to share the datawindow to inner datawindow of nested datawindow. Ex -------- dw_1 is normal datawindow dw_nes is nested datawindow, both are placed one window dw_nes contain dw_child datawindow Question ---------------- i want to share dw_1 and dw_child. I have tried the below code, getting error dw_1.sharedata( dw_nes.object.dw_child) It's the dot notation. You will need to dw_nes.GetChild("dw_child", ldwc) where ldwc is a _local_ datawindowchild. <kzganesan@gmail.com> wrote in message news:4c64c402-bac5-4ee0-83aa-4ac08ffe43e5@r66g2000hsg.go...

datawindow
Add direct setting and getting capability for the datawindow where clause. This would have to be a string array in case of unions. Return ONLY the where clause(s) in the main select (in case of sub-selects, ignore the where clause or somehow list it as a subselect in the where or a subselect in the select). It would be great if I could just get and set this as a value and have the datawindow automatically change (or add) the where clause as specified. This is for setting the where clause dynamically at run time. Currently have to parse through the datawindow.table.select looking f...

modifiyin a datawindow in a datawindow
Hi, When I want to modify a datawindow, then it's just dw1.modify() But what do I have to do when I want to modify a datawindow in a datwindow ? I tried : dw1.dw2.modify() but that doesn't work. Anyone can help me out with this ? thanks. Regards, David get the dw via getchild & apply modify In article <4575976f.4dda.1681692777@sybase.com>, David says... > Hi, > When I want to modify a datawindow, then it's just > dw1.modify() > > But what do I have to do when I want to modify a datawindow > in a datwindow ? > I tried : dw...

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...

DataWindow Within DataWindow
How Can I access/modify object/control from a Datawindow within Datawindow. When i access/modify object/control from a Datawindow i used dw_1.modify("name.text = 'new val'") but within another datawindow or child datawindow it doesnt work. Your description is difficult to understand due to the terminology. First, a datawindow is assigned to a control - either a datawindow control or a datastore. Second, the Modify function can only be called within a script. With that as a basis, can you rephrase the question and describe more precisely what you want to do? ...

DataWindows and datawindow objects
Difference between Datawindow and datawindowobjects? - datawindow is a control on a userobject or a window - datawindowobject (DWObject) is a control within a datawindow, defined in the dataobject of the datawindow. You refer to it as <datawindow-instance>.Object.<datawindow object> HTH, Ben (bede) <Santhoshi> wrote in message news:3f8bee8b.4631.846930886@sybase.com... > Difference between Datawindow and datawindowobjects? Not exactly; DW Control is a "container" that reserves real-estate on the surface of a visual object. DW Obj...

Datawindows with child datawindows
I want to create a datawindow whose only data is three columns that will themselves be drop-down data windows. These child datawindows will be populated in PB script with dw_1.GetChild(). When I create that parent datawindow (New | Datawindow | Freeform), what do I choose in the next dialog box ("Which datasource would you like to use?") External? Thanks. That depends on how you want to populate and use the columns of the main DW. The DDDW is an edit style that assists the user in selecting a value for the column in the main DW. If you want to retrieve the values ...

Drop Down Datawindows in a HTML Datawindow not working
Hi, I have a HTML Datawindow with some dropdown datawindows in it. Everything works fine except the drop down datawindows. The dddw's work fine in PB or Datawindow Builder. All the dataobjects are in one pbl. Any idea... Thanks.. Reddy Can you take a look at the generated HTML and see if the data from the dddw is present? The way it works is that the dddw is retrieved and then the rows used in the html. Can you tell if it is being retrieved? Also, does it work from previewing in PowerDynamo? -- Build Your Future With PowerBuilder 7.0 www.c...

Is there any issue in creating dynamic datawindow in Datawindow.Net?
Hi I have created a datawindow object in PB10 and exported in to SRD file. In my dot.net application, I read the file into string and issued the following command to create datawindow dynamically. But it throws an methodfailureexception error as "incorrect syntax at line 18 and column 14. Dim ls_create As String Dim fs As FileStream fs = New FileStream(curFileName, FileMode.Open, FileAccess.Read) 'declaring a FileStream to open the file named file.doc with access mode of reading Dim d As New StreamReader(fs) 'creating a new StreamReader and passing the filestream...

DataWindow.NET : issue using external datawindow
Hello, I created an external datawindow with 3 columns, but I have error messages when I want to use it in my .NET application : When I want to insert rows, I get the message : "InsertRow was called when no DataWindow object was attached." I set in design mode my pbl library and also the datawindow name I want to use. I also tried to set it dynamically in the code, but it changes nothing. I'm sure SQLCA isn't useful for this kind of DataWindow, but I also tried to set it and I get the message "SetTransaction was called when no DataWindow object was att...

Drop Down Datawindow On Datawindow Reacts Differently On Two Machines
Hello All, I have a weird situation where I have a datawindow that has a dropdown datawindow on it. When I run it on one machine it displays the display value as specified but when I run it on the other PC it always shows the data value. Both PC's I believe are configured exactly the same. I went option by option through the menus. Both machines are running windows 2000 and both are using Oracle 9.0.1. Any suggestions ? I am at a total loss. Thank You In Advance For Your Time And Effort Ira That symptom means the data value was not found in the DDDW's result set. ...

Web resources about - Drop Down Datawindow issues in Datawindow - sybase.powerbuilder.datawindow

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/18/2015 12:41:33 AM