Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How to stop autoretrieving datawindow

567 views
Skip to first unread message

Alf Kato Brandal

unread,
Dec 27, 2006, 4:41:38 AM12/27/06
to
Hello, I have a problem.

I have a datawindow in my application, it is
retrieving itself when it is constructed, but then the
parameters are not ready, and I cannot stop the
"Please specify retrieval arguments"
dialog to appear.

What can I do to stop this?

Alf Kato


Stephanie Young

unread,
Dec 27, 2006, 7:17:35 AM12/27/06
to
From the datawindow painter, click on the Design menu and select Options.
On the General tab, turn off the Retrieve on Preview checkbox.

"Alf Kato Brandal" <a...@abrandal.com> wrote in message
news:45924de2@forums-1-dub...

Alf Kato Brandal

unread,
Dec 27, 2006, 7:44:37 AM12/27/06
to
This just stops the retrieving in the datawindow painter.
I need to stop it autoretrieving IN the application.

Alf

"Stephanie Young" <stephanie.youngN_O_S_P_A_M@standardregisterD_0_Tcom>
skrev i melding news:4592726f$1@forums-1-dub...

Jim O'Neil [Sybase]

unread,
Dec 27, 2006, 7:53:31 AM12/27/06
to
DataWindows do not autoretieve in the application. Dropdowndatawindows
do, however, by default, but there is an Autoretieve property you can
set on the DDDW object in the datawindow painter.

On 27 Dec 2006 05:44:37 -0700, "Alf Kato Brandal" <a...@abrandal.com>
wrote:

Alf Kato Brandal

unread,
Dec 27, 2006, 8:08:16 AM12/27/06
to
Hmm, ok.
This is a simple datawindow with two arguments.

There is no call to it's retrieve function, but still it retrieves when the
window it is in is opened.
How come, and can I stop it, so that it will not ask for the arguments?
Later on in the application it works fine, cause then you have chosen some
values, and these are used as arguments to
the retrieve function.

Alf

"Jim O'Neil [Sybase]" <joneil_@_sybase_dot_com> skrev i melding
news:p0u4p2d4p9jp47lhp...@4ax.com...

Chris Werner

unread,
Dec 27, 2006, 8:28:28 AM12/27/06
to
Hi Alf,

there must be a call to the retrieve function of the
datawindow. Maybe it is in a higher level of your
application framework? Debug the application to
find the call.

Good luck

Chris Werner

"Alf Kato Brandal" <a...@abrandal.com> schrieb im Newsbeitrag
news:45927e50@forums-1-dub...

Chris Werner

unread,
Dec 28, 2006, 5:31:30 AM12/28/06
to
Hi Alf,

some questions:

1) Is dw_select_acc a descendant of u_dw?

2) Is u_dw a general dataWindow control
without a special dataObject assigned?

3) How dw_select_acc gets a dataObject?

4) How do you know that dw_select_acc is
the originator of the "Please supply retrieval
arguments" dialog?

5) Match the arguments asked for in the "Please
supply retrieval arguments" dialog really the
retrieval arguments in the dataObject of
dw_select_acc?

There is no code for dw_select_acc in the window
you've posted: No assignment of a dataObject, no
setTransObject, no retrieve, nothing. So I assume
the code is must be elsewhere, in a service object
or a parent of dw_select_acc.

A further possibility to debug the reason would be
to run the compiled application (not from the IDE)
using the /pbdebug switch. Run the application until
the "Please supply retrieval arguments" dialog comes
up, then copy the created debug file (should be <appName>.dbg)
and inspect it carefully. Maybe post it here.

Kind regards

Chris Werner

"Alf Kato Brandal" <a...@abrandal.com> schrieb im Newsbeitrag

news:4593a054@forums-1-dub...
> There actually is NO call to the retrieve function of this datawindow. The
> "Please supply retrieval arguments" occur right after the constructor
> event of the datawindow. I have debugged and clicked through hundreds of
> "getMru" events, but there is no receive before suddenly the dialog box
> pops up.
>
> I attach the code of the window here, the datawindow control is called
> dw_select_acc.
>
> Hope someone can help me. Do you happen to know what event comes after
> "constructor()"??
>
> Alf
>
> "Chris Werner" <cwAT{PleaseNoSpam}f-s.de> skrev i melding
> news:4592830c@forums-1-dub...

Bruce Armstrong [TeamSybase]

unread,
Dec 28, 2006, 6:37:53 AM12/28/06
to

You've attached an object that is inherited from another object. We
have no idea what that object is doing. You also didn't include the
datawindow. The prompt may be coming from a child datawindow (e.g., a
DDDW or a nested datawindow) in which you haven't supplied the
retrieval arguments.

On 28 Dec 2006 02:45:40 -0700, "Alf Kato Brandal" <a...@abrandal.com>
wrote:

>There actually is NO call to the retrieve function of this datawindow. The

>"Please supply retrieval arguments" occur right after the constructor
>event of the datawindow. I have debugged and clicked through hundreds of
>"getMru" events, but there is no receive before suddenly the dialog box pops
>up.
>
>I attach the code of the window here, the datawindow control is called
>dw_select_acc.
>
>Hope someone can help me. Do you happen to know what event comes after
>"constructor()"??
>
>Alf
>
>"Chris Werner" <cwAT{PleaseNoSpam}f-s.de> skrev i melding
>news:4592830c@forums-1-dub...

