DDDW display vs data column

SPD0060

unread,

Jan 10, 2010, 5:48:14 PM1/10/10

to

I have DW with a tabular dataobject in it that has one column which is
a long. It has a dddw on it that displays a computed column
(concatenation of a name/company name) but of course stores the
contact id number. Even though the dddw retrieves properly ( I can
see the list names when I click the arrow) it only ever displays the
number. The display column is set to the name of the computed field.
I use the same mechanism on other dw and I can't see anything in the
code that I'm doing differently. Anyone have this happen before?
Ideas?

Thanks.

Jeremy Lakeman

unread,

Jan 10, 2010, 10:30:57 PM1/10/10

to

The order of the retrieve of the main dw and the dddw can be
important.

Jerry Siegel [TeamSybase]

unread,

Jan 10, 2010, 6:10:10 PM1/10/10

to

Quaint. Displaying the data column usually means the lookup failed. Hunch:
check the data types of the main column and DDDW data column.
And BTW it's a good idea to mention the PB version and build when posting a
question.

--
Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
Product Enhancement Requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

"SPD0060" <sda...@archi-tech-ture.com> wrote in message
news:d07a36c6-980e-4473...@f5g2000yqh.googlegroups.com...

SPD0060

unread,

Jan 10, 2010, 9:47:40 PM1/10/10

to

They are both Int in sql 2008 which in the dwo = long. I'm
using version 11.2 b 8542.

> Quaint. Displaying the data column usually means the
> lookup failed. Hunch: check the data types of the main
> column and DDDW data column. And BTW it's a good idea to
> mention the PB version and build when posting a question.
>
> --
> Report Bugs to Sybase:
> http://case-express.sybase.com/cx/welcome.do Product
> Enhancement Requests:
> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>
>
> "SPD0060" <sda...@archi-tech-ture.com> wrote in message
> news:d07a36c6-980e-4473...@f5g2000yqh.googl

> egroups.com... >I have DW with a tabular dataobject in it

SPD0060

unread,

Jan 11, 2010, 10:05:52 AM1/11/10

to

I'm retrieving the main datawindow from the window open
event and then the dropdown is being retrieved right after
the main one in that retrieve event.

dw_user - pfc_retrieve event:
long ll_ret
ll_ret = this.Retrieve(il_ID)
this.inv_base.of_PopulateDDDW()
return ll_ret

pfc_populatedddw event:
long ll_rc
if not isnull(il_Case_id) then
ll_rc = getchild(as_colname, adwc_obj)
If ll_rc < 0 Then Return -1

ll_rc = adwc_obj.settransobject(sqlca)
If ll_rc < 0 Then Return -1

ll_rc = adwc_obj.retrieve(il_Case_Id)
If ll_rc < 0 Then Return -1
end if
Return 1

jeff

unread,

Jan 11, 2010, 10:26:37 AM1/11/10

to

redraw the data window after you populate the drop list.

or toggle the column with focus.

dw_user.setcolumn("A")
dw_user.SetColumn("B")
dw_user.setcolumn("A")

sounds like the datawindow is note re-drawing itself after the dddw's are
populated.

<SPD0060> wrote in message news:4b4b3e50.234...@sybase.com...

SPD0060

unread,

Jan 11, 2010, 11:08:45 AM1/11/10

to

I tried a single dw_users.setcolumn("contact_id") and it
worked!

Why did I need to do it here but not somewhere else?
Because I have 2 dws on the window?