Dropdown grid from Edit Grid fails on first attempt

[rdeardorff@spi-ind.com]

I have a dropdown grid assigned to a field in my Edit Grid.


double clicking on the Dept field, brings up this error?

?

however, if I click OK and then double click on the same field, it works

?

the error log shows this

??

[rdeardorff@spi-ind.com]

this consistently occurs on ONLY the first attempt. All subsequent attempts seem to work. This edit grid is part of a helper app.

update: I have found that sometimes subsequent attempts do fail as well, but it always fails on the first attempt.

[Johnny Major]

It seems like in your original post, you might have wanted to insert some images, as you referenced 'brings up this error.' Can you post them so we can gain a better understanding of the issue you're experiencing?

Thanks!?

[rdeardorff@spi-ind.com]

image.png

this error happens when I click on the Dept field (the only field that is editable in that grid)

click ok and then edit Dept again and it works

image.png??

[rdeardorff@spi-ind.com]

Discovered additional information. If the dropdown field already has data in it, the error occurs. but if the field is blank, it does not.

under the covers, the sql error shows this


image.png?

The sql definition for the dropdown does not have the "AND ((CODE = 'A')), so I presume that is added by Valance. All I want is for the dropdown to display the list from the table lookup, not pre-fill or pre-select the current value.

[Johnny Major]

Thank you for the information. We identified the issue from the error log you provided in your last post and will have it fixed in the next 6.3 update.

[rdeardorff@spi-ind.com]

testing this issue in my regression environment, 6.3.20250910.0

and it does not give the sql error, but now doesn't show anything other than a ghosted outline

image.png?

[rdeardorff@spi-ind.com]

I would like to demonstrate this to you. something real weird is going on.

[rdeardorff@spi-ind.com]

this followup issue is because of the dropdown being defined as an dropdown grid rather than a normal dropdown. I would like to be able to use a dropdown grid if possible.

changing the dropdown grid to a dropdown, and the lookup works...sort of.

after selecting the item from the dropdown, the code field does not get set in the UI...I don't see it until I close and reopen.