Hi again, Jill
Sorry, I did not notice before that you had mentioned that you HAD tried a
character field as well. With that in sight...
Does the exact-same PLAIN query work on that CHAR field without doing a
save/load?
Does it behave the same way whether you start out in query mode then press
load - as it does when you start out in 'regular' mode then press load?
Is your DW perhaps doing any special acrobats to make some fields
editable/non-editable, switching the TabOrder or anything?
Is the query's input something that is acceptable to that particular DW
field? See, the field in QueryMode has the same characteristics as the
DATA field. And really the query field is used as syntax to a WHERE clause
(which really is just string text).
Also, what type of DW are you using? [Is it a form (1-row contained in
header only), grid (mult rows), tabular...?] I ask because one odd thing
that I've just noticed when I load my query is that my top row is blank -
the query actually gets loaded into the 2nd row... So if you only have one
row, that behavior might happen - since no query criteria is found (hence
all rows retrieved).
Have fun,
~Sharon
--
Sharon Weinstrom Buntz | mailto:[EMAIL PROTECTED]
Cheat Sheet for PFC/PB Help | http://www.pfccheatsheet.com/
Sharon Buntz wrote:
>
> Jill,
>
> It's probably the special DATE type. Does it work on a character field?
> Or any other data type?
>
> Also, does a plain DATE query work without doing a save/load?
>
> Because it sounds to me that the problem is caused by the DATE type. That
> would explain the behavior of it loading a DATE query, performing the query
> and finding no matches, then retrieving again (which would effect a total
> re-retrieve of all rows).
>
> Have fun,
> ~Sharon
> --
> Sharon Weinstrom Buntz | mailto:[EMAIL PROTECTED]
> Cheat Sheet for PFC/PB Help | http://www.pfccheatsheet.com/
>
> "Jill M. Claus" wrote:
> >
> > Sharon & Duncan,
> >
> > Thank you both for your patience!
> >
> > First - Sharon - in answer to your question... the query mode window has always
>worked regardless of the save/load functionality I am currently trying to add.
> >
> > Here is where I'm at now...
> >
> > Based on the responses from the two of you, the save command button is working
>correctly. The resulting text file has the correct layout/format. Thank you!
> >
> > However the load button is still not working. When I click on it, the standard
>file open dialogue box opens, but after I select the desired file, it doesn't appear
>to do anything. The file open dialogue box closes and I am left looking at an empty
>query mode grid. If I click on retrieve at that point it retrieves the entire table
>which leads me to believe that it didn't actually "load" anything. I tried saving
>and loading a query with a character field in it instead of a date field and the same
>thing happened.
> >
> > For your reference, here is the code that is in the cb_load button:
> >
> > Integer li_return
> > String ls_path_name, ls_doc_name
> > ls_path_name = "c:\temp\"
> > dw_1.inv_querymode.of_Load("Load a Query", ls_path_name, ls_doc_name,
> > "txt", "Query Mode (*.txt),*.txt")
> >
> > Do you have any other ideas?
> >
> > 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]