Chris Werner

unread,
Dec 28, 2006, 7:31:29 AM12/28/06
to
Hi Alf,

if the debug file really ends when the dialog pops up
I guess you to look at the dataWindow DW_TA_TO.
The last action is an insertRow() into it. So have a look
for DDDWs and nested reports with retrieval arguments
in the dataObject of DW_TA_TO. Let us now what you
find there.

Kind regards

Chris Werner


"Alf Kato Brandal" <a...@abrandal.com> schrieb im Newsbeitrag

news:4593c04e@forums-1-dub...
> Hi Chris.
>
> 1) Yes, it is a descendant of u_dw
>
> and 2) Yes u_dw has no dataObject assigned
>
> 3) The dataobject for dw_select_acc is assigned in the window painter.
>
> 4) The dw_select_acc is the only datawindow with these two arguments so it
> has to be the one asking for them.
>
> 5) Yes, they match, and if I enter valid values, I get data in this window
> initially.
>
> I attach the debug file here. The error happens immediately after the end
> of
> the file. Before the "activate" event. I still cannot understand why
> the window tries to retrieve, since I cannot find any retrieve calls...
>
> Best regards,


> Alf
>
> "Chris Werner" <cwAT{PleaseNoSpam}f-s.de> skrev i melding

> news:4593ab12$1@forums-1-dub...

Philip Salgannik

unread,
Dec 28, 2006, 7:38:48 AM12/28/06
to
Insertrow causes dddws to retrieve, my guess the arguments dialog is from
one of them...

"Chris Werner" <cwAT{PleaseNoSpam}f-s.de> wrote in message
news:4593c731$1@forums-1-dub...

Alf Kato Brandal

unread,
Dec 28, 2006, 7:47:20 AM12/28/06
to
I checked this too, and there are no dddw's in this window that has these
two arguments.
Only the dw_select_acc, and it is just a simple datawindow with 3 columns,
with a where
clause for these two arguments.

And there is no call for dw_select_acc.retrieve, so I do not understand why
it wants to retrieve.

Alf

"Philip Salgannik" <philema...@comcast.net> skrev i melding
news:4593c8e8$1@forums-1-dub...

Dmitri

unread,
Dec 28, 2006, 8:02:45 AM12/28/06
to
"Alf Kato Brandal" <a...@abrandal.com> wrote:

> And there is no call for dw_select_acc.retrieve, so I do not understand
> why it wants to retrieve.

It won't retrieve by itself, so there is dw_select_acc.retrieve() somewhere,
it just isn't obvious. Try the following:

1) place something absolutely trivial into the retrievestart event of the
dw_select_acc;
2) place a breakpoint on it;
3) run the program;
4) when program stops at the breakpoint, look at the Call Stack window. It
might give you some insight.

Dmitri.


Alf Kato Brandal

unread,
Dec 28, 2006, 8:09:17 AM12/28/06
to
Hi Dmitri,

thanks for the tip.

I tried placing a messagebox saying "Hello" in the retrievestart event. The
argument dialog appears
before the program reaches the event...

Alf

"Dmitri" <NOdi...@mail15.com> skrev i melding
news:4593ce85$1@forums-1-dub...

Alf Kato Brandal

unread,
Dec 28, 2006, 8:12:47 AM12/28/06
to
In fact, there is only one call to the retrieve function of this
datawindow in the entire application, and that is
inside an "itemchanged" event for a list. And the
application never reaches this point before asking for
the arguments...

Alf Kato

"Dmitri" <NOdi...@mail15.com> skrev i melding
news:4593ce85$1@forums-1-dub...

Chris Werner

unread,
Dec 28, 2006, 8:34:30 AM12/28/06
to
Hi Alf,

anyway type some values in the dialog, click
OK and see wether the messageBox pops
up. If it does not there's obviously an error
in your assumptions. If it does, follow step 4
from Dmitri's post.

Kind regards

Chris Werner


"Alf Kato Brandal" <a...@abrandal.com> schrieb im Newsbeitrag

news:4593d00d$1@forums-1-dub...

Peter J Brechun

unread,
Dec 28, 2006, 9:19:11 AM12/28/06
to
Try inserting a row into the datawindow in the constructor event.

"Alf Kato Brandal" <a...@abrandal.com> wrote in message
news:45924de2@forums-1-dub...

Jason 'Bug' Fenter [TeamSybase]

unread,
Dec 30, 2006, 7:13:03 PM12/30/06
to
"itemchanged" event for a list? Is this list a datawindow or a listview?
It would not surprise me if a listview were to throw up an itemchanged
event as it was being created (just as a window can throw a resize event
as it is being opened).

Wheeley

unread,
Jan 3, 2007, 12:17:09 AM1/3/07
to
On 27 Dec 2006 02:41:38 -0700, "Alf Kato Brandal" <a...@abrandal.com>
wrote:

Probably the simpest solution would be to add a row of data in the
datawindow object itself. This way the only reason the dialog would
appear was if a retrieve is done. In the dw painter, go to the data
tab and insert a row with some data in it. This isn't the best
solution, but t should work. The best solution is try to find what is
cauisng the retrieve.

Wheeley

0 new messages