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 the problem is caused by the DATE type. That would
explain the behavior of it loading a DATE query, performing the quer
"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]
y 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]
