aHa, Jill
Yes, indeedy. It's all starting to make sense now :-)
1) You have been mixing PLAIN PB stuff with PFC stuff <bg>... Well, I
wish there were a _PFC_ Example of the QueryMode service like the PB one,
but I couldn't find one. Flipside, it is a relatively easy service.
Here's how...
2) Turn on the service in the DW's constructor, by calling
of_SetQuerymode(TRUE)
3) Call of_SetColumnNameSource()/of_SetQueryCols() if desired
4) Do not code any dw_1.Object.datawindow.QueryMode= 'yes/no' - Nor any
other such things, such as QueryClear, etc. Instead, you will use the PFC
QueryMode Service function, of_SetEnabled(), which does that and more for
you. Feel free to go look at the code in
pfcdwsrv(pfc_n_cst_dwsrv_querymode) and pfcmain(pfc_u_dw)
a) For the Query button, if not of_GetEnabled(), then of_SetEnabled(TRUE)
b) For the Retrieve button, if of_GetEnabled(), then
of_SetEnabled(FALSE). Then, either call of_SetRetrieveOnDisabled(FALSE)
and do your own retrieve, or go with the default and let it auto-retrieve
when QueryMode is disabled.
c) For the Save/Load buttons, all that is needed is the of_Save/Load()'s
5) You may also want to enable/disable the Save button appropriately
(since you cannot save a query unless the user is in QueryMode and has
entered something to save).
6) Once the user retrieves and then reenters into QueryMode, yes, the
normal behavoir is that the previous query info is "lost" (if not saved and
then reloaded). I suppose that if you and your users really wanted to, you
could try to code in that functionality. But, hm, I personally would see
if it was worth it. Maybe y'all could compromise and do that only if they
previously did a save or something.
7) That's it! You're QueryModing PFC style now <s>
Have fun,
~Sharon
--
Sharon Weinstrom Buntz | mailto:[EMAIL PROTECTED]
Cheat Sheet for PFC/PB Help | http://www.pfccheatsheet.com/
"Jill M. Claus" wrote:
>
> Sharon,
>
> I agree, things definitely weren't adding up - that's why I was so confused!
>
> There is only one datawindow on the window. I had copied the window from the
>PowerBuilder examples and just looked again at the two functions that were already in
>there. (wf_query_mode and wf_retrieve_mode) The following line is in each
>respectively dw_1.Object.datawindow.querymode= 'yes' and
>dw_1.Object.datawindow.querymode= 'no' ... I tried switching the code so that it does
>a SetQueryMode on open and then SetEnabled as needed, but then when you switch back
>and forth between query / retrieve modes, you loose the criteria you just typed in.
>I think that may have been what was causing me all the problems! It's all starting
>to make sense now :-)
>
> Jill
>
> Jill Claus (842-4369)
> Financial Information Management
>
> >>> Sharon Buntz <[EMAIL PROTECTED]> 09/30/99 01:42AM >>>
> yo, Jill
>
> So glad you got it working... But, wait, something does NOT add up!
>
> If THAT were the problem (if you had not yet called of_SetQuerymode(TRUE)),
> then your dw_1.inv_querymode.of_Load() would have gotten a null object
> reference. Jill, you only have to call of_SetQuerymode(TRUE) ONCE - to
> instantiate the service - usually in the DW's constructor. But now it
> sounds like you have it THREE times in your 'window':
> 1) Wherever your window had it to make QueryMode work in the first place,
> 2) Wherever you added it to make your save work, and now
> 3) Wherever you just added it to make your load work.
>
> And there IS only ONE DW doing the QueryMode hop in your 'window', correct?
>
> And there is NOT any place doing a of_SetQuerymode(FALSE), correct? (The
> code to turn off the service is in pfc_u_dw's destructor event.)
>
> When I first read your note, I thought, well maybe she means
> of_SetEnabled(). But, no, that would not make sense either!
>
> Whaddup, girl?!
>
> ~Sharon
> --
> Sharon Weinstrom Buntz | mailto:[EMAIL PROTECTED]
> Cheat Sheet for PFC/PB Help | http://www.pfccheatsheet.com/
>
> "Jill M. Claus" wrote:
> >
> > Duncan & Sharon,
> >
> > I got it working! :-)
> >
> > As it turns out, I did have to explicitly say of_SetQuerymode(TRUE) before the
>load. (not only just for the save)
> >
> > Thank you so much for your help!
> >
> > Jill
> >
> > Jill Claus (842-4369)
> > Financial Information Management
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
