Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (6)

Resolved Specify retrieval arguments

  1. Advice
0
Votes
Undo
  1. Tracy Lamb
    Tracy Lamb
  2. PowerBuilder
  3. Wednesday, 5 April 2023 20:50 PM UTC

Me again!

Today when testing my app, I keep getting a popup asking for a retrieval argument for edit_user.  That's not a field I would ever do a retrieval argument on. Not sure why PB is asking for a retrieval argument.

The window I'm opening has a pfc_tab object, tab_1.  Tab_1 contains 11 pfc data windows, the window has two pfc dw. I checked every one of the dws for the retrieval argument.  When I open the window, then click Cancel on the pop-up window, all the data seems to be retrieved just fine.

In the past few days, I've been testing RichText edit styles. Nothing with retrieval arguments. 

I'm using PB2021, Build 1509, PFC 12.

How can I figure out which dw is throwing the pop-up window?  I've run the debugger and put breaks in several different locations, but everything seems OK. 

~~~Tracy

 

  1. DataWindow
  2. PFC
  3. PowerBuilder (Appeon)
How can I disable the RichTextToolbar?
Install PB2021-1509 on a new computer
Accepted Answer
Tracy Lamb
Tracy Lamb Accepted Answer Pending Moderation
  1. Wednesday, 12 April 2023 18:32 PM UTC
  2. PowerBuilder
  3. # Permalink

Sorry I didin't get back early, took a few days off for Easter. I traced every dw and dddw and couldn't find where the error is coming from.  I ended up just restoring the code from a backup, that got rid of the error.  Then I had to spend a couple hours re-doing the new code since the last back up.  I must have fat-fingered something somewhere, probably what Arnd suggested.

~~~Tracy

Comment
There are no comments made yet.
Responses (6)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 5 April 2023 21:24 PM UTC
  2. PowerBuilder
  3. # 1

Hi Tracy;

  Thought: Maybe a price of PowerScript code that is adding that RA dynamically to a Select statement (just a guess)?

Regards ... Chris

Comment
Tracy Lamb
  1. Tracy Lamb
  2. Thursday, 6 April 2023 00:05 AM UTC
No, i haven't changed anything except the Edit Style - changed a couple of them on a couple different dws from Edit to RichText to test. No problems opening other winodows with simllar characteristics, no problem. Just the Lab folder window. The odd thing is , I would never have the edit_user as retrieval argument. How would powerscript be adding that RA dymamically? Baffled why it's asking for a RA for edit_user. This problem isn't even related to the database changes I made. I restored last week's database, no changes. Same error.
  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Thursday, 6 April 2023 15:49 PM UTC
Hi,

What if you first undo your changes, test and then one by one change the edit styles again and test every time?
  1. Helpful 1
There are no comments made yet.
Rajesh Selvam
Rajesh Selvam Accepted Answer Pending Moderation
  1. Wednesday, 5 April 2023 22:35 PM UTC
  2. PowerBuilder
  3. # 2

Maybe the drop down datawindow assigned to one of the column has this retrieval argument. 

Comment
There are no comments made yet.
Gregory Rusak
Gregory Rusak Accepted Answer Pending Moderation
  1. Wednesday, 5 April 2023 22:35 PM UTC
  2. PowerBuilder
  3. # 3

Any new dddw introduced to any of the datawindows that might have that retrieval argument for edit_user ?

Comment
There are no comments made yet.
John Fauss
John Fauss Accepted Answer Pending Moderation
  1. Thursday, 6 April 2023 01:41 AM UTC
  2. PowerBuilder
  3. # 4

Hi, Tracy -

I suggest you search all DataWindow Data Objects in the application for the following string:

' arguments=(("edit_user",'

(without the apostrophes shown above). This is the leading portion of how a retrieval argument is defined in DW source code. That should help you locate the DW or DDDW that has a retrieval argument named edit_user.

Best regards, John

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Thursday, 6 April 2023 15:06 PM UTC
Hi John ;

A general search on the keyword "edit_user" should locate it right away.

The only thing I can think of that would not locate this column is it was dynamic (ie: name picked up at runtime from an external App source).

Regards ... Chris
  1. Helpful
John Fauss
  1. John Fauss
  2. Thursday, 6 April 2023 15:16 PM UTC
Yes, but a more generalized search as you suggest may return potentially many "false positive" results, especially if that is a commonly-used column name. if the goal is to find where a retrieval argument named "edit_user" has been defined in a DW, then I believe my suggestion helps you find exactly what you are looking for.
  1. Helpful
There are no comments made yet.
Arnd Schmidt
Arnd Schmidt Accepted Answer Pending Moderation
  1. Thursday, 6 April 2023 22:33 PM UTC
  2. PowerBuilder
  3. # 5

Hi Tracy,

this does not look like a simple Retrieval Argument issue but more related to QueryMode / Criteria stuff.

Search your DW Source to find something like this in the Column Specification.

criteria.dialog=yes

Or in the Datawindow Painter in modified DWs :

hth

Arnd

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.