Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dropdown Bug?

Status
Not open for further replies.

GreenTreeFrog

Programmer
Jun 15, 2010
7
AU
A couple of maintenance windows have dropdowns where the User selects from a list of up to 100 items, enters a description in another field then Saves.

Only some of my dropdowns seems to have a bug where they are only displaying one row with a vertical scroll bar even though I have defined to to display 10 rows.

If I click another dropdown (date field or other) on the same window, then go back to my offending buggy dropdown, then it displays the 10 rows correctly.

What is with that!!

Any advice greatly appreciated. Thanks!
 
No. And I had never used that feature before so I just learnt something thanks!

They are not Auto Retrieve either. I populate them in the window code using GetDWChild, SSetTrans and Retrieve.
 
When do you do the Getchild, etc.? My guess based on your description is in itemchanged which gets triggered when a column loses focus (or an accepttext).

Matt



"Nature forges everything on the anvil of time"
 
Nope.

In the ancestor Open script, I call a custom event that gets all child datawindows in all datawindows on the window.

Then it performs the dwc retrieves in a function.

I even moved the retrieve to the last event fired, and same result.
 
How many rows are retrieved by the dddw's retrieve?
You can trap the SQL being sent to the database by creating a user defined transaction object, placing some code in the sqlpreview event and then stopping there in the debugger when the dddw column is retrieved.

Matt

"Nature forges everything on the anvil of time"
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top